SELECT DISTINCT(p.propid),r.revs, p.reviews,if(p.reviews!="",p.reviews,r.revs) as newrev, p.category_id,p.user_id,category.name as cat_name,p.people_sleep,p.bedrooms,p.bathrooms,p.children,p.airport,p.features,p.pets,p.smoke,p.zip, p.wheelchair,p.prop_title,p.prop_desc,p.property_type,p.isilink_coid, p.isilink_prop_id, p.isilink,p.escapia, p.escapia_prop_id, prop_date,display_calender,other_url_calender,is_feature, p.min_rate, p.max_rate,p.min_week, p.max_week,p.min_month, p.max_month, p.review_rating, s.offer_start_date as special FROM property p LEFT JOIN ( SELECT propid,count(id) revs FROM review WHERE status = 1 GROUP BY `propid` ) r ON r.propid = p.propid LEFT JOIN special_offer s ON ( p.propid = s.propid ) LEFT JOIN category ON (p.category_id=category.id) LEFT JOIN effective_dates ed ON ( ed.propid = p.propid ) WHERE p.active IN("yes","d") Rent this Vacation Rentals | NYvacationrentals.com
go

Featured Vacation Rentals in New York

 
Show Big Map Show Big Map
Availability
Price Range
Bedrooms
  • Studio (1)
  • 1 Bedroom (93)
  • 2 Bedrooms (240)
  • 3 Bedrooms (310)
  • 4+ Bedrooms (255)
Bathrooms
  • 1 Bathroom (333)
  • 2 Bathrooms (364)
  • 3 Bathrooms (137)
  • 4+ Bathrooms (53)
Sleeps
  • Sleeps 1-4 (150)
  • Sleeps 5-9 (493)
  • Sleeps 10-13 (163)
  • Sleeps 14-18 (46)
  • Sleeps 19-22 (10)
  • Sleeps 23 or more (13)
Property Type
  • House (855)
  • Studio (3)
  • Apartment (35)
  • Cottage (12)
  • Cabin (21)
  • Barn (3)
  • Mansion (3)
  • Bungalow (2)
  • Chalet (3)
  • Condo (5)
  • Country House (3)
  • Lodge (1)
  • Villa (1)
  • Townhome (1)
Popular Filters
  • Deal available (0)
  • Reviewed (4)
  • Book online (18)
Rental Manager
  • All (948)
  • Property manager (18)
  • Rental owner (930)

Vacation Rentals (948)

List View Map View Favorites ()
Sort by:
New York Vacation Rentals | About Us | Owner/Manager Login
Advertise | Help | Contact Us | Privacy Policy | Terms Of Use
© Copyright 2000-Present New York Vacation Rentals, LLC. All Rights Reserved.