Brickell Listings

Features
: In Ground
: Yes
: Unfurnished
2
2
Property Description

LUXURIOUS TWO-STORY HOME IN PRIME LOCATION OF WEST KENDAL, PROPERTY FEATURES TWO MASTER BEDROOMS SUITES, ONE ON THE FIRST FLOOR WITH A PRIVATE ENTRANCE THAT CAN BE USED AS A QUARTER IN LAW. ALL OTHER BEDROOMS ARE LOCATED ON THE SECOND FLOOR. A TASTEFULLY REMODELED KITCHEN OVERLOOKING A SPARKLING POOL. ALL NEW STAINLESS-STEEL APPLIANCES, WINE COOLER, AND GAS RANGE. THE ROOF IS ONLY FIVE YEARS OLD. SECURITY CAMERAS ARE INCLUDED WITH THE SALE. THIS HOME IS SITTING ON ONE OF THE LARGER LOTS IN THE NEIGHBORHOOD. SPACIOUS INDOOR AND OUTDOOR LIVING FOR THOSE WHO LOVE TO ENTERTAIN. COME AND FALL IN LOVE WITH THIS GEM.

Single Family Home Sold WEITZER LAGO MAR HOMES,Weitzer Lago Mar Hom2,5

15798 SW 74th St, Miami, Florida 33193

  • Bedrooms : 5
  • Bathrooms : 4
  • Square Footage: 2,504 Sqft
$780,000
Listing ID#A11422338
QR Code
Basic Details
Building Name : WEITZER LAGO MAR HOMES,Weitzer Lago Mar Hom
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11422338
Price : $799,000
Original Price : $849,000
Bedrooms : 5
Bathrooms : 4
Half Bathrooms : 1
Square Footage : 2,504 Sqft
Year Built : 1994
Property Sub Type : Single Family Residence
Assoc Fee Frequency : Quarterly
Association Fee : 279
DOM : 65
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