SELECT SQL_CALC_FOUND_ROWS homestayindia_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM homestayindia_postmeta price_meta2 WHERE price_meta2.post_id=homestayindia_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-05-19:2027-05-19' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM homestayindia_postmeta price_meta3 WHERE price_meta3.post_id=homestayindia_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM homestayindia_posts
WHERE 1=1 AND homestayindia_posts.post_type = 'accommodation' AND ((homestayindia_posts.post_status = 'publish'))
GROUP BY homestayindia_posts.ID HAVING 1=1
ORDER BY accommodation_price ASC
LIMIT 0, 24
New Marine Drive Road, Ballia Panda, Puri, Odisha - 752001.
From Rs.
Hotel Dreamland in Puri, Odisha, offers a comfortable stay near the beach with well-appointed rooms, delicious dining, and warm hospitality, making it an ideal choice for travelers seeking relaxation and convenience.
Abaam Hotel in Kochi offers modern accommodations with free Wi-Fi, complimentary breakfast, and an on-site restaurant. Conveniently located opposite Vyttila Mobility Hub, it's ideal for business and leisure travelers.
Bison Valley Ellakkal Tea Company Road Ratnagiri, Munnar, Kerala - 685565.
From Rs.
Casa Amari Plantation Resort in Munnar, Kerala, offers a serene escape amidst lush tea gardens. Experience cozy cottages, breathtaking views, and warm hospitality, perfect for a rejuvenating getaway in nature’s lap.
Periyar Mountain Palace in Thekkady, Kerala, offers luxurious accommodations amidst lush greenery. It features modern amenities and is close to Periyar Wildlife Sanctuary.
Hotel Sonar Bangla in Puri, Odisha, offers beachfront luxury with comfortable rooms, sea views, and top-notch amenities. Enjoy delicious cuisine, serene ambiance, and easy access to Jagannath Temple and Golden Beach.
Jamyang Retreat in Aritar, Sikkim, offers a serene escape amidst the Eastern Himalayas, featuring comfortable accommodations, warm hospitality, and proximity to attractions like Lampokhari Lake.
Oongkingheem Homestay is a serene, family-run retreat in Rangpokhola, East Sikkim, offering authentic Sikkimese hospitality, traditional cuisine, scenic views, and a peaceful escape amidst nature.
Mairung Forest, Algarah, Kalimpong, West Bengal - 734314.
From Rs.
Zakhira Homestay in Mairung Gaon, Offbeat Kalimpong, offers serene mountain views, traditional hospitality, organic food, and a peaceful escape amidst nature—perfect for a soulful Himalayan getaway.
Creazy Peaks Homestay in Rishop offers stunning Kanchenjunga views, cozy rooms, delicious home-cooked food, and warm hospitality—perfect for a peaceful Himalayan escape amidst nature and serene mountain vibes.
Risheehat, Rishihat Tea Estate, Soriang Khasmahal, West Bengal 734102
From Rs.
Darjeeling View Homestay in Risheehat offers cozy rooms, delicious home-cooked meals, and breathtaking views of Kanchenjunga, surrounded by peaceful tea gardens near Darjeeling town.
Radha Soami Homestay in Takdah offers cozy rooms, home-cooked meals, and warm hospitality amidst serene tea gardens and pine forests—perfect for a peaceful, offbeat getaway near Darjeeling.
Chubi, UT, behind HP Petrol Pump, Leh, Ladakh - 194101.
From Rs.
Norbu Ree Homestay in Leh offers warm Ladakhi hospitality, cozy rooms, delicious home-cooked meals, stunning mountain views, and easy access to major attractions, creating a perfect retreat in Ladakh.
Manirang Homestay in Dhankhar offers a cozy stay with scenic mountain views, traditional Spitian food, and easy access to Dhankar Monastery and Lake for trekking and sightseeing.
Hotel Mountain Nest, Manali offers cozy rooms, mountain views, warm hospitality, delicious food, and easy access to local attractions—perfect for a peaceful and memorable stay in the Himalayas.
Hotel The Jade Mountain in Dalhousie offers scenic mountain views, cozy rooms, delicious food, and warm hospitality—perfect for a peaceful getaway amidst nature with easy access to local attractions.
Near MG Marg, Beside Big Bazar, 737101 Gangtok, India, Nam Nang Road Gangtok, Sikkim - 737101.
From Rs.
Summit Namnang Courtyard & Spa in Gangtok offers scenic views, cozy rooms, a relaxing spa, and warm hospitality—perfect for a peaceful Himalayan retreat near MG Marg.
Kamal’s Homestay in Sittong offers a peaceful escape amidst orange orchards, mountain views, and warm hospitality—perfect for nature lovers seeking an offbeat, authentic Darjeeling village experience.
abakoshi, Mirik, Sagmaru Tea Garden, West Bengal - 734215.
From Rs.
River Valley Homestay in Tabakoshi offers a peaceful riverside escape amidst tea gardens, with cozy rooms, home-cooked meals, and warm hospitality—perfect for exploring offbeat Darjeeling’s natural beauty.
Keatel Crans Retreat in Lingtam, East Sikkim, offers serene mountain views, modern amenities, and warm hospitality—an ideal stay along the Silk Route for nature lovers and peace seekers.