Size: All Sizes Studio 1 Bedroom 2 Bedroom 3+ Bedroom Area: All Areas East Above 14th Street South of 14th Street West Above 14th Street Rent: All Prices Less than $2000 2000 to $3000 3000 to $4000 $4000+ Sort By: Rent Bedroom Location Available Date Recently Posted Search for Building 121 Reade Street 50 Prince Street 284 Mott Street 10 Jones Street 12 East 22 Street 239 Park Avenue South 295 Park Avenue South 214 East 24th Street 382 3rd Avenue 207 East 27th Street 230 East 30th Street 433 West 43rd Street 237 East 53rd Street 239 East 53rd Street 123 East 54th Street 880 Lexington Avenue 882 Lexington Avenue 229 East 67th Street 425 East 80th Street 429 East 80th Street 104 Suffolk Street Sort By: Rent Bedroom Location Available Date Recently Posted  Last updated on 3/10/10

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 'AND Apartments.Buildingid = Buildings.BuildingId And Apartments.AreaId = Areas.A' at line 1