Here we cover all the more in-land local towns, and countryside locations surrounding these.
Places such as Manacor, Buger, Campanet, Selva, Inca, Sa Pobla and many many more.
Please see our properties for rent in these areas below :
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 (Resort = 'Manacor' OR Resort = 'Buger' OR Resort = 'Campanet' OR Resort = 'Selva' OR Resort = 'Inca' OR Resort = 'Sa Pobla' OR Resort = 'Arta' OR Resort = 'Consell' OR Resort = 'Lloseta' OR Resort = 'Llubi' OR Resort = 'Muro' OR Resort = 'Petra' OR Resort = 'Sineu') ORDER BY Trick DESC, offerCheck DESC, isNew DESC, PropDetails.ID DESC