Seahorse Cottage - 67 E. Water Street - Rosemary Beach, FL

67 E. Water St. , Rosemary Beach , FL 32413

  • 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

The 2,200 square foot Seahorse Cottage, a colorful and festive beach home situated in a quiet area of Rosemary Beach, offers a private heated pool in a sheltered courtyard (fees apply for pool heating). Conveniently located just steps away from the fitness center and indoor pool, this home provides a perfect location for the best in family vacation living. Fully equipped kitchen and ample living areas make this home a wonderful spot to gather and relax when you are not out on the beach or enjoying the beautiful architecture of Rosemary Beach.

Guests also have access to all Rosemary Beach amenities, including 4 private heated pools, tennis courts, fitness center, private beach, 2 large greens overlooking the Gulf, and many shops and restaurants for your enjoyment.

The home’s private courtyard is surrounded by stucco wall and mature lush vegetation. Sunny 10 x 16 private heated pool with 6 loungers and a large umbrella for relaxation. Outdoor eating area features round table with 4 chairs. Hot/cold outdoor shower. Gas BBQ grill is poolside so the chef can be with the family. Use of one garage bay is included.

Please note that the pool heater at Seahorse Cottage is an electric heater, which cannot be operated should temperatures fall below 50°.

Hardwood floors and 10 foot ceilings throughout the house. Wireless internet service. Large living room adjacent to kitchen and dining area makes entertaining convenient. It features a comfortable sofa, 2 wicker side chairs with ottomans, 2 additional upholstered side chairs, coffee table, ample reading lamps, 32” flat panel TV, DVD/CD player, digital cable, and French doors leading to pool courtyard. Second seating area in living room with lamp offers another place to gather. Interesting lighting accents dining table with 8 chairs, and French doors leading to pool courtyard. The kitchen is outfitted with stainless appliances, Jenn-aire range, granite countertops, breakfast bar with 4 stools, plus separate wine frig. Queen bedroom has small dresser and LCD TV. Hall bath has vanity sink and tub/shower.

On the second story, the master bedroom features a 4-poster king bed, large armoire, festive linens, LCD TV with digital cable, walk-in closet, ceiling fan, and sofa for relaxation. Private master bath has long double vanity with granite countertop and walk-in shower. Queen bedroom has 2 bedside tables, dresser, ceiling fan and LCD TV. Second bedroom has 2 twin beds with 2 twin trundles underneath, bedside table, dresser, ceiling fan and LCD TV. Hall bath has tiled vanity sink and tub/shower. Large wrap around balcony frames three sides of the home on the second floor giving ample area for outdoor relaxation. Several comfortable seating arrangements are available as well as a table, reading lamp, hammock and outdoor fans which help cool as do natural breezes from the Gulf. Large laundry room has over-sized capacity washer and dryer, built-in ironing board, mini frig, microwave and laundry sink.

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

Beds: K, 2Q, 2T w/ 2T Trundles

Map and Location Information

67 E. Water St., Rosemary Beach, FL 32413

Property Details

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

Rates

From To Weekly Nightly
Summer 2010
05/29/2010
08/06/2010 $2985 $
Late Summer 2010
08/07/2010
09/05/2010 $2390 $375
Fall 2010
09/06/2010
10/31/2010 $1790 $280
Winter 2010 (Nov)
11/01/2010
11/19/2010 $1495 $235
Thanksgiving 2010
11/20/2010
11/27/2010 $1790 $280
Winter 2010 (Dec)
11/28/2010
12/17/2010 $1495 $235
Christmas Holidays
12/18/2010
01/01/2011 $1790 $280
(default) 53 queries took 44 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` = 'seahorse-cottage-67-e-water-street-rosemary-beach-fl' 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` = (149) 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` = (149) 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` = (149) 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` = (149) 770
35SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (149) 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` = (149) 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` = (149) 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` = 149 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.116', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 149, 0, '/florida-rentals/south-florida/seahorse-cottage-67-e-water-street-rosemary-beach-fl')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` = 149 LIMIT 1111
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` = (149) 0020
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` = (149) 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` = (149) 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` = (149) 770
47SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (149) 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` = (149) 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` = (149) 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` = 149 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` = 149) 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` = 149 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` >= '2026-04-05' AND `Auction`.`auction_start_date` <= '2026-04-05' 110
(ownerware) 2 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `events_property`35350
2DESCRIBE `listings`32320