Brickell Listings

Features
: Lake
: Restrictions Or Possible Restrictions
: Unfurnished
2
2
Property Description

Just Reduced! Owner is very MOTIVATED. Immaculate 4BR/3BA with 2 car garage and completely fenced. Lake front across the street with beautiful sunset views. ALARM, CABLE AND LANDSCAPING INCLUDED IN THE HOA. Open floor plan, very bright interiors, high arched windows and vaulted ceilings. New kitchen with granite counters, tall cabinets and stainless steel appliances. Extremely clean and spacious. Large master bedroom with 2 walk-in closets. Large master bathroom with his and hers sinks, shower, and a roman tub. RC plantation blinds, tiled throughout with wood in stairs, loft in second floor, and bedrooms. Tons of upgrades, must see ASAP cause it will not last! Upscale community clubhouse with huge pool and gym.

Single Family Home Sold MANDARIN LAKES2,627 Sqft

27577 SW 143rd Ct, Homestead, Florida 33032

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 2,627 Sqft
$470,000
Listing ID#A11361871
QR Code
Basic Details
Building Name : MANDARIN LAKES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11361871
Price : $499,500
Original Price : $520,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 2,627 Sqft
Year Built : 2007
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Monthly
Association Fee : 274
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