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 (city = 'Keaau' OR postalCode = 'Keaau' OR region like '%|Keaau|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Welcome to Pua Lani, a gated one acre estate two blocks from the ocean that features resort landscaping and large lawn areas that create a very private and serene setting for your stay.
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Keaau
Modern furnishings and recently updated with Air Conditioners in every room!! New Kitchen appliances makes meal prep a breeze. Private home is conveniently located 30 minutes from Hilo, 40 minutes from the newest beach in the world, and less ...
3 bedroom
2 bathroom
Sleeps 8
Hawaii> Keaau
Explore the Big Island and use Casa Tortuga as your home base. Only 40 feet from the ocean, this 1400 sq. ft. luxury custom built home has a feeling that brings serenity to all of its guests. It lies on one half acre in a quiet upscale ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Keaau
The Bird's Nest is located in a peaceful neighborhood that is surrounded by lush greenery and bird songs can be heard throughout the day & tree frogs at night. The house sits high above the ground which makes it feel as if you are staying in a ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Keaau
Aloha and welcome to my Hawai’i Island cottage!
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Keaau
Private Acre, Entire Home has Air-Conditioning, Private Safe to store valuables, Fully stocked Kitchen with many small appliances ( coffee machines, toaster, crockpot, rice maker, Waffle maker, Blender), Washer & Dryer, Ice Chest, Beach Chairs, ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Keaau
Welcome to Hale Kailani, the 'Sea and Sky House'. Enjoy breathtaking views of the Pacific Ocean, amazing sunrises, occasional lightning storms, year round turtle and spinner dolphins and seasonal humpback whales right off the back lanai. ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Keaau
Enjoy indoor-outdoor living in our bright, open home... Relax on the lanai overlooking lush vegetation and lava outcrops, smell the fragrant Hawaiian air and listen to the waves crash in the distance. Secluded and quiet--a garden oasis far ...
2 bedroom
2 bathroom
Sleeps 5
Hawaii> Keaau
Swap the daily grind for luxurious absolute oceanfront tranquility with an escape to Paradise Breeze Retreat in Keaau, Hawaii. Only a 25 minute drive from Hilo Airport but a world away from stress. Stunning panoramic oceanfront views from every ...
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Keaau
Located on the Big Island of Hawaii, this detached studio guest house is fully furnished, very private, with vaulted ceilings on a beautifully landscaped 3 acre privately enclosed property. Property has a gated entrance with private gate code, ...
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Keaau
E Komo Mai (welcome) to Hale Hapu’u! Our little Hawaiian hut is perfect for couples seeking an authentic Big Island experience. The Hale is adorned with hand carved art from local artists, an outdoor bath set in the midst of a tropical garden...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Keaau
New home and new VRBO listing. House was built in 2020 and has all modern amenities! Get away from the crowds! Experience the best of all worlds; 3 blocks from the ocean on 1 country acre, a gated private home, and only a 45 minute drive to the ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Keaau
The Lava Suite.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Keaau
Welcome to the Blue Horizon. Our luxurious, modern villa with hot tub by the cliff is a perfect place for a family vacation for up to 6 people, 2 story approx 2300sf + 1000sf of view lanais. Downstairs has 2 bedrooms with king beds and 2 bath. ...
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Keaau
Our Beach Road Hale is located in a safe, and peaceful community. In a walking distance from this bnb is a popular 2.5 mile hike to a beautiful secluded beach with turtles relaxing on the shores. Down the other end of the road about a 2min drive...
1 bedroom
1 bathroom
Sleeps 6
Hawaii> Keaau
3 BR/2 BA A-frame home on a beautiful one-acre lot surrounded by a variety of over 40 tropical botanicals and fruit trees. This home has 3 lanais (1-covered, 1-screened in) and an outside dining area with a BBQ. Open concept with large ...
3 bedroom
2 bathroom
Sleeps 10
Hawaii> Keaau
This is a 2-bed, 1-bath with a separate kitchen and dining area, newly constructed unit with air conditioner in both bedrooms, located on a one-acre land harboring the most unique feature of Hawaii Paradise Park in Keaau, offering a real retreat...
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Keaau
Modern home, over 3,500 sq ft; a resort-quality property that can sleep up to 10 guests, on an amazingly lush, fully-landscaped acre. Large living room, exceptional kitchen and dining areas, four lovely bedrooms, a study has been equipped with ...
4 bedroom
3 bathroom
Sleeps 10
Hawaii> Keaau
Peaceful oceanfront paradise! Absolute oceanfront paradise on lava cliffs centrally-located between Hilo, Volcano's National Park and Pahoa. See whales (in season November-March), sea turtles and spinner dolphins right from your backyard! Fully ...
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Keaau
Located in a quiet neighborhood on the pahoehoe lava rocks above the blue Pacific Ocean. Wake up to the most beautiful sunrises and fall asleep to the lull of the ocean waves.
2 bedroom
2 bathroom
Sleeps 8
Hawaii> Keaau
Tiny house located on the Big Island of Hawaii - 10 min drive to Pahoa town, and 30 min drive to downtown Hilo. This getaway bargain is ideal for a single traveler or couple vacationing for a short or long stay.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Keaau
Built in 2022!
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Keaau
Summary:
4 bedroom
2 bathroom
Sleeps 6
Hawaii> Keaau
Be the first ones to stay in this new beautiful designer home. Mid-century modern meets Hawaii. Come and sip a green tea in this luxurious 1 bedroom ocean view home. Nestled just one short block away from the ocean cliffs of Hawaiian Paradise ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Keaau
Peaceful one acre fenced property close to paved main roads. We are minutes from the ocean, downtown Hilo and Volcano National Park.
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Keaau
Orchid Land | 31-Day Minimum
5 bedroom
2 bathroom
Sleeps 8
Hawaii> Keaau
Welcome to Hale Waikahekahe Nui, a stylish and newly constructed luxury home on the east side of the Big Island. Halfway between Hilo & Pahoa, this home is conveniently located to explore the natural wonders of Hawai'i Island. A private ...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Keaau
4 oversized bedroom 3 bathroom, including 2 master bedrooms and enclosed verandas, fully remodeled home in Hawaii Paradise Park. If you wanted to go to the beach or explore Volcano National Park, it's conveniently located for you to explore the...
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Keaau
The Blue Banana Bungalow is located on the Makuu side of Hawaiian Paradise Park, about 30 minutes from Hilo. It features an open kitchen, dining, and living space, and a full bathroom downstairs, and one bedroom upstairs. It is most comfortable ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Keaau
Experience Paradise at Mele Kohola: Your Front Yard Whale Watching Haven!
4 bedroom
3 bathroom
Sleeps 8
Hawaii> Keaau
Comfortable home in Keaau is your base for seeing all of our beautiful island (Hawaii - Big Island). This ohana (family) home has 2 bedrooms - one with a comfortable queen bed and the other with a double full sized bunk bed. Complete new ...
2 bedroom
1 bathroom
Sleeps 6
Hawaii> Keaau
Enjoy a blissful vacation at the Heavenly Hawaiian Paradise Beach House. This 3BR/2BA retreat is perfect for groups of 10, offering welcoming spaces both indoor and outdoor to dine and relax in the beautiful Hawaiian weather. Spacious outdoor ...
3 bedroom
2 bathroom
Sleeps 10
Hawaii> Keaau
Feel comfortable booking our listing.
4 bedroom
3 bathroom
Sleeps 10
Hawaii> Keaau
A serene oceanfront retreat tucked away along the scenic Beach Road in Kea’au, Hawaii. Experience the Big Island’s natural beauty where the sound of crashing waves against the cliffs and tropical breezes greet you every morning.
3 bedroom
2 bathroom
Sleeps 7
Hawaii> Keaau
Experience the best of The Big Island from this 1-bath Keaau studio! This vacation rental features a comfortable living area with lovely natural lighting, a well-equipped kitchenette, and access to the area’s most popular sites. Catch some ...
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Keaau
Welcome to Hale Kāhili! Enjoy a relaxing retreat at our peaceful, pet-friendly home in Hawaiian Paradise Park. Our spacious 4 bed 2 bath home accommodates up to 9 guests and is perfect for families or groups looking for a comfy and convenient ...
4 bedroom
2 bathroom
Sleeps 9
Hawaii> Keaau
Villa Paraiso started rentals in January 2018. Property is specially good for families visiting Hawaii due to quiet hours required in the neighborhood. Before booking please read the 5 house rules below.
3 bedroom
3 bathroom
Sleeps 12
Hawaii> Keaau
The cabin is a very satisfying living space. High ceiling with loft bedroom high end Serta queen sized bed. A fully functional kitchen is also included. It's a very romantic and cozy space especially for couples. You get acces anywhere in the 2 ...
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Keaau
1.36 acres of exotic Tropical food forest with over 100 fruit trees and beautiful landscaping. Centrally located between Hilo, Pahoa and Volcano park.
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Keaau
Mele Kai
3 bedroom
3 bathroom
Sleeps 6
Hawaii> Keaau
Hale Kai
3 bedroom
2 bathroom
Sleeps 4
Hawaii> Keaau
Exceptional Oceanfront Vacation rental. The home has been totally renovated, everything including furnishings are top of the line, Central Spit AIR CONDITIONED , with private POOL. Here is Hawaii Island at its best. Sit on your lanai and watch...
2 bedroom
3 bathroom
Sleeps 5
Hawaii> Keaau
Located in the heart of Hawaiian Paradise Park, the second largest sub-division in the United States, this exquisite vacation rental is only 3 minute drive to the ocean, conveniently located to many tourist attractions and adventure activities....
4 bedroom
4 bathroom
Sleeps 10
Hawaii> Keaau
This Oceanfront home on a half acre of land in Hawaiian Paradise Park gives you the privacy and serenity you're looking for. Set just back from the cliffs it is in full view of the glorious sunrise and dramatic sapphire blue ocean year round! ...
2 bedroom
3 bathroom
Sleeps 4
Hawaii> Keaau
Paradise Retreat is your own private resort on Hawai'i’s Big Island. Relax and enjoy the swimming pool and hot tub in our private, fully enclosed back yard. Lounge poolside in the sun-soaked chaise chairs or stay cool on the covered lanai. In ...
4 bedroom
3 bathroom
Sleeps 6
Hawaii> Keaau
Located in the Kaloli Point sun belt on the East side of the Big Island of Hawai, House of Paddles is within earshot of the Pacific Ocean’s crashing waves. This private tropical oasis is a two-minute walk from the spectacular Puna coastline to...
4 bedroom
3 bathroom
Sleeps 7
Hawaii> Keaau
Welcome to your private oasis on the east side of the Big Island. The first thing you will notice are the breathtaking ocean views, picturesque palms, and refreshing sea breeze - Hawaii’s natural air conditioner! A covered lanai offers the ...
2 bedroom
2 bathroom
Sleeps 4
Hawaii> Keaau
Jungle Villa exemplifies the romance of a tropical island getaway. The very private yard is surrounded by areca palm trees. The Royal Poinciana flowering tree in the middle of the yard erupts in lava red blooms parts of the year. Flowering ...
1 bedroom
2 bathroom
Sleeps 3
Hawaii> Keaau
Sunset Suzys Tropical Retreat is located perfectly 15 minutes outside of Hilo town in a beautiful neighborhood called Hawaiian Paradise park.. It is located on a beautiful one acre lot, filled with fruit trees, green grass, green geckos, and ...
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Keaau
Escape to a charming traditional Hawaiian home, elevated on post and pier for enhanced airflow and privacy. This unique blend of classic architecture and mid-century design features an open-concept great room, complete with a sunken living area,...
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Keaau
