I'm noticing there are some really nice cash flow markets in texas, some of which are really close to the Mexican border, though.

If it's in the restricted zone (within 31 miles of the coast or 62 miles from an international border, you have the choice between using a bank trust and paying the fees mentioned above or using a Mexican corporation and bearing the costs of establishing and maintaining  the corporation.

Quote from @Henry Clark: @Michael PlaksIf they want to stop money laundering and funding terrorism they can control the border.  

Requirements:✔ Experience in international taxation: Understanding of the Germany-USA Tax Treaty and cross-border income taxation✔ Specialization in real estate: Tax treatment of rental income, depreciation, tax benefits, and investment deductions✔ Tax optimization strategies: Maximizing deductions (e.g., business travel, home office), optimizing mixed-income structures✔ Long-term tax planning: Strategies to reduce tax liabilities and avoid unexpected tax payments✔ Proactive advisory & clear communication: Ability to explain complex tax matters in simple terms and provide proactive tax-saving solutionsAdditional Considerations:Expertise in tax treatment of travel to Germany (e.g., for real estate management)Experience with compliance in both countriesIf you meet these qualifications and are interested in working together, or know someone who meets our requests, please send a message. 

After some research online, I am reading that the cost per square foot on a gut renovation of this nature in Stamford CT is anywhere from $150-$350, which is ultimately not very helpful, because at $150 per sq ft, this is a very appealing project with a total profit of ~$175K (46% ROI) and at $350 per sq ft, it very much isn't, because it would be a net loss of 83K (haha).QUESTIONS:What can I do refine my estimate a bit given that I am not allowed to a formal inspection on the property? 

Sounds like you’ve taken the right steps so far by giving formal notice to vacate.

Consider financing options like hard money loans, or FHA loans for house hacking, and focus on areas with strong rental demand near the MA/NH border.

I own a house in North Port, Florida (right on the border of Port Charlotte).

Key point is WITH a SECURED border to stop the flood of 100k-300k monthly illegls. 

I would imagine most attorneys located around the MA, NH border area plan to make more than $200,000 per year.