Brickell Listings

Features
1
0
Property Description

Location location location, you will not want to miss this unique opportunity in the most desirable pocket of this North Miami Beach family neighborhood

Single Family Home For Sale WINDWARD MANOR NO 2

1041 NE 179th St, North Miami Beach, Florida 33162

  • Bedrooms : 3
  • Bathrooms : 2
$1,000,000
Listing ID#A11509829
QR Code
Basic Details
Building Name : WINDWARD MANOR NO 2
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11509829
Price : $1,000,000
Original Price : $1,000,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Year Built : 1957
Property Sub Type : Single Family Residence
DOM : 1
Tax : $1,872
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