Accommodation list layout examples
SELECT SQL_CALC_FOUND_ROWS wp_rsp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rsp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rsp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-09:2028-02-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_rsp_postmeta price_meta3 WHERE price_meta3.post_id=wp_rsp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_rsp_posts
WHERE 1=1 AND wp_rsp_posts.post_type = 'accommodation' AND ((wp_rsp_posts.post_status = 'publish'))
GROUP BY wp_rsp_posts.ID HAVING 1=1
ORDER BY wp_rsp_posts.post_title ASC
LIMIT 0, 1
SELECT SQL_CALC_FOUND_ROWS wp_rsp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rsp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rsp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-09:2028-02-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_rsp_postmeta price_meta3 WHERE price_meta3.post_id=wp_rsp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_rsp_posts
WHERE 1=1 AND wp_rsp_posts.post_type = 'accommodation' AND ((wp_rsp_posts.post_status = 'publish'))
GROUP BY wp_rsp_posts.ID HAVING 1=1
ORDER BY wp_rsp_posts.post_title ASC
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS wp_rsp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rsp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rsp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-09:2028-02-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_rsp_postmeta price_meta3 WHERE price_meta3.post_id=wp_rsp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_rsp_posts
WHERE 1=1 AND wp_rsp_posts.post_type = 'accommodation' AND ((wp_rsp_posts.post_status = 'publish'))
GROUP BY wp_rsp_posts.ID HAVING 1=1
ORDER BY wp_rsp_posts.post_title ASC
LIMIT 0, 7
Arun Home Stay, Barkot
Village Krishna, Sarukhet, Barkot, UttarkashiFrom ₹
Bahuguna Home Stay, Lakhamandal
Village and Post Lakhamandal , Teh-Chakrata, DehradunFrom ₹
Chimi Lhagang Homestay, Bhutan
Youwakha, Punakha, BhutanFrom ₹
Druk Noryang Hotel, Thimphu
177 Chang Lam, SE, Norzin, Opposite NFFP Head OfficeFrom ₹
Fort Chabariya, Kekri
Villages: Chabariya, Post: Kanuj, Vaya: Bhagera, Tehsil: kekri, District: AjmerFrom ₹
Gadmen Alpenrose, Switzerland
Sustenstrasse 342, 3863 Gadmen, SwitzerlandFrom ₹
Haywizz Havelock Island Resort
1, Govindanagar Havelock, Port Blair, Andaman and Nicobar Islands 744211From ₹
SELECT SQL_CALC_FOUND_ROWS wp_rsp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rsp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rsp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-09:2028-02-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_rsp_postmeta price_meta3 WHERE price_meta3.post_id=wp_rsp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_rsp_posts
WHERE 1=1 AND wp_rsp_posts.post_type = 'accommodation' AND ((wp_rsp_posts.post_status = 'publish'))
GROUP BY wp_rsp_posts.ID HAVING 1=1
ORDER BY wp_rsp_posts.post_title ASC
LIMIT 0, 3
SELECT SQL_CALC_FOUND_ROWS wp_rsp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rsp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rsp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-09:2028-02-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_rsp_postmeta price_meta3 WHERE price_meta3.post_id=wp_rsp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_rsp_posts
WHERE 1=1 AND wp_rsp_posts.post_type = 'accommodation' AND ((wp_rsp_posts.post_status = 'publish'))
GROUP BY wp_rsp_posts.ID HAVING 1=1
ORDER BY wp_rsp_posts.post_title DESC
LIMIT 0, 3
Urban Trippers Shamiyana Villa by Arindam
C8, Sawai Jai Singh Highway, Bani Park, Jaipur, Rajasthan 302016
From
₹
4 room villa nestled in greenery, Jaipur
Urban Tripper Aamar Bari Homestay by Arindam
Bungalow No - 85, Bengal Greenfield, Gopalnagar, West Bengal 731236
From
₹
SELECT SQL_CALC_FOUND_ROWS wp_rsp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rsp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rsp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-09:2028-02-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_rsp_postmeta price_meta3 WHERE price_meta3.post_id=wp_rsp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_rsp_posts
WHERE 1=1 AND wp_rsp_posts.post_type = 'accommodation' AND ((wp_rsp_posts.post_status = 'publish'))
GROUP BY wp_rsp_posts.ID HAVING 1=1
ORDER BY wp_rsp_posts.post_title ASC
LIMIT 0, 3
Arun Home Stay, Barkot
Village Krishna, Sarukhet, Barkot, Uttarkashi
From
₹
Bahuguna Home Stay, Lakhamandal
Village and Post Lakhamandal , Teh-Chakrata, Dehradun
From
₹
Chimi Lhagang Homestay, Bhutan
Youwakha, Punakha, Bhutan
From
₹
SELECT SQL_CALC_FOUND_ROWS wp_rsp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rsp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rsp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-02-09:2028-02-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_rsp_postmeta price_meta3 WHERE price_meta3.post_id=wp_rsp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_rsp_posts
WHERE 1=1 AND wp_rsp_posts.post_type = 'accommodation' AND ((wp_rsp_posts.post_status = 'publish'))
GROUP BY wp_rsp_posts.ID HAVING 1=1
ORDER BY wp_rsp_posts.post_title DESC
LIMIT 0, 3
Urban Trippers Shamiyana Villa by Arindam
C8, Sawai Jai Singh Highway, Bani Park, Jaipur, Rajasthan 302016