Vacation Rentals - Houses for Rent at Open Vacation Weeks

Refine Search

Save this search

Number of Bedrooms

Number of Bathrooms

Choose Amenities

Your search returned 0 items.

(default) 37 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `listings`	36	36	0
2	DESCRIBE `site_users`	25	25	0
3	DESCRIBE `daily_digests`	8	8	0
4	DESCRIBE `auctions`	19	19	0
5	DESCRIBE `auction_winners`	5	5	0
6	DESCRIBE `bids`	11	11	0
7	DESCRIBE `saved_listings`	3	3	0
8	DESCRIBE `saved_searches`	7	7	0
9	DESCRIBE `sent_auction_notifications`	2	2	0
10	DESCRIBE `sent_listing_notifications`	4	4	0
11	DESCRIBE `sent_offer_wall_notifications`	3	3	0
12	DESCRIBE `email_group_users`	5	5	0
13	DESCRIBE `email_groups`	4	4	0
14	DESCRIBE `admin_email_groups`	3	3	0
15	DESCRIBE `offer_wall`	25	25	0
16	DESCRIBE `payments`	14	14	0
17	DESCRIBE `listing_images`	8	8	0
18	DESCRIBE `rates`	8	8	0
19	DESCRIBE `ratings`	6	6	0
20	DESCRIBE `open_weeks`	5	5	0
21	DESCRIBE `zipcodes`	10	10	0
22	DESCRIBE `amenities`	6	6	0
23	DESCRIBE `groups`	2	2	0
24	DESCRIBE `amenities_listings`	3	3	0
25	DESCRIBE `listing_views`	5	5	0
26	DESCRIBE `site_user_owners`	5	5	0
27	DESCRIBE `listing_areas`	12	12	0
28	DESCRIBE `settings`	7	7	0
29	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1	12	12	0
30	SELECT `Auction`.`id`, `Auction`.`listing_id`, `Auction`.`site_user_id`, `Auction`.`reserve`, `Auction`.`buy_it_now`, `Auction`.`purchased`, `Auction`.`vacation_start_date`, `Auction`.`vacation_end_date`, `Auction`.`auction_start_date`, `Auction`.`auction_end_date`, `Auction`.`blind`, `Auction`.`description`, `Auction`.`bid_count`, `Auction`.`awarded`, `Auction`.`closed_notification`, `Auction`.`re_activate`, `Auction`.`display`, `Auction`.`created`, `Auction`.`modified`, `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other`, `SiteUser`.`id`, `SiteUser`.`username`, `SiteUser`.`password`, `SiteUser`.`name`, `SiteUser`.`company_name`, `SiteUser`.`address`, `SiteUser`.`city`, `SiteUser`.`state`, `SiteUser`.`zipcode`, `SiteUser`.`phone`, `SiteUser`.`email`, `SiteUser`.`cc_email`, `SiteUser`.`created`, `SiteUser`.`modified`, `SiteUser`.`active`, `SiteUser`.`marketing`, `SiteUser`.`notify_emails`, `SiteUser`.`notify_wall_emails`, `SiteUser`.`search_emails`, `SiteUser`.`group`, `SiteUser`.`accepted_terms`, `SiteUser`.`management`, `SiteUser`.`referral_code`, `SiteUser`.`remote_login_key`, `SiteUser`.`advanced_dashboard`, `AuctionWinner`.`id`, `AuctionWinner`.`auction_id`, `AuctionWinner`.`bid_id`, `AuctionWinner`.`site_user_id`, `AuctionWinner`.`created` FROM `auctions` AS `Auction` LEFT JOIN `listings` AS `Listing` ON (`Auction`.`listing_id` = `Listing`.`id`) LEFT JOIN `site_users` AS `SiteUser` ON (`Auction`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `auction_winners` AS `AuctionWinner` ON (`AuctionWinner`.`auction_id` = `Auction`.`id`) WHERE `Auction`.`auction_start_date` <= '2025-05-09' AND `Auction`.`auction_end_date` >= '2025-05-09'	0	0	1
31	SELECT `SavedSearch`.`id`, `SavedSearch`.`title` FROM `saved_searches` AS `SavedSearch` WHERE `SavedSearch`.`site_user_id` IS NULL	0	0	0
32	SELECT `Amenity`.`id`, `Amenity`.`title` FROM `amenities` AS `Amenity` WHERE id IN (27, 16, 12, 46, 32, 12, 17, 4, 1, 21, 37, 5, 14, 50) ORDER BY `id` DESC	13	13	0
33	SELECT `Auction`.`listing_id` FROM `auctions` AS `Auction` WHERE `Auction`.`auction_start_date` <= '2025-05-09' AND `Auction`.`auction_end_date` >= '2025-05-09' AND `Auction`.`awarded` = 0 AND `Auction`.`display` = 1	0	0	0
34	SELECT `Auction`.`id`, `Auction`.`listing_id`, `Auction`.`site_user_id`, `Auction`.`reserve`, `Auction`.`buy_it_now`, `Auction`.`purchased`, `Auction`.`vacation_start_date`, `Auction`.`vacation_end_date`, `Auction`.`auction_start_date`, `Auction`.`auction_end_date`, `Auction`.`blind`, `Auction`.`description`, `Auction`.`bid_count`, `Auction`.`awarded`, `Auction`.`closed_notification`, `Auction`.`re_activate`, `Auction`.`display`, `Auction`.`created`, `Auction`.`modified`, `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other`, `SiteUser`.`id`, `SiteUser`.`username`, `SiteUser`.`password`, `SiteUser`.`name`, `SiteUser`.`company_name`, `SiteUser`.`address`, `SiteUser`.`city`, `SiteUser`.`state`, `SiteUser`.`zipcode`, `SiteUser`.`phone`, `SiteUser`.`email`, `SiteUser`.`cc_email`, `SiteUser`.`created`, `SiteUser`.`modified`, `SiteUser`.`active`, `SiteUser`.`marketing`, `SiteUser`.`notify_emails`, `SiteUser`.`notify_wall_emails`, `SiteUser`.`search_emails`, `SiteUser`.`group`, `SiteUser`.`accepted_terms`, `SiteUser`.`management`, `SiteUser`.`referral_code`, `SiteUser`.`remote_login_key`, `SiteUser`.`advanced_dashboard`, `AuctionWinner`.`id`, `AuctionWinner`.`auction_id`, `AuctionWinner`.`bid_id`, `AuctionWinner`.`site_user_id`, `AuctionWinner`.`created` FROM `auctions` AS `Auction` LEFT JOIN `listings` AS `Listing` ON (`Auction`.`listing_id` = `Listing`.`id`) LEFT JOIN `site_users` AS `SiteUser` ON (`Auction`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `auction_winners` AS `AuctionWinner` ON (`AuctionWinner`.`auction_id` = `Auction`.`id`) WHERE `Auction`.`auction_start_date` <= '2025-05-09' AND `Auction`.`auction_end_date` >= '2025-05-09' AND `Auction`.`awarded` = 0 AND `Auction`.`display` = 1 AND `Auction`.`bid_count` > 0	0	0	0
35	SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` right JOIN site_users ON (`site_users`.`id` = `Listing`.`site_user_id` AND `site_users`.`active` = '1') WHERE ((`Listing`.`active` = 1) AND (`Listing`.`id` IS NULL))	1	1	0
36	SELECT `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other` FROM `listings` AS `Listing` right JOIN site_users ON (`site_users`.`id` = `Listing`.`site_user_id` AND `site_users`.`active` = '1') WHERE ((`Listing`.`active` = 1) AND (`Listing`.`id` IS NULL)) ORDER BY `Listing`.`city` asc LIMIT 10	0	0	0
37	SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `listings` AS `Listing` ON (`Auction`.`listing_id` = `Listing`.`id`) LEFT JOIN `site_users` AS `SiteUser` ON (`Auction`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `auction_winners` AS `AuctionWinner` ON (`AuctionWinner`.`auction_id` = `Auction`.`id`) WHERE `Auction`.`auction_end_date` >= '2025-05-09' AND `Auction`.`auction_start_date` <= '2025-05-09'	1	1	0

(ownerware) 2 queries took 0 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `events_property`		35	35	0
2	DESCRIBE `listings`		32	32	0

Auction Search Results

Refine Search

Prize Details