Brickell Listings

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

Welcome to this charming 1 bedroom and 1 bathroom bungalow nestled in the serene Redlands area. This updated abode exudes warmth and character, boasting a cozy ambiance that feels like home from the moment you step inside. The fully fenced yard offers both privacy and security, making it perfect for enjoying the outdoors or simply unwinding in peace. Don’t miss the opportunity to make this adorable retreat your own. Schedule your showing today.

Single Family Home For Rent REDLAND CITRUS ORCHARDS S

22753 SW 154th Ave, Miami, Florida 33170

  • Bedrooms : 1
  • Bathrooms : 1
$1,700
Listing ID#A11570936
QR Code
Basic Details
Building Name : REDLAND CITRUS ORCHARDS S
Property Type : Single Family Home
Listing Type : For Rent
Listing ID : A11570936
Price : $1,700
Original Price : $1,700
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Year Built : 1945
Property Sub Type : Single Family Residence
DOM : 2
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