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 '%3 bedroom%') 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
Your Island Paradise Awaits You! Feel right at home in our spacious 1700 square foot, 3 bedroom, 2 1/2 bath Villa with an attached garage. This beautifully decorated Villa is just steps away from the resort style pool featuring a lava rock ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa Village
Transient Tax ID # TA-157-170-4832-01
General Excise Tax ID # GE-157-4832-01
Welcome to Hale Leilani (Heavenly Home). Our home is a stunning 3 bedroom hawaiian style home with soaring plantation ceilings all on one level ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Welcome to our Paradise Home come and relax in luxurious surroundings at our tropical condo, which has been freshly painted, and new air conditioner installed and kitchen renovation, new King Mattress. ( Winter 2016). New appliances, carpet ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Puako
Summary:
Aloha Future Guests,
We are pleased to announce that our home is open for bookings and encourage respectful Guests to resume traveling to West Maui. While Lahaina is rebuilding, we are open and welcoming to guests here in ...
- 4 bedroom
- 3 bathroom
- Sleeps 9
Hawaii> Lahaina
Sit back, relax and enjoy the best view of the Waikoloa Beach Resort! The view from this villa is nothing short of breathtaking. From this villa you overlook the signature hole of the golf course and onto the blue waters of the Pacific Ocean. ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Waikoloa
The main living area of Halii Kai 11F has two luxurious soft sofas facing an armoire with a SMART TV and a DVD player. Adjacent is the dining area with a large table seating 6. The large kitchen has a wrap around granite counter with 3 bar ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
Aikane is Hawaiian for 'friendly' which best describes this delightful beach house. Ocean proximity gives you the convenience of a short walk to a variety of beaches. Walk past 2 homes to the ocean then along the coast past 3 more to reach the ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
2nd most reviews on VRBO!!! See other unit we have available: VRBO #950616
The Resort: Beach Villas at Ko Olina.
The Beach Villa is located at Ko Olina, Hawaiian for Place of Joy. Ko Olina is a picturesque resort located on Oahu's ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Ko Olina
ALOHA! Welcome to Kai Lani, located at the entrance to the world-class Ko Olina Resort and Marina.
Kai Lani is Oahu's finest oceanfront resort condominium. Kai Lani, which in the Hawaiian language means "Heavenly Waters", is the only ...
- 4 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kapolei
We are all saddened by the devastating wild fires in Lahaina. It was an historic town with many good restaurants, galleries, and shops. The harbor was busy with sightseeing boats and whale watching boats in the winter. Cruise ships always ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Come visit our place in Paradise in our Tropical family-friendly fully furnished 3-bedroom/2 bath condo with 2 ocean view lanai/balconies.
PLEASE READ MY GREAT REVIEWS!!
We are at Kamaole Beach Royale unit 512 on the 5th floor with ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kihei
Welcome to Kuilima Estates West. Location! Location! Location!
Only steps to the grounds of the famous and newly renovated Turtle Bay Hotel on the North Shore. We are a Legal Vacation Rental.
The condos are Surrounded by Two ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
Aloha, and thank you for your interest in the Beach Villa's at Ko Olina. This property is one of the newest and most exclusive available for rent on the island of Oahu. But more importantly, this is our island home for much of the year. We ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapolei
Welcome to Marriott's luxurious 5-star resort and its spectacular Lahaina and Napili Tower villas! Your sophisticated, bright, spacious oceanfront 3 bedroom/3 bath villa, with breathtaking panoramic Ka'anapali Beach and expansive Pacific Ocean ...
- 4 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lahaina
This is the one! A real Maui home-away-from-home. Plus, 5th night free for the duration of your visit through October 31, 2024! If you are looking for an impressive vacation home with new Ohia wood cabinets, cupboards, and accents in the ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Wailea
This condo is zoned hotel and is in legal compliance with all Maui County ordinances
Suite "Kai Hele Ku" – The Quickest Way to the Ocean
Suite "Kai Hele Ku," in Hawaiian, means "THE QUICKEST WAY TO THE OCEAN." This luxurious ...
- 4 bedroom
- 3 bathroom
- Sleeps 9
Hawaii> Lahaina
Your Paradise Awaits . . . Aloha and Welcome to Oahu's newest beachfront condominium community! The Beach Villas at Ko Olina offers exceptional resort living at its finest with its earthly warmth and sophisticated island inspired ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kapolei
This beautiful 1850 square foot 3 bedroom / 3 bath town home is a very private end unit which has a wall of windows that fill the living area with natural light. On the main floor, you will find a gourmet kitchen with granite counter tops and ...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Kamuela
***This is the most luxurious stay you can get on the North Shore of Oahu! Our amazing Ocean Villa is one of the only two villas located in the whole Ocean Villa Complex that allows you to have Ocean Views from ALL BEDROOMS. Unlike most houses ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
Base Price $395
This dream vacation home is awaiting you! Kick your feet up and relax on this oceanfront property and turn your dreams into a reality. This home is truly a hidden gem if you want to get away from the hustle and bustle of ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Ewa Beach
Come to the gorgeous Maui Ocean Club and vacation in beachfront style! Marriott Vacation Clubs offer a luxurious and relaxing way to vacation while enjoying all the conveniences of home. Located in the Lahaina tower, this very large 3 bedroom/3 ...
- 3 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Lahaina
-AMAZING VIEWS from the OCEANFRONT balcony!
-Master bedroom with king-sized Westin Heavenly® Bed and HDTV
-Master Westin Heavenly® Bath with large shower, vessel tub and double vanity
-Guest bedrooms with king-sized Westin Heavenly® ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
***Aloha and Welcome to Maui and Luana at Honua Kai Resort***
Luana 10B is a ground level beautifully designed and fully furnished villa in the new Luana subdivision of the Honua Kai Resort with 2047 sf of indoor living space. The large lanai...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
Spacious 3-bd Villa at Ko Olina Resort. Beach Tower 5th floor on private wing with large floor plan (sleeps 6!)
3 Bedroom 3 bath, with panoramic Ocean, Pool, and mountain views.
Family friendly: pack-n-play crib and high chair ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapolei
NEW LISTING! This newly renovated 2-story 3 bedroom condo is located at Turtle Bay in the gated community. This is the ONLY condo with split AC downstairs and central AC upstairs. This beautiful island condo sleeps 8 guests.
This condo ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
Welcome to our beautiful Alii Cove Townhome! This Gated Community is located on Alii Drive across the street from Hon'ls Beach and a five minute walk to the Village of Kailua-Kona, where you will find numerous restaurants, shopping, ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kailua Kona
This is a unique listing for booking two individual condos under one booking. You'll be renting Konea 312 and Konea 314 side by side, creating a three-bedroom, two-bathroom combination that can sleep up to ten guests!
Konea 314 is a ...
- 5 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Kaanapali
This property was remodeled in 2020 and was just added to our rental pool! We are still working on finalizing furniture then professional photos will be taken.
**THE TOTAL AMOUNT LISTED IN THE "RATE CALCULATOR" REPRESENTS ROOM AND TAX ONLY....
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kaanapali
E KOMO MAI to the House of Beautiful Breezes.
SWANKY TIKI is the Kauai North Shore vacation home you have been dreaming about.
Feel the beautiful breezes, scented with tropical flowers, throughout the house the minute you walk through ...
- 3 bedroom
- 4 bathroom
- Sleeps 6
Hawaii> Princeville
This home has been well furnished and is great for families looking to enjoy a quiet, private vacation yet be near all the amenities of Waikoloa Beach Resort.
The house has been nicely furnished and offers a spacious great room. The ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Waikoloa
Experience a vibrant, brand new condo in the upscale Pili Mai complex. This gorgeous condo, built in 2020, features an abundance of light through the expansive windows and modern clean-line design. Enjoy the spacious balconies (lanai) with the ...
- 3 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Koloa
Truly a piece of paradise. We have visited this beautiful island for the past 25 years, and finally decided to invest in our own property. We've searched out the perfect place so that you don't have to! Located in the Grand Champions Villas, ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> KIHEI
Kauai’s Most Breathtaking Views at Hanalei Bay Resort
Welcome to our North Shore paradise. Unit 9201/9202/9203 is located in the renowned Bamboo building which features the most stunning views of Hanalei Bay and Bali Hai.
This ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Princeville
Come enjoy what Kauai's North Shore has to offer. Nihilani at Princeville Resort is a perfect jumping off point for cruising the entire north shore from this "home away from home" in your very own fully furnished 3 bed 2.5 bath, air-conditioned...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Recently updated, lovely 3 bedroom (king, queen, 1 twin), 2 bath, 2 story duplex condo located at the outskirts of Princeville on Hanalei Plantation rd. A 15 minute walk will get you to the ruins of the old Club Med and a short trail to the ...
- 3 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Princeville
3 Bed Penthouse, 3 Bath Ocean Front View – Grand Waikikian HGVC Hawaiian Village
3 Bedroom Penthouse Ocean Front View Grand Waikikian (3 Bed/3 Bath Ocean View) , Waikiki Beach – Hilton HGVC
Hilton Hawaiian Village
Grand ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Honolulu
Newly reannotated single family home with 3 bedroom 2 bath plus additional office room located in heart of Kailua. Featured patio deck and huge backyard space at the ground floor. Split AC in the living room, full kitchen with a washer/dryer. ...
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kailua
This exquisite three bedroom oceanview residence boasts epic views of the Pacific Ocean from its premier 9th-floor vantage point, well above the tropical foliage of the Konea Tower interior courtyard. The views are abundant throughout and even ...
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Lahaina
A condo owned by a locally born owner who loves the islands and sharing the magic with visitors from around the world. This property has just been renovated in April 2022 and has a fresh new feel to it....
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Waikoloa
Poipu Makai B3 is located on a bluff a couple of yards from the water with stunning, full uninhibited views of the ocean. Enhance your senses – the visual beauty of the waves crashing against the shoreline and the gentle sound of the living ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Castle Po'ipū Shores 406A - This luxurious upper level, 1960 square-foot, the three-bedroom penthouse will have everyone ready to call Kauai their second home. Expansive ceilings highlight the ocean views and natural sunlight with central ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Koloa
Welcome to our large, spacious home in Princeville, Kauai. Perfect for families, couples, or anyone who loves to spread out, this 2000 sq ft 3 bedroom home has been painstakingly remodeled with luxury finishes throughout.
Located in a ...
- 3 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Princeville
This gorgeous 3 bedroom, 3 bath townhouse located in the Nihilani complex in Princeville is the perfect spot for your family vacation. Spacious and inviting, the home has air conditioning throughout, a fully loaded kitchen, a large living area ...
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Princeville
Rarely available three bedroom, three-and-one-half bath with two covered parking stalls. Panoramic ocean views, Diamond Head, all of the Waikiki coastline and romantic sunsets too! World famous Waikiki Beach is right in front of you. Well ...
- 3 bedroom
- 4 bathroom
- Sleeps 7
Hawaii> Honolulu
Marriott Maui Ocean Club - Lahaina & Napili Towers - 3 Bedroom (sleeps 12)
**Photos shown are stock photos.
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury ...
- 3 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Lahaina
Beautifully styled and well equipped, this three bedroom Mauna Lani Fairways townhome is a great choice for your Hawaiian vacation accommodations! The layout is very comfortable with an open flow from the living area and kitchen. The home ...
- 3 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kamuela
Welcome to Ola Loa Hale!!! (Long Life House) This large three-bedroom, two-bathroom condo is the perfect choice for family and friends traveling together. The home is located in the beautiful Keauhou Kona Surf & Racquet Club, a gated resort ...
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua-Kona
Your private paradise awaits just steps away from Kahana beach. This newly remodeled 3 bedroom townhouse was designed by us with laidback, rustic accents and clean, thoughtful designs to welcome you to your luxury coastal stay.
The ...
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Lahaina
Brand New Listing Located in the upscale Poipu Kai neighborhood this new home embodies pure enjoyment and relaxation. The layout of this three bedroom single level home offers all the room and privacy for a trip of a lifetime. The large pool and...
- 3 bedroom
- 3 bathroom
- Sleeps 7
Hawaii> Koloa
