Townhouse in the New Community The Riviera. Comfortable and open floor plan, three bedrooms, 2.5 bathrooms. Stainless steel kitchen appliances. Hurricane panels, tankless water heater, Ring doorbell. Close to shopping, restaurants, schools, grocery shops, pharmacy, and easy access to Florida’s turnpike. Great Casa Club. XL Washer and dryer inside the unit. Ceramic floor 1st floor and Laminate 2nd floor. Easy to show.
Home For Rent at 1,483 Sqft
1860 SE 26th Ter, Homestead, Florida 33035
- Bedrooms : 3
- Bathrooms : 3
- Square Footage: 1,483 Sqft
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
- Prev
- Result of 571
- Yanai Nassar
- View website
- 786.771.3005
- 786-426-9484
- 786-226-0970
-
brickellmania@gmail.com