Pet-Safe Getaways
Holidawgs.com prides itself in listing pet-safe getaways: pet-friendly getaways that are fully enclosed and secure for your peace of mind travelling with your furkids. Each getaway is rated by how secure you can expect it to be and colour coded accordingly.
Filter pet-safe pet-friendly getaways by location: Pet-friendly in Western Cape, pet-friendly in KwaZula Natal, pet-friendly in Gauteng, pet-friendly in Eastern Cape or pet-friendly in Mpumalanga.
SELECT SQL_CALC_FOUND_ROWS 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=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-12-02:2026-12-02' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts
WHERE 1=1 AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
LIMIT 60, 12