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
Experience coastal living in this beautifully updated 2-bedroom, 1-bath condominium in the Ono Vista community of Waialua. This move-in ready home features thoughtful upgrades throughout, including sleek quartz countertops, fresh interior paint, recessed lighting, and durable vinyl flooring that enhances both style and function. A screened-in lanai extends the living area, creating a versatile space for relaxing, dining, or enjoying the tradewinds. The primary bedroom offers a custom closet designed for efficient storage, and the unit captures pleasant mount Ka'ala views. Ono Vista is a well-maintained community with a swimming pool and convenient access to nearby beaches. This updated condo presents an excellent opportunity for those seeking a clean, modern space in a highly desired North Shore setting. Listing by: REMAX Hawaii North Shore (808) 741-3835
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202526132"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-024"
}
["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(4) "W503"
}
["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(59) "https://listings.hetproductions.com/sites/rnxwgzk/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "560000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(815) "Experience coastal living in this beautifully updated 2-bedroom, 1-bath condominium in the Ono Vista community of Waialua. This move-in ready home features thoughtful upgrades throughout, including sleek quartz countertops, fresh interior paint, recessed lighting, and durable vinyl flooring that enhances both style and function. A screened-in lanai extends the living area, creating a versatile space for relaxing, dining, or enjoying the tradewinds. The primary bedroom offers a custom closet designed for efficient storage, and the unit captures pleasant mount Ka'ala views. Ono Vista is a well-maintained community with a swimming pool and convenient access to nearby beaches. This updated condo presents an excellent opportunity for those seeking a clean, modern space in a highly desired North Shore setting."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "REMAX Hawaii North Shore"
}
["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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "788"
}
["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) "One"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1134.05"
}
["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) "ADNS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "Meme.Moody@remaxhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 741-3835"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Meme Moody"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19138129"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-01T14:10:58.133"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-12-01"
}
["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) "14:10:58.133"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27234315"
}
["listing_image"]=>
array(17) {
[0]=>
string(8) "27234315"
[1]=>
string(8) "27234316"
[2]=>
string(8) "27234317"
[3]=>
string(8) "27234318"
[4]=>
string(8) "27234319"
[5]=>
string(8) "27234320"
[6]=>
string(8) "27234321"
[7]=>
string(8) "27234322"
[8]=>
string(8) "27234323"
[9]=>
string(8) "27234324"
[10]=>
string(8) "27234325"
[11]=>
string(8) "27234326"
[12]=>
string(8) "27234327"
[13]=>
string(8) "27234328"
[14]=>
string(8) "27234329"
[15]=>
string(8) "27234330"
[16]=>
string(8) "27234331"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202526132
)
[StreetNumber] => Array
(
[0] => 68-024
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Apuhihi
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => W503
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/rnxwgzk/unbranded
)
[ListPrice] => Array
(
[0] => 560000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Experience coastal living in this beautifully updated 2-bedroom, 1-bath condominium in the Ono Vista community of Waialua. This move-in ready home features thoughtful upgrades throughout, including sleek quartz countertops, fresh interior paint, recessed lighting, and durable vinyl flooring that enhances both style and function. A screened-in lanai extends the living area, creating a versatile space for relaxing, dining, or enjoying the tradewinds. The primary bedroom offers a custom closet designed for efficient storage, and the unit captures pleasant mount Ka'ala views. Ono Vista is a well-maintained community with a swimming pool and convenient access to nearby beaches. This updated condo presents an excellent opportunity for those seeking a clean, modern space in a highly desired North Shore setting.
)
[ListOfficeName] => Array
(
[0] => REMAX Hawaii North Shore
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 788
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Ono Vista
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 1134.05
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADNS
)
[ListAgentEmail] => Array
(
[0] => Meme.Moody@remaxhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 741-3835
)
[ListAgentFullName] => Array
(
[0] => Meme Moody
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19138129
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-01T14:10:58.133
)
[ListingContractDate] => Array
(
[0] => 2025-12-01
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 14:10:58.133
)
[_thumbnail_id] => Array
(
[0] => 27234315
)
[listing_image] => Array
(
[0] => 27234315
[1] => 27234316
[2] => 27234317
[3] => 27234318
[4] => 27234319
[5] => 27234320
[6] => 27234321
[7] => 27234322
[8] => 27234323
[9] => 27234324
[10] => 27234325
[11] => 27234326
[12] => 27234327
[13] => 27234328
[14] => 27234329
[15] => 27234330
[16] => 27234331
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 1, 2025 - 2:10 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.
