Brickell Listings

Features
: Concrete
: Garden
: Unfurnished
0
0
Property Description

Beautifully remodeled single family pool home in sought after neighborhood of Palm Springs North. Ceramic tile flooring throughout. Property sits on large corner lot. Kitchen and bathrooms have been completely remodeled. Close to major highways and shopping. This home will not last.

Single Family Home Sold PALM SPRINGS NORTH SEC T1,734 Sqft

17500 NW 85th Ave, Hialeah, Florida 33015

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 1,734 Sqft
$750,000
Listing ID#A11362287
QR Code
Basic Details
Building Name : PALM SPRINGS NORTH SEC T
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11362287
Price : $768,000
Original Price : $768,000
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,734 Sqft
Year Built : 1970
Property Sub Type : Single Family Residence
DOM : 48
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