Brickell Listings

Features
: Lake , Water View
: Restrictions Or Possible Restrictions
1
1
Property Description

Beautiful 2/2 with a Waterview you can enjoy from living room, dining room and master bedroom. The unit is spacious. It’s been updated: new hurricane impact windows, new flooring and more. The complex is quiet, clean and has rooms plus common area grills and open spaces for gatherings. It is a pet friendly community. There are pet restrictions. This community sits just west of Aventura in North Miami Beach. Close to main highways, beaches, Aventura Mall, Brightline Station and other main roads. New shops have been incorporated to the California Club mall which is within walking distance. Easy to show, just call.

Condo For Sale at AZURE LAKE CONDO

873 NE 195th St #309, Miami, Florida 33179

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,320 Sqft
$279,999
Listing ID#A11499321
QR Code
Basic Details
Subdivision : 873 NE 195th
Building Name : AZURE LAKE CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11499321
Price : $279,999
Original Price : $305,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,320 Sqft
Year Built : 1970
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 701
DOM : 112
Tax : $2,815
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