Listing
Overview
Price: $585,000
Area: WAIALUA
Status: Active Under Contract
HUGE PRICE REDUCTION! This is the one a rarely available top floor 2 bedroom condo with private covered patio to enjoy every sunrise, sunset, and rainbow. In the winter, from that same patio, view the legendary North Shore waves. Enjoy a homecooked meal in your newly remodeled kitchen, your ingredients will be fresh from the local farmers market, 5 min away. After a hike at the Ka'ena Point nature preserve, 10min away, with Albatross and Monk Seals, a day at the beach, or just a hard day in the office, you can rejuvenate in a private sauna or just take your favorite cocktail poolside. Yes the building has a well maintained pool so if you can't get to the beach that day you can grab a quick dip in the pool that is just downstairs. This newly remodeled unit will help make sure that you have time for enjoying Hawaii by making sure the housework is a breeze with smooth refinished walls. The washer and dryer are brand new, along with the dishwasher. You can maximize the fun and minimize the hassle with this rare find. Sellers are motivated make your offer today before this opportunity disappears. Listing by: Keller Williams Honolulu (808) 596-2888
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202419150"
}
["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(4) "W512"
}
["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(102) "https://www.hommati.com/3DTour-AerialVideo/68-24-Apuhihi-Street-W512-Waialua-Hi--HPI40623871/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "585000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "585000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1110) "HUGE PRICE REDUCTION! This is the one a rarely available top floor 2 bedroom condo with private covered patio to enjoy every sunrise, sunset, and rainbow. In the winter, from that same patio, view the legendary North Shore waves. Enjoy a homecooked meal in your newly remodeled kitchen, your ingredients will be fresh from the local farmers market, 5 min away. After a hike at the Ka'ena Point nature preserve, 10min away, with Albatross and Monk Seals, a day at the beach, or just a hard day in the office, you can rejuvenate in a private sauna or just take your favorite cocktail poolside. Yes the building has a well maintained pool so if you can't get to the beach that day you can grab a quick dip in the pool that is just downstairs. This newly remodeled unit will help make sure that you have time for enjoying Hawaii by making sure the housework is a breeze with smooth refinished walls. The washer and dryer are brand new, along with the dishwasher. You can maximize the fun and minimize the hassle with this rare find. Sellers are motivated make your offer today before this opportunity disappears."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["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) "848"
}
["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) "Two"
}
["View"]=>
array(1) {
[0]=>
string(21) "Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "966.48"
}
["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) "KWPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "clennon@hawaii.edu"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 596-2888"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(20) "Christopher S Lennon"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-07T16:00:44.873"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18226428"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-30T23:27:23.560"
}
["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) "26677407"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26677407"
[1]=>
string(8) "26677408"
[2]=>
string(8) "26677409"
[3]=>
string(8) "26677410"
[4]=>
string(8) "26677411"
[5]=>
string(8) "26677412"
[6]=>
string(8) "26677413"
[7]=>
string(8) "26677414"
[8]=>
string(8) "26677415"
[9]=>
string(8) "26677416"
[10]=>
string(8) "26677417"
[11]=>
string(8) "26677418"
[12]=>
string(8) "26677419"
[13]=>
string(8) "26677420"
[14]=>
string(8) "26677421"
[15]=>
string(8) "26677422"
[16]=>
string(8) "26677423"
[17]=>
string(8) "26677424"
[18]=>
string(8) "26677425"
[19]=>
string(8) "26677426"
[20]=>
string(8) "26677427"
[21]=>
string(8) "26677428"
[22]=>
string(8) "26677429"
[23]=>
string(8) "26677430"
[24]=>
string(8) "26677431"
[25]=>
string(8) "26677432"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202419150
)
[StreetNumber] => Array
(
[0] => 68-24
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Apuhihi
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => W512
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.hommati.com/3DTour-AerialVideo/68-24-Apuhihi-Street-W512-Waialua-Hi--HPI40623871/unbranded
)
[ListPrice] => Array
(
[0] => 585000.00
)
[CurrentPrice] => Array
(
[0] => 585000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => HUGE PRICE REDUCTION! This is the one a rarely available top floor 2 bedroom condo with private covered patio to enjoy every sunrise, sunset, and rainbow. In the winter, from that same patio, view the legendary North Shore waves. Enjoy a homecooked meal in your newly remodeled kitchen, your ingredients will be fresh from the local farmers market, 5 min away. After a hike at the Ka'ena Point nature preserve, 10min away, with Albatross and Monk Seals, a day at the beach, or just a hard day in the office, you can rejuvenate in a private sauna or just take your favorite cocktail poolside. Yes the building has a well maintained pool so if you can't get to the beach that day you can grab a quick dip in the pool that is just downstairs. This newly remodeled unit will help make sure that you have time for enjoying Hawaii by making sure the housework is a breeze with smooth refinished walls. The washer and dryer are brand new, along with the dishwasher. You can maximize the fun and minimize the hassle with this rare find. Sellers are motivated make your offer today before this opportunity disappears.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 51662.00
)
[SqftTotal] => Array
(
[0] => 848
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] => Ono Vista
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 966.48
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP
)
[ListAgentEmail] => Array
(
[0] => clennon@hawaii.edu
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 596-2888
)
[ListAgentFullName] => Array
(
[0] => Christopher S Lennon
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-07T16:00:44.873
)
[Matrix_Unique_ID] => Array
(
[0] => 18226428
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-30T23:27:23.560
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26677407
)
[listing_image] => Array
(
[0] => 26677407
[1] => 26677408
[2] => 26677409
[3] => 26677410
[4] => 26677411
[5] => 26677412
[6] => 26677413
[7] => 26677414
[8] => 26677415
[9] => 26677416
[10] => 26677417
[11] => 26677418
[12] => 26677419
[13] => 26677420
[14] => 26677421
[15] => 26677422
[16] => 26677423
[17] => 26677424
[18] => 26677425
[19] => 26677426
[20] => 26677427
[21] => 26677428
[22] => 26677429
[23] => 26677430
[24] => 26677431
[25] => 26677432
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 51,662
- Living (sf): 848
- Year Built: 1975
- Building Name: Ono Vista
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Mountain,Ocean,Sunset
- Listing Office: Keller Williams Honolulu
- Maintenance Fees: $966
- Land Tenure: FS - Fee Simple
