Brickell Listings

Features
: Pool Area View , Lake
: No
0
0
Property Description

BEAUTIFUL, VERY SPACIOUS 3/2, SPLIT PLAN, ON THE 2ND FLOOR WITH A DIRECT LAKE AND POOL VIEW. NEWER UPDATED OPEN KITCHEN WITH STAINLESS STEEL APPLIANCES. UPDATED BATHROOMS.LARGE ROOMS WITH TWO BIG WALK-IN CLOSETS. 2 ASSIGNED PARKING SPOTS AND AN EXTRA STORAGE BIN.24 HRS SECURITY, LOBBY ATTENDANT. CONVENIENTLY LOCATED TO SHOPPING, MAJOR ROADS AND AVENTURA.

Condo For Sale at CEDAR GLENN CONDO APTS EA

671 NE 195th St #229E, Miami, Florida 33179

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,562 Sqft
$267,000
Listing ID#A11198179
QR Code
Basic Details
Building Name : CEDAR GLENN CONDO APTS EA
Property Type : Condo
Listing Type : For Sale
Listing ID : A11198179
Price : $267,000
Original Price : $267,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,562 Sqft
Year Built : 1975
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 585
DOM : 3
Tax : $2,572
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