Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
59-165 A Ke Nui Road Unit A Haleiwa, HI 96712
Listing Overview
Price: $2,100,000 Area: SUNSET AREA Status: Active
Welcome to this fantastic legal duplex, ideally situated just one house back from the beautiful shores of Sunset Beach on the North Shore of Oahu. In excellent condition, this property is a true surfing paradise, featuring stunning ocean views and private beach access.
With two spacious units, it offers the perfect opportunity for family living or rental income. Enjoy easy access to world-class surf spots and pristine sandy beaches, all just moments away. The property also includes a convenient two-car garage and an outdoor shower, perfect for rinsing off after a day at the beach.
This is a rare opportunity to own a piece of paradise in a prime location. Don’t miss out—schedule a showing today! Listing by: Sterman Realty (808) 271-1831
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423525"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(8) "59-165 A"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Ke Nui"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "A"
}
["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) "2100000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2100000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(709) "Welcome to this fantastic legal duplex, ideally situated just one house back from the beautiful shores of Sunset Beach on the North Shore of Oahu. In excellent condition, this property is a true surfing paradise, featuring stunning ocean views and private beach access.
With two spacious units, it offers the perfect opportunity for family living or rental income. Enjoy easy access to world-class surf spots and pristine sandy beaches, all just moments away. The property also includes a convenient two-car garage and an outdoor shower, perfect for rinsing off after a day at the beach.
This is a rare opportunity to own a piece of paradise in a prime location. Don’t miss out—schedule a showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1720"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1942"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(19) "Garden,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(20) "cathyshanley@aol.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 271-1831"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Cathryn L Shanley"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-10T14:09:03.243"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18312935"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-07T15:22:35.683"
}
["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) "26725383"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26725383"
[1]=>
string(8) "26725384"
[2]=>
string(8) "26725385"
[3]=>
string(8) "26725386"
[4]=>
string(8) "26725387"
[5]=>
string(8) "26725388"
[6]=>
string(8) "26725389"
[7]=>
string(8) "26725390"
[8]=>
string(8) "26725391"
[9]=>
string(8) "26725392"
[10]=>
string(8) "26725393"
[11]=>
string(8) "26725394"
[12]=>
string(8) "26725395"
[13]=>
string(8) "26725396"
[14]=>
string(8) "26725397"
[15]=>
string(8) "26725398"
[16]=>
string(8) "26725399"
[17]=>
string(8) "26725400"
[18]=>
string(8) "26725401"
[19]=>
string(8) "26725402"
[20]=>
string(8) "26725403"
[21]=>
string(8) "26725404"
[22]=>
string(8) "26725405"
[23]=>
string(8) "26725406"
[24]=>
string(8) "26725407"
[25]=>
string(8) "26725408"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423525
)
[StreetNumber] => Array
(
[0] => 59-165 A
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ke Nui
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => A
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 2100000.00
)
[CurrentPrice] => Array
(
[0] => 2100000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to this fantastic legal duplex, ideally situated just one house back from the beautiful shores of Sunset Beach on the North Shore of Oahu. In excellent condition, this property is a true surfing paradise, featuring stunning ocean views and private beach access.
With two spacious units, it offers the perfect opportunity for family living or rental income. Enjoy easy access to world-class surf spots and pristine sandy beaches, all just moments away. The property also includes a convenient two-car garage and an outdoor shower, perfect for rinsing off after a day at the beach.
This is a rare opportunity to own a piece of paradise in a prime location. Don’t miss out—schedule a showing today!
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 5000.00
)
[SqftTotal] => Array
(
[0] => 1720
)
[YearBuilt] => Array
(
[0] => 1942
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,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] => cathyshanley@aol.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 271-1831
)
[ListAgentFullName] => Array
(
[0] => Cathryn L Shanley
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-10T14:09:03.243
)
[Matrix_Unique_ID] => Array
(
[0] => 18312935
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-07T15:22:35.683
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26725383
)
[listing_image] => Array
(
[0] => 26725383
[1] => 26725384
[2] => 26725385
[3] => 26725386
[4] => 26725387
[5] => 26725388
[6] => 26725389
[7] => 26725390
[8] => 26725391
[9] => 26725392
[10] => 26725393
[11] => 26725394
[12] => 26725395
[13] => 26725396
[14] => 26725397
[15] => 26725398
[16] => 26725399
[17] => 26725400
[18] => 26725401
[19] => 26725402
[20] => 26725403
[21] => 26725404
[22] => 26725405
[23] => 26725406
[24] => 26725407
[25] => 26725408
)
)