We have some beautiful Majorca (Mallorca) beach properties to rent - if sun, sand, sea should be within walking distance for your holidays then you have come to right place! Whether you are looking for beach villas in Alcudia, beachfront apartments in Puerto Pollensa, beachfront villas in Palma Nova then see below. Check our Majorca beaches guide for a location guide. Alternatively you can always do a specific search at the top of the page.
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 pBeach=1 ORDER BY Trick DESC, offerCheck DESC, isNew DESC, PropDetails.ID DESC