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 (registration_number like '%TA-%' or registration_number like '%TA %') AND (city = 'laie' OR postalCode = 'laie' OR region like '%|laie|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
Recently updated ocean view home on an ocean front peninsula. Enjoy the views of Laie Bay from the comforts of the home or deck of the house, or venture to the Ocean Front cliffs right in the back yard and indulge in the beauty captured only ... Registration Number: GE-061-340-5184-01, TA-061-340-5184-01
5 bedroom
3 bathroom
Sleeps 14
Hawaii> Laie
This beautiful 4 bedroom home is an easy 3 minute walk to Hukilau Beach. It has been fully gutted and rebuilt and looks and feels like a brand new home. It is a comfortable, clean and relaxing home equipped with A/C, new King beds in the two ... Registration Number: TA-018-462-4128-01, GE-018-462-4128-01, 550160200000
4 bedroom
3 bathroom
Sleeps 11
Hawaii> Laie
Completely restored in 2024, this light-filled, 2,800-sq-ft, open concept home features breathtaking views of Malaekahana Bay. Enjoy the fully equipped modern kitchen, living/dining room for easy entertaining and a recreation room that has a ... Registration Number: GE-117-816-7296-01, TA-117-816-7296-01, 560010720000
3 bedroom
4 bathroom
Sleeps 10
Hawaii> Laie
Hukilau Beach and the blue waters of the Pacific Ocean on one side and the Ko'olau mountains on the other, Hale Lani lives up to its name as the “House of Heaven.” The perfect choice if you’re traveling with a large family or a group of ... Registration Number: 000055003031, TA-048-589-8240-01, GE-048-589-8240-01
6 bedroom
5 bathroom
Sleeps 14
Hawaii> Laie
Welcome to the Coco Bungalow, a delightful Oahu beachfront getaway! This stand-alone studio home offers a unique and enchanting experience.Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Laie
This Oahu ocean side vacation rental with direct views of the ocean and direct access to Laie Beach right out your front door. Decorated with 100 year old antiques from Java and China, mixed with modern comfort furnishings make this a great ... Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
2 bedroom
1 bathroom
Sleeps 4
Hawaii> Laie
Welcome to Papaya 2 at Tiki Moon Villas, offering an idyllic escape just across from the Polynesian Cultural Center. Ideal for families or intimate gatherings of friends, this two-bedroom vacation rental on the North Shore invites you to ... Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
3 bedroom
1 bathroom
Sleeps 4
Hawaii> Laie
Aloha!Registration Number: GE-171-005-3376-01, TA-171-005-3376-01, 550160680000
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Laie
Aloha!Registration Number: GE-171-005-3376-01, TA-171-005-3376-01, 000055016068
4 bedroom
2 bathroom
Sleeps 9
Hawaii> Laie
Welcome to Pineapple Place🍍30 day rentalRegistration Number: GE-074-604-3904-01, TA-074-604-3904-01, 550170650002
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Laie
"Tiki Moon Villas 5" is comprised of five bungalows nestled within +22,000 square feet (+half acre) or (+2000 square meters) of lush oceanfront gardens. Each professionally decorated bungalow provides guests with full kitchens, high-end linens, ... Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
9 bedroom
7 bathroom
Sleeps 26
Hawaii> Laie
Laie Bay views are right outside your window. The Oceans Edge is literally 50 feet away!! Experience island-style living in this beautiful 4-bedroom Hawaiian beach house. Not only is it in the perfect location, but also offers everything you'll ... Registration Number: TA-436-291-3801-01, GE-436-291-3801-01, 550100380002
5 bedroom
5 bathroom
Sleeps 14
Hawaii> Laie
White Hibiscus Estate is located right off the ocean on one of the most scenic views on the island. Wake up to spectacular sunrises and spot whales during the winter whale season. People come from all over to see the spectacular views and watch ... Registration Number: 550100380000, TA-118-525-3376-01, GE-118-525-3376-01
6 bedroom
5 bathroom
Sleeps 15
Hawaii> Laie
30 day rental, please inquire. 888-799-6920Registration Number: 550010130000, TA-210-165-8624-01, GE-210-165-8624-01
4 bedroom
2 bathroom
Sleeps 14
Hawaii> Laie
30-day rental. Please inquire.Registration Number: 310080170003, TA-018-203-1020-01, GE-032-910-7681-01
4 bedroom
4 bathroom
Sleeps 10
Hawaii> Laie
30-day rental. Please inquire.Registration Number: TA-130-961-3586-01, GE-191-801-2100-03, 130049850002
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Laie
Escape to paradise with this 1-bedroom cottage nestled on the shores of Laie, Hawaii. Embracing the serene beauty of the beach, this cozy retreat offers a tranquil escape with its Bali-inspired decor and warm wooden accents. As you step inside, ... Registration Number: TA-130-961-3586-01, GE-191-801-2100-03, 55002025
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Laie
30 Day Rentals Available. High Speed Internet. Remote Work in Paradise!Registration Number: GE-142-706-2784-01, TA-142-076-2784-01, 550030190000
5 bedroom
6 bathroom
Sleeps 16
Hawaii> Laie
This Non-Smoking, beachfront home sparkles with granite countertops, ceramic tile floors, and ceiling fans in all the rooms. Enjoy ocean views from the deck, dining room, living area, and kitchen; and mountain views from the bedrooms. ... Registration Number: GE-095-556-8128-01, TA-095-556-8128-01
4 bedroom
4 bathroom
Sleeps 10
Hawaii> Laie
PRIVATE BEACH HOUSE Registration Number: TA-089-697-4848-01, GE-089-697-4848-01
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Laie
The Bamboo 2 on Oahu is an incredible ocean side vacation rental. Enjoy direct views of the ocean and direct access to Laie Beach right out your back door. Decorated with 100 year old antiques from Java and China, mixed with modern comfortable ... Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
3 bedroom
2 bathroom
Sleeps 6
Hawaii> Laie
CONTACT HOST - click for answers to your questions on the cancellation policy or the property Registration Number: 910070780000, GE-100-125-6960-01, TA-100-125-6960-01
4 bedroom
2 bathroom
Sleeps 10
Hawaii> Laie
Welcome to Waipuna Cottage, a charming oceanfront property located on a private secluded estate with panoramic coastline views. This oceanfront home is kept in its originally built state with much of the original hardware and fixtures present. ... Registration Number: TA-047-284-4288-01, 550020890000, GE-047-284-4288-01
2 bedroom
2 bathroom
Sleeps 6
Hawaii> Laie
“30 day Vacation rental, Live the beach life in this luxury “BEACHFRONT”vacation home now available, Ideal for you and a large group with plenty of room to house up to 15 people MAX, next to the beautiful beaches of Hawaii. This home has ... Registration Number: TA-026-967-9104-01, GE-026-967-9104-01, 550010830001
5 bedroom
4 bathroom
Sleeps 15
Hawaii> Laie
30 days minimum. This newly remodeled rental is located in Laie on Laie Bay on the famous Hukilau Beach. From the second-story front door landing you have a view of the warm waters of the Pacific Ocean. Your view from the bedroom balcony ... Registration Number: GE-208-556-4416-01, 155003033000, TA-208-556-4416-01
3 bedroom
1 bathroom
Sleeps 5
Hawaii> Laie
Step onto your private patio and feel the warm Hawaiian breeze enjoy direct access to the pristine garden and ocean view beyond. his thoughtfully designed 3-bedroom haven on the enchanting North Shore is not just a place to stay – it's a ... Registration Number: TA-064-440-0128-01, 550020820000, GE-064-440-0128-01
4 bedroom
1 bathroom
Sleeps 5
Hawaii> Laie
Laie, Oahu, North Shore Hawaii, 2 bedroom 1 bath apartment on the side of our newly constructed home. Queen bed in one room and the second bedroom has two twin beds, or it can be set up as a bunk bed, or even pushed together for a couple. Sofa ... Registration Number: TA-096-782-1312-01, GE-096-782-1312-01
3 bedroom
1 bathroom
Sleeps 6
Hawaii> Laie
Lā’ie is a very tight knit community, located on the beautiful North Shore of O’ahu. At our Lā’ie Tiny Home/Mobile Home, you will be offered an immersive experience living in the country side by enjoying fresh coconuts from our property ... Registration Number: GE-100-011-9296-01, TA-100-011-9296-01, 550080430000
1 bedroom
1 bathroom
Sleeps 4
Hawaii> Laie
Ocean Cliffs Getaway is located right off the ocean on one of the most scenic views on the island. Wake up to spectacular sunrises and spot whales during the winter whale season. There is a gorgeous family friendly beach just down the way of a ... Registration Number: GE-116-377-4919-01, 440600890000, TA-112-425-7135-01
5 bedroom
5 bathroom
Sleeps 14
Hawaii> Laie
The Ocean Sun is directly on a sandy beachfront with views of the moon and sunrise on the ocean's horizon and is the perfect location for your wedding-moon or just extended romantic vacation get away. Right out your front door is your personal ... Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
2 bedroom
1 bathroom
Sleeps 2
Hawaii> Laie
*PER COUNTY REGULATION THIS PROPERTY ONLY ACCEPTS 1 BOOKING PER 30 DAYSRegistration Number: 550131010000, TA-103-273-1136-01, GE-103-273-1136-01
5 bedroom
2 bathroom
Sleeps 13
Hawaii> Laie
**30 day rental. Please inquire. 888-799-6920Registration Number: GE-135-452-6041-04, 260100068245, TA-152-452-7104-34
3 bedroom
3 bathroom
Sleeps 7
Hawaii> Laie
Laie Bay views are right outside your window. The Oceans Edge is literally 50 feet away!! Experience island-style living in this beautiful 4-bedroom Hawaiian beach house. Not only is it in the perfect location, but also offers everything you'll... Registration Number: GE-862-482-6602-01, TA-213-142-1402-01, 450500660004
4 bedroom
5 bathroom
Sleeps 14
Hawaii> Laie
Congratulations and thanks will go to the decision makers taking the time to note the difference before selecting this hidden gemstone for accomodations while on Oahu. Once your travel companions catch their breath after initial first ... Registration Number: GE-142-894-2848-01, TA-142-894-2848-01
5 bedroom
4 bathroom
Sleeps 15
Hawaii> Laie
Our house is uniquely situated inside the beautiful Kokololio State Beach Park and the treats guest to spectacular sun rises as you see in the pictures.Registration Number: 550010800001, GE-070-622-0032-01, TA-070-622-0032-01
4 bedroom
2 bathroom
Sleeps 10
Hawaii> Laie
The Ocean Breeze is a 1 bedroom, air-conditioned bungalow directly on the ocean with an amazing, direct view of the North Shore with your own personal deck and outdoor shower. The perfect spot for wedding mooners or romantic couples alike! (30 ... Registration Number: TA-064-440-0128-01, 550020820000, GE-064-440-0128-01
2 bedroom
1 bathroom
Sleeps 2
Hawaii> Laie
Are you looking for an affordable beachfront property on a beautiful sandy beach with enough room for 26 people? This property will check all the boxes. It includes TWO adjoining homes located in a private beachfront paradise setting. Great ... Registration Number: 550010130000, TA-210-165-8624-01, GE-210-165-8624-01
9 bedroom
5 bathroom
Sleeps 34
Hawaii> Laie
Welcome to the charming town of Laie, Hawaii, where you'll discover a stunning 4-bedroom beachfront property that combines breathtaking ocean views, luxurious amenities, and a serene coastal lifestyle. Situated on the northeastern coast of Oahu,... Registration Number: 350019150002, TA-001-135-5113-01, GE-119-004-2889-01
5 bedroom
4 bathroom
Sleeps 10
Hawaii> Laie
Nestled on the picturesque shores of Laie, this exquisite 4-bedroom beachfront home offers the epitome of coastal living combined with contemporary elegance. Boasting a semi-private stretch of pristine beach, this retreat invites you to ... Registration Number: 330070200000, GE-650-293-8791-01, TA-255-312-5959-01
4 bedroom
2 bathroom
Sleeps 14
Hawaii> Laie
Welcome to the perfect stay for large groups looking for a beach home! We have room to fit your whole family! This is the perfect paradise getaway for those seeking a calm, private, and relaxing Hawaiian vacation. The sand and water ... Registration Number: TA-210-165-4741-01, 550030220000, GE-609-521-5816-01
10 bedroom
6 bathroom
Sleeps 34
Hawaii> Laie
You'll love being minutes away from world class entertainment, incredible beaches, delicious food, and so much more! Many of these opportunities for adventure can be found right outside the front door! We are minutes to famous attractions such ... Registration Number: GE-017-915-0031-01, TA-103-273-2135-01, 550111020000
5 bedroom
2 bathroom
Sleeps 13
Hawaii> Laie
Located in the serene town of Laie on Oahu, this traditional Hawaiian vacation home offers a perfect retreat for families or groups looking to enjoy the beauty of the beach. With five bedrooms, this spacious accommodation provides ample room for... Registration Number: TA-210-165-8624-01, GE-210-165-8624-01, 550010560000
6 bedroom
4 bathroom
Sleeps 18
Hawaii> Laie
30 day rental. Please inquire.Registration Number: 540015600001, GE-118-525-7896-01, TA-118-515-4562-01
4 bedroom
5 bathroom
Sleeps 15
Hawaii> Laie
4 bedroom home in Laie Hawaii. Will be newly renovated in Fall 2021. Perfect for a family vacation. This is your chance to see Hawaii and experience the beauty of the North Shore. Registration Number: TA-096-782-1312-01,+GE-096-782-1312-01
4 bedroom
2 bathroom
Sleeps 10
Hawaii> Laie
Introducing PAPAYA 1, a sublime oceanfront retreat nestled in the heart of Tiki Moon Villas, just across from the Polynesian Cultural Center. This 1-bedroom vacation rental in Laie on the North Shore of Oahu, Hawaii, offers an enchanting escape ... Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
2 bedroom
1 bathroom
Sleeps 3
Hawaii> Laie
"Papaya Coco" is made up of two of our units, Papaya 3 and Coco Studio, both beach side homes with garden and ocean view. Ideal for a larger family traveling together. The base price covers up to 7 occupants. Maximum occupancy is 10. ... Registration Number: TA-064-440-0128-01, GE-064-440-0128-01, 550020820000
5 bedroom
2 bathroom
Sleeps 10
Hawaii> Laie
Maleka Farm in Laie, Hawaii, where you can park at the farm, and embark on a wonderful escape in our Ford Transit Connect camper van. Registration Number: GE-074-660-4032-01, TA-074-660-4032-01, 550170040002
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Laie
This campervan comes with its very own camping spot on a little farm. No need to worry about finding parking accommodations, we have it all figured out! Now you can enjoy the island without the worry of figuring out where to sleep ... Registration Number: TA-074-660-4032-01, GE-074-660-4032-01, 550170040002
1 bedroom
1 bathroom
Sleeps 2
Hawaii> Laie
*30 night rental*Registration Number: TA-210-165-8624-01, GE-210-165-8624-01, 550010560000
5 bedroom
3 bathroom
Sleeps 20
Hawaii> Laie
A lovely couple or family get-away, close to world famous beaches, hikes at all levels of difficulty, the Polynesian Cultural Center, BYU-Hawaii and Laie Temple. Fully stocked kitchen includes a full oven, Keurig coffee maker, rice maker, and ... Registration Number: TA-070-685-7984-01, 550150070000, GE-070-685-7984-01
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Laie
