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<< Costa Rica Vacations<< Puntarenas Vacations<< Esterillos Vacations<<

Esterillos Holiday Villa

‹ ›

Casa Oso Rojo

3 Bedroom Esterillos Holiday Villa Sleeps 6
Rates: 500-400 USD per night. Minimum Rental - 1 night.

Amenities
Attractions
Rates
Reviews
Inquire

Right in the heart of Del Pacifico at Esterillos is Casa Oso Rojo, a distinctive custom home. Set on a hole of our future-planned golf course with remarkable views of the Pacific, this home features an extremely unique floor plan, with a detached master suite. The home has a private pool, 3 bedrooms and baths, gourmet kitchen and plenty of outdoor space, emphasizing a connection with nature and outdoor living.

● 1 TVs

● Views

● Hot Tub

● Private Swimming Pool

● Washer Dryer

● Air - Conditioning

● Central Air

● Microwave

● Hair Dryer

● Full Kitchen

● Iron

● Internet Access

● Linens Included

● Maid Service Available

● Parking Available

● Seaside

Detached Master Suite	2nd Master Suite	3rd Bedroom
Double Bed, Private Bath.	King Bed, Private Bath.	Double Bed.

Nestled in the rolling hills overlooking the exotic palm coast of Esterillos Este is Del Pacifico... a singularly unique development designed for the individual in all of us.

Del Pacifico at Esterillos is a village by the sea - a private place to relax, recharge, and reflect... a place where families come together season after season to share old memories and create new ones. Not just houses on a hill, but rather a master-planned community meticulously designed by internationally renowned architects, and woven into the very fabric of Costa Rica's rich cultural heritage and natural beauty.

Green Season: May 1- November 20: Daily Rental $400/ Weekly $2400

High Season: Nov 21- April 30 (excluding peak season dates below):
Daily Rental $450/Weekly $2700

Peak Seasons: Dec 20- Jan 3 & April 5-12: Daily Rental $500/Weekly $3000

Pricing for Holiday Villa in Esterillos Costa Rica are quoted in USD

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy: 50% is refundable if canceled 48 hours prior to arrival, except peak season when 15 days are required.
Deposit Required for Holiday Villa : Until confirmed, rates are subject to change without notice. A 50% non-refundable deposit required to confirm rentals with the remaining 50% due 30 days prior to arrival. A refundable security deposit will be taken at check-in.

Write a Review

Esterillos Costa Rica Local Attractions

At Del Pacifico, daily maid service, 24 hour security and concierge services are available for all rental properties. Enjoy the luxurious amenities of a four-star hotel in our tropical paradise. Our expertly trained staff is available to assist you in getting the most out of your vacation. Whether your whim is to arrange a massage, take a private surfing lesson, or horseback ride down the beach at sunset…our concierge staff is ready to assist you.

Esterillos Local Attractions
Golf	Nearby	Horseback Riding	Nearby
Restaurants	Nearby	Deep Sea Fishing	Nearby
Fishing - Other	Nearby	Boating	Nearby
Beach	Nearby	Swimming	Nearby
Casino	Nearby	Marina	Nearby
Rain Forest	Nearby	Hiking	Nearby

Casa Oso Rojo is a Esterillos Holiday Villa in Puntarenas Costa Rica

Esterillos Holiday Villa

Casa Oso Rojo

3 Bedroom Esterillos Holiday Villa Sleeps 6 Rates: 500-400 USD per night. Minimum Rental - 1 night.

3 Bedroom Esterillos Holiday Villa Sleeps 6
Rates: 500-400 USD per night. Minimum Rental - 1 night.