Brickell Listings

Features
: Unfurnished
2
0
Property Description

BRAND NEW CONSTRUCTION HOUSE 4 BED 2 BATHS. ALMOST 100% COMPLETED!!!. ALL TILED. GREAT CABINETS NO ASSOCIATION. NO LIENS. NO HASSLES. THIS IS NOT A REMODELED HOUSE THIS HOUSE IS BRAND NEW FROM THE GROUND UP. BUILT WITH THE LATEST BUILDING CODE. IMPACT WINDOWS TOP OF THE LINE CABINETRY AND CENTRALLY LOCATED.WILL NOT LAST. VERY CLOSE TO WYNWOOD, DOWNTOWN AND MIAMI BEACH AND IT IS THE PERFECT STARTER HOME. HOUSE WILL SELL BY ITSELF. JUST BRING BUYER!

Single Family Home Sold SEMINOLE LAWNS1,500 Sqft

5260 NW 32nd Ave, Miami, Florida 33142

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 1,500 Sqft
$499,000
Listing ID#A11353676
QR Code
Basic Details
Building Name : SEMINOLE LAWNS
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11353676
Price : $499,900
Original Price : $499,900
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,500 Sqft
Year Built : 2023
Property Sub Type : Single Family Residence
DOM : 40
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