SELECT JrbRO_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM JrbRO_postmeta price_meta2 WHERE price_meta2.post_id=JrbRO_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-09-22:2028-09-22' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM JrbRO_postmeta price_meta3 WHERE price_meta3.post_id=JrbRO_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM JrbRO_posts INNER JOIN JrbRO_postmeta ON ( JrbRO_posts.ID = JrbRO_postmeta.post_id )
WHERE 1=1 AND (
( JrbRO_postmeta.meta_key = 'accommodation_location_post_id' AND JrbRO_postmeta.meta_value IN ('558') )
) AND JrbRO_posts.post_type = 'accommodation' AND ((JrbRO_posts.post_status = 'publish'))
GROUP BY JrbRO_posts.ID HAVING 1=1
ORDER BY JrbRO_posts.post_title ASC
Unfortunately no accommodations were found.
Go City: New York Explorer Pass: 100+ Things to Do Including Edge
Go City New York
From
€
78
Exploring New York City can get expensive with steep admission costs quickly depleting budgets. Save money with this New York explorer pass.
New York City Christmas Lights Private Horse Carriage Ride
New York City Christmas
From
€
163
See New York City during its glittering, festive best—and enjoy a romantic way to explore—on a private, 45-minute horse-and-carriage ride.
Statue of Liberty, Ellis Island, and 9/11 Memorial Guided Tour
Statue of Liberty of New York City’s
From
€
70
Experience three of New York City’s top sights on this tour to the Statue of Liberty, Ellis Island, and the 9/11 Memorial. Start with an expedited ferry ride to Lady Liberty
Unfortunately no cruises were found.
Unfortunately no car rentals were found.