I believe the appreciation will slow/stop in much of the gulf towns on the water because of this.

Pretty cool.You probably won't find this type of home in Florida or anywhere where the water table is high.

Just starting out and testing waters for BRRR in Chicagoland area.Any advice or suggestions regarding this?

That actually is a benefit, as no one is expected to water the yard.  

(And I would tell you to not buy a property that doesn't cash flow unless you have significant resources behind you that could absorb anything that could come at you - like replacing a $5,000 AC one month followed by replacing a $1,000 hot water heater the next).   

Each of the 5 warehouses on this campus will require updates (construction of offices/bathrooms, roof repairs, paint, siding repairs, new penetrations for doors, updates to electrical, insulation, and extension of water and sewer). 

It had 22 of the 25 lots occupied but we'll be fixing it up, filling it up, billing back water and raising rent up to market.

If needed add a minimum of 15kModerate RehabCan save at least two of the following- Electric, Drywall, Flooring, Plumbing (likely touch ups in the other two)Redo KitchenRedo Existing BathroomsNo framing or architect plans neededPaintFinish BasementAdd a split unit to existing duct work (prevent from tearing up existing plaster/drywall)*Think of a grandma home that does not have knob and tube and has been on top of roof/windows so we aren’t as worried about mold/water damage*Light RehabComps do not need a finished basement or basement is finished to comp standardComps do not need HVAC or you can just add split unit to existing ductworkKitchenBathroomFloorsPaintNo major rehaul of mechanics needed (aka do not need to rip out walls)LipstickPaint, Floors, appliances in the most basic sense ARV Range Full Gut Moderate Light Lipstick +450 (A+) 150-300 N/A N/A N/A 380-450 (A) 90-120 70-75 N/A N/A 270-400 (B/B+) 85-100 60-70 N/A N/A 210-270 (B-) 75-80 60-65 45-55 N/A 170-210(C/C+) 65-75 50-60 40-50 15-30 140-170(C-) 60-70 50-60 35-45 10-20 120-140 (D) 55-65 40-50 25-35 5-15 Philly Neighborhoods Breakdown:A+ : Obvious Prime Real Estate.

I learned the hard way how to shut off water and how to winterize.

You also mentioned an unpaid water bill, so be sure to deduct any outstanding balance from that bill as well.