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. Step inside this beautifully furnished and spacious bungalow, where you'll find comfort and style ...
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! My name is Lindsey and I'm happy to be your host in beautiful Laie, located on the world-famous North Shore of Oahu. Like the hibiscus in our yard, I grew up here and love this town so much that I'm raising my own children in this side...
Registration Number: GE-171-005-3376-01, TA-171-005-3376-01, 550160680000
2 bedroom
1 bathroom
Sleeps 5
Hawaii> Laie
Aloha! My name is Lindsey and I was born and raised right here in beautiful Laie, HI located on the world famous North Shore of Oahu. This is our personal family home and we will go going on vacation. I love this town so much, that once I got...
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 rental Beautiful studio apartment 5 min walk to the beach! Sparkling clean! Close to the Polynesian Cultural Center, BYUH, Laie Temple, beautiful beaches and 20min drive to popular North Shore beaches ...
Registration 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-6920 This is your perfect getaway paradise for those seeking for quiet, private, and relaxing Hawaiian vacation. The sand and water are just steps away. You will love the sound of the ocean lulling ...
Registration 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. Welcome to Moku Paradise! This 3 bedroom, 3 bath + studio cottage island style oceanfront home has breathtaking ocean views and a semi-private beach. This is a perfect getaway paradise for those seeking a ...
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. Welcome to Moku Paradise B! This 1 bedroom, 1 bath island-style oceanfront cottage has breathtaking ocean views and a semi-private beach. This is a perfect getaway paradise for those seeking a calm, private,...
Registration Number: TA-130-961-3586-01, GE-191-801-2100-03, 130049850002
1 bedroom
1 bathroom
Sleeps 3
Hawaii> Laie
Welcome to our coastal haven, a North Shore oasis that seamlessly blends comfort, style, and panoramic ocean views. This private upstairs duplex unit invites you into a world of relaxation and luxury. Here's what awaits you: Living ...
Registration Number: 550040010000, GE-064-189-2909-01, TA-064-189-2909-01
3 bedroom
3 bathroom
Sleeps 6
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! Popular beachfront rental well known as the LAIE BEACH RETREAT or LAIEBEACHRETREAT Sandy BEACHFRONT North Shore retreat located on the Hukilau Beach of Laie Bay!...
Registration Number: GE-142-706-2784-01, TA-142-076-2784-01, 550030190000
5 bedroom
6 bathroom
Sleeps 16
Hawaii> Laie
This cozy studio apartment has recently been renovated and is ideal for 2-3 people. You'll love the proximity to beautiful Hukilau Beach-an easy 5-8 min walk. Delicious Restaurants and food trucks are near by but there is a cook-top and ...
Registration Number: TA-018-462-4128-01, GE-018-462-4128-01, 550160390001
0 bedroom
1 bathroom
Sleeps 2
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 PLEASE CONTACT US ABOUT AVAILABILITY *** OUR CALENDAR MAY NOT REFLECT CURRENT OPENINGS *** *****We may not advertise to rent for a period of shorter than 30 days. We may rent for shorter durations as long...
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 ***this property may not be rented for less than 30 consecutive days. Rental prices will not be reduced or adjusted based on the number of days the...
Registration Number: 910070780000, GE-100-125-6960-01, TA-100-125-6960-01
4 bedroom
2 bathroom
Sleeps 10
Hawaii> Laie
CONTACT HOST - click for answers to your questions on the cancellation policy or the property ***this property may not be rented for less than 30 consecutive days. Rental prices will not be reduced or adjusted based on the number of days the ...
Registration Number: 910070780000, GE-100-125-6960-01, TA-100-125-6960-01
2 bedroom
1 bathroom
Sleeps 4
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
This newly updated cute and comfortable 3 bedroom home, now with A/C sleeps 7 people and is perfect for family or friends that want to relax on the beach and enjoy the beautiful country surroundings of the North Shore. The master bedroom ...
Registration Number: GE-018-462-4128-01, TA-018-462-4128-01, 550160390001
3 bedroom
2 bathroom
Sleeps 7
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 DAYS AIR CONDITIONING in every room. Wow! This newly remodeled 5-bedroom, 2-bath home speaks comfort and convenience. Aside from having cool and relaxing bedrooms, the ...
Registration 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-6920 Welcome to Moku Paradise! This 3 bedroom, 3 bath island style oceanfront home has breathtaking ocean views and semi-private beach. This is a perfect getaway paradise for those seeking a calm, ...
Registration 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. IMPORTANT! Per Oahu law, we can only rent to one family per month! Our ...
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. Island Hibiscus Hale 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 ...
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. There are two A/Cs in the house. One in the master a big ...
Registration Number: TA-096-782-1312-01,+GE-096-782-1312-01
4 bedroom
2 bathroom
Sleeps 10
Hawaii> Laie
This home has a casual Island feel but with updated features. It was fully renovated 8 years ago and within the last 2 months we have given it a mini makeover. We love how spacious and private it feels and also its location right across the ...
Registration Number: 550090370000, GE-018-462-4128-01, TA-018-462-4128-01
5 bedroom
4 bathroom
Sleeps 13
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