SELECT wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2026-03-06:2028-03-06' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_id AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('17986','20777','19920','11304','10200','1323','598','177','152') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','room_type','accommodation','wpcf7_contact_form','ufaq','mc4wp-form' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','room_type','accommodation','wpcf7_contact_form','ufaq','mc4wp-form' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
From exotic gardens to a rejuvenating Thai Spa, it's a haven of tranquility in the Mountains. With stunning Costa Blanca views, golf courses nearby and a Kids' Club, it caters to all.
Indulge in year-round luxury at a sprawling resort on Tenerife's southwest coast. Neo-classical elegance meets family fun with a colossal infinity pool and pirate ship splash zone.
Immerse in the perfect blend of sophistication and family fun at this hotel with a modern interior harmonizing with the lush golf course. Adventure unfolds with play areas and a kids club.
Indulge in the ultimate all-inclusive luxury, where world-class amenities meet local discovery. Michelin-starred dining, kids-friendly paradise, beachside bliss and access to the spa.
This is an upscale, family-friendly resort offering an all-inclusive Mediterranean escape along the island’s beautiful coast. Nestled among scenic coves, the resort combines elegant accommodations, Michelin-starred dining, and a wide range of activities.
This is a stylish five-star boutique hotel located in the heart of Barcelona, just steps from Las Ramblas and the cathedral. Guests can enjoy panoramic city views from the rooftop terrace, that also features an outdoor pool.
Le Méridien Ra is a luxurious beachfront retreat set in a beautifully restored historical building. With its serene atmosphere, wellness focus, and stunning Mediterranean views, it’s a perfect coastal escape for families and couples alike.
In the heart of Costa del Sol, this historic luxury haven beckons with beachfront charm. From chic double rooms to private villas, bask in impeccable service. A paradise for ages 4 to 14.
This 5-star eco resort, nestled in a lush ecological park, offers a unique, nature-immersed retreat just 25 minutes from the beach. Kids adore the weekend kids club and farm animals.
Discover a resort resembling a quaint Spanish village on the vibrant Costa Blanca. Enjoy pools, kids club, tennis courts and exclusive Level privileges with personalized service.
Indulge in beachfront bliss at this chic hotel. The kids club offers creative activities, dive into the pools or hit the beach, savor Balearic delights and keep fit in the gym.
This luxurious beachfront resort is surrounded by lush gardens and stunning ocean views. With modern accommodations, world-class dining, multiple pools, and a focus on wellness, the resort offers tailored experiences, including a kids' zone and adults-only spaces.
Embark on a five-star retreat, nestled in lush Guia de Isora. Kids indulge in the Kids Club, offering diverse activities, sports enthusiasts relish golf, tennis, and fitness classes.
With its focus on relaxation and well-being, Six Senses Ibiza provides a tranquil retreat on one of the Mediterranean's most vibrant islands. It also offers a dedicated Kids Club, providing fun and educational activities for younger guests.
Set amid rolling golf greens and Andalusian charm, this property is a serene luxury retreat on the Costa del Sol, blending timeless architecture, Mediterranean elegance, and world-class leisure in a sun-drenched setting.
A luxurious retreat blending Andalusian charm with contemporary elegance, this five-star resort offers stylish accommodations, world-class dining, a serene spa, and stunning golf course views, making it an ideal destination for relaxation and indulgence.
A stylish, family-friendly resort on the southern coast of Spain, blending relaxed Andalusian charm with modern comforts. Surrounded by golf courses, rolling hills, and the Mediterranean Sea, it's an ideal base for active families.
This art nouveau apartment, blending vintage and modern decor, features a light-filled gallery overlooking a tranquil courtyard. It offers every convenience, including baby gear.
Experience Catalonia at its finest in these countryside apartments, blending tradition with sustainability. Stylishly decorated, eco-conscious and family-friendly, with shared amenities.
Where historic allure meets modern comfort: From the cozy log burner in the living room to the spacious garden with swings, hammock, and BBQ, every nook invites fun and relaxation.
Nestled on the outskirts of Garrotxa, this renovated farmhouse offers a serene family retreat amidst cornfields. Ideal for hikes and biking in a Volcanic Zone Natural Park.
Escape to this rural retreat nestled in a valley amid vineyards and mountains with rustic charm, comfy rooms and a refreshing pool. Explore nearby hiking trails, golfing and theme parks.
The Costa Blanca Family Retreat blends rustic charm, scenic beauty, and family-friendly design to ensure a great holiday both parents and children alike.
Reveal seaside charm in this revamped villa. Set in a family-friendly community, relish shared amenities like a pool, tennis court and playground – a perfect retreat for all ages.
This charming boutique hotel is a stylish hideaway that blends contemporary Mediterranean design with Ibiza’s laid-back spirit. Nestled in a picturesque town just moments from the island’s best beaches, it offers an intimate atmosphere, personalized service, and an authentic sense of island tranquility.
The spacious and light-filled finca was recently tastefully renovated and features 4 bedrooms (3 doubles and 1 twin). Each room features an individually controllable air-conditioning.
Escape to a serene Mallorcan oasis – a converted finca turned into an intimate rural hotel. Immerse in vibrant gardens, a heated pool, family-friendly amenities, toys and outdoor play areas.
The South Tenerife Hideaway is a five-star luxury hotel situated in Costa Adeje, featuring 139 exclusive accommodations, many of which offer private pools. The resort blends cutting-edge architecture with quiet exclusivity and panoramic views of the Atlantic Ocean and La Gomera island.
Spain is a very family-friendly destination with a wide range of attractions for both adults and children. From our home base in Barcelona we have visited many family-oriented properties in the country, which we’ve added to our growing collection of family-friendly accommodations. The best time to visit Spain is either in late spring or early autumn - especially if you're going to the south or the Mediterranean coastal areas. Northern Spain is at its peak in July and August, and central Spain is best visited in October or May.
