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 '%Bungalow%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Aloha,
In regard to the Covid-19 restrictions, Hawaii Governor David Ige has announced that people traveling to the state now must be in possession of the results of their COVID-19 tests before departing on the last leg of their trips. If ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Ocean View
The “Lalamilo Beach Bungalow” has been a labor of love for the owners, who have taken a personal interest in the restoration and preservation of this historic,1930’s beach front home. Originally accessible only by boat (there were no ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
POIPU-- Kauai-- Vacation Home Rental-- Ho'ona Road-- Baby Beach Bungalow 2 is steps away from a crescent-shaped white sand beach called Baby Beach and is located in a family-friendly neighborhood on Ho'ona Road.
We do not have A/c, all ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Poipu
Location Location Location! Our Lanikai ocean front location exactly in front of the twin Mokulua Islands provides endless hours of outstanding views from the ocean front yard, the living room, dining room, and side deck.
A perfect place...
- 3 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua
Mana Kauai Island Vacations present the charming Umetsu Cottage!
Welcome to our idyllic one bedroom, one and a half bath cottage at the Hanalei Bay. This remodeled beach cottage reflects the era of Old Hawaii. Located steps from the iconic ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Hanalei
Welcome to South Sea Bungalows:
South Sea Arts has grown beyond the gallery and restaurant designing to provide Polynesian culture aficionados, collectors of Hawaiiana and people who appreciate culture in an oasis to call home during their ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapolei
Please inquire for one or two night rentals.
Hale Hapuna is your private oasis perfectly located to enjoy all the Big Island has to offer.
World class beaches of Hapuna and Mauna Kea await you just 5 minutes away as well as many ...
- 3 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Waimea
Aloha! We renovated this old-style Hawaiian home so that it will have the charm of old Hawaii with modern conveniences.
This garden oasis (we've planted over 3,000 trees and plants) is in the most awesome location - situated right at the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
Our Home is available and away from the current Kilauea eruption zone. Enjoy your stay here.
Between the Scenic Route and the ocean. Good ocean views in an agricultural setting. All NEW furniture and incidentals. Terrific landscaping....
- 3 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Pepeekeo
Aloha! We renovated this old-style Hawaiian home so that it will have the charm of old Hawaii with modern conveniences.
It is a great retreat for a maximum of 2 easy-going, nonsmoking adults (25 years and older only).
This garden ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
Welcome to the Coco Bungalow, a delightful Oahu beachfront getaway! This stand-alone studio home offers a unique and enchanting experience.
Step inside this beautifully furnished and spacious bungalow, where you'll find comfort and style ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Laie
This lovely 5 bedroom garden-view home is nestled among tropical foliage and surrounded by large green lawns. Guests may enjoy all the amenities of Waimea Plantation Cottages resort including the oceanfront swimming pool, sand volleyball court, ...
- 5 bedroom
- 7 bathroom
- Sleeps 10
Hawaii> Waimea
Wake up on Oahu's dreamy North Shore to the sounds of waves, exotic birds and fresh mountain breeze. Enjoy island living with fast wifi, home office, in house laundry, new powerful AC, 5 min to Haleiwa town with lots of shops & restaurants, swim...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Haleiwa
Hanalei Happy Place Bungalow
Permitted Vacation Rental Property - TVNC#4339
Transient vacation rental is located in the tsunami evacuation zone
Charming bungalow studio with jungle views close to the beach!
Nestled between ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Hanalei
LOCATION LOCATION LOCATION.....
Enter Paradise
Relax and Enjoy the Gentle Breezes of Kailua…
The Original Kailua Beach Bungalow is elegantly renovated with a spacious open floor plan. Modern design mingles with Hawaiian tradition - ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
Aloha! Step into the ultimate relaxation experience at our stunning 3-bedroom, 2-bath retreat in the heart of Princeville. This beautifully designed Hawaiian-style home features air conditioning and is located on a coveted corner lot in a ...
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Princeville
Kailua's Lofty Bungalow is a premier private luxury bungalow getaway - Modern design mingles with traditional elegance in this newly built bungalow. Beautifully furnished with comfort and ease. Open floor plan that features floor to ceiling ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
Hale Moi #216A. Welcome to your Garden Island oasis: a stylish island-style retreat in the heart of Princeville. This beautiful, newly renovated studio is your perfect home base for trips to Hanalei town (10 mins) and the incredible beaches on ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Princeville
Kailua's Banyan Beach Bungalow is Magnificently Graceful in it's Design. Truly Island Elegance at it's best.... Floor to Ceiling Windows - this beautiful bungalow was built with thoughtful touches and amenities throughout.
Located on a ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
The Shack
Our calendar is updated in real-time & our nightly rates are accurately displayed. Simply enter your desired dates and click 'Book Now!'
Hawaii is calling- answer with this laid-back island bungalow. Just a step from ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kailua-Kona
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
Treat yourself to a gorgeous natural setting with a magical banyan tree while still being close to amenities. Nestled in the jungle and surrounded by greenery, our comfortable bungalow offers a queen bed, small kitchen, private entry, large ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kealakekua
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
Your Waialua getaway awaits at this charming 1-bedroom condo. Marvelous ocean views and excellent beach access make this property a gem for guests looking to unwind. The cozy interior and convenient amenities ensure a comfortable stay. You're ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Waialua
Expansive, updated & private bungalow with a spacious lanai and NO neighbors above, below, or either side. The bungalow has been beautifully updated and features a large kitchen, high-end island furnishings that are classic and comfortable. The...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
On-Site Whale Watching | 4 Snorkeling Sets | Wraparound Lanai
An unforgettable Hawaiian escape begins and ends here at 'Anji's Beach House,' a 3-bedroom, 3-bath vacation rental in Captain Cook. Nestled on the picturesque Kona Coast, this ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Captain Cook
FULLY EQUIPPED, QUIET AND CLOSE TO EVERYTHING!
This is a clean, bright and spacious condo with bedroom loft in Princeville!
We provide you with everything you need and in good quality, making it easy to take advantage of all the ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Attractive, ground floor, 2 bedroom 1 bathroom unit with a separate living room and private entry. On the island Oahu, you'll find comfort, relaxation here while on vacation. 6-8 minute walk away awaits you to world famous Kailua Beach, The ...
- 3 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Kailua
This condo is decorated and furnished with a comfortable tropical, 'home-away-from-home' feel. Since it is family-owned, we take great pride in keeping it immaculately maintained. The on-site management team, Castle Resorts & Hotels, will ensure...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Welcome to Hale Makani Aloha, a gorgeous 1 bedroom and 1 bath condo located conveniently just steps away from the longest stretch of sandy beach on the Island of Maui. Given our excellent location in the heart of Maui and just 10 miles from the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Our Beach Home here next to Hanalei Bay can be yours (Standard Occupancy is 2*)! Walk out your front door and across the grass to the sand and sea.
Hanalei Moon Beach Cottage is named after the famous Hawaiian song "Hanalei Moon," which ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Hanalei
A charming 1930-era cottage, with a screened-in sitting area on the lanai, well-stocked kitchen, bath, will sleep two in a comfy queen-sized bed. Perfect for single or double occupancy. Covered parking close by. An outdoor patio fronting the ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Holualoa
Baby Beach Bungalow I is located in the coveted Baby Beach neighborhood of Ho'ona Road. This charming one-level cottage offers a large master bedroom (king bed) and a guest bedroom (queen/twin bed), each with a full bath, full kitchen, washer ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Koloa
Peaceful cottage getaway at the reef. Enjoy a slice of Hawaiiana in the heart of the South Kohala Coast. Quiet, midcentury modern, newly refreshed cottage just steps from sand beaches, lava tidepools, snorkel, dive, swim, boogie, nap, picnic, ...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Waimea
This will truly be your home away from home vacation! Nestled in a quiet residential neighborhood, you'll be immersed in Kaua'i's ~island time~. Enjoy the less than two minute walk to the beach for the unobstructed view of Ni'ihau and the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kekaha
The Hana Ocean Palms Bungalow is located across from one of Hana's most beautiful oceanfront pools - Waioka Pond (Venus Pool). The property is nestled in a coconut palm grove and surrounded by almost an acre of lush tropical flowers, fruit ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Hana
Aloha & Welcome to our Ocean/Beach front Backyards Bungalow:) If you are looking for paradise look no more! This beachfront backyard bungalow is located just to the right of famous Sunset Beach in the heart of the world famous North Shore on a ...
- 3 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Haleiwa
Our completely remodeled tropical retreat is located in the highly desirable area of South Kihei, which is renowned for its beautiful beaches and proximity to restaurants and shops. This ground floor condo opens up to a lanai with a tropical ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Welcome to our Nalo Road Bungalow, a picturesque home situated just a few blocks from Poipu Beach Park and steps from the ocean. You will love views from the large covered lanai that has plenty of space for relaxing and socializing with friends....
- 4 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Koloa
10% discount for weekly stays July-Aug
Aloha & Welcome to the Kona Bali Kai Complex located on Ali'i Drive in the heart of the famed Kona resort area across from Banyan's surf break and approximately 3 miles south of vibrant Kailua-Kona. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
Laie, Oahu, North Shore Hawaii, 2 bedroom 1 bath apartment on the side of our newly constructed home. Queen bed in one room and the second bedroom has two twin beds, or it can be set up as a bunk bed, or even pushed together for a couple. Sofa ...
- 3 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Laie
With high-end natural Travertine flooring sets the scene for relaxed beachside luxe living. Vaulted Ceilings create an airy & grand feel-magnifying & diffusing sunshine & natural light. The Chef's Kitchen affords comfortable & fun entertaining ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Aloha!
Maui Banyan is an ideal and popular vacation getaway, conveniently located in South Kihei, just a short walk away from the beautiful Kamaole Beach Park II (lifeguard-attended) and the nearby shops and restaurants. The grounds are ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
On half acre of lush tropical setting, minutes away from the historic Holualoa village, (driving), home of the best coffee in the world, also 10 minutes away from Kailua-Kona and beaches, (driving). This room has its own private bathroom and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Holualoa
Wow, this place is COOL! This charming 1960s Beach Bungalow has been thoughtfully renovated for timeless appeal. Enjoy peekaboo ocean views from the lanai (and inside), and walk right across the street to Kaanapali Beach!
Pedal & Dink! ...
- 3 bedroom
- 2 bathroom
- Sleeps 9
Hawaii> Lahaina
Pack your bags for a serene tropical getaway and stay at this light-filled vacation rental in Kailua-Kona! This quaint 2-bedroom, 1-bathroom house on the Big Island of Hawaii, just 15 minutes from Downtown Kona, won’t disappoint! With a ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
THE HOUSE: Light and airy bungalow (single story) located on Halama Street, the most walkable street in Kihei. The bungalow was designed by an interior designer with beautiful and fun touches throughout. Across the street from the ocean and ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Hale kilo hōkū means "star gazing house" because you can clearly see the stars while sitting on the Lanai on any given night. This is a brand newly constructed property located in Hawaiian paradise park approximately 1 mile from the ocean. ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Keaau
2 bedroom/2bath Oceanfront home one mile south of Magic Sands Beach. Crashing waves lull you to sleep each night. Enjoy the Big Island and all it has to offer from the diversity of water sports to beautiful hikes to the Volcano National Park....
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
This will truly be your home away from home vacation! Nestled in a quiet residential neighborhood, you'll be immersed in Kaua'i's ~island time~. Enjoy the less than two minute to walk to the beach for the unobstructed view of Ni'ihau and the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kekaha
