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, rewritten_description,
(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 '%Retreat%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Discover your family’s ideal getaway in the heart of Princeville at Hanalei, Kauai! Our spacious vacation rental offers a tranquil oasis surrounded by lush landscapes and tranquil gardens. Designed for relaxation and connection, this private
- 4 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Puako Pau Hana is a great place to escape from all your cares! Located in the heart of Puako, you are literally just a few steps to the most beautiful little beach in Puako!
Puako is known for it's magical old fashioned neighborhood feel and
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waimea
UALANI RETREAT
Fully Licensed & Permitted
Locally Owned & Operated B&B
Permit # BBPH 2012/0002
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Haiku
Welcome to The Palms at Wailea – Your Island Paradise Awaits!
Located in the prestigious Wailea resort community, The Palms at Wailea condo complex stands out as one of Maui's most elegant destinations. Our 1-bedroom, 2-bathroom condo
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
Discover beautiful Kauai from this spacious 1 bedroom vacation home (built in 2018) in the heart of sunny Poipu. Located in Poipu Beach Estates, the newest upscale neighborhood bordering the Kiahuna Golf Course, that is just minutes from the
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Koloa
Our Tropical Retreat Guest House is a luxurious 1 bedroom, 1 full bath resort-style guest house located in one of Hilo’s premier subdivisions. Our guest house is truly a tropical paradise with a very spacious living area. The guest house opens
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hilo
Picture Shangri La with rolling mists and sunshine over the canopy of Ohia Lehua with the tip of Mauna Kea poking through the valleys off in the near distance...
Ahu Lani Retreat Center is an educational and retreat facility located at
- 11 bedroom
- 5 bathroom
- Sleeps 20
Hawaii> Honokaa
IF YOU'RE PINING FOR A LUSH, LAZY, LANGUID ESCAPE...A BAREFOOT TRANQUILITY...A BALMY, PALMY, SEA-SCENTED ADVENTURE...LOOK NO FURTHER!!
Rated #1 Because...
1. AS SEEN ON TV - The Discovery Channel recently filmed our home, Hale Mana,
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kilauea
This beautifully decorated deluxe three bedroom condo is situated in the heart of Waikoloa Beach Resort. With no units above or below, the condo offers the most in privacy. It is newly professionally decorated in Ocean colors with granite and
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Hawaii State Tax ID: 148-388-6592-01. Hawai'i County IDs: STVR 19-345557, NUC 19-293
Aloha! E komo mai. Welcome to Fern Cottage. Located across from Volcano Village, and just minutes from Hawaii Volcanoes National Park, we invite you to
- 2 bedroom
- 1 bathroom
- Sleeps 5
Hawaii> Volcano
Anchor Cove D2 is a single story property perched at the beachfront on the beautifully landscaped grounds of Hale Pau Hana Resort. Originally the resort restaurant, the building was reconstructed as a side by side duplex. Its prime location,
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
RiverSong is nestled in two tropical acres alongside Kilauea River. The river sings below and waterfalls splash beneath your private, secluded lanai. Our gardens abound with color from red ginger, gardenia, orange and yellow heliconia, purple
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
Surround yourself with the lush scenery of Maui Breeze Retreat at Ho'ol!ei, a tastefully decorated two-story villa with spectacular views of the Pacific Ocean. Your exquisite island retreat in Wailea offers spacious, well-appointed living
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kihei
One of only seven Hualalai Penthouse Villas. Upper-level Villa featuring single level interior with over 4,200 sq feet of living and lanai space. Hear the sounds of the Pacific Ocean while enjoying the beautiful close unobstructed ocean and
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Nestled on the slopes of Hualalai, the Keauhou Hideaway is a private retreat on 2.7 acres of lush tropical vegetation. The 800' elevation affords a spectacular view of the Kona coastline and ensures warm, sunny days and cool nights.
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Brought to you by Paradise in Hawaii Luxury Homes.
Welcome to Pacific Vista Retreat, a part of our Hawaiian Luxury Collection.
Pacific Vista Retreat in Kahakai Estates is a wonderful 5-bedroom home, minutes away from downtown
- 5 bedroom
- 4 bathroom
- Sleeps 11
Hawaii> Kailua-Kona
Length of stay: MINIMUM 30 NIGHTS. Monthly rental. Property damage insurance required.
Kai Lani is a quiet gated community located in Ko Olina, a 640 acre oceanfront resort on West Oahu, the dry leeward side of the island. Ko Olina
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapolei
The Royal Palms Estate is perfect for multi-generational families, friends, and groups of fewer than 12 people. Unfortunately, we can not have large weddings or parties.
The Royal Palms has 13 Acres Of Exotic Fruit Trees, Tropical
- 5 bedroom
- 6 bathroom
- Sleeps 10
Hawaii> Ninole
PLEASE NOTE: YOU ARE RENTING FROM A PRIVATE OWNER. ALL ACCESS INFORMATION WILL BE SENT TO YOU DIRECTLY FROM THE OWNERS. OUR ONLY ASSOCIATION WITH THE MAUI BANYAN RESERVATION DESK IS FOR THEM TO ISSUE PARKING PASSES AND POOL CODES, THEY DO NOT
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Please read listing description for full details on this lovely property! We also have another listing at the Keauhou Surf and Racquet Club if this property isn't available: Vrbo 1620967.
We are an approved Short Term Vacation Rental
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Immerse yourself in the tranquil sounds of the waves, our oceanfront condo offers the ultimate beach experience! Just steps away, you can enjoy wonderful swimming and snorkeling, and even spot turtles on the beach. Take in the beautiful ocean
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Ekahi Ocean Studio is a studio perfectly located in the lower village of Wailea Ekahi (#8C), a lush-landscaped paradise, just steps from the oceanfront pool and to world-renowned Keawakapu beach. This studio is perfect for couples seeking a
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
We have remodeled our spacious one bedroom condo with amenities to be our home away from home. We invite you to make it yours while you enjoy the finest beaches and sunny weather of Kihei. Keep in touch with free wireless
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Enjoy spectacular, sweeping, front-on views of the Pacific from the living room, bedroom and lanai of this spacious 1483 sq. ft. 8th floor two-bedroom, two-bath corner unit at the Mahana on Ka'anapali Beach - rated as one of the best beaches in
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Hale Kainalu is a sweet getaway at the end of Lanikai with exclusive secluded beach used by only 5 houses within a gated drive. This beautiful cottage is literally right on the beach & overlooks the crystal clear, blue and green hued water. Wake
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua
Modern luxury right on the Waikoloa Village Golf Course! Ocean and sunset views from the lanai and almost every room!! Our Hawaiian home was completely renovated in 2017, with a brand new kitchen featuring custom maple cabinets, quartz
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
Luxurious Tropical Retreat - Unit 31D is truly "one-of-kind"!
Ideally located overlooking the lower Ekahi Village, Unit 31D provides our guests with the best of everything Maui has to offer: spectacular views, privacy and a short stroll
- 2 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Wailea
Special Permit: (SUP2) SUP220170018
Permit: BBMP20170006
Relax in the luxury and privacy of this quiet neighborhood that is still convenient to modern amenities and restaurants. This location is a little slice of heaven, a different
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kula
Experience the Beauty of Hawaii at Ohana Retreat
Ohana Retreat is the ultimate getaway for large families looking to embrace the breathtaking beauty of Hawaii. Our spacious island-style home features eight luxurious bedroom suites, each
- 8 bedroom
- 9 bathroom
- Sleeps 18
Hawaii> Kailua-Kona
Hualalai Hale is your personal Luxe resort home located in the exclusive Hualalai Resort, Hawaii on the Big Island. Offering four beautifully decorated bedroom suites, each with their own bath, this single-story, marbled and wood floor, grand
- 4 bedroom
- 5 bathroom
- Sleeps 8
Hawaii> Kailua Kona
Waialua Retreat is your home away from home! Located on a quiet residential cul-de-sac, you will truly relax as you dine on the lanai of this spectacular, architecturally designed beachfront home, while taking in amazing sunrises and sunsets.
- 4 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Waialua
This newly constructed split-level home features an open floor plan, only the finest finishes, and its own pool and jacuzzi, along with access to the KaMilo pools, fitness center, and other recreational facilities. Luxuriously appointed, it
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kamuela
*Please note: Maximum stay is 12 nights. Mahalo.
*Please note: Bamboo Retreat is not suitable for children under age 10. Mahalo.
Located at 1400' elevation in the lush foothills above Hilo, just 15 min from downtown, this cloud
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Hilo
This property is hotel zoned, and not being affected by the recent proposed legislation.
Luxury at its finest! Ho'olei Villa 17-1! Mesmerizing ocean views and bright open floor plan welcome you. Enjoy the beautiful Maui sunsets on your
- 3 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Kihei
Escape to a lush and secluded mountain retreat Kona coffee farm, just minutes away from sun-kissed beaches, Kailua and Captain Cook. Enjoy picturesque sunsets and stargaze at night. Relax in peaceful moments surrounded by full ocean views,
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Holualoa
Beautifully remodeled ground floor corner unit in Building 20, with Pacific Ocean views! From the front Lanai, there is a broad green lawn, lined with palm trees that take you to one of the most beautiful swimming and surfing beaches in the
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
Aloha and Welcome to Kihei Beach Ho’okipa, located directly on the beautiful six mile white sands of Sugar Beach in Kihei town on the island of Maui.We are centrally situated on Maui’s south shore. Special rates are available let us know
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Kiahuna Plantation #2115: Tropical décor delights in this 690sf rare deluxe ground-floor suite. You and your friends or family can easily access the grounds from your ground-floor balcony and walk to world-famous Poipu Beach which according to
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> KOLOA
Wailea Grand Champions Villas -- Condo #188
Aloha!
You are coming to Maui for your Dream vacation---Why not stay in a Tranquil, spacious condo full of High-end amenities while enjoying the island? We welcome you to share our
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea
Discover your tropical retreat at our enchanting two-bedroom holiday house in Kailua-Kona. Paradise is ready for you. Nestled just a short 11-minute drive from the vibrant Kailua Pier, you'll be perfectly positioned to explore the island's top
- 2 bedroom
- 3 bathroom
- Sleeps 5
Hawaii> Kailua-Kona
Experience an unforgettable stay at the Magical Lava Temple, a 3BR/1BA off-grid sanctuary located 4 miles from the base of the world’s most active volcano. Surrounded by lava fields and breathtaking views, this open-air loft offers a unique
- 4 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Pahoa
Feel at home in this gorgeous corner, top floor villa in the Hali'i Kai oceanfront development in upscale Waikoloa Beach Resort. This fabulous 2 bedroom villa is perfect for 4 adults (plus one child with owner approval).
Enjoy your
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Waikoloa
Leimoku is a large and accommodating, beautifully updated, and modern Hawaii home on Oahu's famous North Shore. Located on the "quiet side" of the North Shore, away from all the crowds, this 3000 sq.ft. home is comfortable and luxurious, with
- 5 bedroom
- 5 bathroom
- Sleeps 10
Hawaii> Waialua
We are THE perfect luxury listing on the east side of the Big Island! A quick distance to black sand beaches, waterfalls, the volcano and charming Hilo town.
ALOHA! Welcome to Hale Kakahi or Hawaiian for “unique, outstanding,
- 4 bedroom
- 4 bathroom
- Sleeps 9
Hawaii> Pahoa
Permits
BBMP2019/0006 & SUP2 2019/0003
GE-081-730-0480-01 & TA-081-730-0480-01
This is a BnB not a STRH
Owners live on property.
Aloha, sorry but at this time we are not hosting to families with children younger than 16.
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Makawao
Pu'u O Hoku Ranch offers a unique getaway for travelers seeking a rustic retreat. You can hike, swim, stargaze, surf, and see a working ranch in action. Pu'u O Hoku is one of the few places in the islands where you can feel Hawaii as it once
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kaunakakai
Wailea Elua 107
Wailea Elua Village is an exclusive beachfront property in the heart of Wailea, offering a tranquil retreat surrounded by 24 acres of lush tropical landscaping. This gated, low-density community consists of two-story buildings
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea, Maui
Experience the Elegance of Oceanfront Living at Lokelani B102 – Your Private Maui Escape
Step into your dream Maui getaway at Lokelani B102, a fully renovated beachfront sanctuary offering uninterrupted panoramic ocean views just steps
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
This property is offered as a monthly rental. Although full-month occupancy is not required, the monthly rate remains fixed and applies in full, regardless of the number of nights stayed, as prorated rates are not available.
Hale Ohana
- 4 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Kailua
Restore and enjoy all Kapalua has to offer! This private condo's idyllic location is perfect for a romantic getaway, or a peaceful place to relax and restore. Take a walk along the beach boardwalk to spot sea turtles, barbecue or lounge at the
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
