Search property to rent in Majorca
We're sorry but we have no results for this criteria at the moment
We do however have plenty of other properties across Majorca so why not use our Property search facility on the right to view some of our other properties.
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 (offerCheck=1 OR offerTrick=1) ORDER BY Trick DESC, offerCheck DESC, isNew DESC, PropDetails.ID DESC, SleepsFrom ASC
Back to top