Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
68-121 AU Street Unit 302 Waialua, HI 96791
Listing Overview
Price: $889,000 Area: WAIALUA Status: Active
BEACH FRONT Waialua Gem, 2/2/1 covered parking stall near bus line, Aweoweo beach park, and community jogging and walking path. Short drive to The Waialua Shopping Center, skydiving, Kaena Point, and Historic Haleiwa town with beautiful shops, delicious restaurants, food trucks, health care, food market, and drug store. The Ritz-Carlton Oahu Turtle Bay golfing, spa, hiking and most famous surf spots along The 7-mile miracle make the North Shore highly desirable. This condo was fully renovated in 2023, and is completely furnished, so you can move right in, or great rental opportunity. Seller is also offering credits towards non recurring closing costs and / or towards interest rate buydowns. Listing by: MOKULANI Properties, inc (808) 282-2583
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421609"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "68-121"
}
["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(3) "302"
}
["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) "889000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "889000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(703) "BEACH FRONT Waialua Gem, 2/2/1 covered parking stall near bus line, Aweoweo beach park, and community jogging and walking path. Short drive to The Waialua Shopping Center, skydiving, Kaena Point, and Historic Haleiwa town with beautiful shops, delicious restaurants, food trucks, health care, food market, and drug store. The Ritz-Carlton Oahu Turtle Bay golfing, spa, hiking and most famous surf spots along The 7-mile miracle make the North Shore highly desirable. This condo was fully renovated in 2023, and is completely furnished, so you can move right in, or great rental opportunity. Seller is also offering credits towards non recurring closing costs and / or towards interest rate buydowns."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "MOKULANI Properties, inc"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "860"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1984"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Sunset Shores"
}
["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(46) "Coastline,Garden,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1049.83"
}
["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) "BRUN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(32) "ma2822583@MOKULANIproperties.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 282-2583"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Mary Anne Bruno"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-03T16:28:48.273"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18277790"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-06T22:26:58.907"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26720960"
}
["listing_image"]=>
array(14) {
[0]=>
string(8) "26720960"
[1]=>
string(8) "26720961"
[2]=>
string(8) "26720962"
[3]=>
string(8) "26720963"
[4]=>
string(8) "26720964"
[5]=>
string(8) "26720965"
[6]=>
string(8) "26720966"
[7]=>
string(8) "26720967"
[8]=>
string(8) "26720968"
[9]=>
string(8) "26720969"
[10]=>
string(8) "26720970"
[11]=>
string(8) "26720971"
[12]=>
string(8) "26720972"
[13]=>
string(8) "26720973"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421609
)
[StreetNumber] => Array
(
[0] => 68-121
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => AU
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 302
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 889000.00
)
[CurrentPrice] => Array
(
[0] => 889000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => BEACH FRONT Waialua Gem, 2/2/1 covered parking stall near bus line, Aweoweo beach park, and community jogging and walking path. Short drive to The Waialua Shopping Center, skydiving, Kaena Point, and Historic Haleiwa town with beautiful shops, delicious restaurants, food trucks, health care, food market, and drug store. The Ritz-Carlton Oahu Turtle Bay golfing, spa, hiking and most famous surf spots along The 7-mile miracle make the North Shore highly desirable. This condo was fully renovated in 2023, and is completely furnished, so you can move right in, or great rental opportunity. Seller is also offering credits towards non recurring closing costs and / or towards interest rate buydowns.
)
[ListOfficeName] => Array
(
[0] => MOKULANI Properties, inc
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 860
)
[YearBuilt] => Array
(
[0] => 1984
)
[BuildingName] => Array
(
[0] => Sunset Shores
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1049.83
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => BRUN
)
[ListAgentEmail] => Array
(
[0] => ma2822583@MOKULANIproperties.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 282-2583
)
[ListAgentFullName] => Array
(
[0] => Mary Anne Bruno
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-03T16:28:48.273
)
[Matrix_Unique_ID] => Array
(
[0] => 18277790
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-06T22:26:58.907
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26720960
)
[listing_image] => Array
(
[0] => 26720960
[1] => 26720961
[2] => 26720962
[3] => 26720963
[4] => 26720964
[5] => 26720965
[6] => 26720966
[7] => 26720967
[8] => 26720968
[9] => 26720969
[10] => 26720970
[11] => 26720971
[12] => 26720972
[13] => 26720973
)
)
