Brickell Listings

Features
: Heated , Automatic Chlorination , In Ground
: Other
: Yes
: Unfurnished
0
0
Property Description

Beautiful and upgraded home with the lowest price in the desired Country Club of Miami, Large fenced patio, with a heated pool, and Tiki Hut, which is great for entertaining. Marble floors and granite counters. Impact windows. Garage was converted into an extra room. Large paved circular driveway. Room for boat or RV. No HOA.

Single Family Home For Sale COUNTRY CLUB OF MIAMI EST1,983 Sqft

18620 W Oakmont Dr, Hialeah, Florida 33015

  • Bedrooms : 4
  • Bathrooms : 3
  • Square Footage: 1,983 Sqft
$1,149,000
Listing ID#A11513628
QR Code
Basic Details
Building Name : COUNTRY CLUB OF MIAMI EST
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11513628
Price : $1,149,000
Original Price : $1,249,000
Bedrooms : 4
Bathrooms : 3
Half Bathrooms : 1
Square Footage : 1,983 Sqft
Year Built : 1980
Property Sub Type : Single Family Residence
DOM : 57
Tax : $6,998
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