Sea Groove

84 W. Grove Avenue , 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

Just completely redecorated, Sea Groove is a beautiful gulf view home nestled among magnolias and live oaks with 5 bedrooms/4.5 baths that sleeps up to 17 people. Spectacular rooftop gazebo with views over forest canopy and the gulf. Relax in hammocks or Adirondack chairs. Great for sunsets! Located in Old Seagrove Beach on an oak-canopied road, just a quarter mile east of Seaside. Lovely, shaded one block walk to public beach access (250 walking steps). Private heated pool (fees apply for pool heating) in screened enclosure, with hot/cold outdoor shower. Parking for 4 cars. Quiet neighborhood. Walk to beach, Seagrove Village Market, restaurants and Seaside. Gas grill. Ceiling fans throughout home.

First Level: Inviting entry porch with Adirondacks. Screened front porch with teak outdoor dining table and chairs. Tile floors on this level. Combination family room and dining room adjoin the large kitchen. Kitchen has granite countertops, gas range, frig with ice maker, dishwasher and 2 sinks. Dining table seats 6 - 12 plus 4 more at breakfast bar. Family room features comfortable overstuffed sofas, two side chairs, ottomans, large TV, DVD, stereo, games, puzzles, and gas log fireplace. King master bedroom on this floor has flat panel TV, DVD, private exterior entrance, and a private bath with pedestal sink and tub/shower. Half bath and full-sized washer/dryer are also on this level.

Second Level: Beautiful bamboo hardwood floors. Large screened porch with café tables and chairs, foosball table and ping pong table. King master bedroom has TV, DVD, dresser and private bath with vanity sink and tub/shower. Queen bedroom has TV, armoire and a full sized baby crib. Kid's bunkroom has two bunk beds with 2 trundles underneath, plus 2 dressers. Playroom/Office has bunk with full-sized sofa/bed on bottom and twin bed on top, TV/VCR/DVD and wireless high speed internet connectivity. Shared hall bathroom has vanity sink and tub/shower.

Third Level: Beautiful bamboo hardwood floors. Queen master bedroom features a dresser, large TV, DVD and a private bath with shower. This bedroom opens onto a balcony in the magnolia and oak tree canopy which has a spiral staircase to the rooftop gazebo. This spectacular outdoor area is equipped with Adirondack chairs, 2 hammocks and amazing views of the gulf over the tree tops. Catch the breezes and the sunset.

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

Bedrooms: 5 Bathrooms: 4 Half Bathrooms: 1 Beds: 2K, 2Q, 3 Bunks (7T,1D)

Map and Location Information

84 W. Grove Avenue, Seagrove Beach, FL 32459

Property Details

Listing No#: 140
Bedrooms: 5
Bathrooms: 4
Sleeps: 17
Square Feet:
Area: Florida Panhandle, Gulf Coast

Rates

From To Weekly Nightly
Summer 2010
05/29/2010
08/06/2010 $3290 $
Late Summer 2010
08/06/2010
09/05/2010 $2630 $415
Fall 2010
09/06/2010
10/31/2010 $1975 $310
Winter 2010 (Nov)
11/01/2010
11/19/2010 $1645 $260
Thanksgiving 2010
11/20/2010
11/27/2010 $1975 $310
Winter 2010 (Dec)
11/28/2010
12/17/2010 $1645 $260
Christmas Holidays 2010
12/18/2010
01/01/2011 $1975 $310
(default) 53 queries took 40 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` = 'sea-groove-' 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` = (140) 0018
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` = (140) 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` = (140) 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` = (140) 770
35SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (140) 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` = (140) 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` = (140) 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` = 140 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 17170
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)', 140, 0, '/florida-rentals/sea-groove-')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` = 140 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` = (140) 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` = (140) 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` = (140) 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` = (140) 770
47SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (140) 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` = (140) 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` = (140) 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` = 140 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 17170
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` = 140) WHERE 1 = 1 17170
52SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 140 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-06-30' AND `Auction`.`auction_start_date` <= '2025-06-30' 110
(ownerware) 2 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `events_property`35350
2DESCRIBE `listings`32320