Your name:	*
And email:	*
Telephone:
Arrival:
# nights:
# Adults:		#Children:
Additional comments:

Message:

SELECT CityID, MinimumNightlyRentalTypes.Name AS MinimumNightlyRental, PropertyTypes.Name as Type, Users.FirstName, Users.LastName, Users.PrimaryTelephone, Users.Country AS OwnerCountry, Users.Email, Users.Username, Users.Address AS OwnerAddress, Users.EveningTelephone, Users.DaytimeTelephone, Users.MobileTelephone, Users.Website, Users.City AS OwnerCity, Users.State AS OwnerState, Users.Zip AS OwnerZip, Users.Registered, Users.IfPayTravelAgents, Users.DateCreated, Cities.City, StateProvinces.StateProvince, Countries.Country, Regions.Region, CASE WHEN EXISTS (SELECT * FROM PropertiesAmenities INNER JOIN Amenities ON PropertiesAmenities.AmenityID = Amenities.ID WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND (Amenities.Amenity = 'Smoking Permitted')) THEN 'Yes' ELSE 'No' END AS Smoking, CASE WHEN EXISTS (SELECT * FROM PropertiesAmenities INNER JOIN Amenities ON PropertiesAmenities.AmenityID = Amenities.ID WHERE (PropertiesAmenities.PropertyID = Properties.ID) AND (Amenities.Amenity = 'Pet Friendly')) THEN 'Yes' ELSE 'No' END AS PetFriendly, Properties.ID, Properties.UserID, Properties.Name, Properties.TypeID, Properties.Address, Properties.CityID, Properties.IfShowAddress, Properties.PaymentMethod ,Properties.NumBedrooms, Properties.NumBaths, Properties.NumSleeps,Properties.MinNightRate,Properties.HiNightRate,Properties.MinRateCurrency,Properties.Name2, Properties.MinimumNightlyRentalID, Properties.NumTVs, Properties.NumVCRs, Properties.NumCDPlayers, Properties.Description, Properties.Amenities, Properties.LocalAttractions, Properties.Rates, Properties.CancellationPolicy, Properties.DepositRequired, Properties.IfMoreThan7PhotosAllowed, Properties.IfFinished, Properties.IfApproved, CASE WHEN EXISTS (SELECT * FROM Invoices WHERE (Invoices.PropertyID = Properties.ID) AND (PaymentAmount >= InvoiceAmount) AND (GETDATE() <= RenewalDate)) THEN 1 ELSE 0 END AS IfPaid, Properties.DateAdded, Properties.DateStartViewed, Properties.VirtualTour, Properties.RatesTable, Properties.PricesCurrency, Properties.CheckIn, Properties.CheckOut, Properties.LodgingTax, Properties.TaxIncluded, Properties.DateAvailable, Properties.IfDiscounted, Properties.IfLastMinuteCancellations, Properties.LastMinuteComments, Properties.HomeExchangeCityID1, Properties.HomeExchangeCityID2, Properties.HomeExchangeCityID3, Properties.HomeExchangeComments FROM Properties INNER JOIN Cities ON Properties.CityID = Cities.ID INNER JOIN StateProvinces ON StateProvinces.ID = Cities.StateProvinceID INNER JOIN Countries ON StateProvinces.CountryID = Countries.ID INNER JOIN Regions ON Countries.RegionID = Regions.ID INNER JOIN Users ON Properties.UserID = Users.ID LEFT OUTER JOIN MinimumNightlyRentalTypes ON Properties.MinimumNightlyRentalID = MinimumNightlyRentalTypes.ID LEFT OUTER JOIN PropertyTypes ON Properties.TypeID = PropertyTypes.ID LEFT JOIN PropertyCategories ON PropertyCategories.ID=PropertyTypes.Category WHERE (Properties.ID = @PropertyID)

North America Vacations<< USA Vacations<< Alabama Vacations<< Gulf Shores Vacations<<

Gulf Shores Crystal Shores Oceanfront Condo

‹ ›

Cyrstal Shores condo

2 Bedroom Gulf Shores Crystal Shores Oceanfront Condo Sleeps 6
Rates: 250-145 USD per night. Minimum Rental - 3 nights.

Amenities
Attractions
Rates
Reviews
Inquire

Our 2br/2ba Condo is DIRECTLY on the Gulf in one of the newest buildings in Gulf Shores on West Beach. We have 2 king sized beds and a sleeper sofa, so we sleep 6 comfortably. We have just upgraded the furniture in the living room and have a 2 tv's -- on in the living area and one in the masterbedroom (which is also directly on the gulf)...

You will love our premium bedding, cleanliness of our condo, and also all the extras that come with it. Our condos come with beach towels and beach chairs (we actually give you a key to the owners closet so if you want to bring a bike, there's a place to store it, too!)...This condo is furnished as a true second home, and we know you'll love it.

● 2 TVs

● Views

● Jacuzzi - Inside

● Private Swimming Pool

● Washer Dryer

● Air - Conditioning

● BBQ Grill

● Full Kitchen

● Internet Access

● Linens Included

● Parking Available

● Beach Front

Please contact us regarding amenities

Daily $250-$145
Weekly $900-$1300

Pricing for Crystal Shores Oceanfront Condo in Gulf Shores USA are quoted in USD

Check in time 3 PM
Check out time 11 AM
Payment methods accepted:
Cancellation Policy: Please contact us for Cancellation Policies
Deposit Required for Crystal Shores Oceanfront Condo : Please contact us regarding payment details

Write a Review

Gulf Shores USA Local Attractions

Gulf Shores Local Attractions
Golf	Nearby	Restaurants	Nearby
Beach	Nearby	Swimming	Nearby

Cyrstal Shores condo is a Gulf Shores Crystal Shores Oceanfront Condo in Alabama USA

Alabama Cities:
Gulf Shores

Gulf Shores Crystal Shores Oceanfront Condo

Cyrstal Shores condo

2 Bedroom Gulf Shores Crystal Shores Oceanfront Condo Sleeps 6 Rates: 250-145 USD per night. Minimum Rental - 3 nights.

2 Bedroom Gulf Shores Crystal Shores Oceanfront Condo Sleeps 6
Rates: 250-145 USD per night. Minimum Rental - 3 nights.