Brickell Listings

Features
: Other
: Unfurnished
4
2
Property Description

Mediterranean home style in Mandarin Lakes with double Garage, spacious porch on the front, kitchen with granite countertop with family room, living and dining room (can be use extra room or office room) Many large windows that allow natural light. Huge master room with 2 walking closets and suite master room. Ful crow-molding in the property. Spacious back yard in pavers you can fence for privacy. HOA includes Internet, Cable, security patrol, landscaping Maintenace in common areas, clubhouse with pool resort style, fitness center and event room.
Easy to show, vacant.

Single Family Home Sold MANDARIN LAKES2,211 Sqft

13984 SW 274th Ter, Homestead, Florida 33032

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 2,211 Sqft
$464,000
Listing ID#A11472988
QR Code
Basic Details
Building Name : MANDARIN LAKES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11472988
Price : $478,900
Original Price : $478,900
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 2,211 Sqft
Year Built : 2006
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Monthly
Association Fee : 350
DOM : 5
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