Vacations Abroad Vacations-Abroad.com

+1-877-672-2556
Skype

Africa
Egypt

Kenya

Mauritius

Morocco

South Africa
Contact Us
Our Press

List a Property
About Us
Rental Guarantee
Our Blog
Asia
Cambodia

India

Indonesia

Israel

Malaysia

Maldives

Nepal

Philippines

Sri Lanka

Thailand

Turkey
Contact Us
Our Press

List a Property
About Us
Rental Guarantee
Our Blog
Europe
Austria

Belgium

Bulgaria

Croatia

Cyprus

Czech Republic

England

Estonia

France

Germany

Greece

Hungary

Ireland

Italy

Latvia

Malta

Montenegro

Netherlands

Poland

Portugal

Romania

Scotland

Spain

Switzerland

Ukraine

Wales
Contact Us
Our Press

List a Property
About Us
Rental Guarantee
Our Blog
North America
Bahamas

Barbados

Belize

British West Indies

Canada

Costa Rica

Dominica

Dominican Republic

French West Indies

Guatemala

Jamaica

Mexico

Netherlands Caribbean

Nicaragua

Panama

Saint Kitts and Nevis

St Lucia

St Vincent and Grenadines

Trinidad and Tobago

US Caribbean

USA
Contact Us
Our Press

List a Property
About Us
Rental Guarantee
Our Blog
Oceania
Australia

Cook Islands

Fiji

French Polynesia

New Zealand
Contact Us
Our Press

List a Property
About Us
Rental Guarantee
Our Blog
South America
Argentina

Brazil

Colombia

Peru
Contact Us
Our Press

List a Property
About Us
Rental Guarantee
Our Blog

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

Message:

SELECT CityID, MinimumNightlyRentalTypes.Name AS MinimumNightlyRental, PropertyTypes.Name as Type,PropertyCategories.CategoryTypes, 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 Vacation Ideas<< Hawaii Vacations Destinations<< Kauai Island Vacation Rentals and Boutique Hotels

Kauai Island Condo Rental

THE ORCHID ROOM AT HALE MOI Condo Rental

1 Bedroom Kauai Island Hale Moi Condo Sleeps 2
Rates: 75-100 USD per night. Minimum Rental - 2 nights.

Inquire
Write a Review

THE ORCHID ROOM AT HALE MOI USA Hale Moi Condo

THE ORCHID ROOM AT HALE MOI Kauai Island Hale Moi Condo

AMENITIES

Kauai Island Condo Rental

A beautifully remodeled, immaculately clean, bright, spacious, and luxurious studio, located in the renownd Princeville community on Kauai's magnificent North Shore. Relax on your private lanai and enjoy jungle, mountain, and distant waterfall views while listening to song birds. Walk to Hideaways Beach and Princeville Resort. Newly decorated with tropical furnishings including a King bed with a bamboo framed canopy. WiFi, kitchenette and living area for your comfort.

● 1 TVs

● Microwave

● Internet Access

THE ORCHID ROOM AT HALE MOI Hawaii Hale Moi Condo

RATES

Kauai Island Condo Rental

$75-$100 a night

Pricing for Hale Moi Condo in Kauai Island USA are quoted in USD

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted:
Cancellation Policy: Please contact us for Cancellation Policies
Deposit Required for Hale Moi Condo : Please contact us regarding payment details