Brickell Listings

Features
: Other View
: Restrictions Or Possible Restrictions
: Unfurnished
2
2
Property Description

4 BEDROOM/3 BATHS TOWNHOUSE ON THE LAKE. GATED-COMMUNITY, CLOSE TO EVERYTHING. TILE FLOORS IN THE FIRST FLOOR AND CARPET ON THE BEDROOMS. COMMUNITY HAS 24HR SECURITY, POOL, CLUB HOUSE, JOGGING TRAILS, ETC…

Condo Sold at CHAMPION LAKES

381 NE 194th Ln, Miami, Florida 33179

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,920 Sqft
$588,000
Listing ID#A11402991
QR Code
Basic Details
Building Name : CHAMPION LAKES
Property Type : Condo
Listing Type : Sold
Listing ID : A11402991
Price : $595,000
Original Price : $630,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,920 Sqft
Year Built : 2015
Property Sub Type : Townhouse
Assoc Fee Frequency : Monthly
Association Fee : 653
DOM : 126
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