Brickell Listings

Features
: No
: Unfurnished
1
1
Property Description

Del Mesa is a collection of new townhomes for sale coming soon to Siena Reserve, a masterplan community in the bustling city of Miami, FL. There is so much to do in Miami for families at all stages. Residents have access to local hot spots such as Zoo Miami or the Fair Child Botanic Garden. Plus, downtown Miami and the Florida Keys are just a quick drive for sandy beaches, shopping, entertainment and more.

Condo Sold at Siena Reserve

23409 SW 131 Court, Homestead, Florida 33032

  • Bedrooms : 4
  • Bathrooms : 3
$487,390
Listing ID#A11378979
QR Code
Basic Details
Building Name : Siena Reserve
Property Type : Condo
Listing Type : Sold
Listing ID : A11378979
Price : $478,390
Original Price : $478,390
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 1
Year Built : 2022
Property Sub Type : Townhouse
Assoc Fee Frequency : Monthly
Association Fee : 140
DOM : 18
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 `listing` = '9' AND `property_type` = '36' AND ( MATCH( `textsearch` ) AGAINST ( '(+"LOC-33131") "Listing ID 33131"' IN BOOLEAN MODE ) ) AND `show_address`='1' AND `f_140`='1' AND (`f_140_options` LIKE '%,1,%' OR `f_140_options` LIKE '%,3,%' OR `f_140_options` LIKE '%,4,%' OR `f_140_options` LIKE '%,5,%' OR `f_140_options` LIKE '%,6,%' OR `f_140_options` LIKE '%,7,%' OR `f_140_options` LIKE '%,8,%' OR `f_140_options` LIKE '%,9,%' OR `f_140_options` LIKE '%,10,%') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si DESC , p.id ASC LIMIT , 1

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