Brickell Listings

Features
: Canal
: Yes
: Unfurnished
2
2
Property Description

Spacious and bright 4/3 waterfront home in sought out community. Split floor plan and tiled throughout. New roof 2021.Solar water heater. 9,000 sq. ft fenced lot. Room for a pool. The home has several fruit trees to include mango, avocado, lychee, and sapodilla. NO HOA. Near shopping, restaurants and major highways. Priced to Sell! DU required with all financed offers. POF for cash offers; no exceptions.

Single Family Home Sold PALM SPRINGS SUB SEC 3 5T1,910 Sqft

911 W 51st Pl, Hialeah, Florida 33012

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,910 Sqft
$656,000
Listing ID#A11444322
QR Code
Basic Details
Building Name : PALM SPRINGS SUB SEC 3 5T
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11444322
Price : $674,999
Original Price : $674,999
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,910 Sqft
Year Built : 1957
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 `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