Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Live the elevated North Shore lifestyle at the Ritz-Carlton. Remarkable, memorable, and primely positioned four-bedroom beachfront villa. Rare opportunity to own one of the few spacious four bedroom unit on the third floor (top floor) with high ceilings and best beachfront positioning. Miles of sandy beaches to follow in either direction, swimming, snorkeling, fishing, surfing, horseback riding and beauty of the ocean. Generous spaces for entertaining, lanai for lounging, sipping cocktails, or morning coffee with the sun rising and the smell of the salt air. Luxuriously casual, timeless furnishings have been updated in mid 2022. Tennis courts, pickleball, pools, golf courses, oceanfront workout facilities, and all the Ritz-Carlton has to offer. This is a legal vacation rental, so viewing is subject to availability for in-person showings. Stellar condition and a rare gem. Imagine living the life at Ritz-Carlton Turtle Bay on the famous North Shore of Oahu everyday or rent it out when you are not in residence. Listing by: Coldwell Banker Realty (808) 371-5123
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202527792"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "57-020"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Kuilima"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "304"
}
["City"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96731"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(41) "https://player.vimeo.com/video/1148208317"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "5548000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1024) "Live the elevated North Shore lifestyle at the Ritz-Carlton. Remarkable, memorable, and primely positioned four-bedroom beachfront villa. Rare opportunity to own one of the few spacious four bedroom unit on the third floor (top floor) with high ceilings and best beachfront positioning. Miles of sandy beaches to follow in either direction, swimming, snorkeling, fishing, surfing, horseback riding and beauty of the ocean. Generous spaces for entertaining, lanai for lounging, sipping cocktails, or morning coffee with the sun rising and the smell of the salt air. Luxuriously casual, timeless furnishings have been updated in mid 2022. Tennis courts, pickleball, pools, golf courses, oceanfront workout facilities, and all the Ritz-Carlton has to offer. This is a legal vacation rental, so viewing is subject to availability for in-person showings. Stellar condition and a rare gem. Imagine living the life at Ritz-Carlton Turtle Bay on the famous North Shore of Oahu everyday or rent it out when you are not in residence."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2433"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1972"
}
["BuildingName"]=>
array(1) {
[0]=>
string(26) "Ocean Villas at Turtle Bay"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(22) "Coastline,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "3364.79"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "darcy@homesbythesea.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 371-5123"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "D'Arcy S Kerrigan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19167440"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-25T20:08:23.707"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-12-22"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "20:08:23.707"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27252674"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "27252674"
[1]=>
string(8) "27252675"
[2]=>
string(8) "27252676"
[3]=>
string(8) "27252677"
[4]=>
string(8) "27252678"
[5]=>
string(8) "27252679"
[6]=>
string(8) "27252680"
[7]=>
string(8) "27252681"
[8]=>
string(8) "27252682"
[9]=>
string(8) "27252683"
[10]=>
string(8) "27252684"
[11]=>
string(8) "27252685"
[12]=>
string(8) "27252686"
[13]=>
string(8) "27253074"
[14]=>
string(8) "27253075"
[15]=>
string(8) "27253076"
[16]=>
string(8) "27253077"
[17]=>
string(8) "27253078"
[18]=>
string(8) "27253079"
[19]=>
string(8) "27253080"
[20]=>
string(8) "27253081"
[21]=>
string(8) "27253082"
[22]=>
string(8) "27253083"
[23]=>
string(8) "27253084"
[24]=>
string(8) "27253085"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202527792
)
[StreetNumber] => Array
(
[0] => 57-020
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kuilima
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => 304
)
[City] => Array
(
[0] => Kahuku
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96731
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1148208317
)
[ListPrice] => Array
(
[0] => 5548000.00
)
[Neighbourhood] => Array
(
[0] => KUILIMA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Live the elevated North Shore lifestyle at the Ritz-Carlton. Remarkable, memorable, and primely positioned four-bedroom beachfront villa. Rare opportunity to own one of the few spacious four bedroom unit on the third floor (top floor) with high ceilings and best beachfront positioning. Miles of sandy beaches to follow in either direction, swimming, snorkeling, fishing, surfing, horseback riding and beauty of the ocean. Generous spaces for entertaining, lanai for lounging, sipping cocktails, or morning coffee with the sun rising and the smell of the salt air. Luxuriously casual, timeless furnishings have been updated in mid 2022. Tennis courts, pickleball, pools, golf courses, oceanfront workout facilities, and all the Ritz-Carlton has to offer. This is a legal vacation rental, so viewing is subject to availability for in-person showings. Stellar condition and a rare gem. Imagine living the life at Ritz-Carlton Turtle Bay on the famous North Shore of Oahu everyday or rent it out when you are not in residence.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 2433
)
[YearBuilt] => Array
(
[0] => 1972
)
[BuildingName] => Array
(
[0] => Ocean Villas at Turtle Bay
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 3364.79
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kahuku
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => darcy@homesbythesea.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 371-5123
)
[ListAgentFullName] => Array
(
[0] => D'Arcy S Kerrigan
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19167440
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-25T20:08:23.707
)
[ListingContractDate] => Array
(
[0] => 2025-12-22
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 20:08:23.707
)
[_thumbnail_id] => Array
(
[0] => 27252674
)
[listing_image] => Array
(
[0] => 27252674
[1] => 27252675
[2] => 27252676
[3] => 27252677
[4] => 27252678
[5] => 27252679
[6] => 27252680
[7] => 27252681
[8] => 27252682
[9] => 27252683
[10] => 27252684
[11] => 27252685
[12] => 27252686
[13] => 27253074
[14] => 27253075
[15] => 27253076
[16] => 27253077
[17] => 27253078
[18] => 27253079
[19] => 27253080
[20] => 27253081
[21] => 27253082
[22] => 27253083
[23] => 27253084
[24] => 27253085
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 25, 2025 - 8:08 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
