A lift station failed during the last hurricane. 

Okay, I'll jump in here.I've done SBA 7(a) loans, one for 1.7mil and another for 2 mil, for two separate commercial properties (gas station c-stores, ground up raze and rebuilds). 

That's like buying a lot to build a gas station, but it's zoned residential currently...but maybe you can get a permit. 

Under Servicemembers Civil Relief Act (SCRA), the following are considered “uniformed members:” Armed servicesActivated National GuardCommissioned Corps of the Public Health ServiceCommissioned Corps of the National Oceanic and Atmospheric AdministrationTo terminate the lease agreement, the tenant must meet the following conditions:Tenant joins the military after signing the lease agreement or signed the lease agreement while in the military then ordered to permanently change location or deploy for more than 90 days;Tenant provides landlord written notice; andTenant provides landlord copy of the military ordering him/her for a permanent change of station or deployment for a period of 90 days or more.Landlord fails to perform its dutiesFailure to do repairsTexas law mandates residential landlords to make a diligent effort in repairing property problems that materially affect the physical health or safety of an ordinary tenant.

You'll need to know if your site will gravity feed to sewer, need easements to cross other properties, or will need a pump station or grinder pumps for each home.  

I was ultimately swayed by people in my orbit to get an Executive MBA (no specializations, canned program), for the network and for the serendipitous possibilities that could come from my fellow students and the professors.

When we were stationed in England, and bought our houses, we got a thick stack of documents going back to the Norman Invasion of 1066. 

I stopped at the police station and they gave me 5 police reports since last month.

Additionally, they may want to seek legal or financial advice to ensure they make the best decision for their specific circumstances.If after all this if you still looking to take advantage of such opportunity, I would verbalize in your new duty station that you invest in real-estate and that are looking to take over a loan.

With a 1-BR condo, the appreciation lags well behind SFH's, but over the long term there's no way it will lose value -- it's near hotels, a major bar/restaurant destination, good schools, and a station that serves the city's best Metro line.