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<< Redington Shores Vacations<<

Redington Shores Beachfront Condo

‹ ›

Sunset Villas

2 Bedroom Redington Shores Beachfront Condo Sleeps 5
Rates: 319-162 USD per night. Minimum Rental - 1 week.

Amenities
Attractions
Rates
Reviews
Inquire

Enjoy glorious sunsets on the Gulf of Mexico in this lovely beachfront rental in very private building (4 units only). Relax on the deck or enjoy your day in this quiet, wide, white sand beach. Excellent location by city park, near shopping and restaurants. Convenient to all attractions in the Tampa Bay area.

● 1 TVs

● Views

● Shared Swimming Pool

● Washer Dryer

● Air - Conditioning

● Central Air

● BBQ Grill

● Microwave

● Full Kitchen

● Iron

● Internet Access

● Linens Included

● Elevator

● Parking Available

● Public Transportation Near

● Beach Front

● Seaside

Each Unit Features:

Balcony with Gulf view
Fully Equipped Kitchen
Linen & Towels
Washer/Dryer
Dishwasher
Iron/Ironing Board
Central Heat & A/C
Satellite TV
Telephone
Wireless DSL

Property Amenities:

New heated Pool with Whirlpool Jets
BBQ Grill
Covered Picnic Area
Large Deck Overlooking Beach
Assigned Parking
Smoke Free Property

Please contact Resort Rentals or visit their website for detailed rates and availability.

Pricing for Beachfront Condo in Redington Shores USA are quoted in USD

Check in time 3 PM
Check out time 10 AM
Payment methods accepted:
Cancellation Policy: Please contact Resort Rentals or visit their website for details.
Deposit Required for Beachfront Condo : Please contact Resort Rentals or visit their website for details.

Write a Review

Redington Shores USA Local Attractions

Redington Shores Local Attractions
Golf	Nearby	Biking	Nearby
Restaurants	Nearby	Nightlife	Nearby
Museums	Nearby	Deep Sea Fishing	Nearby
Fishing - Other	Nearby	Boating	Nearby
Tennis	Nearby	Beach	Nearby
Art Galleries	Nearby	Kayaking	Nearby
Swimming	Nearby	Marina	Nearby

Sunset Villas is a Redington Shores Beachfront Condo in Florida USA

Redington Shores Beachfront Condo

Sunset Villas

2 Bedroom Redington Shores Beachfront Condo Sleeps 5 Rates: 319-162 USD per night. Minimum Rental - 1 week.

2 Bedroom Redington Shores Beachfront Condo Sleeps 5
Rates: 319-162 USD per night. Minimum Rental - 1 week.