Listing
Overview
Price: $460,000
Area: WAIALUA
Status: Active
North Shore living at its best! Two blocks to the beach or relax beside the salt water pool after a detox in the sauna. This GROUND FLOOR unit features a private fenced yard, in-unit washer/dryer, wood countertops, cool tile floors, AC and renovated bathroom with tiled shower. There is also an on-demand water heater to save electricity and closet space. Building is pet friendly with no weight limit! House rules in supplements for review. *School district determined using Hawaii DOE School Finder website. Please verify. Listing by: Seaside Realty LLC (808) 271-4142
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202510998"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-090"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(2) "Au"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "E102"
}
["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(50) "https://hommati.tours/tour/2372562?play=no&mls=yes"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "460000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(524) "North Shore living at its best! Two blocks to the beach or relax beside the salt water pool after a detox in the sauna. This GROUND FLOOR unit features a private fenced yard, in-unit washer/dryer, wood countertops, cool tile floors, AC and renovated bathroom with tiled shower. There is also an on-demand water heater to save electricity and closet space. Building is pet friendly with no weight limit! House rules in supplements for review. *School district determined using Hawaii DOE School Finder website. Please verify."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Seaside Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "796"
}
["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,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "995.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) "18717858"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-05-01T08:45:01.910"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-05-01"
}
["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) "08:45:01.910"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26979814"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26979814"
[1]=>
string(8) "26979815"
[2]=>
string(8) "26979816"
[3]=>
string(8) "26979817"
[4]=>
string(8) "26979818"
[5]=>
string(8) "26979819"
[6]=>
string(8) "26979820"
[7]=>
string(8) "26979821"
[8]=>
string(8) "26979822"
[9]=>
string(8) "26979823"
[10]=>
string(8) "26979824"
[11]=>
string(8) "26979825"
[12]=>
string(8) "26979826"
[13]=>
string(8) "26979827"
[14]=>
string(8) "26979828"
[15]=>
string(8) "26979829"
[16]=>
string(8) "26979830"
[17]=>
string(8) "26979831"
[18]=>
string(8) "26979832"
[19]=>
string(8) "26979833"
[20]=>
string(8) "26979834"
[21]=>
string(8) "26979835"
[22]=>
string(8) "26979836"
[23]=>
string(8) "26979837"
[24]=>
string(8) "26979838"
[25]=>
string(8) "26979839"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202510998
)
[StreetNumber] => Array
(
[0] => 68-090
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Au
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => E102
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://hommati.tours/tour/2372562?play=no&mls=yes
)
[ListPrice] => Array
(
[0] => 460000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => North Shore living at its best! Two blocks to the beach or relax beside the salt water pool after a detox in the sauna. This GROUND FLOOR unit features a private fenced yard, in-unit washer/dryer, wood countertops, cool tile floors, AC and renovated bathroom with tiled shower. There is also an on-demand water heater to save electricity and closet space. Building is pet friendly with no weight limit! House rules in supplements for review. *School district determined using Hawaii DOE School Finder website. Please verify.
)
[ListOfficeName] => Array
(
[0] => Seaside Realty LLC
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 51662.00
)
[SqftTotal] => Array
(
[0] => 796
)
[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,Other
)
[MaintenanceExpense] => Array
(
[0] => 995.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] => 18717858
)
[MatrixModifiedDT] => Array
(
[0] => 2025-05-01T08:45:01.910
)
[ListingContractDate] => Array
(
[0] => 2025-05-01
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:45:01.910
)
[_thumbnail_id] => Array
(
[0] => 26979814
)
[listing_image] => Array
(
[0] => 26979814
[1] => 26979815
[2] => 26979816
[3] => 26979817
[4] => 26979818
[5] => 26979819
[6] => 26979820
[7] => 26979821
[8] => 26979822
[9] => 26979823
[10] => 26979824
[11] => 26979825
[12] => 26979826
[13] => 26979827
[14] => 26979828
[15] => 26979829
[16] => 26979830
[17] => 26979831
[18] => 26979832
[19] => 26979833
[20] => 26979834
[21] => 26979835
[22] => 26979836
[23] => 26979837
[24] => 26979838
[25] => 26979839
)
)
- BedsTotal: 1
- Full Baths: 1
- Land Area (sf): 51,662 sf
- Living (sf): 796
- Year Built: 1975
- Building Name: Ono Vista
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: Garden,Other
- Listing Office: Seaside Realty LLC
- Maintenance Fees: $995
- 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 May 1, 2025 - 8:45 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.
© Marcus Realty. All Rights Reserved.
