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 = '96731' OR postalCode = '96731' OR region like '%|96731|%') AND sleeps>=1 order by rating desc LIMIT 0, 50
The Space
Come enjoy this newly updated, spacious end-unit condo in beautiful Turtle Bay. It is as comfortable as it is beautiful. Whether it's breakfast in bed or a drink on the lanai swing, you may not want to leave. Everything has...
Registration Number: 570010270156, GE-168-790-0160-01, TA-168-790-0160-01, 1990/NUC-1947
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahuku
Our Villa is Located on the Turtle Bay Resort! You can use the Ocean Villas pool and Jacuzzi, park for free, and pay no resort fees! You can also use most of the Turtle Bay Resort Amenities for a fee. You have FREE access to the 12 miles of ...
Registration Number: STR #1805, GE-016-005-5296-01, 570010130004, TA-016-005-5296-01
- 5 bedroom
- 3 bathroom
- Sleeps 10
Hawaii> Kahuku
Our Villa is Located on the Turtle Bay Resort! You can use the Ocean Villas pool and Jacuzzi, park for free, and pay no resort fees! You can also use most of the Turtle Bay Resort Amenities for a fee. You have FREE access to the 12 miles of ...
Registration Number: TA-044-199-7312-02, GE-044-199-7312-02, 570010130024
- 5 bedroom
- 3 bathroom
- Sleeps 12
Hawaii> Kahuku
Aloha! Come enjoy your Tropical Hawaiian Vacation in our beautiful, clean, and relaxing one bedroom and two bath condo with all the conveniences of home. Our spacious condo is the perfect blend of tropical seclusion amidst all the amenities ...
Registration Number: GE-035-125-0432-01, TA-035-125-0432-01
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kahuku
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 ...
Registration Number: GE-097-928-2432-01, TA-097-928-2432-01
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kahuku
This newly renovated, well-stocked two-bedroom, two bathrooms with loft space is fantastic getaway and a convenient, clean space for you home away from home with your family or friends. You can enjoy all that the North Shore has to offer and ...
Registration Number: 157001029160, GE-034-877-2352-01, TA-034-877-2352-01
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
February Dates Still Available:
Feb 22nd - 28th, 2025 - 45% off at $395/night. 3 night minimum.
Enjoy the comforts of home in the Luxury Ocean Villa, 217. This second floor studio villa has an exceptional, unobstructed ocean view ...
Registration Number: TA-084-774-2976-01, GE-084-774-2976-01, 570010130013
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Beautiful and charming describes this tranquil and peaceful ocean front cottage.
It sits on the 1st level, beach front, of a private estate home on over 3/4 acres of manicured lawn to the ocean. A view from every room!
Fall asleep to ...
Registration Number: 1910570090015, TA-003-769-9352-01, GE-006-769-3952-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Welcome to Kuilima Estates West. Location! Location! Location!
Only steps to the grounds of the famous and newly renovated Turtle Bay Hotel on the North Shore. We are a Legal Vacation Rental.
The condos are Surrounded by Two ...
Registration Number: TA-180-910-5920-01, GE-180-910-5920-01
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
Surf's up on the North Shore and our condo is the perfect place to Hang Ten! You'll appreciate the attention to detail, modern amenities and the chic, decor when you escape to our Surfer's Paradise. Our location provides easy access to the ...
Registration Number: 1990/NUC-2052, 570010290198, GE-128-654-7968-02, TA-128-654-7968-02
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
Relax to swaying palms, stunning seas and a tropical breeze! You deserve it!
Step right out the lanai onto fairway one of the Fazio golf course. Swaying Palms is an end unit, situated within the complex to provide lots of natural light, ...
Registration Number: TA-029-568-0000-01, GE-029-568-0000-01, STR 2428, 570010290000
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
***This is the most luxurious stay you can get on the North Shore of Oahu! Our amazing Ocean Villa is one of the only two villas located in the whole Ocean Villa Complex that allows you to have Ocean Views from ALL BEDROOMS. Unlike most houses ...
Registration Number: GE-097-928-2432-01, TA-097-928-2432-01, 1570010130036
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
Welcome to our little piece of paradise. A perfect place to stay during your visit to Oahu. Our CLEAN and beautifully UPDATED condo can sleep 6 comfortably. With TWO king beds and a one queen sofa bed. It also includes a brand new full-size ...
Registration Number: GE-041-793-7920-01, 157001029169, TA-041-793-7920-01
- 2 bedroom
- 2 bathroom
- Sleeps 5
Hawaii> Kahuku
Make the most out of your tropical Hawaiian adventure by spending it here at the comfortable and heavenly Ocean Villa at Turtle Bay. This 3 bedroom, 2 bath can accommodate an astounding 8 people, making it an excellent choice for a large family ...
Registration Number: TA-208-597-4016-01, GE-208-597-4016-01, 570010130014
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
The maximum number of guests for this property is 2.
This is when QUALITY meets LOCATION!!!
Implacably maintained, built with only the best of the line in luxury, this Ocean Villa is located in arguably the best location on the ...
Registration Number: GE-156-544-8704-01, 1570010130017, TA-156-544-8704-01
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahuku
Our Turtle Bay Hideaway is the perfect place for your Hawaiian getaway! Enjoy 5 miles+ of secluded beaches, 2 private swimming pools, 2 private tennis courts, 2 PGA golf courses, horseback riding, surfing, snorkeling, diving, fishing, ...
Registration Number: GE-000-000-0000-00, TA-00
- 1 bedroom
- 1 bathroom
- Sleeps 8
Hawaii> Kahuku
We are all looking for a quiet, restful, safe place to de-stress and forget the troubles of the world. As a Hawaii born and raised local, there are few places that can rival this task than the North Shore on Oahu. With 24 hr security, free ...
Registration Number: 570010290098, TA-136-982-1184-01, GE-136-982-1184-01
- 3 bedroom
- 2 bathroom
- Sleeps 7
Hawaii> Kahuku
Our Villa 315 is Located on the Turtle Bay Resort! You can use the Ocean Villas pool and Jacuzzi, park for free, and pay no resort fees! You can also use most of the Turtle Bay Resort Amenities for a fee. You have FREE access to the 12 miles of ...
Registration Number: 570010130054, STR #1810, GE-133-407-6928-01, TA-133-407-6928-01
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
This one bedroom, one bathroom condo was completely renovated in 2020 and has everything you need to relax and enjoy your time on the island. It is the perfect space for solo travel, couples or escaping with your best friend. All of the ...
Registration Number: TA-053-334-6816-01, 157001027035, GE-053-334-6816-01
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahuku
~ You just found your Base Camp to explore the North Shore of Oahu ~
Our condo has just been completely remodeled and redecorated with two brand new bathrooms as of September 2021. We are situated alongside the Palmer Golf Course and are...
Registration Number: TA-164-934-4512-01, GE-164-934-4512-01, 570010270054
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kahuku
This lovely 1 bedroom w/loft upgraded unit has new kitchen cabinets & appliances, ceramic tile floors and granite countertops. The living room has a flat-screen TV, internet and WIFI, and ceiling fan. Window a/c in the living room and the ...
Registration Number: 570010270101, GE-030-645-5552-01, TA-030-645-5552-01
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kahuku
Hale Maluhia ~ The Peaceful Home at Turtle Bay Resort – North Shore Serenity
Escape to tranquility at Hale Maluhia, a serene one-bedroom, one-bathroom condo located on the lush grounds of The Ritz-Carlton at Turtle Bay, on Oahu’s stunning...
Registration Number: GE-039-790-3360-01, TA-039-790-3360-01, 157001027103
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kawela Bay
*Newly renovated* 3 bed 2 bath beach condo that Sleeps 10+. Make this Island Oaisis yours! Discover O'ahu and enjoy the beautiful North Shore! Just a 5 minute walk to the relaxing beaches of Turtle bay and a 5-15 min drive to many legendary ...
Registration Number: GE-155-544-9344-01, TA-155-544-9344-01, 570010290011
- 4 bedroom
- 2 bathroom
- Sleeps 12
Hawaii> Kahuku
Our bright and breezy Kuilima West condo is located steps away from Turtle Bay Resort, Lei Lei's restaurant, walking trails, golf, and the beautiful beaches of Oahu's North Shore. With two Tempur-Pedic king beds and AC in all bedrooms and the ...
Registration Number: GE-095-490-2528-02, 570010290007, TA-095-490-2528-01
- 3 bedroom
- 2 bathroom
- Sleeps 10
Hawaii> Kahuku
Our number one priority at SEArider is to provide our guests with a luxury Hawaiian experience. This unit has been completely renovated with our main focus being quality and comfort. Nestled in the condominiums that surround Turtle Bay, TWO has ...
Registration Number: TA-164-934-4512-01, GE-164-934-4512-01, 570010270053
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Aloha & welcome!
If you are looking for a cozy and convenient place to stay in Turtle Bay, look no further than our 1 bedroom, 2 bathroom condo that can sleep up to 4 guests!
This property is situated in the famous Turtle Bay ...
Registration Number: TA-155-309-0048-01, 1570010270122, GE-155-309-0048-01
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kahuku
Aloha & Welcome to our stunning condo located at the Kuilima Condos at Turtle Bay, on the North Shore of Oahu.
Our condo is the perfect destination for those seeking a luxurious and relaxing vacation in paradise with two Split AC units that ...
Registration Number: TA-066-317-7216-01, GE-066-317-7216-03, 1570010290152
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Escape to pure bliss at our newly renovated Turtle Bay condo, nestled on Oahu's serene North Shore. This luxurious retreat features 4 Bedrooms, king beds, AC, and TVs in each room for your utmost comfort and entertainment. Located steps from ...
Registration Number: 1487, TA-054-139-9552-01, GE-054-139-9552-01, 570010290029
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
Relax and unwind with your family in modern luxury. We’re excited to share with you our newly renovated oceanside condo. Nestled perfectly between the North Shore of Oahu’s world class surfing destinations and world famous golf courses - ...
Registration Number: GE-113-723-4023-01, TA-113-723-4023-01, 570010290148
- 2 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Kahuku
2 bed 2 bath condo with a loft. Sleeps 4 people. Explore Oahu and enjoy North Shore's beautiful ocean. Just a 8 minute walk to the relaxing beaches of Turtle Bay Resort. A short 5-15 min drive to many legendary beaches with soft sand, ...
Registration Number: TA-133-799-2704-01, GE-133-799-2704-01, 570010290099
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kahuku
Enjoy Oahu's magnificent North Shore from a luxury three-bedroom, privately-owned villa. You will awaken each morning to the sounds of ocean waves and tropical birds just a few steps from your lanai in this small piece of paradise. Later in the ...
Registration Number: 1570010130019, GE-157-647-8720-01, TA-157-647-8720-01
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
This is a newly owned One-bedroom studio villa. Designed with Romance and Island flare in mind for lovers.
Enjoy Oahu's magnificent North Shore from a luxury one-bedroom, privately-owned villa. You will awaken each morning to the sounds ...
Registration Number: 570010130039, GE-157-647-8720-01, TA-157-647-8720-01
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Kahuku
This villa is a unique combination of our existing two villas; our 3-bedroom (VRBO 3722129) and our one-bedroom (VRBO 3722906) villas. These two units are separated by adjoining doors. We've chosen to add this listing, combining the two villas ...
Registration Number: 570010130039, TA-069-519-9744-01, GE-069-519-9744-01
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kahuku
Fully stocked home for your dream Hawai'i vacation!
-close to beach
-10 minute drive to Sunset beach
- Family friendly
- 5 minutes to PCC, BYUH
- walking distance from food trucks
- AC in all rooms
- Wifi
- Smart TV with...
Registration Number: 234873628432, GE-178-502-4963-22, TA-432-234-7849-01
- 3 bedroom
- 3 bathroom
- Sleeps 6
Hawaii> Kahuku
paradisesandshawaiirentals.com
8083828016
E’komo mai “welcome” to Turtle Bay Ocean Villa unit 210! Newly updated, painted and re-decorated in July 2024, this charming 1700 sq ft villa will help make all of your Hawaii ...
Registration Number: TA-200-438-5792-01, GE-200-438-5792-01, 570010130031
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
For the discerning traveler, a designer curated space with every luxury detail thought of. When you step inside, you can feel the love poured into this space, and the exquisite detailed craftsmanship throughout. Nestled on the 3rd green of the ...
Registration Number: 570010290172, TA-003-979-5200-01, GE-003-979-5200-01
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Unwind in this serene, stylish oasis with a picturesque view of the golf course. Delight in the breathtaking scenery of the North Shore and charming Turtle Bay while luxuriating in the delightful, balmy tropical Hawaiian atmosphere.
This ...
Registration Number: 570010290126, GE-016-439-1424-01, TA-136-490-8544-01, 920250420000
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Experience this spacious, clean & comfortable, newly remodeled unique 2-story townhouse with the conveniences of a home which is fully air-conditioned w/ new quiet Mitsubishi split system a/c. This is especially important for the hot and humid ...
Registration Number: GE-030-861-4656-01, TA-030-861-4656-01, W98376539-01, 570010290158
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
Ocean Pearl is a luxurious retreat nestled in the heart of scenic Turtle Bay Resort, offering a perfect blend of comfort, convenience, and breathtaking views. With three full bedrooms and two full Jack & Jill bathrooms, this spacious abode ...
Registration Number: TA-033-418-2400-01, GE-033-418-2400-01, 660060050044
- 3 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
Welcome to Villa 318, one of the most spacious and luxurious properties at Ocean Villas and Turtle Bay. Nestled on Oahu's stunning North Shore, this tropical retreat is the ideal escape for families looking to relax and enjoy a slice of ...
Registration Number: 1776, GE-048-529-9712-01, TA-048-529-9712-01, 1570010130057
- 4 bedroom
- 3 bathroom
- Sleeps 8
Hawaii> Kahuku
BRAND NEW RENOVATION. This unit backs up to the world famous Fazio golf courses with a beautiful view of the 18th hole from the relaxing lanai. Just a five-minute walk from the beaches at Turtle Bay Resort and access to miles of walking and ...
Registration Number: TA-028-409-7024-01, GE-028-409-7024-01, 6685825-0160, 570010270144
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kahuku
"Coconut Crest Cottage" is a perfect tropical getaway for families, small groups, or visitors to BYU-Hawai'i. Nestled in the heart of Oahu's North Shore within convenient proximity to the ocean and the iconic Kahuku Sugar Mill, featuring ...
Registration Number: 570010470000, GE-423-194-9006-01, TA-423-194-9006-01
- 3 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
Please reach out to us prior to booking.
Welcome to your luxurious 5-bedroom retreat on the North Shore of Oahu, just steps away from the pristine beach. This spacious and beautifully appointed home offers the perfect blend of comfort and...
Registration Number: TA-160-422-3940-01, GE-121-651-7175-01, 620029730001
- 5 bedroom
- 3 bathroom
- Sleeps 14
Hawaii> Kauku
Bring the whole family or group of friends to this great place with lots of room for everyone.
Spacious, ground floor, end unit fronts the 1st hole of the Fazio Course. Beautiful sunset views from screened in lanai. 3 Pools. BBQ Grills. ...
Registration Number: 570010290009, TA-147-868-8768-01, GE-147-868-8768-01
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
**Special 2025 Rates – Don't Miss Out**
Book your stay at our cozy retreat and enjoy exclusive discounted rates for 2025! We're preparing for a major pipe replacement project and exciting renovations planned for 2026, including modern unit ...
Registration Number: 1570010270049, TA-204-999-8972-01, GE-204-999-9872-01
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kahuku
Welcome to Plumeria Tree Hale!! Part of the Kuilima Estates East community, this tastefully designed unit comes with 1 bedroom, 1 bathroom and offers 785 interior square feet of space for your enjoyment. The property was named Plumeria Tree Hale...
Registration Number: TA-024-834-8672-01, 1570010270041, GE-024-834-8672-02
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
Welcome to The Drifter!! Part of the Kuilima Estates East community, the unit was designed with the goal of offering a “Relaxed Luxury” experience. Meaning, to provide guests with an elevated design aesthetic with a feel-good comfortability....
Registration Number: TA-058-675-3024-02, GE-058-675-3024-02, 1570010270131
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kahuku
Please contact us before booking.
Escape to the North Shore of Oahu with this charming 3-bedroom, 2-bath beachfront cottage. Ideal for family getaways or a peaceful retreat, this home is steps from the beach, offering direct access to ...
Registration Number: GE-249-515-7606-01, 650084610000, TA-191-252-7917-03
- 3 bedroom
- 2 bathroom
- Sleeps 9
Hawaii> Kahuku
TMK #: 570010130032, GE-124-431-5648-02, TA-124-431-5648-02, Permit#: 2301-CCH-1024
See other host fees compared to ours
3 Bedroom Ocean Villa at Turtle Bay Resort Villa
Prime beachfront and oceanfront location with ocean views. ...
Registration Number: 2301-CCH-1024, TA-124-431-5648-02, GE-124-431-5648-02, 570010130032
- 4 bedroom
- 2 bathroom
- Sleeps 8
Hawaii> Kahuku
Enjoy the best of what the ‘fabled North Shore’ has to offer in this authentically designed Hawaiian-beach-themed unit, that sleeps up to four (4) adults, with Resort-style amenities at your doorstep, including snorkeling beach access, ...
Registration Number: STR#244, 570010270015, TA-111-255-1472-01, GE-103-396-7616-01
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kahuku
