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
57-020 Kuilima Drive Unit 207 Kahuku, HI 96731
Listing Overview
Price: $4,200,000 Area: KUILIMA Status: Sold (Limited photos per MLS privacy policy)
Luxurious cceanfront 3 bedroom Legal vacation rental property. Be part of the newly branded Ritz Carlton at Turtle Bay resort. Recent and extensive updates make this an ideal investment as it is a completely furnished and turn key property. High end finishes and appliances throughout. Enjoy ocean views from the lanai of this exceptional location. Very close to a protected swimming cove with a sandy beach. Rare opportunity to invest and enjoy one of the most desirable resorts in the Hawaiian Islands. You and your guests have access to the many amenities of the resort. Roy's Beach house restaurant is adjacent to the building and provides great food and drinks at the swimming beach. Exceptional golfing on the Palmer course, restaurants, horseback riding, snorkeling, hiking to remote beaches and the world class surfing on north shore is all close by. Excellent income generating property legally recognized for nightly rental. Listing by: Real Broker, LLC (855) 450-0442
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202511552"
}
["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) "207"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4200000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KUILIMA"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(935) "Luxurious cceanfront 3 bedroom Legal vacation rental property. Be part of the newly branded Ritz Carlton at Turtle Bay resort. Recent and extensive updates make this an ideal investment as it is a completely furnished and turn key property. High end finishes and appliances throughout. Enjoy ocean views from the lanai of this exceptional location. Very close to a protected swimming cove with a sandy beach. Rare opportunity to invest and enjoy one of the most desirable resorts in the Hawaiian Islands. You and your guests have access to the many amenities of the resort. Roy's Beach house restaurant is adjacent to the building and provides great food and drinks at the swimming beach. Exceptional golfing on the Palmer course, restaurants, horseback riding, snorkeling, hiking to remote beaches and the world class surfing on north shore is all close by. Excellent income generating property legally recognized for nightly rental."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Real Broker, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1698"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1972"
}
["BuildingName"]=>
array(1) {
[0]=>
string(26) "Ocean Villas at Turtle Bay"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "Three"
}
["View"]=>
array(1) {
[0]=>
string(22) "Coastline,Garden,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1744.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RBLL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "jason@oahuhomerealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(855) 450-0442"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Jason Subt"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2025-10-10"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18733208"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-12T06:33:31.510"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-05-06"
}
["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) "06:33:31.510"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26986615"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26986615"
[1]=>
string(8) "26986616"
[2]=>
string(8) "26986617"
[3]=>
string(8) "26986618"
[4]=>
string(8) "26986619"
[5]=>
string(8) "26986620"
[6]=>
string(8) "26986621"
[7]=>
string(8) "26986622"
[8]=>
string(8) "26986623"
[9]=>
string(8) "26986624"
[10]=>
string(8) "26986625"
[11]=>
string(8) "26986626"
[12]=>
string(8) "26986627"
[13]=>
string(8) "26986628"
[14]=>
string(8) "26986629"
[15]=>
string(8) "26986630"
[16]=>
string(8) "26986631"
[17]=>
string(8) "26986632"
[18]=>
string(8) "26986633"
[19]=>
string(8) "26986634"
[20]=>
string(8) "26986635"
[21]=>
string(8) "26986636"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202511552
)
[StreetNumber] => Array
(
[0] => 57-020
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Kuilima
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] => 207
)
[City] => Array
(
[0] => Kahuku
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96731
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 4200000.00
)
[Neighbourhood] => Array
(
[0] => KUILIMA
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => Luxurious cceanfront 3 bedroom Legal vacation rental property. Be part of the newly branded Ritz Carlton at Turtle Bay resort. Recent and extensive updates make this an ideal investment as it is a completely furnished and turn key property. High end finishes and appliances throughout. Enjoy ocean views from the lanai of this exceptional location. Very close to a protected swimming cove with a sandy beach. Rare opportunity to invest and enjoy one of the most desirable resorts in the Hawaiian Islands. You and your guests have access to the many amenities of the resort. Roy's Beach house restaurant is adjacent to the building and provides great food and drinks at the swimming beach. Exceptional golfing on the Palmer course, restaurants, horseback riding, snorkeling, hiking to remote beaches and the world class surfing on north shore is all close by. Excellent income generating property legally recognized for nightly rental.
)
[ListOfficeName] => Array
(
[0] => Real Broker, LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1698
)
[YearBuilt] => Array
(
[0] => 1972
)
[BuildingName] => Array
(
[0] => Ocean Villas at Turtle Bay
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => Coastline,Garden,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 1744.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RBLL
)
[ListAgentEmail] => Array
(
[0] => jason@oahuhomerealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (855) 450-0442
)
[ListAgentFullName] => Array
(
[0] => Jason Subt
)
[CloseDate] => Array
(
[0] => 2025-10-10
)
[Matrix_Unique_ID] => Array
(
[0] => 18733208
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-12T06:33:31.510
)
[ListingContractDate] => Array
(
[0] => 2025-05-06
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 06:33:31.510
)
[_thumbnail_id] => Array
(
[0] => 26986615
)
[listing_image] => Array
(
[0] => 26986615
[1] => 26986616
[2] => 26986617
[3] => 26986618
[4] => 26986619
[5] => 26986620
[6] => 26986621
[7] => 26986622
[8] => 26986623
[9] => 26986624
[10] => 26986625
[11] => 26986626
[12] => 26986627
[13] => 26986628
[14] => 26986629
[15] => 26986630
[16] => 26986631
[17] => 26986632
[18] => 26986633
[19] => 26986634
[20] => 26986635
[21] => 26986636
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 12, 2025 - 6:33 AM
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.
