I would highly recommend you sell and do a 1031 exchange into something that will produce income, like a rental property.

., assets that tend to produce income for more than a year) are expensed over a specified "useful life." 

According to the water meter, approximately 1 days after being served the court summons for eviction, the tenant turned on all of the faucets in the home and ran them for about 55 days.

Besides buying turn-key properties with all cash (from the likes of REI etc), are there any other passive RE investment opportunities that will fit this criteria ?  

If you want to get a weekly dose of STR info I highly recommend signing up for Garrett's STR news that is emailed weekly, here's how to do that - https://app.tango.us/app/workflow/BiggerPockets-free-Short-T...Keep us updated on what you decide and how things turn out!

My first property, a C-Class multi-family in Houston, seemed like a great investment, but it turned out to be a money pit.

Assuming that's what you're looking for, the above mentioned google turned up this website: https://www.charlestoncounty.org/property-info.phpIf you click on the GIS parcel viewer option, there's a search bar where you can punch in a street address.

The costs sound a little low to me if you are talking turn key including permits, site work, utilities, plans, surveys etc.

I have yet to be turned down for a credit card.  

@Dan AshleyYou’re wise to be looking for ways to turn rent into your own equity.