Previous Next

68-121 Au Street Unit 403 Waialua, HI 96791

Listing
Overview

Price: $777,000
Area: WAIALUA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202511291"
  }
  ["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) "403"
  }
  ["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) "777000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(691) "LOAN IS ASSUMABLE 3.25% approx.$318k balance. Breathtaking views from this ocean front property on the North Shore with private beach access. Sunset Shores provides a pool, jacuzzi, and BBQ area directly on the beachfront. This unit has a great floor plan allowing for an option to open the front bedroom to an extended living room having wall-to-wall oceanfront views. A nice open kitchen with counter seating. Full size W/D in the unit with a bar nook area. Both bedrooms are spacious with generous sized closets. The front bedroom is equipped with a murphy bed to maximize options. The unit is in great condition and shows pride in ownership. Close to Haleiwa, Schofield and Wheeler base."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "SC Realty, LLC"
  }
  ["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(8) "22346.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "860"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1982"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(13) "Sunset Shores"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "4-7"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(22) "Coastline,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1175.81"
  }
  ["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) "SCRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "solanagrover@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 358-0502"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Solana S Grover"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18726642"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-12T09:02:18.177"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-02"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Ocean"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:02:18.177"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26982501"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "26982501"
    [1]=>
    string(8) "26982502"
    [2]=>
    string(8) "26982503"
    [3]=>
    string(8) "26982504"
    [4]=>
    string(8) "26982505"
    [5]=>
    string(8) "26982506"
    [6]=>
    string(8) "26982507"
    [7]=>
    string(8) "26982508"
    [8]=>
    string(8) "26982509"
    [9]=>
    string(8) "26982510"
    [10]=>
    string(8) "26982511"
    [11]=>
    string(8) "26982512"
    [12]=>
    string(8) "26982513"
    [13]=>
    string(8) "26982514"
    [14]=>
    string(8) "26982515"
    [15]=>
    string(8) "26982516"
    [16]=>
    string(8) "26982517"
    [17]=>
    string(8) "26993213"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202511291
        )

    [StreetNumber] => Array
        (
            [0] => 68-121
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Au
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 403
        )

    [City] => Array
        (
            [0] => Waialua
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96791
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 777000.00
        )

    [Neighbourhood] => Array
        (
            [0] => WAIALUA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => LOAN IS ASSUMABLE 3.25% approx.$318k balance. Breathtaking views from this ocean front property on the North Shore with private beach access. Sunset Shores provides a pool, jacuzzi, and BBQ area directly on the beachfront. This unit has a great floor plan allowing for an option to open the front bedroom to an extended living room having wall-to-wall oceanfront views. A nice open kitchen with counter seating. Full size W/D in the unit with a bar nook area. Both bedrooms are spacious with generous sized closets. The front bedroom is equipped with a murphy bed to maximize options. The unit is in great condition and shows pride in ownership. Close to Haleiwa, Schofield and Wheeler base.
        )

    [ListOfficeName] => Array
        (
            [0] => SC Realty, LLC
        )

    [BedsTotal] => Array
        (
            [0] => 2
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 22346.00
        )

    [SqftTotal] => Array
        (
            [0] => 860
        )

    [YearBuilt] => Array
        (
            [0] => 1982
        )

    [BuildingName] => Array
        (
            [0] => Sunset Shores
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 2
        )

    [StoriesType] => Array
        (
            [0] => 4-7
        )

    [View] => Array
        (
            [0] => Coastline,Ocean,Sunset
        )

    [MaintenanceExpense] => Array
        (
            [0] => 1175.81
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => SCRE
        )

    [ListAgentEmail] => Array
        (
            [0] => solanagrover@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 358-0502
        )

    [ListAgentFullName] => Array
        (
            [0] => Solana S Grover
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18726642
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-12T09:02:18.177
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-02
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

    [PropertyFrontage] => Array
        (
            [0] => Ocean
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 09:02:18.177
        )

    [_thumbnail_id] => Array
        (
            [0] => 26982501
        )

    [listing_image] => Array
        (
            [0] => 26982501
            [1] => 26982502
            [2] => 26982503
            [3] => 26982504
            [4] => 26982505
            [5] => 26982506
            [6] => 26982507
            [7] => 26982508
            [8] => 26982509
            [9] => 26982510
            [10] => 26982511
            [11] => 26982512
            [12] => 26982513
            [13] => 26982514
            [14] => 26982515
            [15] => 26982516
            [16] => 26982517
            [17] => 26993213
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Land Area (sf): 22,346 sf
• Living (sf): 860
• Year Built: 1982
• Building Name: Sunset Shores

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Coastline,Ocean,Sunset
• Listing Office: SC Realty, LLC

FINANCIAL INFO

• Maintenance Fees: $1,176
• Land Tenure: FS - Fee Simple

SCHOOLS

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on May 12, 2025 - 9:02 AM 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.