Brickell Listings

Features
: Yes
: Unfurnished
0
0
Property Description

LOCALIZATION!!!! GORGEOUS ONE OF A KIND 2/2.5 WITH HIGH CEILINGS IN THE LIVING ROOM. THIS HOME OFFERS A BEAUTIFUL VIEW IF THE GOLF COURSE rnTHE HOME HAS BEEN REMODELED NEW FLOORS, NEW KITCHEN CABINETS AND QUARTZ COUNTER TOPS, STAIN STEAL APPLIANCES, NEW BATHDROOMS. THIS HOME WILL NOT LAST. rnCALL LISTING AGENT. EASY TO SHOW!

Condo Sold at COUNTRY CLUB OF MIAMI CON

6762 Brookline Dr, Hialeah, Florida 33015

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,752 Sqft
$415,000
Listing ID#A11338417
QR Code
Basic Details
Building Name : COUNTRY CLUB OF MIAMI CON
Property Type : Condo
Listing Type : Sold
Listing ID : A11338417
Price : $429,900
Original Price : $445,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,752 Sqft
Year Built : 1968
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 0
DOM : 76
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