Yellow House

42 Montgomery St. , Seagrove Beach , FL 32459

  • 1 Star
  • 2 Star
  • 3 Star
  • 4 Star
  • 5 Star
  • ratings Star (
    Notice (8): Array to string conversion [APP/views/elements/facades/ratings/display_ratings.ctp, line 5]
    
    Array ratings)
0 ratings

This charming, renovated, 4 bedroom/3.5 bath gulf front home is located south of 30-A on quiet side street and sleeps up to 12 people. Sitting directly on the gulf in Seagrove Beach just one half mile east of Seaside, Yellow House has its own private steps to the beach. This 2,180 square foot home is all on one level making for easy access for all ages.

Outdoor Features: Outdoor shower and foot wash for beach cleanup. Parking for 3 cars in the gravel driveway. Gas BBQ grill. Screened porch on the gulf front. Large expansive decks with ample seating span the house on the gulf side allow for lounging “up top” when others are on the beach. Great place for grandparents to watch over all the action in the sand and water.

Inside Features: Large combination family room/dining room/kitchen, all overlooks gulf. Tiled floors and ceiling fans throughout. Large, bright, open kitchen features stainless frig with icemaker, dishwasher, range, microwave, TV, corian countertops, and a long breakfast bar with barstool seating for 6. Dining table seats 6 more, plus an additional side table can seat another 4. Family room seating includes comfortable queen sleeper sofa, love seat and 3 comfortable side chairs (one with ottoman). Other features include a work desk with leather office chair, 56” LCD TV, Blue Ray DVD, digital cable, Direct TV, stereo and high speed wireless internet connectivity. Yellow House provides free long distance usage. Built-in cabinetry in the living room showcases the family’s 50 year history of vacationing in this home. Convenient half bath off kitchen. Large laundry room with full size washer/dryer.

Two bedrooms are on each side of the family room making this house perfect for two families to share and have some privacy. Queen master bedroom has a beautiful gulf view, 40” TV, Digital cable, and Direct TV. Private tiled bathroom with vanity sink and tub/shower. Kid’s bedroom features four twin beds (one is a trundle), TV/VCR/DVD and gulf views. Tiled hall bath with vanity sink and shower.

On the other side of the family room, two more queen bedrooms share an adjoining tiled bath with vanity sink and shower. One bedroom has gulf views. Each bedroom has chest of drawers, closet, bedside lamps, bedside tables and TVs.

Vacation Property Features:
Kitchen
  • Full Kitchen
Outdoor Features
  • Gas Grill
Communications
  • Cable/Satellite TVs,
  • Wireless Internet Access
Suitability
  • Non-smoking,
  • Handicap Access
Activities Available
  • Water Skiing,
  • Fishing
Other Features
  • Screened Porch,
  • Washer/Dryer
Property Location/View
  • Gulf Front
Payment Method
  • Visa,
  • Mastercard,
  • Check,
  • Discover
Additional Features

Beds: 3Q, 4T, QSS

Map and Location Information

42 Montgomery St., Seagrove Beach, FL 32459

Property Details

Listing No#: 166
Bedrooms: 4
Bathrooms: 3
Sleeps: 12
Square Feet: 2189
Area: Florida Panhandle, Gulf Coast

Rates

From To Weekly Nightly
Summer 2010
05/29/2010
08/06/2010 $4190 $660
Late Summer 2010
08/07/2010
09/05/2010 $3350 $525
Fall 2010
09/06/2010
10/31/2010 $2515 $395
Winter 2010 (Nov)
11/01/2010
11/19/2010 $2095 $330
Thanksgiving 2010
11/20/2010
11/27/2010 $2515 $395
Winter 2010 (Dec)
11/28/2010
12/18/2010 $2095 $330
Christmas Holidays 2010
12/18/2010
01/01/2011 $2515 $395
(default) 53 queries took 42 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`660
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` = 'yellow-house-' LIMIT 1111
31SELECT `Zipcode`.`id`, `Zipcode`.`zipcode`, `Zipcode`.`zip_type`, `Zipcode`.`city_name`, `Zipcode`.`city_type`, `Zipcode`.`state_name`, `Zipcode`.`state_abbr`, `Zipcode`.`area_code`, `Zipcode`.`latitude`, `Zipcode`.`longitude` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zipcode` = (166) 0020
32SELECT `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` FROM `auctions` AS `Auction` WHERE `Auction`.`listing_id` = (166) 000
33SELECT `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` = (166) 12120
34SELECT `Rate`.`id`, `Rate`.`site_user_id`, `Rate`.`listing_id`, `Rate`.`title`, `Rate`.`from_date`, `Rate`.`to_date`, `Rate`.`weekly`, `Rate`.`nightly` FROM `rates` AS `Rate` WHERE `Rate`.`listing_id` = (166) 770
35SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (166) 000
36SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = (166) 000
37SELECT `OpenWeeks`.`id`, `OpenWeeks`.`listing_id`, `OpenWeeks`.`open_dates`, `OpenWeeks`.`has_open_dates`, `OpenWeeks`.`updated` FROM `open_weeks` AS `OpenWeeks` WHERE `OpenWeeks`.`listing_id` = (166) 000
38SELECT `Amenity`.`id`, `Amenity`.`title`, `Amenity`.`group_id`, `Amenity`.`show_on_offer_wall`, `Amenity`.`created`, `Amenity`.`modified`, `AmenitiesListing`.`id`, `AmenitiesListing`.`amenity_id`, `AmenitiesListing`.`listing_id` FROM `amenities` AS `Amenity` JOIN `amenities_listings` AS `AmenitiesListing` ON (`AmenitiesListing`.`listing_id` = 166 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 15150
39DESCRIBE `mm_events`990
40INSERT INTO `mm_events` (`id`, `event`, `ref_id`, `ip_address`, `agent`, `property_id`, `user_id`, `page_url`) VALUES (NULL, 'PROPERTY_VIEW', NULL, '216.73.216.13', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 166, 0, '/florida-rentals/yellow-house-')10
41SELECT LAST_INSERT_ID() AS insertID110
42SELECT `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`.`id` = 166 LIMIT 1110
43SELECT `Zipcode`.`id`, `Zipcode`.`zipcode`, `Zipcode`.`zip_type`, `Zipcode`.`city_name`, `Zipcode`.`city_type`, `Zipcode`.`state_name`, `Zipcode`.`state_abbr`, `Zipcode`.`area_code`, `Zipcode`.`latitude`, `Zipcode`.`longitude` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zipcode` = (166) 0019
44SELECT `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` FROM `auctions` AS `Auction` WHERE `Auction`.`listing_id` = (166) 000
45SELECT `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` = (166) 12120
46SELECT `Rate`.`id`, `Rate`.`site_user_id`, `Rate`.`listing_id`, `Rate`.`title`, `Rate`.`from_date`, `Rate`.`to_date`, `Rate`.`weekly`, `Rate`.`nightly` FROM `rates` AS `Rate` WHERE `Rate`.`listing_id` = (166) 770
47SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (166) 000
48SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = (166) 000
49SELECT `OpenWeeks`.`id`, `OpenWeeks`.`listing_id`, `OpenWeeks`.`open_dates`, `OpenWeeks`.`has_open_dates`, `OpenWeeks`.`updated` FROM `open_weeks` AS `OpenWeeks` WHERE `OpenWeeks`.`listing_id` = (166) 000
50SELECT `Amenity`.`id`, `Amenity`.`title`, `Amenity`.`group_id`, `Amenity`.`show_on_offer_wall`, `Amenity`.`created`, `Amenity`.`modified`, `AmenitiesListing`.`id`, `AmenitiesListing`.`amenity_id`, `AmenitiesListing`.`listing_id` FROM `amenities` AS `Amenity` JOIN `amenities_listings` AS `AmenitiesListing` ON (`AmenitiesListing`.`listing_id` = 166 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 15150
51SELECT `Group`.`id`, `Group`.`title`, `Amenity`.`id`, `Amenity`.`title`, `Amenity`.`group_id`, `Amenity`.`created`, `Amenity`.`modified`, `AmenitiesListing`.`amenity_id`, `AmenitiesListing`.`listing_id` FROM `groups` AS `Group` inner JOIN amenities AS `Amenity` ON (`Amenity`.`group_id` = `Group`.`id`) inner JOIN amenities_listings AS `AmenitiesListing` ON (`AmenitiesListing`.`amenity_id` = `Amenity`.`id` AND `AmenitiesListing`.`listing_id` = 166) WHERE 1 = 1 15150
52SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 166 000
53SELECT 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
(ownerware) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `events_property`35351
2DESCRIBE `listings`32321