68-024 Apuhihi Street Unit W301 Waialua, HI 96791
Listing
Overview
Price: $560,000
Area: WAIALUA
Status: Active
Don’t miss this rare opportunity to own the corner unit at Ono Vista that is closest in the complex to the beach access and offers increased privacy as well as a more open, extremely breezy, and bright feel due to the location and the bonus of additional windows upstairs and downstairs in the end unit. The upgraded kitchen and living area include quartz countertops, stainless appliances, and new tile floors extending onto the lanai, where you will relax and watch countless amazing sunsets and appreciate the unique glass enclosure of this unit. Upgrades downstairs include a new bath vanity and fixtures, a tiled floor throughout, and brand-new floor-to-ceiling mirrored closet doors in both bedrooms. Ono Vista is a highly desirable community with a saltwater pool, sauna, on-site manager, and nearby beach access to a beautiful beach great for swimming and long beach walks. This unit has a relaxed feeling that can’t be beaten and is an invaluable opportunity for one looking to enjoy the best of this fantastic community. The unit was owner-occupied until Jan.1 but is currently tenant-occupied and showing by appointment. Listing by: OahuRE.com (808) 425-7887
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202406376"
}
["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) "W301"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "560000.00"
}
["CurrentPrice"]=>
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(1135) "Don’t miss this rare opportunity to own the corner unit at Ono Vista that is closest in the complex to the beach access and offers increased privacy as well as a more open, extremely breezy, and bright feel due to the location and the bonus of additional windows upstairs and downstairs in the end unit. The upgraded kitchen and living area include quartz countertops, stainless appliances, and new tile floors extending onto the lanai, where you will relax and watch countless amazing sunsets and appreciate the unique glass enclosure of this unit. Upgrades downstairs include a new bath vanity and fixtures, a tiled floor throughout, and brand-new floor-to-ceiling mirrored closet doors in both bedrooms. Ono Vista is a highly desirable community with a saltwater pool, sauna, on-site manager, and nearby beach access to a beautiful beach great for swimming and long beach walks. This unit has a relaxed feeling that can’t be beaten and is an invaluable opportunity for one looking to enjoy the best of this fantastic community. The unit was owner-occupied until Jan.1 but is currently tenant-occupied and showing by appointment."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "OahuRE.com"
}
["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) "952"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(9) "ONO VISTA"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "4-7"
}
["View"]=>
array(1) {
[0]=>
string(15) "Mountain,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "966.48"
}
["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) "GIVE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "bryn@oahure.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 425-7887"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Bryn W Kaufman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-29T22:28:18.840"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17887482"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-03-15T13:40:21.137"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26131052"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26131052"
[1]=>
string(8) "26131053"
[2]=>
string(8) "26131054"
[3]=>
string(8) "26131055"
[4]=>
string(8) "26131056"
[5]=>
string(8) "26131057"
[6]=>
string(8) "26131058"
[7]=>
string(8) "26131059"
[8]=>
string(8) "26131060"
[9]=>
string(8) "26131061"
[10]=>
string(8) "26131062"
[11]=>
string(8) "26131063"
[12]=>
string(8) "26131064"
[13]=>
string(8) "26131065"
[14]=>
string(8) "26131066"
[15]=>
string(8) "26131067"
[16]=>
string(8) "26131068"
[17]=>
string(8) "26131069"
[18]=>
string(8) "26131070"
[19]=>
string(8) "26131071"
[20]=>
string(8) "26131072"
[21]=>
string(8) "26131073"
[22]=>
string(8) "26131074"
[23]=>
string(8) "26131075"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "22:28:18.840"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-03-15"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202406376
)
[StreetNumber] => Array
(
[0] => 68-024
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Apuhihi
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => W301
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 560000.00
)
[CurrentPrice] => Array
(
[0] => 560000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Don’t miss this rare opportunity to own the corner unit at Ono Vista that is closest in the complex to the beach access and offers increased privacy as well as a more open, extremely breezy, and bright feel due to the location and the bonus of additional windows upstairs and downstairs in the end unit. The upgraded kitchen and living area include quartz countertops, stainless appliances, and new tile floors extending onto the lanai, where you will relax and watch countless amazing sunsets and appreciate the unique glass enclosure of this unit. Upgrades downstairs include a new bath vanity and fixtures, a tiled floor throughout, and brand-new floor-to-ceiling mirrored closet doors in both bedrooms. Ono Vista is a highly desirable community with a saltwater pool, sauna, on-site manager, and nearby beach access to a beautiful beach great for swimming and long beach walks. This unit has a relaxed feeling that can’t be beaten and is an invaluable opportunity for one looking to enjoy the best of this fantastic community. The unit was owner-occupied until Jan.1 but is currently tenant-occupied and showing by appointment.
)
[ListOfficeName] => Array
(
[0] => OahuRE.com
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 952
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => ONO VISTA
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => Mountain,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 966.48
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => GIVE
)
[ListAgentEmail] => Array
(
[0] => bryn@oahure.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 425-7887
)
[ListAgentFullName] => Array
(
[0] => Bryn W Kaufman
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-29T22:28:18.840
)
[Matrix_Unique_ID] => Array
(
[0] => 17887482
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-03-15T13:40:21.137
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26131052
)
[listing_image] => Array
(
[0] => 26131052
[1] => 26131053
[2] => 26131054
[3] => 26131055
[4] => 26131056
[5] => 26131057
[6] => 26131058
[7] => 26131059
[8] => 26131060
[9] => 26131061
[10] => 26131062
[11] => 26131063
[12] => 26131064
[13] => 26131065
[14] => 26131066
[15] => 26131067
[16] => 26131068
[17] => 26131069
[18] => 26131070
[19] => 26131071
[20] => 26131072
[21] => 26131073
[22] => 26131074
[23] => 26131075
)
[MatrixModifiedTime] => Array
(
[0] => 22:28:18.840
)
[ListingContractDate] => Array
(
[0] => 2024-03-15
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 952
- Year Built: 1975
- Building Name: ONO VISTA
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Mountain,Sunset
- Listing Office: OahuRE.com
- Maintenance Fees: $966
- Land Tenure: FS - Fee Simple
- Elementary School: Waialua
- Middle School: Waialua
- High School: Waialua