Listing
Overview
Price: $3,850,000
Area: HALEIWA
Status: Active
The mailing/street entrance address is 61-173 Lokoea Place; the TMK Address is 62-405 Kamehameha Hwy. One of a kind property in the heart of Haleiwa. This property offers nearly 3 acres with 250 ft frontage on the Anahulu stream. It features a brand-new dock for boats, kayaks, and jet skis. Agriculture and business rental income opportunities. Scenic beauty with lush vegetation and waterways. It is conveniently located near Haleiwa town center. This rare investment opportunity combines natural beauty and income potential. Contact us today to schedule a viewing and explore endless possibilities! Listing by: Hawaii Life (800) 370-3848
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202410463"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "62-405"
}
["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(39) "http://player.vimeo.com/video/938469931"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3850000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3850000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(601) "The mailing/street entrance address is 61-173 Lokoea Place; the TMK Address is 62-405 Kamehameha Hwy. One of a kind property in the heart of Haleiwa. This property offers nearly 3 acres with 250 ft frontage on the Anahulu stream. It features a brand-new dock for boats, kayaks, and jet skis. Agriculture and business rental income opportunities. Scenic beauty with lush vegetation and waterways. It is conveniently located near Haleiwa town center. This rare investment opportunity combines natural beauty and income potential. Contact us today to schedule a viewing and explore endless possibilities!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(11) "Hawaii Life"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "124276.68"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1668"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1980"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "9"
}
["StoriesType"]=>
array(1) {
[0]=>
string(7) "One,Two"
}
["View"]=>
array(1) {
[0]=>
string(30) "Garden,Mountain,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) "HLRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "seanginella@me.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(800) 370-3848"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Sean F Ginella"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-06-04T20:39:04.063"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17983579"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-02T17:34:47.400"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(10) "Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26192435"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "26192435"
[1]=>
string(8) "26192436"
[2]=>
string(8) "26192437"
[3]=>
string(8) "26192438"
[4]=>
string(8) "26192439"
[5]=>
string(8) "26192440"
[6]=>
string(8) "26192441"
[7]=>
string(8) "26192442"
[8]=>
string(8) "26192443"
[9]=>
string(8) "26192444"
[10]=>
string(8) "26192445"
[11]=>
string(8) "26192446"
[12]=>
string(8) "26192447"
[13]=>
string(8) "26192448"
[14]=>
string(8) "26192449"
[15]=>
string(8) "26192450"
[16]=>
string(8) "26192451"
[17]=>
string(8) "26192452"
[18]=>
string(8) "26192453"
[19]=>
string(8) "26192454"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202410463
)
[StreetNumber] => Array
(
[0] => 62-405
)
[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] => http://player.vimeo.com/video/938469931
)
[ListPrice] => Array
(
[0] => 3850000.00
)
[CurrentPrice] => Array
(
[0] => 3850000.00
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => The mailing/street entrance address is 61-173 Lokoea Place; the TMK Address is 62-405 Kamehameha Hwy. One of a kind property in the heart of Haleiwa. This property offers nearly 3 acres with 250 ft frontage on the Anahulu stream. It features a brand-new dock for boats, kayaks, and jet skis. Agriculture and business rental income opportunities. Scenic beauty with lush vegetation and waterways. It is conveniently located near Haleiwa town center. This rare investment opportunity combines natural beauty and income potential. Contact us today to schedule a viewing and explore endless possibilities!
)
[ListOfficeName] => Array
(
[0] => Hawaii Life
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 124276.68
)
[SqftTotal] => Array
(
[0] => 1668
)
[YearBuilt] => Array
(
[0] => 1980
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 9
)
[StoriesType] => Array
(
[0] => One,Two
)
[View] => Array
(
[0] => Garden,Mountain,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] => HLRE
)
[ListAgentEmail] => Array
(
[0] => seanginella@me.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (800) 370-3848
)
[ListAgentFullName] => Array
(
[0] => Sean F Ginella
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-06-04T20:39:04.063
)
[Matrix_Unique_ID] => Array
(
[0] => 17983579
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-02T17:34:47.400
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26192435
)
[listing_image] => Array
(
[0] => 26192435
[1] => 26192436
[2] => 26192437
[3] => 26192438
[4] => 26192439
[5] => 26192440
[6] => 26192441
[7] => 26192442
[8] => 26192443
[9] => 26192444
[10] => 26192445
[11] => 26192446
[12] => 26192447
[13] => 26192448
[14] => 26192449
[15] => 26192450
[16] => 26192451
[17] => 26192452
[18] => 26192453
[19] => 26192454
)
)
- BedsTotal: 6
- Full Baths: 4
- Land Area (sf): 124,277
- Living (sf): 1,668
- Year Built: 1980
- Property Condition: Above Average
- Number of Parking Spaces: 9
- View: Garden,Mountain,Sunrise,Sunset
- Listing Office: Hawaii Life
- Land Tenure: FS - Fee Simple
- Elementary School: Haleiwa
- Middle School: Waialua
- High School: Waialua