Brickell Listings

Features
: Other View
: No
0
0
Property Description

Wonderful Collins Ave studio, only 1 block from the beach, fully furnished. Located next to high end restaurants, hotels and more. Fully AirBnB approved condos with daily rentals allowed.

Condo For Sale at OCEAN VILLAS CONDO

3700 Collins Ave #S-309, Miami Beach, Florida 33140

  • Bathrooms : 1
  • Square Footage: 300 Sqft
$285,000
Listing ID#A11519426
QR Code
Basic Details
Building Name : OCEAN VILLAS CONDO
Property Type : Condo
Listing Type : For Sale
Listing ID : A11519426
Price : $285,000
Original Price : $285,000
Bathrooms : 1
Half Bathrooms : 0
Square Footage : 300 Sqft
Year Built : 1938
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 620
DOM : 0
Tax : $2,589
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