Brickell Listings

Features
: Other
: Yes
: Unfurnished
1
0
Property Description

House to live in, entertain, and enjoy with all the latest accoutrements. Nestled in unincorporated Miami-Dade between Coral Gables and South Miami. Fenced corner lot. Walk to University of Miami. Near US 1, SW 57 Ave, SW 56 St (Miller Rd), airport, shopping districts. All new: open floor plan; uniform oversize porcelain floors; bathrooms, wood kitchen cabinetry with quartzite countertops; built in appliances; window treatments; all doors and hardware; interior and exterior paint; 5 ton A/C including duct work; ceiling insulation; sprinkler system including pump; concrete slab semicircular in front drive way and on the side; recessed lights; resodded and landscape. Metal roof is 8 years old. Updated electricity 8 years ago. Septic tank in front yard area, PVC pipes under the house.

Single Family Home For Sale BILTMORE HEIGHTS RED RD A2,374 Sqft

5890 SW 51st Ter, Miami, Florida 33155

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 2,374 Sqft
$1,640,000
Listing ID#A11454428
QR Code
Basic Details
Building Name : BILTMORE HEIGHTS RED RD A
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11454428
Price : $1,687,000
Original Price : $1,700,000
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 2,374 Sqft
Year Built : 1970
Property Sub Type : Single Family Residence
DOM : 60
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