Listing
Overview
Price: $2,720,000
Area: KOKOKAHI
Status: Active
Welcome to your waterfront paradise on Kaneohe Bay! With 3 separate dwellings and plenty of parking, this unique property offers a harmonious blend of natural beauty and functional luxury. The main house boasts 3 bedrooms, 2 full baths, an attached guest cabin (2 bed, 1 bath) plus a flex office space. Two detached 1 bedroom units offer versatile living or rental income options. The pier provides direct access to the bay for you to explore with SUPs, kayaks, or boats. Custom upgrades add character to this home. A redwood deck crafted using wood repurposed from San Diego Yacht Club provides an inviting gathering space outside. Inside, a custom mango wood bar adds warmth and charm to the kitchen. Unique touches, such as a light fixture imported from Nantucket and a brass porthole in the guest cabin, reflect the home's coastal ambiance. The large fully fenced grassy lawn offers ample room for entertaining or pets. A thriving garden surrounds the home, complete with a mature avocado tree, papaya, lime, ti plants, and rosemary. Protected by the geographic features of Kaneohe Bay, this waterfront retreat is shielded from flooding and erosion, ensuring peace of mind for years to come. Listing by: Keller Williams Honolulu (609) 865-6296
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408407"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "45-005"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Likeke"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96744"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(59) "https://media.visionaryviewsllc.com/sites/ynezzqp/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2720000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "2720000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "KOKOKAHI"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1196) "Welcome to your waterfront paradise on Kaneohe Bay! With 3 separate dwellings and plenty of parking, this unique property offers a harmonious blend of natural beauty and functional luxury. The main house boasts 3 bedrooms, 2 full baths, an attached guest cabin (2 bed, 1 bath) plus a flex office space. Two detached 1 bedroom units offer versatile living or rental income options. The pier provides direct access to the bay for you to explore with SUPs, kayaks, or boats. Custom upgrades add character to this home. A redwood deck crafted using wood repurposed from San Diego Yacht Club provides an inviting gathering space outside. Inside, a custom mango wood bar adds warmth and charm to the kitchen. Unique touches, such as a light fixture imported from Nantucket and a brass porthole in the guest cabin, reflect the home's coastal ambiance. The large fully fenced grassy lawn offers ample room for entertaining or pets. A thriving garden surrounds the home, complete with a mature avocado tree, papaya, lime, ti plants, and rosemary. Protected by the geographic features of Kaneohe Bay, this waterfront retreat is shielded from flooding and erosion, ensuring peace of mind for years to come."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "9060.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3642"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1950"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(21) "Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Puohala"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(4) "King"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Castle"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "KWPP04"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "julia@framo-akselrud.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(609) 865-6296"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Julia Akselrud"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-04-28T17:00:01.790"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17944058"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-17T11:26:15.383"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(16) "Ocean,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26169134"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26169134"
[1]=>
string(8) "26169135"
[2]=>
string(8) "26169136"
[3]=>
string(8) "26169137"
[4]=>
string(8) "26169138"
[5]=>
string(8) "26169139"
[6]=>
string(8) "26169140"
[7]=>
string(8) "26169141"
[8]=>
string(8) "26169142"
[9]=>
string(8) "26169143"
[10]=>
string(8) "26169144"
[11]=>
string(8) "26169145"
[12]=>
string(8) "26169146"
[13]=>
string(8) "26169147"
[14]=>
string(8) "26169148"
[15]=>
string(8) "26169149"
[16]=>
string(8) "26169150"
[17]=>
string(8) "26169151"
[18]=>
string(8) "26169152"
[19]=>
string(8) "26169153"
[20]=>
string(8) "26169154"
[21]=>
string(8) "26169155"
[22]=>
string(8) "26169156"
[23]=>
string(8) "26169157"
[24]=>
string(8) "26169158"
[25]=>
string(8) "26169159"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408407
)
[StreetNumber] => Array
(
[0] => 45-005
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Likeke
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Kaneohe
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96744
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://media.visionaryviewsllc.com/sites/ynezzqp/unbranded
)
[ListPrice] => Array
(
[0] => 2720000.00
)
[CurrentPrice] => Array
(
[0] => 2720000.00
)
[Neighbourhood] => Array
(
[0] => KOKOKAHI
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to your waterfront paradise on Kaneohe Bay! With 3 separate dwellings and plenty of parking, this unique property offers a harmonious blend of natural beauty and functional luxury. The main house boasts 3 bedrooms, 2 full baths, an attached guest cabin (2 bed, 1 bath) plus a flex office space. Two detached 1 bedroom units offer versatile living or rental income options. The pier provides direct access to the bay for you to explore with SUPs, kayaks, or boats. Custom upgrades add character to this home. A redwood deck crafted using wood repurposed from San Diego Yacht Club provides an inviting gathering space outside. Inside, a custom mango wood bar adds warmth and charm to the kitchen. Unique touches, such as a light fixture imported from Nantucket and a brass porthole in the guest cabin, reflect the home's coastal ambiance. The large fully fenced grassy lawn offers ample room for entertaining or pets. A thriving garden surrounds the home, complete with a mature avocado tree, papaya, lime, ti plants, and rosemary. Protected by the geographic features of Kaneohe Bay, this waterfront retreat is shielded from flooding and erosion, ensuring peace of mind for years to come.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 6
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 9060.00
)
[SqftTotal] => Array
(
[0] => 3642
)
[YearBuilt] => Array
(
[0] => 1950
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Puohala
)
[MiddleOrJuniorSchool] => Array
(
[0] => King
)
[HighSchool] => Array
(
[0] => Castle
)
[ListOfficeMLSID] => Array
(
[0] => KWPP04
)
[ListAgentEmail] => Array
(
[0] => julia@framo-akselrud.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (609) 865-6296
)
[ListAgentFullName] => Array
(
[0] => Julia Akselrud
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-04-28T17:00:01.790
)
[Matrix_Unique_ID] => Array
(
[0] => 17944058
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-17T11:26:15.383
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26169134
)
[listing_image] => Array
(
[0] => 26169134
[1] => 26169135
[2] => 26169136
[3] => 26169137
[4] => 26169138
[5] => 26169139
[6] => 26169140
[7] => 26169141
[8] => 26169142
[9] => 26169143
[10] => 26169144
[11] => 26169145
[12] => 26169146
[13] => 26169147
[14] => 26169148
[15] => 26169149
[16] => 26169150
[17] => 26169151
[18] => 26169152
[19] => 26169153
[20] => 26169154
[21] => 26169155
[22] => 26169156
[23] => 26169157
[24] => 26169158
[25] => 26169159
)
)
- BedsTotal: 6
- Full Baths: 5
- Land Area (sf): 9,060
- Living (sf): 3,642
- Year Built: 1950
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Mountain,Ocean,Sunset
- Listing Office: Keller Williams Honolulu
- Land Tenure: FS - Fee Simple
- Elementary School: Puohala
- Middle School: King
- High School: Castle
