Brickell Listings

Features
0
0
Property Description

UNDER CONSTRUCTION CORNER HOME. 4 BEDROOM 2 BATH WITH LARGE BACKYARD. IMPACT WINDOWS AND DOORS. TILE THROUGHOUT, KITCHEN WOOD CABINETS AND GRANITE COUNTERTOPS. NO HOMEOWNERS ASSOCIATION. PROPERTY SHOULD BE COMPLETED APPROX. JULY 2024.

Single Family Home For Sale ROOSEVELT HOMESITES

605 SW 11th Ave, Homestead, Florida 33030

  • Bedrooms : 4
  • Bathrooms : 2
$460,000
Listing ID#A11571649
QR Code
Basic Details
Building Name : ROOSEVELT HOMESITES
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11571649
Price : $460,000
Original Price : $460,000
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Year Built : 2024
Property Sub Type : Single Family Residence
DOM : 7
Tax : $2,573
Search Results

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 1' at line 1]
SELECT `id` FROM `wp_wpl_properties` AS p WHERE 1 AND `f_151` = '1' AND `googlemap_ln` <= -80.1728475295166 AND `googlemap_lt` <= 25.78380663412404 AND `googlemap_ln` >= -80.2028882704834 AND `googlemap_lt` >= 25.771564094476545 AND `price_si` <= '999999999999' AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY FIELD(p.zip_name, 33131) DESC, p.price_si ASC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent