select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `address`,round(price) as price,minimum_nights, `rating`, `review_count`,`latitude`, `longitude`,case when propertyName='' then trim(address) else CONCAT(CONCAT(propertyName,'(',trim(address)),'',')') end as addre,propertyName,
(6371 *
acos(
cos( radians( 21.2759167 ) ) *
cos( radians( `latitude` ) ) *
cos(
radians( `longitude` ) - radians( -157.8233677 )
) +
sin(radians(21.2759167)) *
sin(radians(`latitude`))
)
) as distance from `vacationrentalindex` a inner join vacationrentalindexfeed b on a.uniturl=b.unitUrl and a.headline!='' and a.thumbnailUrl!='' and b.enabled=1 and b.blocked=0 ) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%Volcano National Park%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Experience the tranquility and beauty of the rainforest while enjoying modern conveniences. Create lasting memories in this unique and serene retreat. Enjoy a portable air conditioner to keep you cool and plenty of hot water for your comfort. ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Mountain View
Hale Ma‘ukele is a large, well decorated home located near the heart of Volcano Village and 1 mile from Volcano National Park. It has 2.5 baths, 3 bedrooms, 4 beds, a large living area, and a 4 person hot tub. We have a fully equipped kitchen,...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Volcano
Entire house 2 bedroom full kitchen 1.5 bath washer&dryer and a screened in lanai on 2 acres of ohia forest with fruit trees private and quiet with lock box for entrance....
some of the things that I provide is lot of clean towels a full...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Mountain View
Awarded Most Hopspitable Host for the State of Hawai’i, Gigi’s Volcano Cottage is the perfect place to stay if you want a quiet, cozy and peaceful retreat. Relax to the sound of local birds, wind in the trees, rain showers on the roof. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Volcano
The Jungalow is a charming bungalow nestled among native hapu'u tree ferns and ohi'a trees in the high rain forest. The Jungalow has been lovingly restored with attention to detail. Recent upgrades include new exterior and interior paint, new...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Volcano
Hale Malie is a charming 1-bed/1-bath cottage retreat on a private half acre of lush Hawaiian rain forest just minutes from Volcano National Park. Featuring vaulted ceilings, a full kitchen, a sunny dining area, and expansive covered lanai, this...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Volcano
Cedarwood Bungalow | New Home
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
The whole home is built with 4x6 redwood cedar. The aroma of the...
- 3 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Volcano
Stan and I had a property in Kapoho listed with VRBO for four and a half years. Mama J's Pond House was taken by Pele, the Hawaiian goddess of fire on June 5th, 2018 during the Kilauea eruption. During our time of being hosts, we learned a lot...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Pahoa
A warm room awaits in a home on a quiet cul de sac in the Volcano Golfcourse and Country club. Minutes from the entrance of Hawaiʻi Volcanoes National Park, Historic Volcano Village, golf course and Winery. A covered garage with private ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Volcano
✿ The Bungalow is a great retreat and safe haven from the stress of every day life. It's a peaceful, tranquil, hidden sanctuary in a lush tropical rainforest, yet close to town and beaches!
✿ We are a licensed vacation rental and ...
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Hilo
Hawaii Pickleball Addicts Lodge is a beautiful large private home with 2 covered Pickleball Courts (35' x 60' x 22' each) on 2 acres in Mountain View, HI, close to Volcano National Park, Kea'au, Kalapana Black Sand Beach, Uncle Robert's Awa Bar ...
- 7 bedroom
- 3 bathroom
- Sleeps 14
Hawaii> Mountain View
Please download and use the VRBO Vacation Rental app while while traveling. It will make your trip easier and more enjoyable. Thank you!
Also, we do not recommend using a GPS as we have received comments that it may lead you ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Volcano
Dramatic ocean and lava rock shoreline views, walk to black sand beach
(All about Julie’s place)
Relax and reconnect in one of the most stunning and serene locations in all of Hawaii! Sea Mountain Resort is a truly magical place, ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Pahala
***** WE ARE LOCATED IN FERN FOREST Mountain View , 24 MINUTES TO VOLCANO NATIONAL PARK
We only allow maximum10 nigths stay
We love to share, our sweet and simple private cabin in the Ohia forest not far from Volcanoes National ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Pahoa
Relax at this gorgeous place with your friends & family to the sound of coqui frogs and rain and feel like you're at home. Our place sleeps up to 10 people. The guest rooms are huge, clean, and airy. There is a full kitchen for you to cook in if...
- 3 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Keaau
Nestled within the prestigious Volcano Golf & Country Club community, this charming 3-bedroom single family home offers an ideal retreat for families seeking quality time together or medical professionals embarking on assignments, all while ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Volcano
We can't wait for you to experience this cabin in a jungle. We wanted to create a peaceful and romantic cabin in big island Hawaii near National Volcano Park. This space is cozy small studio cabin with the patio. Bedroom has queen size bed with ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> fern Forest
