61-651 Kamehameha Highway Haleiwa, HI 96712
Listing
Overview
Price: $4,970,000
Area: KAWAILOA-NORTH SHORE
Status: Active
White-Sand-Beachfront on our North Shore Gold Coast (between Laniakea and Papailoa). Large Lot with nice beach frontage and fully landscaped. Come up from your almost private beach and take an outdoor shower (there are two of them). Or turn around and paddle out to two world-class Surf Breaks right out back; Himalayas and Laniakea - paddle out zones are less than 30 steps away! New Mitsubishi Split Air Efficient Air Conditioning units in every room and Solar Hot Water for both units with 2 Tanks. Great for extended family or you can live in the main house and rent out the guest cottage with its own large partial kitchen and living room. Lots of Rental Income possible as there is a history of this being a great Beachfront Short-Term Vacation Rental (30 days, or more) and the homes are both Fully Furnished and ready to occupy or rent. Upstairs is the newer Main Section of the house and Downstairs is the older single-wall classic beach home closer to the beach (& grandfathered in). 2 full Laundry Rooms. New Electric Entry Gate, wi-fi enabled with security system and video camera. Electric for Jacuzzi Tub is installed and ready for your Hot Tub. Beachfront Living at its best! Listing by: Sterman Realty (808) 637-6200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415257"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "61-651"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "4970000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "4970000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(20) "KAWAILOA-NORTH SHORE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1199) "White-Sand-Beachfront on our North Shore Gold Coast (between Laniakea and Papailoa). Large Lot with nice beach frontage and fully landscaped. Come up from your almost private beach and take an outdoor shower (there are two of them). Or turn around and paddle out to two world-class Surf Breaks right out back; Himalayas and Laniakea - paddle out zones are less than 30 steps away! New Mitsubishi Split Air Efficient Air Conditioning units in every room and Solar Hot Water for both units with 2 Tanks. Great for extended family or you can live in the main house and rent out the guest cottage with its own large partial kitchen and living room. Lots of Rental Income possible as there is a history of this being a great Beachfront Short-Term Vacation Rental (30 days, or more) and the homes are both Fully Furnished and ready to occupy or rent. Upstairs is the newer Main Section of the house and Downstairs is the older single-wall classic beach home closer to the beach (& grandfathered in). 2 full Laundry Rooms. New Electric Entry Gate, wi-fi enabled with security system and video camera. Electric for Jacuzzi Tub is installed and ready for your Hot Tub. Beachfront Living at its best!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Sterman Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "2"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "9507.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3257"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1962"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(29) "Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["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-09-11T09:28:54.733"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18104644"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-06T13:04:59.360"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26612539"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26612539"
[1]=>
string(8) "26612540"
[2]=>
string(8) "26612541"
[3]=>
string(8) "26612542"
[4]=>
string(8) "26612543"
[5]=>
string(8) "26612544"
[6]=>
string(8) "26612545"
[7]=>
string(8) "26612546"
[8]=>
string(8) "26612547"
[9]=>
string(8) "26612548"
[10]=>
string(8) "26612549"
[11]=>
string(8) "26612550"
[12]=>
string(8) "26612551"
[13]=>
string(8) "26612552"
[14]=>
string(8) "26612553"
[15]=>
string(8) "26612554"
[16]=>
string(8) "26612555"
[17]=>
string(8) "26612556"
[18]=>
string(8) "26612557"
[19]=>
string(8) "26612558"
[20]=>
string(8) "26612559"
[21]=>
string(8) "26612560"
[22]=>
string(8) "26612561"
[23]=>
string(8) "26612562"
[24]=>
string(8) "26612563"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415257
)
[StreetNumber] => Array
(
[0] => 61-651
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 4970000.00
)
[CurrentPrice] => Array
(
[0] => 4970000.00
)
[Neighbourhood] => Array
(
[0] => KAWAILOA-NORTH SHORE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => White-Sand-Beachfront on our North Shore Gold Coast (between Laniakea and Papailoa). Large Lot with nice beach frontage and fully landscaped. Come up from your almost private beach and take an outdoor shower (there are two of them). Or turn around and paddle out to two world-class Surf Breaks right out back; Himalayas and Laniakea - paddle out zones are less than 30 steps away! New Mitsubishi Split Air Efficient Air Conditioning units in every room and Solar Hot Water for both units with 2 Tanks. Great for extended family or you can live in the main house and rent out the guest cottage with its own large partial kitchen and living room. Lots of Rental Income possible as there is a history of this being a great Beachfront Short-Term Vacation Rental (30 days, or more) and the homes are both Fully Furnished and ready to occupy or rent. Upstairs is the newer Main Section of the house and Downstairs is the older single-wall classic beach home closer to the beach (& grandfathered in). 2 full Laundry Rooms. New Electric Entry Gate, wi-fi enabled with security system and video camera. Electric for Jacuzzi Tub is installed and ready for your Hot Tub. Beachfront Living at its best!
)
[ListOfficeName] => Array
(
[0] => Sterman Realty
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 2
)
[LotSizeArea] => Array
(
[0] => 9507.00
)
[SqftTotal] => Array
(
[0] => 3257
)
[YearBuilt] => Array
(
[0] => 1962
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Haleiwa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[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-09-11T09:28:54.733
)
[Matrix_Unique_ID] => Array
(
[0] => 18104644
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-06T13:04:59.360
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26612539
)
[listing_image] => Array
(
[0] => 26612539
[1] => 26612540
[2] => 26612541
[3] => 26612542
[4] => 26612543
[5] => 26612544
[6] => 26612545
[7] => 26612546
[8] => 26612547
[9] => 26612548
[10] => 26612549
[11] => 26612550
[12] => 26612551
[13] => 26612552
[14] => 26612553
[15] => 26612554
[16] => 26612555
[17] => 26612556
[18] => 26612557
[19] => 26612558
[20] => 26612559
[21] => 26612560
[22] => 26612561
[23] => 26612562
[24] => 26612563
)
)
- BedsTotal: 5
- Full Baths: 3
- Half Baths: 2
- Land Area (sf): 9,507
- Living (sf): 3,257
- Year Built: 1962
- Property Condition: Excellent
- Number of Parking Spaces: 3
- View: Mountain,Ocean,Sunrise,Sunset
- Listing Office: Sterman Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Haleiwa
- Middle School: Waialua
- High School: Waialua
