Brickell Listings

Features
: Unfurnished
5
1
Property Description

Beautiful house in the area of West Kendall. Closed gated desirable community of San Jose, near by County Walk. Very good schools near by and grocery stores and banks 4/2 + den perfect for an office. Also the garage its close perfect to use as an extra bedroom or playroom area. Very nice open Kitchen with all appliances. Big family open area Update bathrooms Laundry room with new Washer and dryer room A lot of storage space Big open backyard

Single Family Home For Rent OAK CREEK NORTH REPLAT1,766 Sqft

15439 SW 141st St, Miami, Florida 33196

  • Bedrooms : 4
  • Bathrooms : 2
  • Square Footage: 1,766 Sqft
$3,700
Listing ID#A11566718
QR Code
Basic Details
Building Name : OAK CREEK NORTH REPLAT
Property Type : Single Family Home
Listing Type : For Rent
Listing ID : A11566718
Price : $3,700
Original Price : $3,800
Bedrooms : 4
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,766 Sqft
Year Built : 1999
Property Sub Type : Single Family Residence
DOM : 20
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