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.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<< Hawaii Vacations<< Kauai Island Vacations<<

Kauai Island Hale Moi Condo

‹ ›

THE ORCHID ROOM AT HALE MOI

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

Amenities
Attractions
Rates
Calendar
Reviews
Inquire

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

$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: Visa, Master Card.
Cancellation Policy: Please contact us for Cancellation Policies
Deposit Required for Hale Moi Condo : Please contact us regarding payment details

Property Availability Calendar

August 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

September 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

October 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

November 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

December 2017

Sun

Mon

Tue

Wed

Thu

Fri

Sat

January 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

February 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

March 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

April 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

May 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

June 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

July 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Member Since:Aug 2008

Website Verified

Write a Review

Kauai Island USA Local Attractions

THE ORCHID ROOM AT HALE MOI is a Kauai Island Hale Moi Condo in Hawaii USA

Kauai Island Hale Moi Condo

THE ORCHID ROOM AT HALE MOI

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

Property Availability Calendar

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