Lucky Enough

123 Hickory Street , 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

If you are lucky enough to be at the beach, lets hope you are “Lucky Enough” to have found this wonderful, beach cottage tucked away beside Seaside in old Seagrove Beach. This 3 bedroom 3 bath home is ideal for your family getaway with everything on one level and a large great room where everyone can gather at the end of the day! Beautifully decorated and spaciously designed to provide comfortable accommodations for everyone. Private pool and screened porch maximize your ability to enjoy the outdoors as well.

Inviting front porch has 2 Adirondacks. Beautiful hardwood floors grace the entire home. As you enter the home you are in the large great room outfitted with queen sleeper sofa, 2 comfy side chairs, one with ottoman, coffee table, 2 lamps, side table, buffet, built-in shelving which houses a large TV, DVD, stereo, books and puzzles. Dining table seats 6. Breakfast bar has 4 barstools at island. Fully stocked kitchen has granite countertops, frig with icemaker, dishwasher, microwave and glass top range. In the hall closet, there is a wagon for taking chairs and toys to the beach. Super capacity washer and dryer in another hall closet.

Bedrooms line the central hallway. Bunk bedroom has bunk with 2 twins, queen bed, armoire with TV and VCR, closet, side table, lamp and private bath with shower and pedestal sink. Queen bedroom has queen bed, bedside table, lamp, chest of drawers, TV, VCR, closet, door to adjacent hall bath, and French doors to the screened porch. Master bedroom has iron king bed, 2 bedside tables, 2 lamps, chest of drawers, armoire with TV and DVD, his/hers closets and French doors to the screened porch. Private master bath has 2 pedestal sinks, jetted tub, and walk-in shower. Hall bath has tub/shower and pedestal sink.

Screened porch runs the entire length of the house and overlooks the pool. It has an outdoor dining table and 4 chairs, 2 rockers, 2 side tables and 2 additional chairs. Private pool is 9 x 24 and has an outdoor table, umbrella and 4 chairs plus a charcoal grill.

Easy beach access straight down the street. Parking for 3 cars on the gravel driveway. Seaside is an easy 2 block walk.

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

Beds - K, 2Q, Bunk (2T)

Map and Location Information

123 Hickory Street, Seagrove Beach, FL 32459

Property Details

Listing No#: 110
Bedrooms: 3
Bathrooms: 3
Sleeps: 10
Square Feet:
Area: Gulf Coast, Florida Panhandle

Rates

From To Weekly Nightly
Summer 2010
05/29/2010
08/06/2010 $2000 $315
Late Summer 2010
08/07/2010
09/06/2010 $1600 $220
Fall 2010
09/06/2010
10/31/2010 $1200 $190
Winter 2010
11/01/2010
11/19/2010 $1000 $160
Thanksgiving 2010
11/20/2010
11/27/2010 $1200 $190
Winter 2010
11/28/2010
12/17/2010 $1000 $160
Christmas Holidays 2010
12/18/2010
01/01/2011 $1200 $190
(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` = 'lucky-enough' 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` = (110) 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` = (110) 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` = (110) 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` = (110) 770
7SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (110) 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` = (110) 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` = (110) 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` = 110 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 13130
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)', 110, 0, '/florida-rentals/lucky-enough')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` = 110 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` = (110) 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` = (110) 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` = (110) 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` = (110) 770
18SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (110) 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` = (110) 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` = (110) 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` = 110 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 13130
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` = 110) WHERE 1 = 1 13130
23SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 110 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)