Brickell Listings

Features
: Yes
: Unfurnished
4
2
Property Description

NEW CONSTRUCTION! Price to sale NOW. Sofia model. Beautiful 4/3 Double car garage Home on a large lot. Features 24×24 ceramic tile floors, impact windows & doors, well design home, walk in closet per room, frameless shower doors in all bathrooms, modern high ceiling areas, soft closing cabinetry, kitchen island with quartz counter and seating area, second living room with in law bed, bath and kitchen aid with independent access. Near shopping malls, supermarkets, and county offices, near great outdoor areas, sports and nature preserve places near the area, not HOA/CDD. Only five minutes to the Turnpike. Not fees, not premium.

Single Family Home For Sale SOUTH MIAMI LAKES,Century Pine Cove

19447 SW 124th Ct, Unincorporated Dade County, Florida 33177

  • Bedrooms : 4
  • Bathrooms : 3
$788,000
Listing ID#A11424224
QR Code
Basic Details
Building Name : SOUTH MIAMI LAKES,Century Pine Cove
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11424224
Price : $788,000
Original Price : $829,900
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Year Built : 2023
Property Sub Type : Single Family Residence
Association Fee : 0
DOM : 265
Tax : $1,995
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