62-405 Kamehameha Highway Haleiwa, HI 96712
Listing
Overview
Price: $3,450,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: Real Broker, LLC (808) 372-8700
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202422027"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3450000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["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(16) "Real Broker, LLC"
}
["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) "124277.00"
}
["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(3) "One"
}
["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(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RBLL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "seanginella@me.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 372-8700"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Sean F Ginella"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-14T16:00:01.310"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18288498"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-09"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26801561"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "26801561"
[1]=>
string(8) "26801562"
[2]=>
string(8) "26801563"
[3]=>
string(8) "26801564"
[4]=>
string(8) "26801565"
[5]=>
string(8) "26801566"
[6]=>
string(8) "26801567"
[7]=>
string(8) "26801568"
[8]=>
string(8) "26801569"
[9]=>
string(8) "26801570"
[10]=>
string(8) "26801571"
[11]=>
string(8) "26801572"
[12]=>
string(8) "26801573"
[13]=>
string(8) "26801574"
[14]=>
string(8) "26801575"
[15]=>
string(8) "26801576"
[16]=>
string(8) "26801577"
[17]=>
string(8) "26801578"
[18]=>
string(8) "26801579"
[19]=>
string(8) "26801580"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202422027
)
[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] =>
)
[ListPrice] => Array
(
[0] => 3450000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[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] => Real Broker, LLC
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 124277.00
)
[SqftTotal] => Array
(
[0] => 1668
)
[YearBuilt] => Array
(
[0] => 1980
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 9
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Mountain,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RBLL
)
[ListAgentEmail] => Array
(
[0] => seanginella@me.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 372-8700
)
[ListAgentFullName] => Array
(
[0] => Sean F Ginella
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-14T16:00:01.310
)
[Matrix_Unique_ID] => Array
(
[0] => 18288498
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[ListingContractDate] => Array
(
[0] => 2024-12-09
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26801561
)
[listing_image] => Array
(
[0] => 26801561
[1] => 26801562
[2] => 26801563
[3] => 26801564
[4] => 26801565
[5] => 26801566
[6] => 26801567
[7] => 26801568
[8] => 26801569
[9] => 26801570
[10] => 26801571
[11] => 26801572
[12] => 26801573
[13] => 26801574
[14] => 26801575
[15] => 26801576
[16] => 26801577
[17] => 26801578
[18] => 26801579
[19] => 26801580
)
)
- BedsTotal: 6
- Full Baths: 4
- Land Area (sf): 124,277 sf
- Living (sf): 1,668
- Year Built: 1980
- Property Condition: Above Average
- Number of Parking Spaces: 9
- View: Garden,Mountain,Sunrise,Sunset
- Listing Office: Real Broker, LLC
- Land Tenure: FS - Fee Simple
