Listed by James Allen Slattery of Blue Banyan Realty LLC
MAXIMUM ROI ON A ROCK-SOLID FOUNDATION! CONCRETE BLOCK FIXER-UPPER!Attention heavy-hitter investors, flippers, and portfolio builders: skip the rotting wood frames and capitalize on pure structural durability. This 2-bedroom, 1-bathroom contractor's special at 174 Celestria Ct features solid concrete block construction (not CBS/stucco frame wrapper over wood), giving you the ultimate industrial-grade bone structure for a high-yield flip or rental property. Spanning 722 square feet, this property is a total interior gut-job requiring a complete cosmetic overhaul and a new roof. Massive Value-Add Bonus: The property includes a detached outbuilding that also requires full rehabilitation. Transform this structure into premium tenant storage, a workshop, or use the square footage to unlock additional rental premiums in a high-demand market.True concrete block flips with detached garages do not sit on the market. If you are afraid of sweat equity, look elsewhere. If you want to capitalize on a rock-solid, recession-proof build with huge margins, act immediately. Cash only. Property sold strictly AS-IS. The land alone is valued at over $135,000. Bring your general contractor and name your terms before another investor locks down this payday!

Listing Tools

Property Details of 174 SE Celestia Court

Property Details

Interior Features

Community

Map Location

Based on information submitted to BeachesMLS as of July 2, 2026 9:33 AM UTC . All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from HDKL Realty. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.