Listing
Overview
Price: $4,250,000
Area: PUPUKEA
Status: Active
1.234 Acre Lot with incredible Custom-Built Home with 3 Levels, interior Elevator, 2 Garages, 6 person Spa-Hot-Tub, Fully Furnished right down to sheets and towels, gourmet kitchen and fully equipped workshop! Large lanais with ocean and sunset views. Home looks out into a tropical forest valley for the most peaceful setting in all of Pupukea yet Kaena Point can be seen in the distance! Multiple Degrees cooler than down below (therefore the fully functioning wood burning fireplace) yet every room is air-conditioned with Split-Air Systems. Cool & Quiet yet minutes to world-famous beaches, Historic Haleiwa Town and Turtle Bay Golf & Dining. Cathedral Ceilings and floor to ceiling windows bring in the light. Dramatic mountain, valley and ocean views! Every room is pre-wired for both Fiber-Optics and Co-Axle Cable. Full Security System, Formal Dining Room, and Majestic Entry-Foyer. One of the most dramatic estates in all of Pupukea Highlands and perfect for the extended family or mountaintop retreat! Country Living at its Best! Listing by: Sterman Realty (808) 637-6200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202418617"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-635"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Akanoho"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(144) "https://click.pstmrk.it/3s/shoots.styronphoto.com%2Fsites%2Fnxwnjzr%2Funbranded/cUpU/XY63AQ/AQ/9dfb57d0-a3ff-4c34-a2af-650e898f4080/3/2JBVugHOca"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4250000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4250000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1047) "1.234 Acre Lot with incredible Custom-Built Home with 3 Levels, interior Elevator, 2 Garages, 6 person Spa-Hot-Tub, Fully Furnished right down to sheets and towels, gourmet kitchen and fully equipped workshop! Large lanais with ocean and sunset views. Home looks out into a tropical forest valley for the most peaceful setting in all of Pupukea yet Kaena Point can be seen in the distance! Multiple Degrees cooler than down below (therefore the fully functioning wood burning fireplace) yet every room is air-conditioned with Split-Air Systems. Cool & Quiet yet minutes to world-famous beaches, Historic Haleiwa Town and Turtle Bay Golf & Dining. Cathedral Ceilings and floor to ceiling windows bring in the light. Dramatic mountain, valley and ocean views! Every room is pre-wired for both Fiber-Optics and Co-Axle Cable. Full Security System, Formal Dining Room, and Majestic Entry-Foyer. One of the most dramatic estates in all of Pupukea Highlands and perfect for the extended family or mountaintop retreat! Country Living at its Best!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "54232.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "6934"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1974"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(12) "Basement,Two"
}
["View"]=>
array(1) {
[0]=>
string(28) "Garden,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(12) "Sunset Beach"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "STER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "richard@sterman.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 637-6200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Richard D Sterman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-12T15:39:43.037"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18211124"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-01T09:31:17.903"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26678497"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26678497"
[1]=>
string(8) "26678498"
[2]=>
string(8) "26678499"
[3]=>
string(8) "26678500"
[4]=>
string(8) "26678501"
[5]=>
string(8) "26678502"
[6]=>
string(8) "26678503"
[7]=>
string(8) "26678504"
[8]=>
string(8) "26678505"
[9]=>
string(8) "26678506"
[10]=>
string(8) "26678507"
[11]=>
string(8) "26678508"
[12]=>
string(8) "26678509"
[13]=>
string(8) "26678510"
[14]=>
string(8) "26678511"
[15]=>
string(8) "26678512"
[16]=>
string(8) "26678513"
[17]=>
string(8) "26678514"
[18]=>
string(8) "26678515"
[19]=>
string(8) "26678516"
[20]=>
string(8) "26678517"
[21]=>
string(8) "26678518"
[22]=>
string(8) "26678519"
[23]=>
string(8) "26678520"
[24]=>
string(8) "26678521"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202418617
)
[StreetNumber] => Array
(
[0] => 59-635
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Akanoho
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://click.pstmrk.it/3s/shoots.styronphoto.com%2Fsites%2Fnxwnjzr%2Funbranded/cUpU/XY63AQ/AQ/9dfb57d0-a3ff-4c34-a2af-650e898f4080/3/2JBVugHOca
)
[ListPrice] => Array
(
[0] => 4250000.00
)
[CurrentPrice] => Array
(
[0] => 4250000.00
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => 1.234 Acre Lot with incredible Custom-Built Home with 3 Levels, interior Elevator, 2 Garages, 6 person Spa-Hot-Tub, Fully Furnished right down to sheets and towels, gourmet kitchen and fully equipped workshop! Large lanais with ocean and sunset views. Home looks out into a tropical forest valley for the most peaceful setting in all of Pupukea yet Kaena Point can be seen in the distance! Multiple Degrees cooler than down below (therefore the fully functioning wood burning fireplace) yet every room is air-conditioned with Split-Air Systems. Cool & Quiet yet minutes to world-famous beaches, Historic Haleiwa Town and Turtle Bay Golf & Dining. Cathedral Ceilings and floor to ceiling windows bring in the light. Dramatic mountain, valley and ocean views! Every room is pre-wired for both Fiber-Optics and Co-Axle Cable. Full Security System, Formal Dining Room, and Majestic Entry-Foyer. One of the most dramatic estates in all of Pupukea Highlands and perfect for the extended family or mountaintop retreat! Country Living at its Best!
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 54232.00
)
[SqftTotal] => Array
(
[0] => 6934
)
[YearBuilt] => Array
(
[0] => 1974
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Basement,Two
)
[View] => Array
(
[0] => Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Sunset Beach
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => STER
)
[ListAgentEmail] => Array
(
[0] => richard@sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 637-6200
)
[ListAgentFullName] => Array
(
[0] => Richard D Sterman
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-12T15:39:43.037
)
[Matrix_Unique_ID] => Array
(
[0] => 18211124
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-01T09:31:17.903
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26678497
)
[listing_image] => Array
(
[0] => 26678497
[1] => 26678498
[2] => 26678499
[3] => 26678500
[4] => 26678501
[5] => 26678502
[6] => 26678503
[7] => 26678504
[8] => 26678505
[9] => 26678506
[10] => 26678507
[11] => 26678508
[12] => 26678509
[13] => 26678510
[14] => 26678511
[15] => 26678512
[16] => 26678513
[17] => 26678514
[18] => 26678515
[19] => 26678516
[20] => 26678517
[21] => 26678518
[22] => 26678519
[23] => 26678520
[24] => 26678521
)
)
- BedsTotal: 4
- Full Baths: 4
- Half Baths: 1
- Land Area (sf): 54,232
- Living (sf): 6,934
- Year Built: 1974
- Property Condition: Excellent
- Number of Parking Spaces: 6
- View: Garden,Mountain,Ocean,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Sunset Beach
- Middle School: Waialua
- High School: Kahuku
