Brickell Listings

Features
: Unfurnished
0
0
Property Description

Motivate seller, shopping, entertainment and major highways. The lovely single Family Home 3B/2B, In law quarters with separate entrance 1/1. Property is being Sold-As Is possible violations. Please do not disturb homeowner or tenant. Contact Listing agent for showing instructions.

Single Family Home Sold SCOTT LAKE MANOR SEC 52,092 Sqft

17720 NW 14th Pl, Miami Gardens, Florida 33169

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 2,092 Sqft
$390,000
Listing ID#A11293124
QR Code
Basic Details
Building Name : SCOTT LAKE MANOR SEC 5
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11293124
Price : $405,000
Original Price : $440,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 2,092 Sqft
Year Built : 1958
Property Sub Type : Single Family Residence
DOM : 178
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