Water's Edge
View Details
Notice (8): Undefined variable: endDateSet [APP/views/elements/facades/listings/listing_result_row.ctp, line 30]
Notice (8): Undefined index: Rate [APP/views/elements/facades/listings/listing_result_row.ctp, line 78]
Warning (2): Invalid argument supplied for foreach() [APP/views/elements/facades/listings/listing_result_row.ctp, line 78]

Water's Edge

142 Geoff Wilder Lane, Seacrest, FL 32413

(Gulf Coast, Florida Panhandle)

4 Beds | 3 Bathrooms | 2351 sqft

Notice (8): Undefined variable: listing [APP/views/elements/facades/listings/listing_result_row.ctp, line 342]
| Owner Operated

Water’s Edge is a stunning, modern and crisp gulf front home with a private heated pool. This bea...

Zoe Carriage House
View Details

Zoe Carriage House

17 Tuckers Lane, Rosemary Beach, FL 32413

(Florida Panhandle, Gulf Coast)

1 Beds | 1 Bathrooms | Owner Operated

Cozy one bedroom/one bath carriage house located on the north side of 30A, convenient to the Rose...

2 The Beach House - 4 Bedroom
View Details

2 The Beach House - 4 Bedroom

35 Wiggle Lane, Rosemary Beach, FL 32413

(Gulf Coast, Florida Panhandle)

4 Beds | 5 Bathrooms | Owner Operated

Newly expanded to include an additional bedroom, 2 additional baths, second kitchen and second li...

(default) 20 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
2SELECT `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`, `Payment`.`id`, `Payment`.`site_user_id`, `Payment`.`listing_id`, `Payment`.`invoice_number`, `Payment`.`auth_id`, `Payment`.`transaction_id`, `Payment`.`subscription_id`, `Payment`.`subscription_text`, `Payment`.`subscription_code`, `Payment`.`amount`, `Payment`.`response_reason_code`, `Payment`.`response_reason_text`, `Payment`.`terms`, `Payment`.`created` FROM `listings` AS `Listing` LEFT JOIN `site_users` AS `SiteUser` ON (`Listing`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `payments` AS `Payment` ON (`Payment`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`seo_title` = 'south-florida' LIMIT 1001
3SELECT `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-07-01' AND `Auction`.`auction_end_date` >= '2025-07-01' 001
4SELECT `SavedSearch`.`id`, `SavedSearch`.`title` FROM `saved_searches` AS `SavedSearch` WHERE `SavedSearch`.`site_user_id` IS NULL 000
5SELECT `Amenity`.`id`, `Amenity`.`title` FROM `amenities` AS `Amenity` WHERE 1 = 1 ORDER BY `title` asc 57570
6SELECT `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-07-01' AND `Auction`.`auction_end_date` >= '2025-07-01' AND `Auction`.`awarded` = 0 AND `Auction`.`display` = 1 AND `Auction`.`bid_count` > 0 000
7SELECT 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`.`seo_url` like 'florida-rentals/south-florida%')) 110
8SELECT `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`.`seo_url` like 'florida-rentals/south-florida%')) ORDER BY `Listing`.`getaway_price` asc LIMIT 20, 10331
9SELECT `ListingImage`.`id`, `ListingImage`.`listing_id`, `ListingImage`.`thumb`, `ListingImage`.`orig`, `ListingImage`.`rotate`, `ListingImage`.`created`, `ListingImage`.`modified`, `ListingImage`.`file_hash` FROM `listing_images` AS `ListingImage` WHERE `ListingImage`.`listing_id` IN (159, 168, 169) 29290
10SELECT `Listing`.`id`, `Listing`.`title`, `Listing`.`active`, `Listing`.`getaway_price`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`getaway`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`area`, `ListingImage`.`id`, `ListingImage`.`thumb`, `ListingImage`.`listing_id`, `Listing`.`latitude`, `Listing`.`longitude` FROM `listings` AS `Listing` left JOIN listing_images AS `ListingImage` ON (`ListingImage`.`id` = `Listing`.`primary_image_id`) WHERE `Listing`.`active` = 1 1611611
11SELECT `Auction`.`id`, `Auction`.`listing_id`, `Auction`.`site_user_id`, `Auction`.`reserve`, `Auction`.`buy_it_now`, `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`.`created`, `Auction`.`modified`, `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`primary_image_id`, `Listing`.`created`, `Listing`.`modified`, `ListingImage`.`id`, `ListingImage`.`listing_id`, `ListingImage`.`thumb`, `Listing`.`latitude`, `Listing`.`longitude` FROM `auctions` AS `Auction` inner JOIN listings AS `Listing` ON (`Listing`.`id` = `Auction`.`listing_id` AND `Listing`.`active` = 1) left JOIN listing_images AS `ListingImage` ON (`ListingImage`.`id` = `Listing`.`primary_image_id`) WHERE `Auction`.`auction_start_date` <= '2025-07-01' AND `Auction`.`auction_end_date` >= '2025-07-01' AND `Auction`.`awarded` = 0 GROUP BY `Listing`.`id` 001
12SELECT `Listing`.`id`, `Listing`.`title`, `Listing`.`active`, `Listing`.`getaway_price`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`getaway`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`area`, `ListingImage`.`id`, `ListingImage`.`thumb`, `ListingImage`.`listing_id`, `Listing`.`latitude`, `Listing`.`longitude` FROM `listings` AS `Listing` left JOIN listing_images AS `ListingImage` ON (`ListingImage`.`id` = `Listing`.`primary_image_id`) WHERE `Listing`.`active` = 1 AND `Listing`.`getaway` = 1 AND `Listing`.`getaway_from_date` >= 2025-07-01 441
13SELECT `ListingAreas`.`id`, `ListingAreas`.`name`, `ListingAreas`.`url`, `ListingAreas`.`description`, `ListingAreas`.`metatitle`, `ListingAreas`.`metakeywords`, `ListingAreas`.`metadescription`, `ListingAreas`.`property_title`, `ListingAreas`.`parent_id`, `ListingAreas`.`zip_codes`, `ListingAreas`.`property_count`, `ListingAreas`.`property_count_this_only` FROM `listing_areas` AS `ListingAreas` WHERE `ListingAreas`.`url` = 'florida-rentals/south-florida' LIMIT 1110
14SELECT 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-07-01' AND `Auction`.`auction_start_date` <= '2025-07-01' 110
15SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
16SELECT `AmenitiesListing`.`id`, `AmenitiesListing`.`amenity_id` FROM `amenities_listings` AS `AmenitiesListing` WHERE `AmenitiesListing`.`listing_id` = 159 AND `AmenitiesListing`.`amenity_id` IN (50, 4, 1) 110
17SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
18SELECT `AmenitiesListing`.`id`, `AmenitiesListing`.`amenity_id` FROM `amenities_listings` AS `AmenitiesListing` WHERE `AmenitiesListing`.`listing_id` = 168 AND `AmenitiesListing`.`amenity_id` IN (50, 4, 1) 000
19SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
20SELECT `AmenitiesListing`.`id`, `AmenitiesListing`.`amenity_id` FROM `amenities_listings` AS `AmenitiesListing` WHERE `AmenitiesListing`.`listing_id` = 169 AND `AmenitiesListing`.`amenity_id` IN (50, 4, 1) 000
(ownerware) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)