Brickell Listings

Features
: Ocean View
: Restrictions Or Possible Restrictions
1
1
Property Description

OCEAN FRONT!! BOUTIQUE BLDG. WRAP AROUND TERRACE WITH VIEWS OF OCEAN AND CITY VIEWS. RECENTLY PAINTED and RECENT FLOORING!! LARGE CAPACITY WASHER AND DRYER IN UNIT. AT THE WAVERLY SURFSIDE YOU WILL ENJOY 2 SWIMMING POOLS BEACH FRONT SWIMMING POOL AND A SUNSET SWIMMING POOL . WALK TO BAL HARBOUR SHOPS, PUBLIX, HOUSES OF WORSHIP. STATE OF THE ART GYM, POOL, COVERED
GARAGE. SELLER FINANCING AVAILABLE.

Condo For Sale at THE WAVERLY AT SURFSIDE B

9201 Collins Ave #921, Surfside, Florida 33154

  • Bedrooms : 2
  • Bathrooms : 2
  • Square Footage: 1,002 Sqft
$869,000
Listing ID#A11028243
QR Code
Basic Details
Subdivision : 9201 Collins
Building Name : THE WAVERLY AT SURFSIDE B
Property Type : Condo
Listing Type : For Sale
Listing ID : A11028243
Price : $869,000
Original Price : $869,000
Bedrooms : 2
Bathrooms : 2
Half Bathrooms : 0
Square Footage : 1,002 Sqft
Year Built : 2003
Property Sub Type : Condominium
Assoc Fee Frequency : Monthly
Association Fee : 0
DOM : 1084
Tax : $7,516
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