Listing
Overview
Price: $4,100,000
Area: PUPUKEA
Status: Active
$150k Price Reduction! Incredible 1.234 Acre Estate with a 3 Level Custom Home and an interior Elevator. Also: 2 double-car Garages, 6 person Spa-Hot-Tub, Gourmet-Kitchen and Fully-Furnished! This home looks into a tropical forest valley for the most peaceful setting in all of Pupukea and watching the sunset in the ocean beyond is fantastic! Much cooler and quieter than any properties down below (therefore the fully operational wood burning fireplace) yet every room is air-conditioned with separate Split-Air Systems. Cool & Quiet is a key feature yet just minutes to world-famous beaches, Historic Haleiwa Town and Turtle Bay Resort. Cathedral Ceilings and floor to ceiling windows bring in the light and dramatic views! Every room is pre-wired w/Fiber-Optics and Co-Axle Cable plus a Full Security System, Formal Dining Room, hardwood floors and Majestic Entry-Foyer and an entire lower level perfect for Hobby Workshop or a huge workout room (elevator stops at this ground level). One of the most dramatic estates in all of Pupukea Highlands and perfect for an extended family or mountaintop retreat! Must see to truly appreciate. 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) "4100000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4100000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1174) "$150k Price Reduction! Incredible 1.234 Acre Estate with a 3 Level Custom Home and an interior Elevator. Also: 2 double-car Garages, 6 person Spa-Hot-Tub, Gourmet-Kitchen and Fully-Furnished! This home looks into a tropical forest valley for the most peaceful setting in all of Pupukea and watching the sunset in the ocean beyond is fantastic! Much cooler and quieter than any properties down below (therefore the fully operational wood burning fireplace) yet every room is air-conditioned with separate Split-Air Systems. Cool & Quiet is a key feature yet just minutes to world-famous beaches, Historic Haleiwa Town and Turtle Bay Resort. Cathedral Ceilings and floor to ceiling windows bring in the light and dramatic views! Every room is pre-wired w/Fiber-Optics and Co-Axle Cable plus a Full Security System, Formal Dining Room, hardwood floors and Majestic Entry-Foyer and an entire lower level perfect for Hobby Workshop or a huge workout room (elevator stops at this ground level). One of the most dramatic estates in all of Pupukea Highlands and perfect for an extended family or mountaintop retreat! Must see to truly appreciate. 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-10-03T12:30:34.223"
}
["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] => 4100000.00
)
[CurrentPrice] => Array
(
[0] => 4100000.00
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => $150k Price Reduction! Incredible 1.234 Acre Estate with a 3 Level Custom Home and an interior Elevator. Also: 2 double-car Garages, 6 person Spa-Hot-Tub, Gourmet-Kitchen and Fully-Furnished! This home looks into a tropical forest valley for the most peaceful setting in all of Pupukea and watching the sunset in the ocean beyond is fantastic! Much cooler and quieter than any properties down below (therefore the fully operational wood burning fireplace) yet every room is air-conditioned with separate Split-Air Systems. Cool & Quiet is a key feature yet just minutes to world-famous beaches, Historic Haleiwa Town and Turtle Bay Resort. Cathedral Ceilings and floor to ceiling windows bring in the light and dramatic views! Every room is pre-wired w/Fiber-Optics and Co-Axle Cable plus a Full Security System, Formal Dining Room, hardwood floors and Majestic Entry-Foyer and an entire lower level perfect for Hobby Workshop or a huge workout room (elevator stops at this ground level). One of the most dramatic estates in all of Pupukea Highlands and perfect for an extended family or mountaintop retreat! Must see to truly appreciate. 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-10-03T12:30:34.223
)
[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
