Brickell Listings

Features
: Free Form , In Ground
: Lake , Garden
: Furniture For Sale
2
2
Property Description

Beautiful Miami lakes home in beautiful SilverCrest lakes Estates sitting on a cul de sac on the lake with amazing views. Property sits and the very end on the cul de sac and has and extra lot. Remodeled pool deck, marbled floors, keystone fireplace, amazing landscaping with fruit trees and palms. Built in patio BBQ area. Backup gas generator to cover the entire house, circular driveway, tiled garaged, Big walk-in closets. Bring your pickiest client.
They will not be disappointed. 24Hr notice a must! contact listing agent for property access.

Single Family Home For Sale SILVERCREST LAKE ESTATES3,093 Sqft

15763 NW 80th Ave, Miami Lakes, Florida 33016

  • Bedrooms : 5
  • Bathrooms : 4
  • Square Footage: 3,093 Sqft
$1,600,000
Listing ID#A11549447
QR Code
Basic Details
Building Name : SILVERCREST LAKE ESTATES
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11549447
Price : $1,600,000
Original Price : $1,600,000
Bedrooms : 5
Bathrooms : 4
Half Bathrooms : 0
Square Footage : 3,093 Sqft
Year Built : 2002
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Monthly
Association Fee : 270
DOM : 8
Tax : $8,070
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