Brickell Listings

Features
: In Ground
: Pool
: Unfurnished
2
2
Property Description

Indulge in luxury with this exquisite 2-story residence spanning 3,800 sq ft in the highly sought-after Mansions at Sion. Revel in a resort-style lifestyle with a pristine pool and the added security of hurricane shutters. This opulent haven boasts 5 beds and 4 baths, with a convenient 1st-floor suite for flexibility and ease. Impeccable design, proximity to shopping centers, and fine dining elevate the experience of living in this prestigious neighborhood. Your dream home awaits in Mansions at Sion!

Single Family Home Sold MANSIONS AT SION3,210 Sqft

14435 SW 23rd Ter, Miami, Florida 33175

  • Bedrooms : 5
  • Bathrooms : 4
  • Square Footage: 3,210 Sqft
$893,500
Listing ID#A11496361
QR Code
Basic Details
Building Name : MANSIONS AT SION
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11496361
Price : $1,050,000
Original Price : $1,150,000
Bedrooms : 5
Bathrooms : 4
Half Bathrooms : 0
Square Footage : 3,210 Sqft
Year Built : 2007
Property Sub Type : Single Family Residence
DOM : 35
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