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
Price: $6,250,000 Area: DIAMOND HEAD Status: Active
A rare opportunity to own one of Diamond Head’s most captivating oceanfront estates at a newly reduced rate; truly the best value Diamond Head. This Balinese-inspired masterpiece blends timeless island elegance with modern sophistication. Designed to embrace Hawaii’s indoor-outdoor lifestyle, the residence opens seamlessly to panoramic ocean vistas and the rhythmic sound of the waves.
This five-bedroom sanctuary showcases bespoke finishes, natural textures, and an architectural flow that evokes both serenity and grandeur. The primary suite offers breathtaking ocean views and a spa-like en-suite retreat, while a private guest apartment—complete with its own entrance—provides stunning views of Diamond Head and total privacy for family or guests.
Outdoors, a private tropical oasis awaits. Surrounded by lush landscaping, the grounds feature a resort-style pool, elevated spa, fire pit, and tranquil koi pond, creating an atmosphere of peaceful indulgence.
Gated and secure, yet minutes from Waikiki Beach and Diamond Head State Monument, this rare offering perfectly balances luxury, seclusion and convenience. it is the premier value in Diamond Head’s pristine oceanfront enclave. Listing by: Coldwell Banker Realty (808) 738-3904
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423874"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "4240"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Kaikoo"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96816"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(44) "https://www.slickpixelshawaii.com/4240kaikoo"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "6250000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "DIAMOND HEAD"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1209) "A rare opportunity to own one of Diamond Head’s most captivating oceanfront estates at a newly reduced rate; truly the best value Diamond Head. This Balinese-inspired masterpiece blends timeless island elegance with modern sophistication. Designed to embrace Hawaii’s indoor-outdoor lifestyle, the residence opens seamlessly to panoramic ocean vistas and the rhythmic sound of the waves.
This five-bedroom sanctuary showcases bespoke finishes, natural textures, and an architectural flow that evokes both serenity and grandeur. The primary suite offers breathtaking ocean views and a spa-like en-suite retreat, while a private guest apartment—complete with its own entrance—provides stunning views of Diamond Head and total privacy for family or guests.
Outdoors, a private tropical oasis awaits. Surrounded by lush landscaping, the grounds feature a resort-style pool, elevated spa, fire pit, and tranquil koi pond, creating an atmosphere of peaceful indulgence.
Gated and secure, yet minutes from Waikiki Beach and Diamond Head State Monument, this rare offering perfectly balances luxury, seclusion and convenience. it is the premier value in Diamond Head’s pristine oceanfront enclave."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "2"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "11580.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "9292"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1964"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(24) "Basement,Two,Split Level"
}
["View"]=>
array(1) {
[0]=>
string(25) "Diamond Head,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "kailuaproperties@yahoo.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Tarlok Singh"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-30T17:00:01.250"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18323294"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26746005"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26746005"
[1]=>
string(8) "26746006"
[2]=>
string(8) "26746007"
[3]=>
string(8) "26746008"
[4]=>
string(8) "26746009"
[5]=>
string(8) "26746010"
[6]=>
string(8) "26746011"
[7]=>
string(8) "26746012"
[8]=>
string(8) "26746013"
[9]=>
string(8) "26746014"
[10]=>
string(8) "26746015"
[11]=>
string(8) "26746016"
[12]=>
string(8) "26746017"
[13]=>
string(8) "26746018"
[14]=>
string(8) "26746019"
[15]=>
string(8) "26746020"
[16]=>
string(8) "26746021"
[17]=>
string(8) "26746022"
[18]=>
string(8) "26746023"
[19]=>
string(8) "26746024"
[20]=>
string(8) "26746025"
[21]=>
string(8) "26746026"
[22]=>
string(8) "26746027"
[23]=>
string(8) "26746028"
[24]=>
string(8) "26746029"
[25]=>
string(8) "26746030"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-10-25"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.250"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423874
)
[StreetNumber] => Array
(
[0] => 4240
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kaikoo
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96816
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.slickpixelshawaii.com/4240kaikoo
)
[ListPrice] => Array
(
[0] => 6250000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => DIAMOND HEAD
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => A rare opportunity to own one of Diamond Head’s most captivating oceanfront estates at a newly reduced rate; truly the best value Diamond Head. This Balinese-inspired masterpiece blends timeless island elegance with modern sophistication. Designed to embrace Hawaii’s indoor-outdoor lifestyle, the residence opens seamlessly to panoramic ocean vistas and the rhythmic sound of the waves.
This five-bedroom sanctuary showcases bespoke finishes, natural textures, and an architectural flow that evokes both serenity and grandeur. The primary suite offers breathtaking ocean views and a spa-like en-suite retreat, while a private guest apartment—complete with its own entrance—provides stunning views of Diamond Head and total privacy for family or guests.
Outdoors, a private tropical oasis awaits. Surrounded by lush landscaping, the grounds feature a resort-style pool, elevated spa, fire pit, and tranquil koi pond, creating an atmosphere of peaceful indulgence.
Gated and secure, yet minutes from Waikiki Beach and Diamond Head State Monument, this rare offering perfectly balances luxury, seclusion and convenience. it is the premier value in Diamond Head’s pristine oceanfront enclave.
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 2
)
[LotSizeArea] => Array
(
[0] => 11580.00
)
[SqftTotal] => Array
(
[0] => 9292
)
[YearBuilt] => Array
(
[0] => 1964
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Basement,Two,Split Level
)
[View] => Array
(
[0] => Diamond Head,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => kailuaproperties@yahoo.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3904
)
[ListAgentFullName] => Array
(
[0] => Tarlok Singh
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-30T17:00:01.250
)
[Matrix_Unique_ID] => Array
(
[0] => 18323294
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] => Ocean
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26746005
)
[listing_image] => Array
(
[0] => 26746005
[1] => 26746006
[2] => 26746007
[3] => 26746008
[4] => 26746009
[5] => 26746010
[6] => 26746011
[7] => 26746012
[8] => 26746013
[9] => 26746014
[10] => 26746015
[11] => 26746016
[12] => 26746017
[13] => 26746018
[14] => 26746019
[15] => 26746020
[16] => 26746021
[17] => 26746022
[18] => 26746023
[19] => 26746024
[20] => 26746025
[21] => 26746026
[22] => 26746027
[23] => 26746028
[24] => 26746029
[25] => 26746030
)
[ListingContractDate] => Array
(
[0] => 2024-10-25
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.250
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 30, 2025 - 5:00 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.
