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<< Panama Vacations<< Panama Vacations<< Vista Mar Vacations<<

Vista Mar Luxury Condo with pool and views

‹ ›

Condo Las Olas

2 Bedroom Vista Mar Luxury Condo with pool and views Sleeps 6
Rates: 200-100 USD per night. Minimum Rental - 2 nights.

Amenities
Attractions
Rates
Reviews
Inquire

Located in the quiet, gated community of Vista Mar, Condo Las Olas offers a spectacular ocean and golf-course view from the balcony of a brand-new, luxury condo.

Two bedrooms host four people comfortably. The kitchen is clean and modern with an attached dining area. All furnishings and amenities are provided so thatyou can move right in! Cable TV and wireless internet keeps you touch with the world during your escape from it!

You can relax on your private balcony or next to the shady social area that boasts a sparkling pool. Or you can take a short walk to one of the most beautiful beaches in Panama!

● 1 TVs

● Pet Friendly

● Views

● Shared Swimming Pool

● Washer Dryer

● Air - Conditioning

● BBQ Grill

● Microwave

● Full Kitchen

● Internet Access

● Linens Included

● Elevator

● Maid Service Available

● Parking Available

Rates vary depending on season and are subject to change.

High Season (November to April):
$400 / Weekend, $900 / Week, $2000 / Month.
Low Season (May to October):
$300 / Weekend, $700 / Week, $1500 / Month.

Pricing for Luxury Condo with pool and views in Vista Mar Panama are quoted in USD

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy: In the unfortunate event that you must cancel you reservation, refunds will be made as follows:
* No Refunds if Cancellation is within 30 Days Prior to Date of Reservation

* 50% Refund of Rental Fees if Cancellation is within 60 Days Prior to Date of Reservation.

* 90% Refund of All Fees Paid if Cancellation is Made at Least 61 Days Prior to Reservation

Deposit Required for Luxury Condo with pool and views : To secure a reservation after confirmation of availability, make a deposit of 50% of the rent via PayPal or bank deposit in Panama. The remaining rent is due in cash upon arrival.

A damage deposit will also be due in cash upon arrival and will be returned at departure as long as there have been no damages.

Write a Review

Vista Mar Panama Local Attractions

Vista Mar Local Attractions
Golf	Nearby	Horseback Riding	5-10 Miles
Restaurants	Under 1 Mile	Hang Gliding	5-10 Miles
Tennis	Nearby	Beach	Nearby
Hiking	5-10 Miles	Kayaking	5-10 Miles
Swimming	Nearby

Condo Las Olas is a Vista Mar Luxury Condo with pool and views in Panama Panama

Vista Mar Luxury Condo with pool and views

Condo Las Olas

2 Bedroom Vista Mar Luxury Condo with pool and views Sleeps 6 Rates: 200-100 USD per night. Minimum Rental - 2 nights.

2 Bedroom Vista Mar Luxury Condo with pool and views Sleeps 6
Rates: 200-100 USD per night. Minimum Rental - 2 nights.