Search property to rent in Majorca

1. OFFER ON!

   Holiday Villa to rent in Bonaire, Mallorca

   • Villa Sleeps: 2-8
   • Bed: 4
   • Bath: 5

   MoreFrom €3,150/week

   Villa Bonaire, Villa to rent in Bonaire

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 (offerCheck=1 OR offerTrick=1) ORDER BY Trick DESC, offerCheck DESC, isNew DESC, PropDetails.ID DESC, SleepsFrom ASC

Back to top