Brickell Listings

Features
: Other , In Ground , Community
: Lake
: Restrictions Or Possible Restrictions , No
: Unfurnished
0
0
Property Description

Impeccably Maintained 2 Bedroom, 1 Bathroom Lakefront Townhome in the Desirable Palm Point Hammocks Community. Charming two-story lot and block residence with breathtaking views of the lush green areas and lake from both your backyard and the screened-in balcony upstairs. Palm Point boasts ample guest parking, a community pool, direct access to trails, and nearby shopping centers within walking distance. Take pleasure in the various community events offered by The Hammocks, along with the numerous perks of residing in this area. Application attached. Pets not allowed per owner’s discretion.

Condo For Rent at PALM POINT AT THE HAMMOCKS,PALM POINT

10540 SW 154TH Ct #7, Miami, Florida 33196

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,076 Sqft
$2,600
Listing ID#A11556265
QR Code
Basic Details
Subdivision : 10540 SW 154TH
Building Name : PALM POINT AT THE HAMMOCKS,PALM POINT
Property Type : Condo
Listing Type : For Rent
Listing ID : A11556265
Price : $2,600
Original Price : $2,600
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 1
Square Footage : 1,076 Sqft
Year Built : 1987
Property Sub Type : Townhouse
DOM : 5
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