Our office will be closed on Monday, November 11th, 2024.
2043 Halekoa Drive Honolulu, HI 96821
Listing Overview
Price: $2,995,000 Area: WAIALAE NUI RDGE Status: Active Under Contract
Award-Winning Designer's Masterpiece with Breathtaking Ocean Views. Completely reimagined by acclaimed designer Kathy Merrill Kelley, this stunning 5-bedroom, 3-bathroom, two car garage, home received Excellence Award from ASID. Panoramic ocean views, whales and rolling surf with a front-row view of Molokai, Lanai, and Maui on clear days. Infinity dunking pool with seems to merge with the ocean below. Thoughtfully placed skylights and custom French doors throughout. Primary Suite with its' own floor of living space, views of the sunrise and ream walk-in closet. Gourmet kitchen features Napolina limestone, distinctive slate walls, ceruse teak cabinets & cantilevered custom shelving. Sub-Zero fridge, Bosch oven and dishwasher, GE monogram Advantium oven. Character cherry wood floors & 850 sq.ft. of additional outdoor living space w/Ipe decking. T&G cedar ceilings, Recessed lighting, exterior is artfully landscaped with Balinese lanterns & garden featuring Kaffir limes, Meyer lemons, heliconia, calamansi and blue ginger. Kahala Mall & favorite surf spots only minutes away. This one of a kind move in ready, fully furnished residence represents the best of island living. Listing by: Berkshire Hathaway HmSvc HI RE (808) 295-4046
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423373"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "2043"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Halekoa"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Drive"
}
["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) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2995000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2995000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(16) "WAIALAE NUI RDGE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1195) "Award-Winning Designer's Masterpiece with Breathtaking Ocean Views. Completely reimagined by acclaimed designer Kathy Merrill Kelley, this stunning 5-bedroom, 3-bathroom, two car garage, home received Excellence Award from ASID. Panoramic ocean views, whales and rolling surf with a front-row view of Molokai, Lanai, and Maui on clear days. Infinity dunking pool with seems to merge with the ocean below. Thoughtfully placed skylights and custom French doors throughout. Primary Suite with its' own floor of living space, views of the sunrise and ream walk-in closet. Gourmet kitchen features Napolina limestone, distinctive slate walls, ceruse teak cabinets & cantilevered custom shelving. Sub-Zero fridge, Bosch oven and dishwasher, GE monogram Advantium oven. Character cherry wood floors & 850 sq.ft. of additional outdoor living space w/Ipe decking. T&G cedar ceilings, Recessed lighting, exterior is artfully landscaped with Balinese lanterns & garden featuring Kaffir limes, Meyer lemons, heliconia, calamansi and blue ginger. Kahala Mall & favorite surf spots only minutes away. This one of a kind move in ready, fully furnished residence represents the best of island living."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(30) "Berkshire Hathaway HmSvc HI RE"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "9000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3340"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1970"
}
["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(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(44) "Coastline,Golf Course,Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Wilson"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Kaimuki"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "BHHR"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "kimmyb@bhhshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 295-4046"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Kimmy Brooke"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-13T17:00:01.657"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18308808"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-07T08:15:33.723"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26721113"
}
["listing_image"]=>
array(19) {
[0]=>
string(8) "26721113"
[1]=>
string(8) "26721114"
[2]=>
string(8) "26721115"
[3]=>
string(8) "26721116"
[4]=>
string(8) "26721117"
[5]=>
string(8) "26721118"
[6]=>
string(8) "26721119"
[7]=>
string(8) "26721120"
[8]=>
string(8) "26721121"
[9]=>
string(8) "26721122"
[10]=>
string(8) "26721123"
[11]=>
string(8) "26721124"
[12]=>
string(8) "26721125"
[13]=>
string(8) "26721126"
[14]=>
string(8) "26721127"
[15]=>
string(8) "26721128"
[16]=>
string(8) "26721129"
[17]=>
string(8) "26721130"
[18]=>
string(8) "26721131"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423373
)
[StreetNumber] => Array
(
[0] => 2043
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Halekoa
)
[StreetSuffix] => Array
(
[0] => Drive
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2995000.00
)
[CurrentPrice] => Array
(
[0] => 2995000.00
)
[Neighbourhood] => Array
(
[0] => WAIALAE NUI RDGE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Award-Winning Designer's Masterpiece with Breathtaking Ocean Views. Completely reimagined by acclaimed designer Kathy Merrill Kelley, this stunning 5-bedroom, 3-bathroom, two car garage, home received Excellence Award from ASID. Panoramic ocean views, whales and rolling surf with a front-row view of Molokai, Lanai, and Maui on clear days. Infinity dunking pool with seems to merge with the ocean below. Thoughtfully placed skylights and custom French doors throughout. Primary Suite with its' own floor of living space, views of the sunrise and ream walk-in closet. Gourmet kitchen features Napolina limestone, distinctive slate walls, ceruse teak cabinets & cantilevered custom shelving. Sub-Zero fridge, Bosch oven and dishwasher, GE monogram Advantium oven. Character cherry wood floors & 850 sq.ft. of additional outdoor living space w/Ipe decking. T&G cedar ceilings, Recessed lighting, exterior is artfully landscaped with Balinese lanterns & garden featuring Kaffir limes, Meyer lemons, heliconia, calamansi and blue ginger. Kahala Mall & favorite surf spots only minutes away. This one of a kind move in ready, fully furnished residence represents the best of island living.
)
[ListOfficeName] => Array
(
[0] => Berkshire Hathaway HmSvc HI RE
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 9000.00
)
[SqftTotal] => Array
(
[0] => 3340
)
[YearBuilt] => Array
(
[0] => 1970
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Golf Course,Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Wilson
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kaimuki
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => BHHR
)
[ListAgentEmail] => Array
(
[0] => kimmyb@bhhshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 295-4046
)
[ListAgentFullName] => Array
(
[0] => Kimmy Brooke
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-13T17:00:01.657
)
[Matrix_Unique_ID] => Array
(
[0] => 18308808
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-07T08:15:33.723
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26721113
)
[listing_image] => Array
(
[0] => 26721113
[1] => 26721114
[2] => 26721115
[3] => 26721116
[4] => 26721117
[5] => 26721118
[6] => 26721119
[7] => 26721120
[8] => 26721121
[9] => 26721122
[10] => 26721123
[11] => 26721124
[12] => 26721125
[13] => 26721126
[14] => 26721127
[15] => 26721128
[16] => 26721129
[17] => 26721130
[18] => 26721131
)
)
