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
67-401 Aikaula Street Waialua, HI 96791
Listing Overview
Price: $625,000 Area: WAIALUA Status: Active
Come and build your Dream Home in Waialua! This is a rare opportunity to own and build your dream home on a prime, level corner vacant lot located directly across from St. Michael's Church in beautiful Waialua Communtiy. It offers the perfect blend of convenience and island living. Just minutes from Haleiwa Town, Mokuleia Beach, schools, and local eateries, this property is the ideal location to build your custom island home. Don't miss this opportunity! Paradise starts here! It is priced below Assessed Value for a quick sale, but not a Short Sale. Listing by: West Oahu Realty, Inc. (808) 223-2888
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202516683"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-401"
}
["PropertyType"]=>
array(1) {
[0]=>
string(16) "Lots/Acres/Farms"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Aikaula"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(560) "Come and build your Dream Home in Waialua! This is a rare opportunity to own and build your dream home on a prime, level corner vacant lot located directly across from St. Michael's Church in beautiful Waialua Communtiy. It offers the perfect blend of convenience and island living. Just minutes from Haleiwa Town, Mokuleia Beach, schools, and local eateries, this property is the ideal location to build your custom island home. Don't miss this opportunity! Paradise starts here! It is priced below Assessed Value for a quick sale, but not a Short Sale."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "West Oahu Realty, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5010.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["YearBuilt"]=>
array(1) {
[0]=>
string(0) ""
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(0) ""
}
["ParkingTotal"]=>
array(1) {
[0]=>
NULL
}
["StoriesType"]=>
array(1) {
[0]=>
NULL
}
["View"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["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) "WORI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(19) "isabelphu@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 223-2888"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Isabel Rivera Phu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18884260"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-23T01:10:14.940"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-07-20"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "01:10:14.940"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27079696"
}
["listing_image"]=>
array(7) {
[0]=>
string(8) "27079696"
[1]=>
string(8) "27079697"
[2]=>
string(8) "27079698"
[3]=>
string(8) "27079699"
[4]=>
string(8) "27079700"
[5]=>
string(8) "27079701"
[6]=>
string(8) "27079702"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202516683
)
[StreetNumber] => Array
(
[0] => 67-401
)
[PropertyType] => Array
(
[0] => Lots/Acres/Farms
)
[StreetName] => Array
(
[0] => Aikaula
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 625000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Come and build your Dream Home in Waialua! This is a rare opportunity to own and build your dream home on a prime, level corner vacant lot located directly across from St. Michael's Church in beautiful Waialua Communtiy. It offers the perfect blend of convenience and island living. Just minutes from Haleiwa Town, Mokuleia Beach, schools, and local eateries, this property is the ideal location to build your custom island home. Don't miss this opportunity! Paradise starts here! It is priced below Assessed Value for a quick sale, but not a Short Sale.
)
[ListOfficeName] => Array
(
[0] => West Oahu Realty, Inc.
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 5010.00
)
[SqftTotal] => Array
(
[0] =>
)
[YearBuilt] => Array
(
[0] =>
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] =>
)
[ParkingTotal] => Array
(
[0] =>
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => WORI
)
[ListAgentEmail] => Array
(
[0] => isabelphu@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 223-2888
)
[ListAgentFullName] => Array
(
[0] => Isabel Rivera Phu
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18884260
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-23T01:10:14.940
)
[ListingContractDate] => Array
(
[0] => 2025-07-20
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 01:10:14.940
)
[_thumbnail_id] => Array
(
[0] => 27079696
)
[listing_image] => Array
(
[0] => 27079696
[1] => 27079697
[2] => 27079698
[3] => 27079699
[4] => 27079700
[5] => 27079701
[6] => 27079702
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 23, 2025 - 1:10 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.
