Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Price: $3,100,000 Area: HALEIWA Status: Active Under Contract
Location, location, location! Situated on the northern edge of historic Haleiwa Town, this custom-built 2022 home overlooks the serene Loko Ea fishpond—where Queen Lili'uokalani once spent her summers. With direct river access and just minutes from Haleiwa’s most popular shops, restaurants, and beaches, this property offers the best of North Shore living. The home features four bedrooms and three full bathrooms, with gorgeous vaulted ceilings and a bright, open-concept floor plan. The island kitchen includes stainless steel appliances, quartz countertops, a spacious pantry, and a built-in wine refrigerator—ideal for entertaining. The primary suite boasts double sinks, a large closet, and modern finishes throughout. Nestled on a private, fully fenced, and level half-acre lot, the property also includes a tranquil lanai—perfect for weekend BBQs—and an oversized two-car garage. Enjoy close proximity to top local attractions such as Haleiwa Joe's, Ali‘i Beach Park, Beach House Restaurant, boutique surf shops, and the picturesque Haleiwa Harbor.
Bonus: The seller is offering a loan rate buydown to help reduce the buyer's monthly payments and make ownership more affordable. Listing by: Pacific Image Properties (808) 783-6254
array(49) {
["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) "3100000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "HALEIWA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1199) "Location, location, location! Situated on the northern edge of historic Haleiwa Town, this custom-built 2022 home overlooks the serene Loko Ea fishpond—where Queen Lili'uokalani once spent her summers. With direct river access and just minutes from Haleiwa’s most popular shops, restaurants, and beaches, this property offers the best of North Shore living. The home features four bedrooms and three full bathrooms, with gorgeous vaulted ceilings and a bright, open-concept floor plan. The island kitchen includes stainless steel appliances, quartz countertops, a spacious pantry, and a built-in wine refrigerator—ideal for entertaining. The primary suite boasts double sinks, a large closet, and modern finishes throughout. Nestled on a private, fully fenced, and level half-acre lot, the property also includes a tranquil lanai—perfect for weekend BBQs—and an oversized two-car garage. Enjoy close proximity to top local attractions such as Haleiwa Joe's, Ali‘i Beach Park, Beach House Restaurant, boutique surf shops, and the picturesque Haleiwa Harbor.
Bonus: The seller is offering a loan rate buydown to help reduce the buyer's monthly payments and make ownership more affordable."
}
["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) "2025-11-25T08:57:39.423"
}
["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(26) {
[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"
[25]=>
string(8) "27103480"
}
["_edit_lock"]=>
array(1) {
[0]=>
string(12) "1734564704:7"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:57:39.423"
}
}
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] => 3100000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => HALEIWA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Location, location, location! Situated on the northern edge of historic Haleiwa Town, this custom-built 2022 home overlooks the serene Loko Ea fishpond—where Queen Lili'uokalani once spent her summers. With direct river access and just minutes from Haleiwa’s most popular shops, restaurants, and beaches, this property offers the best of North Shore living. The home features four bedrooms and three full bathrooms, with gorgeous vaulted ceilings and a bright, open-concept floor plan. The island kitchen includes stainless steel appliances, quartz countertops, a spacious pantry, and a built-in wine refrigerator—ideal for entertaining. The primary suite boasts double sinks, a large closet, and modern finishes throughout. Nestled on a private, fully fenced, and level half-acre lot, the property also includes a tranquil lanai—perfect for weekend BBQs—and an oversized two-car garage. Enjoy close proximity to top local attractions such as Haleiwa Joe's, Ali‘i Beach Park, Beach House Restaurant, boutique surf shops, and the picturesque Haleiwa Harbor.
Bonus: The seller is offering a loan rate buydown to help reduce the buyer's monthly payments and make ownership more affordable.
)
[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] => 2025-11-25T08:57:39.423
)
[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
[25] => 27103480
)
[_edit_lock] => Array
(
[0] => 1734564704:7
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:57:39.423
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 25, 2025 - 8:57 AM
Information is deemed reliable but not guaranteed.
Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®.
If you are interested in those active listings, our company may represent you as the buyer's agent.
If the active listing you are interested in is our company's active listing, you may speak to one of our agents
regarding your options for representation.
