59-056B Kamehameha Highway Unit 59-56B-1 Haleiwa, HI 96712
Listing
Overview
Price: $3,250,000
Area: SUNSET AREA
Status: Active
SPECTACULAR and one of a kind 2.6 ACRE lot overlooking Sunset Beach with views to Kaena Point!! With the beautiful Koolau Mountains behind and ocean views in front, this property is completely surrounded by all that makes country living so special. Bring your ideas and imagination to build your dream home in one of the most highly sought after areas of the North Shore. *Boundary lines on the drone aerial photos are just ESTIMATED locations. See CPR map or in person to know exact boundaries. **Please note that the CPR of this property was VERY recently completed so the assessed value and monthly taxes are accumulative between this lot and neighboring lot and will reflect differently once city comes up with valuation. Listing by: Sterman Realty (808) 780-5673
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202419170"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "59-056B"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(8) "59-56B-1"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3250000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3250000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(725) "SPECTACULAR and one of a kind 2.6 ACRE lot overlooking Sunset Beach with views to Kaena Point!! With the beautiful Koolau Mountains behind and ocean views in front, this property is completely surrounded by all that makes country living so special. Bring your ideas and imagination to build your dream home in one of the most highly sought after areas of the North Shore. *Boundary lines on the drone aerial photos are just ESTIMATED locations. See CPR map or in person to know exact boundaries. **Please note that the CPR of this property was VERY recently completed so the assessed value and monthly taxes are accumulative between this lot and neighboring lot and will reflect differently once city comes up with valuation."
}
["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(9) "113256.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(21) "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(18) "sophia@sterman.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 780-5673"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Sophia L Miller"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-15T10:51:35.447"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18227161"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-31T19:52:57.440"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26678273"
}
["listing_image"]=>
array(11) {
[0]=>
string(8) "26678273"
[1]=>
string(8) "26678274"
[2]=>
string(8) "26678275"
[3]=>
string(8) "26678276"
[4]=>
string(8) "26678277"
[5]=>
string(8) "26678278"
[6]=>
string(8) "26695547"
[7]=>
string(8) "26695548"
[8]=>
string(8) "26695549"
[9]=>
string(8) "26695550"
[10]=>
string(8) "26695551"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202419170
)
[StreetNumber] => Array
(
[0] => 59-056B
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 59-56B-1
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 3250000.00
)
[CurrentPrice] => Array
(
[0] => 3250000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => SPECTACULAR and one of a kind 2.6 ACRE lot overlooking Sunset Beach with views to Kaena Point!! With the beautiful Koolau Mountains behind and ocean views in front, this property is completely surrounded by all that makes country living so special. Bring your ideas and imagination to build your dream home in one of the most highly sought after areas of the North Shore. *Boundary lines on the drone aerial photos are just ESTIMATED locations. See CPR map or in person to know exact boundaries. **Please note that the CPR of this property was VERY recently completed so the assessed value and monthly taxes are accumulative between this lot and neighboring lot and will reflect differently once city comes up with valuation.
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 113256.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => 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] => sophia@sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 780-5673
)
[ListAgentFullName] => Array
(
[0] => Sophia L Miller
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-15T10:51:35.447
)
[Matrix_Unique_ID] => Array
(
[0] => 18227161
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-31T19:52:57.440
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26678273
)
[listing_image] => Array
(
[0] => 26678273
[1] => 26678274
[2] => 26678275
[3] => 26678276
[4] => 26678277
[5] => 26678278
[6] => 26695547
[7] => 26695548
[8] => 26695549
[9] => 26695550
[10] => 26695551
)
)
- View: Mountain,Ocean,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Sunset Beach
- Middle School: Kahuku
- High School: Kahuku
