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<< Florida Vacations<< St Augustine Vacations<<

St Augustine Oceanfront House

‹ ›

Secret Hideaway

2 Bedroom St Augustine Oceanfront House Sleeps 6
Rates: 160-160 USD per night. Minimum Rental - 1 week.

Amenities
Attractions
Rates
Reviews
Inquire

This beach house is a very secluded. The house is raised above the sand dunes and located at the end of a private driveway winding up through the trees to the top of the dunes. The wrap around deck provides relaxing views and limited views of the ocean. You will enjoy the hardwood floors that run throughout the house. Evenings you can cozy up in front of the fireplace and relax.

● 3 TVs

● Views

● Jacuzzi - Inside

● Washer Dryer

● Full Kitchen

● Internet Access

● Linens Included

● Parking Available

● Seaside

● Central Air

● Microwave

● Wood Fireplace

2 Bedrooms ( Queen, 2 Twin size beds)

2 Baths (Jacuzzi tub, walk-in shower, tub/shower combo)

1 Level but raised.

3 Spacious Ocean view Decks & Gazebo

Full size Washer & Dryer

Fully equipped kitchen

Wet bar

Central Heat & Air

DVD & Direct Satellite TV in all Bedrooms,

VCR, Stereo and DSL Internet

Unlimited Long Distance Telephone

2 Car Garage & large driveway

Close to convenience stores, restaurants, & downtown shopping

Weekly Rates $1,300 year round.
Monthly Rates $2,000-3,000

Pricing for Oceanfront House in St Augustine USA are quoted in USD

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Property Lodging Tax : 9%
Tax not included in rates above
Cancellation Policy:
Deposit Required for Oceanfront House :

Member of St. Augustine-St. Johns Co. Chamber Chamber of commerce

Write a Review

St Augustine USA Local Attractions

St Augustine - Historic city.
Daytona Beach - Where speed was born.

St Augustine Local Attractions
Restaurants	Nearby	Nightlife	Nearby
Deep Sea Fishing	Nearby	Fishing - Other	Nearby
Sailing	Nearby	Boating	Nearby
Beach	Nearby	Kayaking	Nearby
Swimming	Nearby	Golf	Nearby
Museums	Nearby	Tennis	Nearby
Wineries	Nearby	Theaters	Nearby
Art Galleries	Nearby	Marina	Nearby

Secret Hideaway is a St Augustine Oceanfront House in Florida USA

St Augustine Oceanfront House

Secret Hideaway

2 Bedroom St Augustine Oceanfront House Sleeps 6 Rates: 160-160 USD per night. Minimum Rental - 1 week.

2 Bedroom St Augustine Oceanfront House Sleeps 6
Rates: 160-160 USD per night. Minimum Rental - 1 week.