Brickell Listings

Features
: Unfurnished
2
2
Property Description

Spectacular Single-Family Home offering 3 Bedrooms & 2 Baths offering nice floor plan and renovated bathrooms High Impact Doors and Windows installed. New tile flooring throughout. Modern custom designed kitchen with SS appliances with wall mount ovens, quartz countertops, and plenty of cabinets storage space, a huge quartz island that entertains both dining and living room. 2 cars garage with plenty of parking. Must See!!! NO HOA!!! Professional pictures to come soon.

Single Family Home Sold SOUTHLAND PINES1,594 Sqft

10734 SW 174th Ter, Miami, Florida 33157

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,594 Sqft
$580,000
Listing ID#A11351374
QR Code
Basic Details
Building Name : SOUTHLAND PINES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11351374
Price : $599,999
Original Price : $599,999
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,594 Sqft
Year Built : 1973
Property Sub Type : Single Family Residence
DOM : 40
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