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<< California Vacations<< Colusa Vacations<<

Colusa Cottage

‹ ›

Jay House

2 Bedroom Colusa Cottage Sleeps 9
Rates: 190-120 USD per night. Minimum Rental - 1 night.

Amenities
Attractions
Rates
Calendar
Reviews
Inquire

Bird watchers, duck hunters, fishermen’s delight. Unpretentious charm in an undiscovered destination! Our 2-bedroom home sleeps up to nine people and is dog-friendly. A short stroll from the Sacramento River, and in easy reach of the refuges in the Sacramento National Wildlife Refuge complex as well as Gray Lodge Wildlife Area.

● 1 TVs

● Pet Friendly

● Views

● Private Tennis Court

● Washer Dryer

● Full Kitchen

● Internet Access

● Parking Available

● Linens Included

Please contact us regarding amenities

RATES
From March 2010 through July 2011:
$120 Per Night (2 people)
$10 extra for each additional person

Visit our website to view current rate information.

Pricing for Cottage in Colusa USA are quoted in USD

Check in time 3 PM
Check out time 2 PM
Payment methods accepted: Visa, Master Card.
Cancellation Policy: Please contact us for Cancellation Policies
Deposit Required for Cottage : 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:Dec 2008

Website Verified

Write a Review

Colusa USA Local Attractions

Colusa Local Attractions
Fishing - Other	Nearby	Tennis	Nearby
Biking	Nearby	Horseback Riding	Nearby
Restaurants	Nearby	Hiking	Nearby
Kayaking	Nearby	Swimming	Nearby

Jay House is a Colusa Cottage in California USA

Colusa Cottage

Jay House

2 Bedroom Colusa Cottage Sleeps 9 Rates: 190-120 USD per night. Minimum Rental - 1 night.

Property Availability Calendar

2 Bedroom Colusa Cottage Sleeps 9
Rates: 190-120 USD per night. Minimum Rental - 1 night.