Accommodation list layout examples
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-09-07:2026-09-07' 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 0, 1
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-09-07:2026-09-07' 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 0, 3
Sarajevo
![bolnicka-31-1024x572](https://kofer.info/wp-content/uploads/2022/08/bolnicka-31-1024x572-1-280x187.webp)
Apartman Aleja
Bolnička 15/II, 71 000 Sarajevo, Bosnia and Herzegovina
Već od
30
€
Osoba : 3
Mapu svih apartmana u Sarajevu pogledajte ovdje
I.Sarajevo
![viber_image_2024-08-12_11-16-29-066](https://kofer.info/wp-content/uploads/2023/11/viber_image_2024-08-12_11-16-29-066-280x187.jpg)
Apartman B&B
Karađorđeva 11 A , Istočno Novo Sarajevo
Već od
25
€
Površina : 47m2 / Osoba : 4
Mapu svih apartmana u Sarajevu pogledajte ovdje
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-09-07:2026-09-07' 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 0, 7
- Jahorina
Apartman A-5
Obućina Bare bb , Jahorina,Već od 80 € - Sarajevo
Apartman Aleja
Bolnička 15/II, 71 000 Sarajevo, Bosnia and HerzegovinaVeć od 30 € - I.Sarajevo
Apartman B&B
Karađorđeva 11 A , Istočno Novo SarajevoVeć od 25 € - Sarajevo
Apartman Bistrik – Sarajevo
Bistrik 21Već od 75 € - Sarajevo
Apartman Bolero
Titova 4Već od 60 € - Sarajevo
Apartman Čengić Vila I
Džemala Bijedića 54/5Već od 25 € - Sarajevo
Apartman Delfin
Ejuba Delalica 48Već od 15 €
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-09-07:2026-09-07' 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 0, 3
Sarajevo
![bolnicka-31-1024x572](https://kofer.info/wp-content/uploads/2022/08/bolnicka-31-1024x572-1-280x187.webp)
Apartman Aleja
Bolnička 15/II, 71 000 Sarajevo, Bosnia and Herzegovina
Već od
30
€
Osoba : 3
Mapu svih apartmana u Sarajevu pogledajte ovdje
I.Sarajevo
![viber_image_2024-08-12_11-16-29-066](https://kofer.info/wp-content/uploads/2023/11/viber_image_2024-08-12_11-16-29-066-280x187.jpg)
Apartman B&B
Karađorđeva 11 A , Istočno Novo Sarajevo
Već od
25
€
Površina : 47m2 / Osoba : 4
Mapu svih apartmana u Sarajevu pogledajte ovdje
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-09-07:2026-09-07' 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 DESC
LIMIT 0, 3
Vlašić
![inbound2290062957360515641-8b1d15895546ff5d5d5db840d369d86c](https://kofer.info/wp-content/uploads/2024/01/inbound2290062957360515641-8b1d15895546ff5d5d5db840d369d86c-280x187.jpg)
Vlašić Aurora Apartment
Dolina panjeva bb, Babanovac, Vlašić
Već od
100
€
Površina : 82m2 / Osoba : 8+
Sarajevo
![SPAVACA-2-56594abd296e2efcf8a3f66003f4efcd](https://kofer.info/wp-content/uploads/2023/11/SPAVACA-2-56594abd296e2efcf8a3f66003f4efcd-280x187.webp)
Villa Trebevićka
Trebevićka 36b
Već od
200
€
Površina : 280 m2 / Osoba : 6
Mapu svih apartmana u Sarajevu pogledajte ovdje
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-09-07:2026-09-07' 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 0, 3
Apartman A-5
Obućina Bare bb , Jahorina,
Već od
80
€
Apartman Aleja
Bolnička 15/II, 71 000 Sarajevo, Bosnia and Herzegovina
Već od
30
€
Apartman B&B
Karađorđeva 11 A , Istočno Novo Sarajevo
Već od
25
€
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-09-07:2026-09-07' 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 DESC
LIMIT 0, 3