Brickell Listings

Features
: Automatic Chlorination , In Ground
: Canal , Pool
2
2
Property Description

Amazing Modern Residence ready for construction. Concrete Construction including roof! Another Fortress that will Withstand any hurricane, forget termites. This is the moment to own a one of a kind Palmetto Bay Masterpiece! Beautiful Property located on a Lovely Canal within a Quiet Cul-de-Sac Location. Foyer Entrance welcomes you into this Modern Family Residence’s Grand Room. Awesome Layout with Large En-suite Bedroom located on the ground floor. Great Chef’s Kitchen with Family Room, Formal Dining Room, Wine Cellar & Pantry. Full sized Cabana Bath and Spacious Laundry room. 4 En-suite Bedrooms upstairs including the Master Grand Suite. Extra Laundry room upstairs! Roof Terrace with Interior Staircase Access for Romantic Stargazing Evenings! Ready for Construction!

Single Family Home For Sale THE LANDINGS SEC 2

16235 SW 89 Ct, Palmetto Bay, Florida 33157

  • Bedrooms : 5
  • Bathrooms : 6
$3,875,000
Listing ID#A11222972
QR Code
Basic Details
Building Name : THE LANDINGS SEC 2
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11222972
Price : $3,875,000
Original Price : $2,799,000
Bedrooms : 5
Bathrooms : 6
Half Bathrooms : 0
Year Built : 2022
Property Sub Type : Single Family Residence
DOM : 587
Tax : $5,459
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