Holiday villas and apartments 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 FROM PropDetails WHERE isDisplayed=1 AND ID >= 0 AND Resort='Lloret de Vistalegre' ORDER BY Trick DESC, offerCheck DESC, isNew DESC, PropDetails.ID DESC, SleepsFrom ASC

Back to top