Listing
Overview
Price: $1,540,000
Area: PUPUKEA
Status: Active Under Contract
It is not hard to imagine your special place within this magic area on one the best lots in the Sunset Hills community.
Rarely available with panoramic ocean and sunset views!
Build your Dream House on this gently sloping lot.
Underground utilities, private roads, cool and open Country Living!
Let us bring the reality of living Up Pupukea to you.
Must see to appreciate! Listing by: Sterman Realty (808) 517-7157
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202502289"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-411"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Wilinau"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["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(54) "https://shoots.styronphoto.com/sites/xawzkaa/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1540000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(378) "It is not hard to imagine your special place within this magic area on one the best lots in the Sunset Hills community.
Rarely available with panoramic ocean and sunset views!
Build your Dream House on this gently sloping lot.
Underground utilities, private roads, cool and open Country Living!
Let us bring the reality of living Up Pupukea to you.
Must see to appreciate!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "44431.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(38) "Coastline,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(6) "Kahuku"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "STER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(17) "cindy@sterman.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 517-7157"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Cynthia A Crown"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18500851"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-27T18:44:55.423"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-24"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "18:44:55.423"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26853276"
}
["listing_image"]=>
array(15) {
[0]=>
string(8) "26853276"
[1]=>
string(8) "26853277"
[2]=>
string(8) "26853278"
[3]=>
string(8) "26853279"
[4]=>
string(8) "26853280"
[5]=>
string(8) "26853281"
[6]=>
string(8) "26853282"
[7]=>
string(8) "26853283"
[8]=>
string(8) "26853284"
[9]=>
string(8) "26853285"
[10]=>
string(8) "26853286"
[11]=>
string(8) "26853287"
[12]=>
string(8) "26853288"
[13]=>
string(8) "26853289"
[14]=>
string(8) "26853290"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202502289
)
[StreetNumber] => Array
(
[0] => 59-411
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Wilinau
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/sites/xawzkaa/unbranded
)
[ListPrice] => Array
(
[0] => 1540000.00
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => It is not hard to imagine your special place within this magic area on one the best lots in the Sunset Hills community.
Rarely available with panoramic ocean and sunset views!
Build your Dream House on this gently sloping lot.
Underground utilities, private roads, cool and open Country Living!
Let us bring the reality of living Up Pupukea to you.
Must see to appreciate!
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 44431.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Sunset Beach
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => STER
)
[ListAgentEmail] => Array
(
[0] => cindy@sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 517-7157
)
[ListAgentFullName] => Array
(
[0] => Cynthia A Crown
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18500851
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-27T18:44:55.423
)
[ListingContractDate] => Array
(
[0] => 2025-01-24
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:44:55.423
)
[_thumbnail_id] => Array
(
[0] => 26853276
)
[listing_image] => Array
(
[0] => 26853276
[1] => 26853277
[2] => 26853278
[3] => 26853279
[4] => 26853280
[5] => 26853281
[6] => 26853282
[7] => 26853283
[8] => 26853284
[9] => 26853285
[10] => 26853286
[11] => 26853287
[12] => 26853288
[13] => 26853289
[14] => 26853290
)
)
- Land Area (sf): 44,431 sf
- View: Coastline,Garden,Mountain,Ocean,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Sunset Beach
- Middle School: Kahuku
- High School: Kahuku
