Brickell Listings

Features
: In Ground
: Pool , Garden
: Yes
: Unfurnished
2
2
Property Description

Elegantly placed residence at the end of a cul-de-sac. This HOME offers space, comfort, amenities, and the convenience of good schools like Palmer Trinity, Westminster, Gulliver and great public schools. Completely remodeled, these 4 Bed 2.5 baths has modern kitchen, 6-year roof, updated bathrooms, ceramic and wood floors. Lovely backyard is surrounded by a concrete fence, lush landscaping; enjoy relaxing pool, chikee hut, BBQ area, and an ample terrace. Must see HOME and investment on your family.

Single Family Home Sold FONDREN ESTATES

18015 SW 82nd Ct, Palmetto Bay, Florida 33157

  • Bedrooms : 4
  • Bathrooms : 3
$1,275,000
Listing ID#A11368235
QR Code
Basic Details
Building Name : FONDREN ESTATES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11368235
Price : $1,249,000
Original Price : $1,249,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 1
Year Built : 1990
Property Sub Type : Single Family Residence
DOM : 31
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