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 '%1 bedroom%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Welcome to our home, Sugar Beach 311. This is a non-smoking, professionally cleaned, recently renovated and updated one bedroom condo. It is an immaculately maintained and spacious one bedroom, third floor corner unit, with front and side views
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Papakea is an unique property. Instead of a high rise it is a set of buildings only 4 levels high. There are three sets of buildings that front the ocean and we are located in the middle section--the perfect location for reaching either of the
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Maui Kai #604. One Bedroom- Flat screen TV, King Bed, Queen sofabed; TV in bedroom. | | This is a beautiful one bedroom sixth floor unit, with expansive views of Molokai and Lanai. Decorated luxuriously with beige tile in the entryway, kitchen
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
The best rainbows are mountain facing. This 10th floor, fully furnished (washer/dryer) is located in the Hokulani Tower at Honua Kai Resort & Spa.
Honua Kai resort offers beach access, multiple pools, water effects, spa amenities, and
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
ALOHA!
***As of September 16th, 2024, we have installed two new split-unit AC (air conditioners)—one in the living room and one in the loft. Both units are of the highest quality and were professionally installed by one of the most
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kahuku
Turn key ready for a relaxing stay.
With on site parking, a common use gated entrance leads you down a lava rock pathway to a private gated courtyard that contains a propane BBQ, water feature, patio table & chairs and lighted umbrella
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
Simply Exquisite! The photos say it all!
This fully air-conditioned penthouse level unit is sure to make your stay in Paradise a romantic and memorable one! Recently remodelled and expertly finished by the best tradesmen, it boasts
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Come and enjoy our island home with us. Koi Palms Cottage is located within our gated property alongside our lovely Koi pond, in the quaint town of Kailua. The owners live on the property in the main house.
The cottage is a 600 square foot 1
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
This one bedroom, smoke-free condo, is located in Ekahi Village, and is a short (less than 4 minutes) relatively flat walk to the beautiful Keawakapu Beach. The unit is located in the lower village. You can stay on the beach for the day or
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> wailea
Retreat from the cares of the world in this tastefully furnished, one-bedroom, one-bath, oceanfront home.
TVR #5082
Punana Aloha, which means 'Love Nest' in Hawaiian, is a one-bedroom, one-bath hideaway on incomparable Anini
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
Beautiful Ocean-view 1-Bedroom Villa available throughout the year, located on Maui's pristine northwestern shore.
The 900sqft Villa includes a fully-equipped kitchen, dining area, bathroom, spacious living room with a pull out sofa bed,
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
If you know your dates I can book as soon as the booking window opens - time stamp guarantees best views! Inquire about the sister property, Westin Nanea, also. I have one bedroom or two bedroom.
Rated one of the best beaches in the world,
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Please come to Maui! The tragic losses in Lahaina left the community devastated and forever changed. Despite the tragic loss, the locals on Maui still need your support. Local restaurants and business are open. Please come support the local
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy a luxurious stay at this beautiful resort located on Ka'anapali Beach in Maui. It has gorgeous views of the Pacific Ocean and the islands of Lana'i and Moloka'i. You can relax by any of several pools while your children play in the kiddie
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This spacious 7th floor unit at the Ilikai Hotel offers comforts of home while on vacation. Relax on the cooler side of the building and enjoy the tropical breezes from the mountain.
KITCHEN
- Refrigerator
- Cooktop/Oven
-
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Ignite your senses with warm, sunny beach days and dazzling sunsets!
Ocean View, Beautiful 1 Bedroom, 1 Bath Premium largest size villa at 900 sq ft, sleeps 4. Parking included, no fees.
Full Resort Access. On one of the world's most
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
If you've been imagining the perfect place to enjoy your upcoming Waikiki getaway, look no further! Expansive Ocean and Park views, private lanai, central air conditioning, covered parking and rooftop pool and saunas check all the boxes and make
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
Welcome to paradise! At a time when there was much uncertainty in the world, we made a big decision to purchase in May 2021, as our lifelong dream is to snowbird in Maui. Until that time comes, we would love to share our home with others.
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Wailea-Makena
This 1 bedroom suite located in the heart of downtown in Executive Centre. Free parking is included! It is 15 minutes to Waikiki, airport. It has central AC, free wifi, and an on-site laundry room. If you don’t have a car, no problem, there
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Newly renovated in clean white with bright accent colors. Features a separate bedroom with it's own lanai. Full kitchen with full size refrigerator, stove, new built-in microwave, Keurig coffee maker, toaster, rice pot, utensils, pots, pans &
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Maui Ka’anapali Villas #A405: One bedroom ocean view on N. Kaanapali Beach with Pool and Beach Access. Maximum occupancy: 3
This condominium is located in the Aloha Tower, the central hub of the property. Situated on the 4th floor, this
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Lahaina
Kaanapali Beach Club is an amazing property with a beautiful swimming pool with a great slide for the kids 🐚humongous hot tub 🛁seats 24 ,made out of lava🌋 stone beautiful gardens🌺 fitness room. Roof top Putt Putt a golf ! Ping pong
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
We are a 1 minute walk from the amazing Ulua Beach. You can see and hear the ocean from our condo. Relax viewing the ocean on a private, quiet lanai surrounded by tropical gardens. Earth-friendly furnishings and complete “green” remodel.
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Wailea
#135 Casa De Emdeko is amazing. The condo is 920 square feet, on the ground floor 30 feet from the sand and less than 30 yards from the ocean. .
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
Enjoy a luxurious stay for a fraction of the cost. Typical savings range from 30-70% when comparing our rates to direct resort bookings. All of our units are managed and maintained by the resort. Upon arrival, guests will check-in at the
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Discover Your Perfect Beachside Retreat in Poipu
Experience paradise in our newly remodeled 1-bedroom condo, ideally situated on Kauai's southern shores in beautiful Poipu. Whether you're a young family, a couple, or an active traveler,
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Poipu
The Palms at Wailea #1804 has been completely renovated, be among the first to enjoy this brand-new high-end renovation in Wailea in which every room has been updated. This bright, spacious condo has a refreshing beach personality, 1000+ sq.
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy the lush beauty of Maui from this single level one bedroom, two bathroom condo located at Kamaole Sands in Kihei. Take a swim at the resort pool or at Kamaole Beach Park just across the street!
At Kamaole Sands 8-203, you can relax
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Our condo is located in east end of island of Molokai. It is NOT on Maui. Watch whales from the lanai during season Dec-April.
The lanai has a full size comfortable couch, table and chairs to enjoy whale watching, sunrise,sunsets and stars
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kaunakakai
2024 DATES OPEN! Super Specials for January! Friday to Friday (cheapest airlines) Jan 12-19 and 19-26. Please message bofore confirming.
Marriott's Kaua'i Beach Club awaits you and your family. Steps from Kalapaki Beach, our amazing
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
If you are looking for a small resort in Maui, then look no further. Aloha Pualani boasts 6 private units with a pool, BBQ and outdoor seating area. Take a stroll across the street to a beautiful sandy beach.
Come and enjoy your Maui
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Our number one priority at SEArider is to provide our guests with a luxury Hawaiian experience. This unit has been completely renovated with our main focus being quality and comfort. Nestled in the condominiums that surround Turtle Bay, TWO has
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Fully remodeled in April 2023, this upscale and spacious one-bedroom retreat awaits you. Unit # is 626 on the 6th floor of the Hokulani tower. Enjoy all the amenities the Honua Kai resort has to offer, freshly prepared meals in your fully
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Kamaole Sands unit #10-213 located on the second floor: This charming one-bedroom/one-bathroom partial ocean view features modern Hawaiian décor throughout the space. The open-concept layout and design were curated with style and comfort in
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
• Oceanfront
• Central A/C unit
• King bed
• Remolded May2023
• Beach access from condo complex
Welcome to our home at Kauhale Makai 610. Our home was updated in May of 2023. Our beautiful and pristine
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Enjoy this relaxed and private, direct ocean front penthouse condo on Kahana Bay. Spectacular views of Molokai, Lanai & Sunsets. Feel the tropical breezes off of the ocean. Smell the fragrant flowers, dip your toes in the warm island waters. Now
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Built in 2022!
This large luxury1-bedroom suite, the main part of the 4 beds, 3 baths single family house with its own private entrance, is located on a one-acre land harboring the most unique feature of Hawaii Paradise Park in Keaau and
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Keaau
This stylish place to stay is perfect for your trip. Fully loaded with everything you need in the kitchen and out on the beach! You'll have a wonderful experience staying at this condo. Kick back and relax with the A/C or hangout outside on the
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kihei
Entering this totally remodeled 1 bedroom/1 bath beachfront condo you are immediately confronted with stunning, unobstructed ocean views. The upgraded kitchen and bathroom are beautiful with marble tiling, granite counters, and lovely cabinets.
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
*** Sanitation/Cleaning Update ***
We understand that our guests’ expectations for hotel cleaning and disinfecting have changed. That’s why we’ve taken additional measures beyond our industry-leading cleaning standards by
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
This spacious one-bedroom resort suite measures approximately 628 square feet. You will enjoy a queen bed in the master bedroom and one queen Sleeper Sofa/Murphy bed in the living area.. Additional amenities include a full kitchen and dining
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kauai
Welcome to Maui Vista 1312. This eclectic updated partial oceanview 1 bedroom condo is located in the heart of South Kihei. This condo can accommodate 4 people & has everything needed to feel at home. Cross the street & end up at Charley Young
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
THOUGHTFULLY CURATED BY OWNER/ARCHITECT TO CREATE A STRONG SENSE OF BELONGING.
YOUR ULTIMATE HAWAIIAN RETREAT IN THE HEART OF WAIKIKI
31st-floor corner unit in the Island Colony Aqua hotel building. You are in the CENTER of
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Honolulu
Welcome to Nani Kai Hale 209. This is a completely remodeled oceanfront 1 bedroom, 2 bathroom condo stunner. Enjoy ocean views throughout this unit and from your private lanai. Being a corner unit the condo feels more private, with more natural
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Kihei
- Villa closest to Oneloa Beach
- One level condo with 17 stairs between parking and front door
- Travertine tile floors in living room, dining room, kitchen and bathroom and carpet in bedroom
- Contemporary galley kitchen with granite
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- 22 stairs between the driveway and front door
- Tile floors throughout this 2-story condo
- Updated kitchen with granite counters includes stovetop/oven, microwave, refrigerator with ice maker,
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
1 Bedroom Golf View
- Kitchen features granite countertops, ceramic cooktop and oven, refrigerator, microwave, dishwasher, coffeemaker, toaster, rice cooker, blender, cookware and tableware
- 1 king bed or 1 queen bed
- Queen sofa bed
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Waikoloa
