68-090 Au Street Unit E312 Waialua, HI 96791
Listing
Overview
Price: $249,000
Area: WAIALUA
Status: Active
Rare bidding opportunity in Waialua! Property offered through USAHomeBids. List price is opening bid price on USA Home Bids. Rare 2-Bedroom, 1-Bath Corner Unit with Peek-a-Boo Ocean Views. Located just steps from the beach. Amenities include a saltwater pool and sauna, this is luxury ocean living without breaking the bank. This unit offers both privacy and comfort in one of the North Shore's best-kept secrets. Avoid the North Shore traffic, and just 15 minutes from the H-2, making your commute to town a breeze. This is North Shore living at it's best. Don’t miss your chance to bid on this one-of-a-kind property. DO NOT DISTURB OCCUPANTS. Open Houses will be the only opportunity to see this home. Open house schedule: Saturday 6-14-2025 3PM-6PM and Sunday 6-15-2025 11AM-2PM. Wednesday 6-18-2025 3PM - 6PM, Saturday 6-21-2025 11AM-2PM and Sunday 6-22-2025 3PM-6PM. There will be no private or separate showings. DO NOT DISTURB OCCUPANTS. DO NOT REQUEST SENTRILOCK SHOWING. Images are from previous occupants. Listing by: Redfin Corporation (808) 201-2821
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202511795"
}
["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) "E312"
}
["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) "249000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1019) "Rare bidding opportunity in Waialua! Property offered through USAHomeBids. List price is opening bid price on USA Home Bids. Rare 2-Bedroom, 1-Bath Corner Unit with Peek-a-Boo Ocean Views. Located just steps from the beach. Amenities include a saltwater pool and sauna, this is luxury ocean living without breaking the bank. This unit offers both privacy and comfort in one of the North Shore's best-kept secrets. Avoid the North Shore traffic, and just 15 minutes from the H-2, making your commute to town a breeze. This is North Shore living at it's best. Don’t miss your chance to bid on this one-of-a-kind property. DO NOT DISTURB OCCUPANTS. Open Houses will be the only opportunity to see this home. Open house schedule: Saturday 6-14-2025 3PM-6PM and Sunday 6-15-2025 11AM-2PM. Wednesday 6-18-2025 3PM - 6PM, Saturday 6-21-2025 11AM-2PM and Sunday 6-22-2025 3PM-6PM. There will be no private or separate showings. DO NOT DISTURB OCCUPANTS. DO NOT REQUEST SENTRILOCK SHOWING. Images are from previous occupants."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["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) "864"
}
["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(14) "Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1102.56"
}
["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) "RFIN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "sloane.kini@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 201-2821"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Sloane Kini"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18740072"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-06-22T17:30:01.213"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-05-12"
}
["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) "17:30:01.213"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26993954"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26993954"
[1]=>
string(8) "26993955"
[2]=>
string(8) "26993956"
[3]=>
string(8) "26993957"
[4]=>
string(8) "26993958"
[5]=>
string(8) "26993959"
[6]=>
string(8) "26993960"
[7]=>
string(8) "26993961"
[8]=>
string(8) "26993962"
[9]=>
string(8) "26993963"
[10]=>
string(8) "26993964"
[11]=>
string(8) "26993965"
[12]=>
string(8) "26993966"
[13]=>
string(8) "26993967"
[14]=>
string(8) "26993968"
[15]=>
string(8) "26993969"
[16]=>
string(8) "26993970"
[17]=>
string(8) "26993971"
[18]=>
string(8) "26993972"
[19]=>
string(8) "26993973"
[20]=>
string(8) "26993974"
[21]=>
string(8) "26993975"
[22]=>
string(8) "26993976"
[23]=>
string(8) "26993977"
[24]=>
string(8) "26993978"
[25]=>
string(8) "26993979"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202511795
)
[StreetNumber] => Array
(
[0] => 68-090
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Au
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => E312
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 249000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Rare bidding opportunity in Waialua! Property offered through USAHomeBids. List price is opening bid price on USA Home Bids. Rare 2-Bedroom, 1-Bath Corner Unit with Peek-a-Boo Ocean Views. Located just steps from the beach. Amenities include a saltwater pool and sauna, this is luxury ocean living without breaking the bank. This unit offers both privacy and comfort in one of the North Shore's best-kept secrets. Avoid the North Shore traffic, and just 15 minutes from the H-2, making your commute to town a breeze. This is North Shore living at it's best. Don’t miss your chance to bid on this one-of-a-kind property. DO NOT DISTURB OCCUPANTS. Open Houses will be the only opportunity to see this home. Open house schedule: Saturday 6-14-2025 3PM-6PM and Sunday 6-15-2025 11AM-2PM. Wednesday 6-18-2025 3PM - 6PM, Saturday 6-21-2025 11AM-2PM and Sunday 6-22-2025 3PM-6PM. There will be no private or separate showings. DO NOT DISTURB OCCUPANTS. DO NOT REQUEST SENTRILOCK SHOWING. Images are from previous occupants.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 51662.00
)
[SqftTotal] => Array
(
[0] => 864
)
[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
)
[MaintenanceExpense] => Array
(
[0] => 1102.56
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waialua
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waialua
)
[HighSchool] => Array
(
[0] => Waialua
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => sloane.kini@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 201-2821
)
[ListAgentFullName] => Array
(
[0] => Sloane Kini
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18740072
)
[MatrixModifiedDT] => Array
(
[0] => 2025-06-22T17:30:01.213
)
[ListingContractDate] => Array
(
[0] => 2025-05-12
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:30:01.213
)
[_thumbnail_id] => Array
(
[0] => 26993954
)
[listing_image] => Array
(
[0] => 26993954
[1] => 26993955
[2] => 26993956
[3] => 26993957
[4] => 26993958
[5] => 26993959
[6] => 26993960
[7] => 26993961
[8] => 26993962
[9] => 26993963
[10] => 26993964
[11] => 26993965
[12] => 26993966
[13] => 26993967
[14] => 26993968
[15] => 26993969
[16] => 26993970
[17] => 26993971
[18] => 26993972
[19] => 26993973
[20] => 26993974
[21] => 26993975
[22] => 26993976
[23] => 26993977
[24] => 26993978
[25] => 26993979
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 51,662 sf
- Living (sf): 864
- Year Built: 1975
- Building Name: Ono Vista
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: Mountain,Ocean
- Listing Office: Redfin Corporation
- Maintenance Fees: $1,103
- 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 June 22, 2025 - 5:30 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.
© Marcus Realty. All Rights Reserved.
