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") AND ( p.bedrooms="2" ) AND ( (p.people_sleep >= 1 AND p.people_sleep <= 4) ) AND p.category_id IN (2433,9710,9705,2435,2436,2437,2438,2439,2440,2441,2442,2443,2444,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,2467,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2445,2446,2447,2448,2449,2450) Catskills Vacation Rentals, Catskills New York Vacation Rental Homes, NYvacationrentals.com
go
New York Vacation Rentals New York Catskills Vacation Rentals

Featured Vacation Rentals in New York

 
Show Big Map Show Big Map
Availability
Price Range
Bedrooms
  • Studio (1)
  • 1 Bedroom (6)
  • 2 Bedrooms (10)
  • 3 Bedrooms (1)
  • 4+ Bedrooms (0)
Bathrooms
  • 1 Bathroom (8)
  • 2 Bathrooms (2)
  • 3 Bathrooms (0)
  • 4+ Bathrooms (0)
Sleeps
  • Sleeps 1-4 (10)
  • Sleeps 5-9 (9)
  • Sleeps 10-13 (0)
  • Sleeps 14-18 (0)
  • Sleeps 19-22 (0)
  • Sleeps 23 or more (0)
Property Type
  • Cabin (3)
  • House (4)
  • Country House (1)
  • Apartment (1)
  • Barn (1)
Popular Filters
  • Deal available (0)
  • Reviewed (0)
  • Book online (0)
Rental Manager
  • All (10)
  • Property manager (0)
  • Rental owner (10)

Catskills Vacation Rentals (10)

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.