Really Big House
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]

Really Big House

820 S. Ocean Blvd., Manalapan, FL 33462

(Palm Beach)

9 Beds | 8 Bathrooms | 22 sqft

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

Newly built magnificent Mediterranean estate with the finest of finishes and amenities. Situated ...

(default) 44 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `listings`36361
2DESCRIBE `site_users`25251
3DESCRIBE `daily_digests`880
4DESCRIBE `auctions`19190
5DESCRIBE `auction_winners`550
6DESCRIBE `bids`11110
7DESCRIBE `saved_listings`330
8DESCRIBE `saved_searches`770
9DESCRIBE `sent_auction_notifications`220
10DESCRIBE `sent_listing_notifications`440
11DESCRIBE `sent_offer_wall_notifications`330
12DESCRIBE `email_group_users`550
13DESCRIBE `email_groups`440
14DESCRIBE `admin_email_groups`330
15DESCRIBE `offer_wall`25250
16DESCRIBE `payments`14140
17DESCRIBE `listing_images`880
18DESCRIBE `rates`880
19DESCRIBE `ratings`660
20DESCRIBE `open_weeks`550
21DESCRIBE `zipcodes`10100
22DESCRIBE `amenities`661
23DESCRIBE `groups`220
24DESCRIBE `amenities_listings`330
25DESCRIBE `listing_views`550
26DESCRIBE `site_user_owners`550
27DESCRIBE `listing_areas`12120
28DESCRIBE `settings`770
29SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
30SELECT `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` = 'florida' LIMIT 1001
31SELECT `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-06-30' AND `Auction`.`auction_end_date` >= '2025-06-30' 000
32SELECT `SavedSearch`.`id`, `SavedSearch`.`title` FROM `saved_searches` AS `SavedSearch` WHERE `SavedSearch`.`site_user_id` IS NULL 000
33SELECT `Amenity`.`id`, `Amenity`.`title` FROM `amenities` AS `Amenity` WHERE 1 = 1 ORDER BY `title` asc 57570
34SELECT `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-06-30' AND `Auction`.`auction_end_date` >= '2025-06-30' AND `Auction`.`awarded` = 0 AND `Auction`.`display` = 1 AND `Auction`.`bid_count` > 0 000
35SELECT 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%')) 111
36SELECT `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%')) ORDER BY `Listing`.`getaway_price` asc LIMIT 80, 10111
37SELECT `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` = (216) 12120
38SELECT `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
39SELECT `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-06-30' AND `Auction`.`auction_end_date` >= '2025-06-30' AND `Auction`.`awarded` = 0 GROUP BY `Listing`.`id` 001
40SELECT `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-06-30 440
41SELECT `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' LIMIT 1110
42SELECT 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-06-30' AND `Auction`.`auction_start_date` <= '2025-06-30' 110
43SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
44SELECT `AmenitiesListing`.`id`, `AmenitiesListing`.`amenity_id` FROM `amenities_listings` AS `AmenitiesListing` WHERE `AmenitiesListing`.`listing_id` = 216 AND `AmenitiesListing`.`amenity_id` IN (50, 4, 1) 110
(ownerware) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `events_property`35351
2DESCRIBE `listings`32321