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:2024-12-20:2026-12-20' 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','19708','11304','10200','8991','6492','6332','1323','598','177','152','146') )
) 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.
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.
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.
Indulge in the charm of this 100m² loft on the 3. floor of a renovated art gallery in Sant Feliu de Guíxols. Perfect for families, books and toys are thoughtfully provided.
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.
Discover a chic and delightful retreat in Sant Feliu de Guíxols. Ideal for multiple families, it boasts 360 m² of space with a garden, a barbecue area and an inviting saltwater pool.
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.
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.
