SQL error #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 2 AND (STR_NUM LIKE '%2399%') AND STR_NAME LIKE('%Collins Av%') AND IM_SQFT>' at line 1.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sbr123i/public_html/904353w/require/search_sorts.php on line 19

SQL error #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 2 AND (STR_NUM LIKE '%2399%') AND STR_NAME LIKE('%Collins Av%') AND IM_SQFT>' at line 1.

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/sbr123i/public_html/904353w/require/search_sorts.php on line 30

The Gansevoort

The condos at The Gansevoort South Beach come with really nice kitchens with granite counters, Sub-Zero Refrigerator and Stainless Steel appliances; the bathrooms are beautiful and it also comes with Bosch washer and dryer inside the unit. All the apartments come unfurnished, the prices are non negotiable but they are really good for what it is, you really feel like you are in a resort. Also, the rent includes the AC, one David Barton Gym membership, 1 valet parking and they allow pets. What a great deal ! This building is brand new, totally renovated with amazing pools and amenities, it is worth it ! Click here to see units for sale in this building.