Brickell Listings

Features
: Unfurnished
0
0
Property Description

Discover the perfect one-bedroom unit with stunning views of the lake. Enjoy the luxurious tile and wood floors, fresh paint, and central air conditioning. This gated community is located in a prime location, just minutes away from schools, shops, and the highway. Don’t miss out on this incredible opportunity to live in a beautiful and convenient location.

Condo For Rent at LAKEVIEW GARDENS AT MIAMI

17530 NW 68th Ave #C3010, Hialeah, Florida 33015

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 660 Sqft
$1,850
Listing ID#A11482933
QR Code
Basic Details
Subdivision : 17530 NW 68th
Building Name : LAKEVIEW GARDENS AT MIAMI
Property Type : Condo
Listing Type : For Rent
Listing ID : A11482933
Price : $1,850
Original Price : $1,850
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 660 Sqft
Year Built : 1972
Property Sub Type : Condominium
DOM : 127
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 `googlemap_ln` <= -80.18469409415071 AND `googlemap_lt` <= 25.816874338565697 AND `googlemap_ln` >= -80.29542151169854 AND `googlemap_lt` >= 25.70319268375598 AND `zip_name` IN ('33131','33130','33129','33135','33133','33145','33132','33137') AND `confirmed` = '1' AND `finalized` = '1' AND `deleted` = '0' AND `expired` = '0' AND `kind` = '0' ORDER BY p.price_si ASC , p.id ASC LIMIT , 1

Agent info
Brickellmania LLC
3011 SW 24 ST. Miami Fl 33145
Contact Agent