Brickell Listings

Features
: Unfurnished
2
2
Property Description

Brand New Pre-Construction spacious half acre lot 4 bedrooms 2 and1/2 baths numerous extra all included in the price. Expected delivery date August – September 2022.

Single Family Home Sold FL CITY HIGHLANDS

18830 SW 354 ST, Miami, Florida 33034

  • Bedrooms : 4
  • Bathrooms : 3
$699,999
Listing ID#A11228273
QR Code
Basic Details
Building Name : FL CITY HIGHLANDS
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11228273
Price : $699,999
Original Price : $679,999
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 1
Year Built : 2022
Property Sub Type : Single Family Residence
DOM : 136
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 ( MATCH( `textsearch` ) AGAINST ( '(+"LOC-Brickell") "Listing ID Brickell"' IN BOOLEAN MODE ) ) AND `show_address`='1' AND `listing` = '9' AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY FIELD(p.zip_name, 33131) DESC, p.price_si ASC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent