Brickell Listings

Features
: Community
: Restrictions Or Possible Restrictions
: Unfurnished
1
1
Property Description

Nice apartment, freshly painted 2 bedrooms and 1 bathroom. Newly installed bathroom and wood floor. Hurricane windows already purchased and will be installed in two months. Excellent Open views towards the Creek East Environmental Preserve and the Oleta River. Trails for biking, jogging also the facilities for kayaking. Beautiful area to live, combination of nature, sports and a spectacular area of shopping/restaurant. Central location, close to A1A and I95, minutes from FIU, Barry University, Bal Harbor and Aventura shopping Mall.

Condo For Rent at VECINO DEL MAR CONDO

2350 NE 135th St #914, North Miami, Florida 33181

  • Bedrooms : 2
  • Bathrooms : 1
  • Square Footage: 918 Sqft
$2,300
Listing ID#A11564086
QR Code
Basic Details
Subdivision : 2350 NE 135th
Building Name : VECINO DEL MAR CONDO
Property Type : Condo
Listing Type : For Rent
Listing ID : A11564086
Price : $2,300
Original Price : $2,300
Bedrooms : 2
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 918 Sqft
Year Built : 1980
Property Sub Type : Condominium
DOM : 9
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