Brickell Listings

Features
: Furnished
0
0
Property Description

The owner is only renting one bedroom and one bathroom of the house, the main door entrance will be share , but you will have a private bedroom/bathroom, the room is furniture with bed, closet, small refrigerator and microwave, tenant is not supposed to be cooking inside the bedroom, one space for parking will be provided. Very close to 826. The House will be only share with the owner.

Condo For Rent at PALM SPRINGS LAKES TOWNHO

7210 W 18th Ave, Hialeah, Florida 33014

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 1,408 Sqft
$900
Listing ID#A11572043
QR Code
Basic Details
Subdivision : 7210 W 18th
Building Name : PALM SPRINGS LAKES TOWNHO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11572043
Price : $900
Original Price : $900
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 1,408 Sqft
Year Built : 1972
Property Sub Type : Townhouse
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