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
One block from the beach on North Shore, peek a boo ocean view, swimming pool & sauna, cool tile floors, in-unit laundry, large closets, updated kitchen/bathroom, lanai & trade winds. LARGE DOG FRIENDLY/pet friendly community. This fresh, townhouse style unit has a special design in which the bedrooms are under your own living area! No one to disturb you at night walking above. Enter on the third floor which is your living/dining/lanai area and the stairs to your left take you down to your bedrooms, bathroom and laundry area. No walkways in front of your bedrooms. Some of the best privacy you can get in a condo on the North Shore. The resident manager is always working to ensure residents have the cleanest and safest complex in the area. Secured salt water swimming pool and sauna area with bathrooms and shaded seating.
Located in the Aweoweo beach neighborhood featuring a fabulous beach park with swings, basketball court, playground, bathrooms, showers, picnic tables and year round ocean activities. Snorkel with fish and Hawaiian green sea turtles in the Summer and surf Pyramids surf break in the winter. Sit on the beach and watch whales jumping just outside the protective reef. Listing by: Seaside Realty LLC (808) 271-4142
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202523868"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(5) "68-24"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Apuhihi"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "303"
}
["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(100) "https://www.hommati.com/3DTour-AerialVideo/unbranded/68-090-Au-St-303W-Waialua-Hi-96791--HPI63799824"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "549999.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1198) "One block from the beach on North Shore, peek a boo ocean view, swimming pool & sauna, cool tile floors, in-unit laundry, large closets, updated kitchen/bathroom, lanai & trade winds. LARGE DOG FRIENDLY/pet friendly community. This fresh, townhouse style unit has a special design in which the bedrooms are under your own living area! No one to disturb you at night walking above. Enter on the third floor which is your living/dining/lanai area and the stairs to your left take you down to your bedrooms, bathroom and laundry area. No walkways in front of your bedrooms. Some of the best privacy you can get in a condo on the North Shore. The resident manager is always working to ensure residents have the cleanest and safest complex in the area. Secured salt water swimming pool and sauna area with bathrooms and shaded seating.
Located in the Aweoweo beach neighborhood featuring a fabulous beach park with swings, basketball court, playground, bathrooms, showers, picnic tables and year round ocean activities. Snorkel with fish and Hawaiian green sea turtles in the Summer and surf Pyramids surf break in the winter. Sit on the beach and watch whales jumping just outside the protective reef."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Seaside Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "51662.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "864"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(9) "Ono Vista"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "4-7"
}
["View"]=>
array(1) {
[0]=>
string(12) "Garden,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1250.00"
}
["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) "SSRE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "ericainhawaii@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 271-4142"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Erica J Lehmkuhl"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19054046"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-10-26T17:00:02.000"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-10-23"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:02.000"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27197521"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27197521"
[1]=>
string(8) "27197522"
[2]=>
string(8) "27197523"
[3]=>
string(8) "27197524"
[4]=>
string(8) "27197525"
[5]=>
string(8) "27197526"
[6]=>
string(8) "27197527"
[7]=>
string(8) "27197528"
[8]=>
string(8) "27197529"
[9]=>
string(8) "27197530"
[10]=>
string(8) "27197531"
[11]=>
string(8) "27197532"
[12]=>
string(8) "27197533"
[13]=>
string(8) "27197534"
[14]=>
string(8) "27197535"
[15]=>
string(8) "27197536"
[16]=>
string(8) "27197537"
[17]=>
string(8) "27197538"
[18]=>
string(8) "27197539"
[19]=>
string(8) "27197540"
[20]=>
string(8) "27197541"
[21]=>
string(8) "27197542"
[22]=>
string(8) "27197543"
[23]=>
string(8) "27197544"
[24]=>
string(8) "27197545"
[25]=>
string(8) "27197546"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202523868
)
[StreetNumber] => Array
(
[0] => 68-24
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Apuhihi
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 303
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.hommati.com/3DTour-AerialVideo/unbranded/68-090-Au-St-303W-Waialua-Hi-96791--HPI63799824
)
[ListPrice] => Array
(
[0] => 549999.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => One block from the beach on North Shore, peek a boo ocean view, swimming pool & sauna, cool tile floors, in-unit laundry, large closets, updated kitchen/bathroom, lanai & trade winds. LARGE DOG FRIENDLY/pet friendly community. This fresh, townhouse style unit has a special design in which the bedrooms are under your own living area! No one to disturb you at night walking above. Enter on the third floor which is your living/dining/lanai area and the stairs to your left take you down to your bedrooms, bathroom and laundry area. No walkways in front of your bedrooms. Some of the best privacy you can get in a condo on the North Shore. The resident manager is always working to ensure residents have the cleanest and safest complex in the area. Secured salt water swimming pool and sauna area with bathrooms and shaded seating.
Located in the Aweoweo beach neighborhood featuring a fabulous beach park with swings, basketball court, playground, bathrooms, showers, picnic tables and year round ocean activities. Snorkel with fish and Hawaiian green sea turtles in the Summer and surf Pyramids surf break in the winter. Sit on the beach and watch whales jumping just outside the protective reef.
)
[ListOfficeName] => Array
(
[0] => Seaside Realty LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 51662.00
)
[SqftTotal] => Array
(
[0] => 864
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Ono Vista
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => Garden,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 1250.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => SSRE
)
[ListAgentEmail] => Array
(
[0] => ericainhawaii@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 271-4142
)
[ListAgentFullName] => Array
(
[0] => Erica J Lehmkuhl
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19054046
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-26T17:00:02.000
)
[ListingContractDate] => Array
(
[0] => 2025-10-23
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:02.000
)
[_thumbnail_id] => Array
(
[0] => 27197521
)
[listing_image] => Array
(
[0] => 27197521
[1] => 27197522
[2] => 27197523
[3] => 27197524
[4] => 27197525
[5] => 27197526
[6] => 27197527
[7] => 27197528
[8] => 27197529
[9] => 27197530
[10] => 27197531
[11] => 27197532
[12] => 27197533
[13] => 27197534
[14] => 27197535
[15] => 27197536
[16] => 27197537
[17] => 27197538
[18] => 27197539
[19] => 27197540
[20] => 27197541
[21] => 27197542
[22] => 27197543
[23] => 27197544
[24] => 27197545
[25] => 27197546
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 26, 2025 - 5:00 PM
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.
