Brickell Listings

Features
: Other
: Pool
2
2
Property Description

Build your dream home! Plans approved and will be ready to break ground soon! See renderings for details. Currently vacant lot, but WILL BE SHOVEL READY AT CLOSING.

Single Family Home For Sale BISCAYNE PARK ESTATES

0 NE 5TH AVE, Biscayne Park, Florida 33161

  • Bedrooms : 5
  • Bathrooms : 6
$1,499,900
Listing ID#A11541893
QR Code
Basic Details
Building Name : BISCAYNE PARK ESTATES
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11541893
Price : $1,499,900
Original Price : $1,499,900
Bedrooms : 5
Bathrooms : 6
Half Bathrooms : 1
Year Built : 2024
Property Sub Type : Single Family Residence
DOM : 0
Tax : $12,904
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