Brickell Listings

Features
: Above Ground
: Other
2
2
Property Description

Welcome to your dream home! This stunning single-family home boasts 4 spacious bedrooms, 3 luxurious bathrooms, and a plethora of high-end features that will make you never want to leave. Step inside and be greeted by the sleek tile flooring and Sub Zero appliances in the gourmet kitchen, perfect for whipping up delicious meals for family and friends. The in-ground pool is the perfect oasis for hot summer days, and with the new swimming pool and salt system, maintenance is a breeze. High impact windows and doors provide security and peace of mind, while the soundproof windows ensure a quiet and serene environment. The huge circular driveway and ample garage offer plenty of parking space for guests, and the new lighting throughout the home creates a warm and inviting atmosphere.

Single Family Home For Sale HEFTLER HOMES AT LAGO MAR2,272 Sqft

7795 SW 161st Ave, Miami, Florida 33193

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 2,272 Sqft
$889,000
Listing ID#A11567846
QR Code
Basic Details
Building Name : HEFTLER HOMES AT LAGO MAR
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11567846
Price : $889,000
Original Price : $889,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 2,272 Sqft
Year Built : 1994
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Monthly
Association Fee : 50
DOM : 8
Tax : $13,323
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