Brickell Listings

Features
: Garden
: Unfurnished
2
2
Property Description

NEW CONSTRUCTION OF ONLY 12 HOUSES, WITH NO ASSOCIATION OR CDD TAX, 4/3.5 ONE-STORY SINGLE-FAMILY HOUSE, NICE KITCHEN AND BATHROOMS, TILES ALL THROUGH OUT, IMPACT DOORS AND WINDOWS AND MORE.rnESTIMATED DELIVERY DATE BY DECEMBER 2022. LOT PREMIUMS APPLY, MORE PROPERTIES AVAILABLE (SEE ATTACHMENTS)rnLOT PREMIUM APPLY

Single Family Home Sold CENTURY PINE COVE,CENTURY HOMEBUILDERS

19419 SW 124th Ct, Miami, Florida 33177

  • Bedrooms : 4
  • Bathrooms : 4
$642,990
Listing ID#A11178321
QR Code
Basic Details
Building Name : CENTURY PINE COVE,CENTURY HOMEBUILDERS
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11178321
Price : $724,990
Original Price : $694,990
Bedrooms : 4
Bathrooms : 4
Half Bathrooms : 1
Year Built : 2023
Property Sub Type : Single Family Residence
DOM : 478
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