I know of one in Newark (w/tenants), duplex style on one half with attached third single-level unit and large flat lot ideal for live-in investor.

Ideally, I signed on with the intent of working with current and future investors.As a hungry Realtor that is eager to make an impact in the Houston market, questions are: Is this situation I am in now something that is worth waiting out, or are these opportunities common for Realtors in Houston? 

Ideally a 4 to 7% rent ratio to sales is the sweet spot.If this is a national chain we want to know what sales does the average store do nationally and is this store below average, average, or above average??

Ideally I would like to buy and rent to start with.

You are in an ideal situation to rehab and flip.

I know of brokers that charge monthly desk fees, but that will not be ideal for a part time agent.

Areas with known reputable property management companies wth references are obviously ideal areas to start looking. 

I am certainly willing to sign a long-term lease, especially in an ideal location.

Ideally without loosing your income.The company should be able to get where you are coming from.  

Ideally, I'd like to get the first deal by sometime this summer and flip it by sometime in the fall.