Brickell Listings

Features
: Restrictions Or Possible Restrictions
: Unfurnished
1
1
Property Description

2 BEDROOMS AND 2 BATHS APARTMENT, IN A RESORT STYLE GATED COMMUNITY, WITH A BEAUTIFUL CLUB HOUSE, POOL, GYM, PLAYGROUND, 24 HRS SECURITY, RESTAURANT, TENNIS, BASKETBALL, AND GOLF COURT. RENTAL PAYMENT INCLUDES BASIC CABLE TV, WATER, AND TRASH REMOVAL. EXCELLENT SCHOOLS, CLOSE TO AIRPORT, EASY ACCESS TO PALMETTO, TURNPIKE, AND SHOPPING MALLS. AVAILABLE STARTING JUNE 15TH.

Condo For Rent at DORAL PK CO CLUB VILLAS C

4750 NW 102nd Ave #104-17, Doral, Florida 33178

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 827 Sqft
$2,700
Listing ID#A11572116
QR Code
Basic Details
Subdivision : 4750 NW 102nd
Building Name : DORAL PK CO CLUB VILLAS C
Property Type : Condo
Listing Type : For Rent
Listing ID : A11572116
Price : $2,700
Original Price : $2,700
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 827 Sqft
Year Built : 1989
Property Sub Type : Condominium
DOM : 0
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