Fountain Blue

2878 E County Hwy 30A , 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

Located directly on the Gulf of Mexico in Old Seagrove Beach 1/3 mile from Seaside, Fountain Blue is a large home that offers the perfect accommodations for your family vacation – 4 large bedrooms/4 baths – sleeps 14. All the rooms are located on one level (two steps between house and sun room), facilitating elderly people and small children. Private steps to the beach right out the sun room door. Recent upgrades include new tile floors in the common areas, a new air conditioning system, and new bedding. Enjoy sweeping beach views and spectacular sunsets from your gulf front deck!

The large tiled sunroom offers panoramic gulf views and features a twin trundle bed – sleeping 2, comfortable wicker seating and sunset views. Large tiled great room adjacent to kitchen/dining area with wrap-around bar makes this the perfect home for a relaxing and enjoyable getaway. The fully stocked tiled kitchen features two ovens, frig, microwave, and dishwasher. The glass top dining table seats up to 10. An additional round game table located in the open living area can seat 4 more. Great room features comfortable, new rattan seating arrangements including a queen sofa bed which sleeps 2, love seat, 2 swivel side chairs and coffee table. Entertainment center includes TV, DVD, and stereo/CD player. Wood-burning fireplace creates a cozy environment in winter months. High speed internet.

King bedroom offers ample closet space, TV, swivel side chair, ceiling fan and private bath with tub/shower. Queen bedroom features TV, chaise long and private bath with tub/shower. The other two bedrooms are situated away from the living area for quiet adult privacy or teen/children activities. The twin bedroom has 2 beds, TV (game use only, no cable) and private bath with walk-in shower. Two full-sized beds are in the 4th bedroom which also has a TV and a private bath with walk-in shower.

Large washer/dryer. Side courtyard features outdoor seating and charcoal BBQ grill. One car may park in garage plus off street parking for 4 additional cars. Private steps to the beach. Outdoor shower.

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

Beds: K, Q, 2D, 4T, QSS

Map and Location Information

2878 E County Hwy 30A, Seagrove Beach, FL 32459

Property Details

Listing No#: 98
Bedrooms: 4
Bathrooms: 4
Sleeps: 14
Square Feet:
Area: Florida Panhandle, Gulf Coast

Rates

From To Weekly Nightly
Summer 2010
05/29/2010
08/06/2010 $3935 $620
Late Summer 2010
08/07/2010
09/05/2010 $3150 $495
Fall 2010
09/06/2010
10/31/2010 $2360 $370
Winter 2010 (Nov)
11/01/2010
11/19/2010 $1970 $310
Thanksgiving 2010
11/20/2010
11/27/2010 $2360 $370
Winter 2010 (Dec)
11/28/2010
12/17/2010 $1970 $310
Christmas Holidays 2010
12/18/2010
01/01/2011 $2360 $370
(default) 24 queries took 39 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` = 'fountain-blue-' LIMIT 1111
3SELECT `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` = (98) 0019
4SELECT `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` = (98) 000
5SELECT `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` = (98) 12120
6SELECT `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` = (98) 770
7SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (98) 000
8SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = (98) 000
9SELECT `OpenWeeks`.`id`, `OpenWeeks`.`listing_id`, `OpenWeeks`.`open_dates`, `OpenWeeks`.`has_open_dates`, `OpenWeeks`.`updated` FROM `open_weeks` AS `OpenWeeks` WHERE `OpenWeeks`.`listing_id` = (98) 000
10SELECT `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` = 98 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 14140
11INSERT 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)', 98, 0, '/florida-rentals/fountain-blue-')10
12SELECT LAST_INSERT_ID() AS insertID110
13SELECT `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` = 98 LIMIT 1110
14SELECT `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` = (98) 0019
15SELECT `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` = (98) 000
16SELECT `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` = (98) 12120
17SELECT `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` = (98) 770
18SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (98) 000
19SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = (98) 000
20SELECT `OpenWeeks`.`id`, `OpenWeeks`.`listing_id`, `OpenWeeks`.`open_dates`, `OpenWeeks`.`has_open_dates`, `OpenWeeks`.`updated` FROM `open_weeks` AS `OpenWeeks` WHERE `OpenWeeks`.`listing_id` = (98) 000
21SELECT `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` = 98 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 14140
22SELECT `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` = 98) WHERE 1 = 1 14140
23SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 98 000
24SELECT 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
(ownerware) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)