Brickell Listings

Features
: Unfurnished
2
2
Property Description

Beautiful 2000 sqft+ house for rent in the heart of North Miami Beach. Spacious 4 bedrooms and 3 bathrooms. This house has been fully renovated, with a gorgeous high end kitchen, new roof, impact windows and doors and more. Plenty of outdoor living space, perfect for a family and entertaining. Close to all houses of worship, the 95, Aventura Mall etc. Please reach out to make this home yours!

Single Family Home For Rent HIGHLAND MANOR SEC 11,577 Sqft

17815 NE 7th Ct, Miami, Florida 33162

  • Bedrooms : 3
  • Bathrooms : 2
  • Square Footage: 1,577 Sqft
$4,000
Listing ID#A11557579
QR Code
Basic Details
Building Name : HIGHLAND MANOR SEC 1
Property Type : Single Family Home
Listing Type : For Rent
Listing ID : A11557579
Price : $4,000
Original Price : $4,000
Bedrooms : 3
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,577 Sqft
Year Built : 1959
Property Sub Type : Single Family Residence
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