Nestled in the historic town of Haleiwa on the North Shore of Oahu, this stunning 4 bedroom, 3 bath custom designed residence offers a unique opportunity to embrace island living at its finest. Overlooking the tranquil Loko Ea Fish Pond, the home spans over 3,000 square feet under roof and features two large enclosed garages. Highlights include gorgeous cedar vaulted ceilings, a large kitchen pantry, stainless steel appliances and a built-in wine fridge. The primary bedroom boasts double sinks, a spacious closet and beautiful quartz countertops throughout. With its spacious open floor plan, the interior is filled with natural light and modern finishes perfect for both relaxation and entertaining. Outside to a private half-acre fully fenced oasis featuring a lush yard that meets the Anahulu River's shore. Enjoy vibrant sunsets while stand up paddling into the evening. Just minutes from world-renowned beaches, surf spots, and charming local shops, this location is a perfect mix of tranquility and adventure. Listing by: Pacific Image Properties (808) 783-6254
array(47) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202425861"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "62-117"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Lokoea"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(1) "2"
}
["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(59) "https://listings.hetproductions.com/sites/zewmaan/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3679000.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(1020) "Nestled in the historic town of Haleiwa on the North Shore of Oahu, this stunning 4 bedroom, 3 bath custom designed residence offers a unique opportunity to embrace island living at its finest. Overlooking the tranquil Loko Ea Fish Pond, the home spans over 3,000 square feet under roof and features two large enclosed garages. Highlights include gorgeous cedar vaulted ceilings, a large kitchen pantry, stainless steel appliances and a built-in wine fridge. The primary bedroom boasts double sinks, a spacious closet and beautiful quartz countertops throughout. With its spacious open floor plan, the interior is filled with natural light and modern finishes perfect for both relaxation and entertaining. Outside to a private half-acre fully fenced oasis featuring a lush yard that meets the Anahulu River's shore. Enjoy vibrant sunsets while stand up paddling into the evening. Just minutes from world-renowned beaches, surf spots, and charming local shops, this location is a perfect mix of tranquility and adventure."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Pacific Image Properties"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "22000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3310"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2022"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "62-117 Lokoea Place"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(28) "Coastline,Marina/Canal,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "PCFC"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "sabrinanorthshore@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 783-6254"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Sabrina Folgosi"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-12-18T14:18:33.017"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18362173"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-12-17"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(33) "Lake/Pond,Stream/Canal,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26810745"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26810745"
[1]=>
string(8) "26810746"
[2]=>
string(8) "26810747"
[3]=>
string(8) "26810748"
[4]=>
string(8) "26810749"
[5]=>
string(8) "26810750"
[6]=>
string(8) "26810751"
[7]=>
string(8) "26810752"
[8]=>
string(8) "26810753"
[9]=>
string(8) "26810754"
[10]=>
string(8) "26810755"
[11]=>
string(8) "26810756"
[12]=>
string(8) "26810757"
[13]=>
string(8) "26810758"
[14]=>
string(8) "26810759"
[15]=>
string(8) "26810760"
[16]=>
string(8) "26810761"
[17]=>
string(8) "26810762"
[18]=>
string(8) "26810763"
[19]=>
string(8) "26810764"
[20]=>
string(8) "26810765"
[21]=>
string(8) "26810766"
[22]=>
string(8) "26810767"
[23]=>
string(8) "26810768"
[24]=>
string(8) "26810769"
}
["_edit_lock"]=>
array(1) {
[0]=>
string(12) "1734564704:7"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202425861
)
[StreetNumber] => Array
(
[0] => 62-117
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Lokoea
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => 2
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/zewmaan/unbranded
)
[ListPrice] => Array
(
[0] => 3679000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Nestled in the historic town of Haleiwa on the North Shore of Oahu, this stunning 4 bedroom, 3 bath custom designed residence offers a unique opportunity to embrace island living at its finest. Overlooking the tranquil Loko Ea Fish Pond, the home spans over 3,000 square feet under roof and features two large enclosed garages. Highlights include gorgeous cedar vaulted ceilings, a large kitchen pantry, stainless steel appliances and a built-in wine fridge. The primary bedroom boasts double sinks, a spacious closet and beautiful quartz countertops throughout. With its spacious open floor plan, the interior is filled with natural light and modern finishes perfect for both relaxation and entertaining. Outside to a private half-acre fully fenced oasis featuring a lush yard that meets the Anahulu River's shore. Enjoy vibrant sunsets while stand up paddling into the evening. Just minutes from world-renowned beaches, surf spots, and charming local shops, this location is a perfect mix of tranquility and adventure.
)
[ListOfficeName] => Array
(
[0] => Pacific Image Properties
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 22000.00
)
[SqftTotal] => Array
(
[0] => 3310
)
[YearBuilt] => Array
(
[0] => 2022
)
[BuildingName] => Array
(
[0] => 62-117 Lokoea Place
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Marina/Canal,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => PCFC
)
[ListAgentEmail] => Array
(
[0] => sabrinanorthshore@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 783-6254
)
[ListAgentFullName] => Array
(
[0] => Sabrina Folgosi
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-12-18T14:18:33.017
)
[Matrix_Unique_ID] => Array
(
[0] => 18362173
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[ListingContractDate] => Array
(
[0] => 2024-12-17
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Lake/Pond,Stream/Canal,Waterfront
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26810745
)
[listing_image] => Array
(
[0] => 26810745
[1] => 26810746
[2] => 26810747
[3] => 26810748
[4] => 26810749
[5] => 26810750
[6] => 26810751
[7] => 26810752
[8] => 26810753
[9] => 26810754
[10] => 26810755
[11] => 26810756
[12] => 26810757
[13] => 26810758
[14] => 26810759
[15] => 26810760
[16] => 26810761
[17] => 26810762
[18] => 26810763
[19] => 26810764
[20] => 26810765
[21] => 26810766
[22] => 26810767
[23] => 26810768
[24] => 26810769
)
[_edit_lock] => Array
(
[0] => 1734564704:7
)
)
