61-006 Kamehameha Highway Haleiwa, HI 96712
Listing
Overview
Price: $2,500,000
Area: WAIMEA
Status: Active
Speechless!! A one of kind, majestic property on high over looking Oahu's majestic landmark known as "Waimea Bay. " Home to 30 foot waves with surfers flocking in from all over the world. Watch Dolphins and Turtles frolicking as sunbathe from up top. Bring your vision of unlimited potentials. Listing by: West Oahu Realty, Inc. (808) 428-6363
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202404218"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "61-006"
}
["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(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) "2500000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2500000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "WAIMEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(293) "Speechless!! A one of kind, majestic property on high over looking Oahu's majestic landmark known as "Waimea Bay. " Home to 30 foot waves with surfers flocking in from all over the world. Watch Dolphins and Turtles frolicking as sunbathe from up top. Bring your vision of unlimited potentials."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "West Oahu Realty, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "281049.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(30) "Coastline,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "WORI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "coyoteatkunia@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 428-6363"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Nainiu J Fakava"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-10T06:00:20.247"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17846849"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-02-26T11:34:49.980"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Preservation"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26108587"
}
["listing_image"]=>
array(2) {
[0]=>
string(8) "26108587"
[1]=>
string(8) "26108588"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202404218
)
[StreetNumber] => Array
(
[0] => 61-006
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[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] => 2500000.00
)
[CurrentPrice] => Array
(
[0] => 2500000.00
)
[Neighbourhood] => Array
(
[0] => WAIMEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Speechless!! A one of kind, majestic property on high over looking Oahu's majestic landmark known as "Waimea Bay. " Home to 30 foot waves with surfers flocking in from all over the world. Watch Dolphins and Turtles frolicking as sunbathe from up top. Bring your vision of unlimited potentials.
)
[ListOfficeName] => Array
(
[0] => West Oahu Realty, Inc.
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 281049.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Coastline,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => WORI
)
[ListAgentEmail] => Array
(
[0] => coyoteatkunia@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 428-6363
)
[ListAgentFullName] => Array
(
[0] => Nainiu J Fakava
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-10T06:00:20.247
)
[Matrix_Unique_ID] => Array
(
[0] => 17846849
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-02-26T11:34:49.980
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Preservation
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26108587
)
[listing_image] => Array
(
[0] => 26108587
[1] => 26108588
)
)
- View: Coastline,Ocean,Sunrise,Sunset
- Listing Office: West Oahu Realty, Inc.
- Land Tenure: FS - Fee Simple