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)

Europe Vacations<< Ireland Vacations<< Roscommon Vacations<< Castlerea Vacations<<

Castlerea Holiday Cottage

‹ ›

Kiltale House

3 Bedroom Castlerea Holiday Cottage Sleeps 7
Rates: 100-75 EUR per night. Minimum Rental - 3 nights.

Amenities
Attractions
Rates
Calendar
Reviews
Inquire

Traditiional farmhouse on own spacious grounds, nice peaceful location, large garden with B.B.Q facilities. Centrally located for touring all the heritage sights of County Meath, including Newgrange, Hill of Tara, Trim Castle (home of the film Braveheart) and many other sights. On main bus route to the city and very convenient to Dublin airport. Free farm tours , lots of animals to pet and feed, children's playground and playhouse on site. A holiday spent on Kiltale Farm is one you will never forget.Why not book now and experience life on an irish working farm.Families can partake in the daily farm chores.

● 2 TVs

● Views

● Shared Tennis Courts

● Wood Fireplace

● Washer Dryer

● Pool Table

● BBQ Grill

● Microwave

● Hair Dryer

● Full Kitchen

● Iron

● Internet Access

● Linens Included

● Maid Service Available

● Parking Available

Master Bedroom	Pink Room	Blue Room
King Bed, Shared Bath, TV, DVD, VCR.	1-Twin Bed, Shared Bath, TV, DVD, VCR.	2-Twin Beds, Shared Bath, TV, DVD, VCR.

Private parking, children's playground and playhouse on site, mini pet farm, tennis court, angling tackle house.

From Euro 495.00 to Euro 670.00 per week

Pricing for Holiday Cottage in Castlerea Ireland are quoted in Euro

Check in time Check with Owner
Check out time Check with Owner
Payment methods accepted: Visa, Master Card.
Cancellation Policy: Check with owner
Deposit Required for Holiday Cottage : Euro 150.00

Property Availability Calendar

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

August 2018

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Member Since:Dec 2005

Website Verified

Member of Failte Ireland and Chamber of Commerce Chamber of commerce

Write a Review

Castlerea Ireland Local Attractions

There are 8 golf courses within 10 minutes drive, swimming pool, Dublin Zoo, Fairyhouse racecourse (home of Irish Grand National), heritage sights, ie. Newgrange, Hill of Tara, Trim Castle, Loughcrew.

Castlerea Local Attractions
Golf	Nearby	Lake	Nearby
Horseback Riding	Nearby	Restaurants	Nearby
Nightlife	Nearby	Museums	Nearby
Deep Sea Fishing	Nearby	Fishing - Other	Nearby
Sailing	Nearby	Hunting	Nearby
Boating	Nearby	Race Track-Horse	Nearby
Public Gardens	Nearby	Beach	Nearby
Fly Fishing	Nearby	Kayaking	Nearby
Scuba Diving	Nearby	Swimming	Nearby
Race Track-Dog	Nearby

Kiltale House is a Castlerea Holiday Cottage in Roscommon Ireland

Roscommon Cities:
Castlerea,
Strokestown

Castlerea Holiday Cottage

Kiltale House

3 Bedroom Castlerea Holiday Cottage Sleeps 7 Rates: 100-75 EUR per night. Minimum Rental - 3 nights.

Property Availability Calendar

3 Bedroom Castlerea Holiday Cottage Sleeps 7
Rates: 100-75 EUR per night. Minimum Rental - 3 nights.