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 '%beach house%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Welcome to the Poipu Beach House. IG @poipubeachhouse. A beautiful 1920s-era plantation home steps from Poipu Beach. This home is a historical gem that takes you back to old Hawaii with original wood floors, lava rock footings, and 100+ year ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Koloa
****Please note this property may not be rented for less than 30 consecutive days. Rental prices will not be reduced or adjusted based on the number of days the rental is actually used or occupied. Please inquire regarding availability for stays...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Haleiwa
LOCATION: Hale Poipu is in an unbeatable location in the prestigious Poipu Kai Resort, adjacent to the world-class Grand Hyatt Resort. It’s a great home base to enjoy and explore Kauai. Within a few short minutes, you can surf at ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Koloa-Poipu
Kona Bay Estates is a gated and patrolled oceanfront community. The Sunset Beach House offers 2700 square feet of luxurious space. It is just 500 meters from the sea. Opening walls of glass offer indoor-outdoor living with spectacular views of ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
Check out this drone video showing the home, neighborhood and proximity to the ocean: https://youtu.be/4d2V5HbQ1cY
Upgrade your Vacation at our Magic Sands Beach House! Best Location, Lifestyle & Amenities! Maximizing Kona's beaches & ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kailua-Kona
This is a legal permitted vacation rental. Permit #TVNC-5151.
See the actual cancellation policy and refund policy in "house rules" and on the rental agreement. Please send us the ages of all the people that will be staying at the house ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Haena
HI Tax ID-W01462890-02
31 Kaiholo place, nestled behind the famous Mama's Fish House(please make reservations before you arrive).
This home has 3 bedrooms, 2 full baths, living room, dining room, dining area, fully equipped ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Paia
The Old Style is a stand alone beach house just steps from the sand as seen above (Standard occupancy is 2*). There is lots of light, great views & a very restful feeling. Single wall redwood was the preferred building style back in the day. It ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hanalei
County of Kauai Rental License # TVNC 1074 - State of Hawaii Business Registration #s GE-075-701-4528-01 & TA-075-701-4528-01 - 24 hr guest contact: Keenan Driver @ 808-639-0772. Please do not call this # to book reservations.
Be ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kekaha
This elegant and timeless oceanfront estate is situated on the scenic shores of beautiful Puako Bay. One of Hawaii's last remaining peaceful little beach communities, Puako is steeped in history from abundant fishing to sugar cane farming and ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kamuela
The property is a legally permitted short-term vacation rental home. The permit license number is: SWTM 2013/0007 /GE-TA#124-364-3904-01.
LAHAINA BABY BEACH PLACE
Is an Eco-friendly, solar-powered, low/no VOC Paradise retreat. A ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Unit B1 is Ocean Front at Sunset Hale. Newly updated 2-bedroom 2.5-bath ground floor oceanfront unit.
The Kitchen, living room and dining area are all facing out to beautiful ocean and sunset views! Enjoy these views from inside or ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Haleiwa
Paulele is a beautiful Hawaiian-style home right on the closest beach road (Weke Rd.) on breathtaking Hanalei Bay! This tasteful and comfortable home has four bedrooms, five baths, a fully-equipped kitchen, and it comes with everything you’ll ...
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Hanalei
Just steps from one of the most beautiful tourist-free beaches on the island of Oahu, this Hawaiian style home is a perfect peaceful getaway for your extended family. Listen to the waves crashing as you relax on the lanai, or barbeque for your ...
- 5 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Kailua
Hale La in Kekaha, Kauai~ TVNC-4251
Imagine spending your next vacation at one of the most beautiful properties on Kauai! Your days are filled with exploring miles of white sand beaches steps from your luxury vacation home, hiking the ...
- 5 bedroom
- 5 bathroom
- Sleeps 11
Hawaii> Kekaha
This gorgeous property is a favorite vacation spot for well-known actors, musicians, athletes, artists, doctors and entrepreneurs. We have many repeat visitors who feel that our house is their second home.
Rising from the Pacific, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Haena-Hanalei
With Brennecke's Beach and Poipu Beach within view and just a short walk away, this two-bedroom, two-bath beach house on Kauai's sunny south shore is a great place to call home when visiting the beautiful Garden Island. Enjoy tropical ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Our Pool is Heated..!
Hale Makai is bright, open and airy with high ceilings and tons of windows. Super clean and meticulously maintained with enough space to spread out both inside and outside.
Our home was recently redone top to bottom ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Aloha & welcome to our home - Hale Kika @ Poipu Kai resort. Hale Kika is an open concept beach house with great views from the main living area, 3 bedrooms and 2 1/2 bathrooms. Views from the house span from the Haupu Mountain to full ocean ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Maui County Rental permit - STPH 2018/0003 (this is a legal, permitted Maui vacation rental)
TA-066-523-9552-02 / GE-066-523-9552-02 TMK-260090240001
It's a Beach House! A place to relax, unwind, listen to the breeze through the ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Paia
Amazing oceanfront condo. Poipu Beach is a short walk away. Completely air conditioned. There are free visitor tickets available at the Poipu Beach Athletic Club. Access to a swimming pool with a water slide, a gym, tennis courts, and other ...
- 8 bedroom
- 7 bathroom
- Sleeps 22
Hawaii> Koloa
GE: 184-440-0128-01
TAT: 184-440-0128-01
Aloha and welcome to the Hale Anna, Maui. The Hale Anna is a beautiful, private home located across a quiet street from miles of sandy beach. This home is a legal Grandfathered vacation rental ...
- 3 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to the Indo Lotus Beach House, where tranquility meets paradise on the "Charley Young" end of Kamaole One Beach in South Maui. Immerse yourself in the sacred and peaceful ambiance just steps away from the Pacific Ocean, offering ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Peaceful and centrally-located beach house along the Seven Mile Miracle, the surfing mecca on Oahu which includes Waimea Bay, Banzai Pipeline, and Sunset Beach. Large 2 bedroom/1 bathroom with high ceilings, off-street parking with spectacular ...
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Haleiwa
**Please contact for availability!
Experience the ideal North Shore lifestyle in this architecturally renowned Hawaiian beachfront cottage. Here you will find the perfect Island getaway for couples or small families looking for privacy, ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waialua
Very rare spot, one of the few single house by Alii dr. and just on the water.
Drift away to paradise in this amazing 2-bedroom, 2-bath Kailua-Kona oceanfront home. The endless ocean views will keep you coming back year after year. Begin ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
One of the original homes on Kailua Beach, this Renovated 1937 five bedroom Cottage is just one house from the middle of Kailua Beach, the #1 Beach in the world. Nestled between a park and a rarely used club with only one beachfront neighbor, ...
- 5 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Kailua
The Kona Lighthouse is centrally located in a peaceful neighborhood along the Gold Coast of the Big Island, a 5-mile scenic, oceanfront drive between the towns of Kailua-Kona and Keauhou-Kona. —- Ideal for family and small group vacations. A ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
ALOHA! The Kailua Bliss Beach House is a casual and relaxed beach house in the quiet Beachside neighborhood in Kailua, located on a private street, 1 house from the white sands of Kailua beach (Private beach gate is located adjacent to our ...
- 5 bedroom
- 4 bathroom
- Sleeps 10
Hawaii> Kailua
Welcome to the Hilo Beach House - A Unique Boutique Inn located in the quiet tropical oceanfront setting of Onekahakaha Beach Park. Stay at this upscale 4 room Inn. Rest, Relax, and Rejuvenate at this Tropical Oceanfront Retreat.
If the...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Hilo
Hoku Lani, or “Heavenly Star” is a two story air conditioned 3 bedroom, 2.5 bath home with lofty ceilings, concrete construction and gorgeous details throughout. You’ll love the mahogany and kiwi custom cabinetry and granite countertops ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kihei
Aloha and Welcome to Kolea Landing
A short walk (less than 400 steps to be exact) and you will be relaxing at Lanikai Beach! Our 2,200 sf guest house is the perfect blend of island and modern living. Our guest house has a master bedroom ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua
The Stice Team of Hawaii Life Vacations welcomes you home to one of the most desirable ocean view one bedroom residences in all of the Papakea Resort. Papakea B105 is a spacious ground-floor residence that is highly upgraded on all surfaces and ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Alaeloa 12 is the perfect getaway for that extended stay. Ask about longer stay discounts.
If you want to live out that dream tropical paradise Maui vacation, Alaeloa 12 is the vacation home for you and your family. Our remodeled home is ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Lahaina
Imagine waking to the sun rising over the Pacific as you are awakened by the sounds of tranquil tradewinds rustling through the palm trees. Not a care in the work with the Mokulua Islands as a backdrop to this new day in paradise!
NUC: ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kailua
This is unique property has singular direct beach access to Polo Beach.
Walk out of your oceanfront yard over a short lava rock path to put toes in the powdery sand, snorkel, boogie board and sand castle. Come back to jump in the pool, ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kihei
Welcome to the Earthy Modern Beach House! Designed with boho, chic, surf vibes & located in a lush private lane of homes right off the famous Ali'i Dr. We are are a 5 minute walk from a lovely hidden beach and 10 minute drive to the town ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
This wonderful 3 bedroom, 2 bath for 8 Kekaha beach house, is located just 200 yards to the beach, just blocks from fabulous Kekaha Beach park, and just a 7 min drive to the road to the famous Polihale Coast! Kekah gets the least amount of rain ...
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kekaha
In the heart of Punalu'u you will find a gorgeous 2 bedroom 1 bath home fully gated with AC in bedrooms and steps from a white sandy beach. There are views of the ocean and of the Koolau mountain range. This secluded property has an outdoor ...
- 3 bedroom
- 1 bathroom
- Sleeps 7
Hawaii> Hauula
Balmy days and breezy nights await at this 2-bedroom, 2-bath vacation rental in Kailua-Kona. With the Pacific Ocean as your backyard, you won't have to travel far for some vitamin D and 'sea,' whether you'd prefer to surf and swim or snorkel and...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
E Komo Mai!
At Nalu Hale (surf house) we welcome you to emerse yourself in surf culture. Wake up to the waves crashing on the shore of Kahalu'u Bay and never miss a sunset. Whether you like to surf, sup or snorkel, Nalu Hale puts you just...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
This is a very special property within a treasure of history, located across the street from Kahalu'u Bay & Beach Park on the mauka (mountain) side of Ali'i Drive. Known for world class snorkeling with beautiful coral reefs, bright fish, sea ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
Experience true paradise in this charming Puako beach house! Featuring two bedrooms and two bathrooms, it's the perfect spot for a family or small group getaway. Just steps away from Beach 69, you can enjoy the peace of the ocean along with a ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kamuela
Stay in this beautifully designed vintage Hawaiian style home 350 feet from the Brennecke's Beach side of Poipu Beach park, in the heart of Poipu. Spacious lanais and outdoor living gives everything Kauai has to offer, as well having your ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Koloa
Indulge in an Unforgettable Stay at Our BRAND-NEW Luxury Beach House at Kailua Beach
Escape to our newly built, luxurious rental home, perfectly nestled in the heart of the most sought-after location by the world-renowned Kailua Beach. ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua
Located in Waianae, this vacation home is on the beach. Perfect for families and those who like surfing, 2 minutes walk away. 2 minutes to watch a beautiful Sunset , The area's natural beauty can be seen at Waianae Mountain...is and Tropic ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waianae
Absolutely stunning 3 bedroom/2 bath beach house. Hale Laʻi Laʻi ~ Home of tranquility and contentment. Recently remodeled to create a feeling of contemporary elegance and relaxation with total beach vibes. Everything has been upgraded with ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
This property is located in a Tsunami Evacuation Zone. Instructions for evacuation are posted near the front door. TVNCU #1294 This 2 bedroom beach house has been freshly updated. Comfortable furniture with covered lanai overlooking the ocean. ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hanalei
The ultimate eco-retreat. Timeless design for indoor-outdoor relaxation, dining and sleeping. Experience ocean views and crashing waves from wide-open bifold doors. Walk nextdoor to Kehena black sand beach, or drive the Red Road to Hawaii's only...
- 2 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Pahoa
Barefoot Beach House is a welcoming three-bedroom, two-bathroom beachfront home perfect for couples, families, or small groups. The large, window-lined living and kitchen area has a fantastic beach park and ocean view out the front, incredible...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Hilo