Brickell Listings

Features
: In Ground
: Unfurnished
0
0
Property Description

Back on the market, PRICE DROP!! Welcome to North Miami Beach. Location Location Location!rnClose to all houses of worship, beaches, and the 95, this home is turnkey where absolutely nothing was spared. This 2209 sqft home boasts 4 large bedrooms and 3 bath,and 24×48 porcelain tile flooring. This home features a state of the art kitchen with an island waterfall, high end appliances, and all was beautifully renovated. Enjoy the backyard and pool, making this large outdoor space ideal for entertaining.

Single Family Home Sold HIGHLAND ESTATES1,535 Sqft

860 NE 174th St, Miami, Florida 33162

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,535 Sqft
$960,000
Listing ID#A11374684
QR Code
Basic Details
Building Name : HIGHLAND ESTATES
Property Type : Single Family Home
Listing Type : Sold
Listing ID : A11374684
Price : $990,000
Original Price : $990,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,535 Sqft
Year Built : 1954
Property Sub Type : Single Family Residence
DOM : 17
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