Brickell Listings

Features
: Other
2
2
Property Description

Gorgeous remodeled 3-bedroom, 2-full Bath, den/office living room, one story home perfectly located! Beautiful tile and wood floors throughout, SS appliances, great size kitchen, huge master bedroom with walking closet and bathroom. Close to supermarkets, restaurants, shops, banks, schools and airport. High Impact Hurricane Windows in the front of the house! Showings by appointment only.

Single Family Home For Sale TAMIAMI HIGHLANDS1,253 Sqft

5635 SW 5th Ter, Miami, Florida 33134

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,253 Sqft
$625,000
Listing ID#A11556444
QR Code
Basic Details
Building Name : TAMIAMI HIGHLANDS
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11556444
Price : $625,000
Original Price : $625,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,253 Sqft
Year Built : 1948
Property Sub Type : Single Family Residence
DOM : 36
Tax : $8,130
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