Listing
Overview
Price: $4,795,000
Area: SUNSET AREA
Status: Active
Welcome to Stunning Sunsets and one of the Top white sand beaches on the North Shore and Oahu!
This very unique North Shore beachfront home, beautifully upgraded and well appointed, is just steps to the sand.
Scenic views from the luscious lawn, living room, kitchen, upstairs-loft suite, and covered lanai include seasonal surf and whale watching. The well established landscaping and vegetation ensure privacy from beach. Ideally located in the middle of the “Seven Mile Miracle”, close to schools, shopping, golf, snorkeling, churches and some of the best surf breaks in the world.
*Brand New Spilt AC Throughout, Blue Rock Driveway and Backyard Sod.
Perfect for a primary residence, second home or family retreat!
Real AVM Range: $4,139,600-$5,081,500 (09-09-2024) Confidence Score 90%.
*Be sure to Click on Virtual Tour Icon* Listing by: Sterman Realty (808) 637-6200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414881"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-557"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Ke Iki"
}
["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(54) "https://shoots.styronphoto.com/sites/zejbkjq/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4795000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4795000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(842) "Welcome to Stunning Sunsets and one of the Top white sand beaches on the North Shore and Oahu!
This very unique North Shore beachfront home, beautifully upgraded and well appointed, is just steps to the sand.
Scenic views from the luscious lawn, living room, kitchen, upstairs-loft suite, and covered lanai include seasonal surf and whale watching. The well established landscaping and vegetation ensure privacy from beach. Ideally located in the middle of the “Seven Mile Miracle”, close to schools, shopping, golf, snorkeling, churches and some of the best surf breaks in the world.
*Brand New Spilt AC Throughout, Blue Rock Driveway and Backyard Sod.
Perfect for a primary residence, second home or family retreat!
Real AVM Range: $4,139,600-$5,081,500 (09-09-2024) Confidence Score 90%.
*Be sure to Click on Virtual Tour Icon*"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6260.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1938"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1978"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(15) "Two,Split Level"
}
["View"]=>
array(1) {
[0]=>
string(22) "Coastline,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(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "STER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "Beatnik@sterman.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 637-6200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Beatnik A Cross"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-23T14:33:49.177"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18090721"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-28T10:37:44.477"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26602763"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26602763"
[1]=>
string(8) "26602764"
[2]=>
string(8) "26602765"
[3]=>
string(8) "26602766"
[4]=>
string(8) "26602767"
[5]=>
string(8) "26602768"
[6]=>
string(8) "26602769"
[7]=>
string(8) "26602770"
[8]=>
string(8) "26602771"
[9]=>
string(8) "26602772"
[10]=>
string(8) "26602773"
[11]=>
string(8) "26602774"
[12]=>
string(8) "26602775"
[13]=>
string(8) "26602776"
[14]=>
string(8) "26602777"
[15]=>
string(8) "26602778"
[16]=>
string(8) "26602779"
[17]=>
string(8) "26602780"
[18]=>
string(8) "26602781"
[19]=>
string(8) "26602782"
[20]=>
string(8) "26602783"
[21]=>
string(8) "26602784"
[22]=>
string(8) "26602785"
[23]=>
string(8) "26602786"
[24]=>
string(8) "26602787"
[25]=>
string(8) "26603766"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414881
)
[StreetNumber] => Array
(
[0] => 59-557
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ke Iki
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => A
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/sites/zejbkjq/unbranded
)
[ListPrice] => Array
(
[0] => 4795000.00
)
[CurrentPrice] => Array
(
[0] => 4795000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to Stunning Sunsets and one of the Top white sand beaches on the North Shore and Oahu!
This very unique North Shore beachfront home, beautifully upgraded and well appointed, is just steps to the sand.
Scenic views from the luscious lawn, living room, kitchen, upstairs-loft suite, and covered lanai include seasonal surf and whale watching. The well established landscaping and vegetation ensure privacy from beach. Ideally located in the middle of the “Seven Mile Miracle”, close to schools, shopping, golf, snorkeling, churches and some of the best surf breaks in the world.
*Brand New Spilt AC Throughout, Blue Rock Driveway and Backyard Sod.
Perfect for a primary residence, second home or family retreat!
Real AVM Range: $4,139,600-$5,081,500 (09-09-2024) Confidence Score 90%.
*Be sure to Click on Virtual Tour Icon*
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 6260.00
)
[SqftTotal] => Array
(
[0] => 1938
)
[YearBuilt] => Array
(
[0] => 1978
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two,Split Level
)
[View] => Array
(
[0] => Coastline,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Sunset Beach
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => STER
)
[ListAgentEmail] => Array
(
[0] => Beatnik@sterman.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 637-6200
)
[ListAgentFullName] => Array
(
[0] => Beatnik A Cross
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-23T14:33:49.177
)
[Matrix_Unique_ID] => Array
(
[0] => 18090721
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-28T10:37:44.477
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26602763
)
[listing_image] => Array
(
[0] => 26602763
[1] => 26602764
[2] => 26602765
[3] => 26602766
[4] => 26602767
[5] => 26602768
[6] => 26602769
[7] => 26602770
[8] => 26602771
[9] => 26602772
[10] => 26602773
[11] => 26602774
[12] => 26602775
[13] => 26602776
[14] => 26602777
[15] => 26602778
[16] => 26602779
[17] => 26602780
[18] => 26602781
[19] => 26602782
[20] => 26602783
[21] => 26602784
[22] => 26602785
[23] => 26602786
[24] => 26602787
[25] => 26603766
)
)
- BedsTotal: 3
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 6,260
- Living (sf): 1,938
- Year Built: 1978
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Coastline,Ocean,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Sunset Beach
- High School: Waialua
