Brickell Listings

Features
: In Ground
: Partially
1
1
Property Description

APARTMENT FURNISHED OR UNFURNISHED, EXCELLENT LOCATION, FULL OF NATURAL LIGHT, REMODELED, NICE POOL, CLOSE TO FIU, BARRY UNIVERSITY, NOVA UNIVERISTY AND COLLEGES, NEXT TO BISCAYNE BLV, AVENTURA MALL, BAL HARBOUR MALL, PLAZAS AND SHOPS, BEACHES, I95 AND OTHER HIGHWAYS, NEXT TO FT. LAUDERDALE AND MIAMI INTERNATIONAL AIRPORT

Condo For Rent at THREE HORIZONS NORTH COND

1470 NE 125th Ter #510, North Miami, Florida 33161

  • Bedrooms : 1
  • Bathrooms : 1
  • Square Footage: 875 Sqft
$1,780
Listing ID#A11553006
QR Code
Basic Details
Subdivision : 1470 NE 125th
Building Name : THREE HORIZONS NORTH COND
Property Type : Condo
Listing Type : For Rent
Listing ID : A11553006
Price : $1,780
Original Price : $1,850
Bedrooms : 1
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 875 Sqft
Year Built : 1970
Property Sub Type : Condominium
DOM : 32
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