Listing
Overview
Price: $539,999
Area: WAIALUA
Status: Active
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(6) "Active"
}
["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-02-25T17:05:05.960"
}
["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:05:05.960"
}
["_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
)
[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-02-25T17:05:05.960
)
[ListingContractDate] => Array
(
[0] => 2025-10-23
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:05:05.960
)
[_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
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 51,662 sf
- Living (sf): 864
- Year Built: 1975
- Building Name: Ono Vista
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: Garden,Ocean
- Listing Office: Seaside Realty LLC
- Maintenance Fees: $1,250
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on February 25, 2026 - 5:05 PM
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.
© Marcus Realty. All Rights Reserved.
