Price: $539,999 Area: WAIALUA Status: Active Under Contract
Assumable VA loan at 2.75% for Veterans with remaining entitlement. Loan balance approximately $270,000 & monthly payment $1,389.73.
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 property. 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. 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 beach park with swings, basketball court, playground, bathrooms, showers, picnic tables. Snorkel with fish and Hawaiian green sea turtles in the Summer and surf Pyramids surf break watching whales in the winter. Listing by: Seaside Realty LLC (808) 723-0953
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) "539999.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "Assumable VA loan at 2.75% for Veterans with remaining entitlement. Loan balance approximately $270,000 & monthly payment $1,389.73.
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 property. 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. 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 beach park with swings, basketball court, playground, bathrooms, showers, picnic tables. Snorkel with fish and Hawaiian green sea turtles in the Summer and surf Pyramids surf break watching whales in the winter."
}
["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) 723-0953"
}
["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) "2026-05-17T11:19:15.400"
}
["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) "11:19:15.400"
}
["_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] => 539999.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Assumable VA loan at 2.75% for Veterans with remaining entitlement. Loan balance approximately $270,000 & monthly payment $1,389.73.
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 property. 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. 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 beach park with swings, basketball court, playground, bathrooms, showers, picnic tables. Snorkel with fish and Hawaiian green sea turtles in the Summer and surf Pyramids surf break watching whales in the winter.
)
[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) 723-0953
)
[ListAgentFullName] => Array
(
[0] => Erica J Lehmkuhl
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19054046
)
[MatrixModifiedDT] => Array
(
[0] => 2026-05-17T11:19:15.400
)
[ListingContractDate] => Array
(
[0] => 2025-10-23
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:19:15.400
)
[_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 May 17, 2026 - 11:19 AM
Information is deemed reliable but not guaranteed.
Copyright: 2026 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.
