Brickell Listings

Features
: Ocean View
1
1
Property Description

REDUCE!! Great apartment, amazing views from Balcony 8th Floor Ready to live in or rent it out. Excellent location close to highways and supermarkets. No rental restrictions Schedule and show it today!

Condo For Sale at KEYSTONE TOWERS CONDO

2020 NE 135th St #808, North Miami, Florida 33181

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 806 Sqft
$243,500
Listing ID#A11488382
QR Code
Basic Details
Subdivision : 2020 NE 135th
Building Name : KEYSTONE TOWERS CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11488382
Price : $243,500
Original Price : $275,000
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 806 Sqft
Year Built : 1969
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 537
DOM : 151
Tax : $3,410
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