Brickell Listings

Features
: Equipment Stays , In Ground
: Pool
: Yes
: Unfurnished
2
2
Property Description

Welcome to No HOA fees! This unique home has all impact windows and doors. Exquisite custom railings. 4 spacious bedrooms, 1 bedroom is down stairs High ceilings thought out. Home is in mint condition. Great schools, spectacular parks, and everything else you might need is within a 5 minute drive.

Single Family Home Sold REVISED PLAT OF HAMMOCKS2,541 Sqft

15270 SW 115th Ter, Miami, Florida 33196

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 2,541 Sqft
$755,000
Listing ID#A11412419
QR Code
Basic Details
Building Name : REVISED PLAT OF HAMMOCKS
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11412419
Price : $775,000
Original Price : $775,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 2,541 Sqft
Year Built : 1999
Property Sub Type : Single Family Residence
DOM : 14
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 `googlemap_ln` <= -80.18469409415071 AND `googlemap_lt` <= 25.816874338565697 AND `googlemap_ln` >= -80.29542151169854 AND `googlemap_lt` >= 25.70319268375598 AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si ASC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent