Brickell Listings

Features
: Community
: Unfurnished
0
0
Property Description

Beautiful 3/3 – 2 Story Townhome in Water Stone MARBELLA COVE Gated Community including Clubhouse, Pool, Exercise Room, Walking Trail, Security, landscaping and a lot more. Washer/Dryer inside the unit. Fresh paint, wood floor. Close to Expressway and Shopping Centers, next to Walmart, Publix and Target. Centrally located in the City of Homestead, close to Bayfront park Marina and Homestead Hospital.

Condo For Rent at MARBELLA COVE

2306 NE 42nd Cir, Homestead, Florida 33033

  • Bedrooms : 3
  • Bathrooms : 3
  • Square Footage: 1,428 Sqft
$2,500
Listing ID#A11505493
QR Code
Basic Details
Subdivision : 2306 NE 42nd
Building Name : MARBELLA COVE
Property Type : Condo
Listing Type : For Rent
Listing ID : A11505493
Price : $2,500
Original Price : $2,600
Bedrooms : 3
Bathrooms : 3
Half Bathrooms : 0
Square Footage : 1,428 Sqft
Year Built : 2003
Property Sub Type : Townhouse
DOM : 34
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