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
Freshly Renovated One Bedroom Ocean View Suite at Marriott's Maui Ocean Club!
Family time is limited, make the most of your vacation time with an out of this world Ocean front experience. Why pay for a small hotel room when you can get ...
- 2 bedroom
- 2 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, ...
- 1 bedroom
- 2 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
VIDEO OF CONDO: SEE #3 PHOTO
THIS IS AN '03 UNIT OR A REAL "1 BEDROOM OCEAN VIEW & KITCHEN".
THE '02 & '03 UNITS HAVE 1 BEDROOM AND FACE THE OCEAN. THE '01 & '04 UNITS ARE STUDIOS FACING THE CITY. ALL OTHER UNITS ARE MOUNTAIN ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Honolulu
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
Contact us at 206 484 3766
Amazing oceanfront 1 bedroom, 2 full bath condo. Located in tower 1, 4th floor, unit #407, at The Whaler Resort on a beach often voted "one of the worlds most beautiful".
We are on the south "sunny" ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Condo, 1 Bedroom, 1 Bath, (Sleeps 1-4)
Aloha! Welcome to Paradise!
Located in the newer Konea Tower!
Welcome to the Honua Kai Resort and Spa, Maui's newest luxury beachfront resort. Located in West Maui, North Ka'anapali ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaanapali
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
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
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
This gorgeous remodeled deluxe one bedroom, two bathroom unit features contemporary Island style furnishings throughout. A fully equipped gourmet kitchen provides all your cooking needs, including granite countertops and stainless steel ...
- 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
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
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
Charming resort setting near town on Alii Drive, with elevators, central AC, 2 pools and a private sandy beach right on the shoreline.
This 1 bedroom unit will sleep 4, as there is a King bed in the bedroom, and a queen sized sleeper ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua Kona
Maui Banyan F-103 Ground Floor Condo - COMPLETE REMODEL.
**Please note: This is a ground floor unit, although there are stairs down from the parking lot and another set of stairs down to the ground floor hallway.
We purchased ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Amazingly beautiful intimate gated community nestled in ancient lava flow with stunning tropical landscaping including water features and golf course views. Adjacent to two magnificent golf courses, The Bay Club has 2 tennis courts, 3 pools, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Waikoloa Village
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
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
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
