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 '%Kapalua Bay Villa%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Lovely Island Retreat at Quam Properties 14B1
Quam Properties 14B1 is a one-bedroom condo featuring amenities such as picturesque ocean views, vibrant tropical decor, and complimentary high-speed wireless internet. The condo can
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
MAUI IS CALLING AND YOU MUST GO
Your Tropical Paradise Found
Kapalua Bay Villa 31-B2
Inhale the delightful island air and feel the
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Experience unparalleled ocean and white sand beach views from every room in this
luxurious oceanfront villa on Oneloa Bay. Ideally nestled in building #20, next to private
access steps to Oneloa Beach and the resort's three-mile coastal
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
Kapalua Bay Villa offers a tranquil setting with close proximity to many of Maui's top rated beaches, champion golf courses, and restaurants. Kapalua Bay Villa 34B4 will not disappoint you with its breathtaking ocean views, tastefully
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua translates to "arms embracing the sea" in Hawaiian. Enjoy one of the most special places on Maui at this 1-bedroom 1-bath Kapalua Bay Villa. Enjoy expansive views & the fresh island breeze from this second level unit with large bay
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapalua
Experience Oceanview Bliss at Kapalua Bay Villa 12G4!
Kapalua Bay Villa 12G4 is a beautifully remodeled and spacious 1-bedroom, 1-bathroom ocean view condo, just a short walk to the beautiful beaches located in Kapalua. This condo
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Breathtaking oceanfront villa at Kapalua Bay Villas with private lanai, stunning Molokai views, and unmatched privacy-perfect for a serene Maui escape just steps from the ocean and nearby pools.
*Special Offer - Book any KBM rental home
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Lahaina
Experience luxury at Kapalua Bay Villa Located on the ground level! Kapalua Bay Villa 22G2 is a Two Bedroom, Three Bathroom unit with a spectacular 180° ocean view! Featuring an open floor plan and an expansive inside and outside lanai! You
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
- 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
Luxury 2-bedroom, 3-bath Kapalua Bay Villa with expansive ocean views, upscale interiors, three lanais, snorkeling, beaches, and coastal trail access.
*Special Offer: Book any KBM rental home in Hawaii for 6 nights or more with an arrival
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kapalua
FREE daily activities included with your stay value up to $1035! Complimentary admission, every day of your stay*: Lu’au, Golf, Whale Watch (seasonal), Dinner Sunset Sail, Snorkel Sail, Alpaca Farm Tour, Pineapple Farm Tour, and All Day
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Near Kapalua Golf Tournament! Construction Special: 5/12/25-7/11/25 $289/Night; There will be power washing, sanding, grinding, possible jackhammering and painting including scaffolding and ladders staged at the building. A plumbing inspection
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Construction Special Until 5/2/25: $289/Night; Renovation work for Kapalua Bay Villas 29G-2 to begin 12/12/24 - 2/15/25. Work will include drywall, cabinets, counters, and electrical. Building maintenance work at building 29 starts 3/3/25-
- 2 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Lahaina
We welcome you to stay in our lovely one bedroom, one bathroom condo, just a short walk to the beautiful beaches located in Kapalua. Set along the picturesque waters of Namalu Bay, Montage Kapalua Bay welcomes you with genuine island hospitality
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
This unit has a bright, clean, and fresh aesthetic, in the living room, you will find comfortable seating, including the Queen sleeper sofa, an LCD flat screen TV for relaxing after a fun day outdoors and incredible scenic views, large floor to
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Kapalua Bay Villas - 1-bedroom, 1.5-bathroom villa located in an exclusive gated oceanfront community
16 acres with sandy beach and ocean views
Two pools
Tennis courts
Newly renovated and furnished
AC
Free parking and No resort
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Bay Villas 1-bedroom, 1-bathroom villa located in the exclusive gated oceanfront community.
16 Acres with sandy beach and ocean views.
Two pools
Tennis
Newly renovated and furnished.
AC
Free parking and No resort
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
We welcome you to stay at Kapalua Bay Villa 12B4 this lovely one-bedroom, one-bathroom condo, just a short walk to the beautiful beaches located in Kapalua. Set along the picturesque waters of Namalu Bay, Kapalua Bay welcomes you with genuine
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Experience oceanfront bliss at this beautiful Kapalua Bay Villa! This one-bedroom, two-bath townhouse-style villa offers gorgeous views of Maui's shoreline and Oneloa Bay. Tastefully updated with custom cabinetry and granite counters, it
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Bay Villas 1-bedroom, 1-bathroom villas located in the exclusive gated oceanfront community
16 acres with sandy beach and ocean views
Two pools
Tennis courts
Newly renovated and furnished
AC
Free parking and No resort
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Kapalua Bay Villas 1-bedroom, 2-bathroom villas located in the exclusive gated oceanfront community
16 Acres with sandy beach and ocean views
Two pools
Tennis
Newly renovated and furnished
AC
Free parking and No resort
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Ocean-view 2-bedroom villa with full kitchen, A/C, and 3 baths. Walk to Napili and Kapalua beaches, dine on the lanai, and explore nearby golf, shops, and coastal trails.
*Special Offer- Book any KBM rental home in Hawaii for 6 nights or
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Lahaina
Luxurious 1-bedroom, 1.5-bath villa with ocean views, gourmet kitchen, private lanai, in-unit laundry, & resort access. Soaring ceilings & island breezes make this Maui retreat unforgettable.
*Special Offer: Book any KBM rental home in
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
The Kapalua Bay Villas are closest to Oneloa Beach offering spacious one and two-bedroom oceanfront and ocean view villas with well-appointed kitchens, laundry and central air conditioning. Resort amenities include three pools, two tennis
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Lahaina
Refined oceanfront villa in Kapalua Bay with private lanai, direct access to Oneloa Bay and coastal trails, resort amenities, and serene tropical elegance-perfect for couples or small families.
*Special Offer: Book any KBM rental home in
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapalua
This beautiful ocean-view Kapalua Bay Villa is tastefully updated with custom cabinetry and granite counters throughout! Stainless steel appliances in the kitchen. Fabulous ocean views from the upstairs master suite and main living area
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- Split level Condo
- Villa closest to Kapalua Beach
- No stairs between parking lot and front door
- Tile flooring throughout and carpet in bedroom
- Kitchen with stainless steel appliances – fridge with ice maker, stove/oven,
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- Split level condo with 16 stairs between the driveway and front door and 25 steps to Pool C
- Carpet throughout and tile floors in kitchen and bathroom
- Fully equipped kitchen with stainless steel
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- Split level loft style villa with no stairs between parking and front door
- Tile floors throughout
- Updated kitchen with granite counters, farmhouse sink includes – fridge with ice maker,
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- One level condo with 19 stairs between parking and front door
- Tile flooring throughout
- Updated white kitchen with granite counters includes stovetop/oven, microwave, and refrigerator with ice maker,
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- 1st floor villa with 16 stairs between parking and front door
- Travertine tile floors throughout
- Updated open kitchen with granite counters and all the expected appliances, including: fridge with ice
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- One level condo with no stairs between parking and the front door
- Travertine tile floors in living room, dining room, kitchen; porcelain tile in bathroom and carpet in bedroom
- Updated white kitchen
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- Split level villa with no stairs between parking and front door
- Tile floors throughout
- Updated kitchen with granite counters includes – fridge with ice maker, stove/oven, microwave, dishwasher,
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa is closest to Oneloa Beach
- Split level condo with no stairs from parking to the villa
- Tile flooring in kitchen, living room, and bathroom and carpet in bedroom
- Fully equipped kitchen with stainless steel appliances
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- 1st floor villa accessible by 16 stairs from parking lot
- Large oceanfront lanai off living and dining areas with direct lawn access
- Tile floors throughout
- Updated kitchen with granite counters
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- Split level condo with 19 stairs between the driveway and front door
- Tile entry, kitchen and bathrooms, carpet in living area, dining room and bedroom
- Living room, kitchen and ½ bath on first
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Bay Villas Gold Oceanfront 1 Bedroom
- Bay Villas are closest to Oneloa Beach
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom with 1 king bed
- Queen sofa bed in
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
- Villa closest to Oneloa Beach
- 1st floor villa accessible by 16 stairs from parking lot
- Travertine tile floors throughout
- Updated open kitchen with granite counters and stainless steel appliances – fridge with ice maker,
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Lahaina
Bay Villas Ocean View 1 Bedroom
- Bay Villas are closest to Oneloa Beach
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom with 1 king bed or 1 queen bed
- Queen sofa
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Bay Villas Gold Ocean View 1 Bedroom
- Bay Villas are closest to Oneloa Beach
- Fully equipped kitchen includes stovetop/oven, microwave, refrigerator, coffeemaker, cookware, tableware
- Bedroom with 1 king bed or 1 queen bed
- Queen
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Lahaina
Luxurious oceanfront villa with panoramic Molokai views, private lanai, gourmet kitchen, and spa-inspired master suite-perfect for a relaxing Maui escape with comfort, style, and island charm.
*Special Offer- Book any KBM rental home in
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kapalua
