. Payement by VISA possible
. Send to a friend
. Waranty
FR | NL

Retour à l'AccueilInformations supplémentairesOwnersNewsletterMy reservationsOur BrochuresPromotionsLes Goodies

SEARCH and BOOK
Lancer la recherche

Special Event

Sport & Adventure

New owner

My selection

Map of the DOM-TOM


Search :
Area :

Département :

 
Back to results
Send this house to a friend
CARCES  Reference :3383017-01
Capacity : 4 persons
Domestic animals allowed: 1
This holiday cottage is occupied for :
Week from Saturday 26/07/2008 to Saturday 02/08/2008.

Price :

Theme holiday cottageSwimming-poolDomestic Animals allowed
This apartment is in a small residence situated in a quiet place, in the countryside. There is a shared swimming-pool for the customers of the whole residence.


select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=9 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=131 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
Composition
Level 0
Sitting room  TV, DVD, Hi-Fi
Dining room 
Equipped kitchen  Electric cooker x 2, Oven, Cooker hood, Microwave, Fridge, Freezer, Dishwasher
Bedroom 1 - 2p  2p bed x 1, TV
     Private bathroom  Shower x 1, Washbasin x 1, WC, Hairdryer
Storeroom  Washing machine, Electric iron, Hoover
Level 1
Bedroom 2 - 2p  2p bed x 1
Outside
Outdoor swimming-pool  Shared with other houses (5), Safe, Enclosed, Availability From May to September
Private car park  Number of car park: 2


select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=38 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=173 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=22 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=159 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=21 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=19 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
General situation

select distinct TypeDetail.Nom,TypeDetail.NomData1,Detail.Numerique,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2,round(Detail.Decimale,1) from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=28 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous

Charges - Services - Guarantee
To pay at the holiday house
Deposit to pay cash,
   (Paid back 15 days after holiday)
€ 500.00 
Cleaning (compulsory)€ 50.00 
Water-Electr-Heating According to consumption and market price


select distinct TypeDetail.Nom,TypeDetail.NomData4,Detail.Decimale,TypeDetail.NomData2,Detail.Texte1,TypeDetail.NomData3,Detail.Texte2 from Categorie,Detail,TypeDetail,TypeCategorie where Categorie.IDCategorie=Detail.IDCategorie and TypeCategorie.IDTypeCategorie=Categorie.IDTypeCategorie and TypeDetail.IDTypeDetail=Detail.IDTypeDetail and IDLocation=1578 and Categorie.IDTypeCategorie=94 AND Detail.Affichage='CHECKED' order by Detail.NOrder : Error:Column 'IDLocation' in where clause is ambiguous
TOP
Back to results
Envoyer ce bien à un ami
 
  Guarantees
Your holidays are too precious to be wasted...
  OUR SELECTION
 

0.066390037536621