Brickell Listings

Features
: Unfurnished
2
2
Property Description

Beautiful light and bright 4/3 SFR. Lots of space and potential.rn Do not Disturb Owners. Calls will NOT be answered. Email for all inquiries and showings. CASH ONLY

Single Family Home Sold FLORINDA ESTATES3,182 Sqft

8726 NW 139th Ter, Miami Lakes, Florida 33018

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 3,182 Sqft
$594,660
Listing ID#A11324471
QR Code
Basic Details
Building Name : FLORINDA ESTATES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11324471
Price : $699,000
Original Price : $509,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 3,182 Sqft
Year Built : 2006
Property Sub Type : Single Family Residence
DOM : 50
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