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 '%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
Luxury. A cut above all other condos, hotels, or rentals. Don’t settle. This unit is clean, modern, and provides everything you could ever want and more. Located just steps from the ocean, our condo offers stunning panoramic views of the ocean...
- 1 bedroom
- 1 bathroom
- Sleeps 2
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 BBQ, water feature, patio table & chairs and lighted umbrella to enjoy ...
- 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
Marriott Kauai Beach Club1 Bedroom Unit Sleeps 4
**Photos are stock images of the resort and do not guarantee the view type shown"
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
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
1 Bedroom Condo with King in Master, Sleeper Sofa in Living Room. Full Kitchen/Balcony/Deck Washer/Dryer/Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, Wyndham Bali Hai Villas ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
1 Bedroom Condo with King in Master, Sleeper Sofa in Living Room. Full Kitchen/Balcony/Deck Washer/Dryer/Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, Wyndham Bali Hai Villas ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
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
1 Bedroom Condo with King in Master, Sleeper Sofa in Living Room. Full Kitchen/Balcony/Deck Washer/Dryer/Wireless Internet. No A/C - ceiling fans only
Located in the leading resort community of Princeville, Kauai, Wyndham Bali Hai Villas...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Location: Come experience the very best of island living at One Ala Moana, steps away from Ala Moana Shopping Center. Minutes to Waikiki, downtown.
Interior: Features Philpotts designed deep-smoked walnut wide plank flooring. Magnificent ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
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
Ka'anapali Beach Club by Diamond Resorts 1 Bedroom Unit Sleeps 4
**Photos are stock photos of the resort and do not depict the actual view of the unit booked.
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Diamond Resort Kaanapali Beach Club -OCEAN VIEW 1 Bedroom Sleeps up to 5
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Lawai Beach Resort 1 Bedroom Sleeps 4
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking process ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Koloa
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
This Kaua’i Marriott Resort on Kalapaki Beach is known for its warm island hospitality and idyllic location on the Garden Isle. It underwent a $50 million upgrade, with major enhancements to all of the guest rooms, suites, restaurants and pool...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lihue
Wyndham Waikiki Beach Walk - 1 Bedroom Unit Sleeps 4
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking process ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
Castle Bamboo Waikīkī Hotel #903 - Indulge in this specialty suite with a unique outdoor living room on an oversized lanai overlooking the city. The space is anchored with stone flooring and furnished with sofa seating under a thatched hut, ...
- 1 bedroom
- 1 bathroom
- Sleeps 5
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
Private Cottage 1/2 mile walk to the beach!
We are a Tahitian Style Pole House, set as the first house on a cul-du-sac about 15 walking minutes for Kamaole Beach Parks 2 and 3 and beautiful Kiawakapu Beach. We offer you your own Maui home...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Our Oceanfront one bedroom corner unit 608 is located on the North End of the Maui Kai. The direct view of the beautiful blue pacific will take your breath away. The islands of Lanai and Molokai in the distance and the northern coastline are ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
***PLEASE NOTE THAT THE POOL AREA WILL BE CLOSED FROM NOVEMBER 3-7, 2025 FOR ROUTINE ANNUAL MAINTENANCE. We apologize for any inconvenience. ***
This gorgeous remodeled deluxe one bedroom, two bathroom unit features contemporary Island ...
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kihei
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
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
Thank you for your interest in booking with Bellani Vacations!
**Please "CONTACT HOST" first to confirm that your dates are available, and to receive an accurate price quote. The Vrbo calendar is not always accurate in real time, as ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapolei
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
Just 2 blocks from the world-famous Waikiki Beach. Short-term 1 to 6 month rental (28 day minimum). Completely renovated 1 Bedroom, 1 Bath condo at Waikiki Lanais with a private lanais with golf course and mountains views. Unit features all new ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Honolulu
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
The Whaler at Kaanapali Beach is situated on the magnificent Kaanapali coast with beautiful beaches and beachfront walking path next to the upscale Whalers Village with high-end shopping, dining and the famous Hawaiian gem Black Rock. It is an ...
- 3 bedroom
- 2 bathroom
- Sleeps 5
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
Concierge Realty is proud to present luxury suites at Marriott's Waikoloa Ocean Club!
** Reservations are available in weekly (7 night) increments with arrivals and departures on Fridays, Saturdays, and Sundays only.
** All ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
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
Soak up every shade of blue in this recently remodeled one-bedroom one-bathroom deluxe suite with views of the Pacific Ocean which you can enjoy from your private lanai. This unit's décor brings the beautiful blues into your living space. The ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> HONOLULU
Wyndham Bali Hai Villas 1 Bedroom Sleeps 4
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” FEATURE***
Book our Amazing Luxury Villa & let The Timeshare Brokers, LLC make the booking process ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Princeville
Bellani Vacations is happy to offer 1 bedroom villas at Ka'anapali Beach Club!
**Choose a Friday, Saturday, or Sunday for check-in, and enjoy a 7 night stay. We can typically book this resort in 7 night increments. Please use the ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Enjoy your stay at a newly remodeled 1 Bedroom apartment, located .5 a mile from the water and 1.5 mile away from famous Magic Sands Beach. Beautiful area to go Biking or jogging. When you're not outside enjoying paradise, you have your own ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua-Kona
Marriott Kauai Beach Club- 1 Bedroom Oceanfront Unit Sleeps 4!
**Photos are stock images of the resort and do not guarantee the view shown**
***PLEASE DO NOT PUT IN A RESERVATION REQUEST USING THE “REQUEST TO BOOK” ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lihue
