Brickell Listings

Features
: In Ground
: Pool , Garden
: Yes
: Furnished , Furniture Negotiable
7
4
Property Description

Welcome to Casa Palma Real, a contemporary slice of paradise Costa Rica surrounded by beautiful mature landscaping w/ 16 royal palms on a tree-lined 1+ acre lot. Total sq ft 6106. A paradise for entertaining. There are two kitchens and two full laundry rooms. Main house is 1 story w/loft & expansive floor plan w/ tall ceilings, multiple wings great for the multi-generational family, maid/in law, art/musician studio. Expanded covered terrace w/ bbq & Brand New custom Pool Deck & Jacuzzi made from Dominican Coral & new Permitted Pool House/Cabana w/ 4 car garage & unfinished 2nd story possible for expansion. 60 solar panels. Storage Shed, huge green space, quiet dead end street, circular driveway w/ port cochere. Easy access to Turnpike, I-75. SR 826 & OPF Executive Airport.

Single Family Home For Sale FLORIDA FRUIT LAND COMPANY5,274 Sqft

10050 NW 135th St, Hialeah Gardens, Florida 33018

  • Bedrooms : 5
  • Bathrooms : 5
  • Square Footage: 5,274 Sqft
$2,750,000
Listing ID#A11408612
QR Code
Basic Details
Building Name : FLORIDA FRUIT LAND COMPANY
Property Type : Single Family Home
Listing Type : For Sale
Listing ID : A11408612
Price : $2,750,000
Original Price : $2,900,000
Bedrooms : 5
Bathrooms : 5
Half Bathrooms : 1
Square Footage : 5,274 Sqft
Year Built : 1981
Property Sub Type : Single Family Residence
DOM : 207
Tax : $10,694
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