Holiday villas to rent in Lloret De Vistalegre
-
Sa SerraVilla in Lloret de Vistalegre
- Villa Sleeps: 1-6
- Bed: 3
- Bath: 2
MoreFrom €1,500/week
Sa Serra, Villa to rent in Lloret de Vistalegre
SELECT PropDetails.ID, DateAdded, Adjective, Type, Resort, HomePrice, Intro, isVillaOfMonth, isNew, isDisplayed, thumbCheck, Moneda, offerApplied,SleepsFrom,SleepsTo,pGolf,pCountry,pBeach,Pool,Name,offerCheck,Advertiser,offerLastMinute,showCalendar,SmallPrint,Bedrooms,Bathroom,Internet,AirCon,Television FROM PropDetails WHERE isDisplayed=1 AND ID >= 0 AND Type='villa' AND Resort='lloret de vistalegre' ORDER BY Trick DESC, offerCheck DESC, isNew DESC, PropDetails.ID DESC, SleepsFrom ASC
Back to top