Brickell Listings

Features
: Garden View
: Restrictions Or Possible Restrictions
16
0
0
Property Description

Spacious 1 bed gem in a gated, quiet, enjoyable and very well maintained community with tropical landscaping within walking distance to supermarkets, stores, restaurants and gorgeous parks and only blocks from the beach.

Condo For Sale at HARMONY VILLA CONDO

728 Lenox Ave #7A, Miami Beach, Florida 33139

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 690 Sqft
$274,000
Listing ID#A11546464
QR Code
Basic Details
Subdivision : 728 Lenox
Building Name : HARMONY VILLA CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11546464
Price : $274,000
Original Price : $289,000
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 690 Sqft
Year Built : 1953
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 800
DOM : 34
Tax : $4,551
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