Brickell Listings

Features
: Unfurnished
2
2
Property Description

BRAND NEW 2022 CONSTRUCTION. This home features 4/3 Total 3157sqft 2600 Sqft Living area with an open concept and spacious layout with high ceilings. Custom European style kitchen with high end appliances. Master bedroom suite and bath with tub and separate walk in shower and double sinks. Ready to move in.

Single Family Home Sold SILVER PINES

8500 SW 198th St, Cutler Bay, Florida 33189

  • Bedrooms : 4
  • Bathrooms : 3
$820,000
Listing ID#A11359452
QR Code
Basic Details
Building Name : SILVER PINES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11359452
Price : $834,900
Original Price : $834,900
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Year Built : 2023
Property Sub Type : Single Family Residence
DOM : 28
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