Brickell Listings

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

Imagine living in a home that is a RESORT! This magnificent 2,137 sq ft 2 story masterpiece in Shore Crest
features 4 bedrooms and 3 beautifully remodeled marble bathrooms in the main house plus a charming guest
cottage with a separate entrance. Remodeled sparing no expense, features include all new impact windows and
doors, amazing gourmet chef’s kitchen, energy efficient solar panels, pool with salt system and a lush tropical
backyard that is perfect for a family gathering or for entertaining friends. This is living the Ritz Carlton lifestyle!
Additional features include new AC, updated electrical and plumbing, tons of natural light and lots of closet space.
A MUST SEE! Easy to show.

Single Family Home Sold DAVIS HARBOR1,538 Sqft

1164 NE 86th St, Miami, Florida 33138

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,538 Sqft
$1,282,500
Listing ID#A11449032
QR Code
Basic Details
Building Name : DAVIS HARBOR
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11449032
Price : $1,349,000
Original Price : $1,349,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,538 Sqft
Year Built : 1951
Property Sub Type : Single Family Residence
DOM : 98
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