Brickell Listings

Features
: Garden
: Unfurnished
2
1
Property Description

Wow!Huge Price Reduction !-4 bed-2 bath, Incredible Renovated Home by Falls just completed! Excellent schools- All Glass Impact Windows and doors, New Roof, New Sprinkler system front and rear, New Designer kitchen, All New Appliances, Designer bathrooms, New Electric Cicruit Breaker panel box, All 12×24 designer floor tile, Gorgeous bathrooms and vanities, Very spacious master shower with rainfall ceiling shower head, New Tankless instant hot water heater, Tiled Entry walkway, Completely fenced rear, large utility shed. Huge oversized 18,000 sf lot, 4 bedrms (split floor plan-primary bedroom opposite side house- 3 bedrooms other side) 2148 sf interior, house is a show stopper in an New Designer window shades ,great schools/shopping nearby ****.Larger than tax rolls 2150 sf ****

Single Family Home Sold RANCHO MANOR1,762 Sqft

8960 SW 125th Ter, Miami, Florida 33176

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 1,762 Sqft
$879,500
Listing ID#A11264517
QR Code
Basic Details
Building Name : RANCHO MANOR
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11264517
Price : $889,000
Original Price : $999,000
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,762 Sqft
Year Built : 1958
Property Sub Type : Single Family Residence
Association Fee : 0
DOM : 188
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