Previous Next

68-152 Au Street Unit D Waialua, HI 96791

Listing
Overview

Price: $985,000
Area: WAIALUA
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202612754"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "68-152"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(2) "Au"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "D"
  }
  ["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) "985000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1041) "Experience the North Shore lifestyle in this beautifully designed 2-bedroom, 2.5-bath elevated house, built in 2007 for modern island living. Located just across the street from a sandy beach, this home offers comfort, & functionality in an unbeatable setting. The ground level includes a two-car garage with extra storage. Upstairs, the open kitchen, dining, and living area features a half-bath for guests and flows to a large covered lanai, perfect for entertaining. On the top floor, you’ll find a primary suite with full bath, plus a second spacious bedroom, another full bath, and a laundry area off the hallway.    Only one block away are the playground, basketball court and picnic tables of Aweoweo Beach Park where neighbors gather to play and watch the sunset. Hop on the Waialua multi-use path nearby and bike less than 3 miles to Historic Hale?iwa Town. A great value, this home offers easy access to beaches, recreation, dining, and shopping. It has a new roof (Fall 2023) and did not flood during the recent Kona Low storms."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Team Real Estate, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "2820.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1417"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2007"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "200.00"
  }
  ["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) "TEAM"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "teamremonique@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 554-3168"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Monique Cole"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19553705"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-10T13:19:20.030"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-07-03"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "13:19:20.030"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27454093"
  }
  ["listing_image"]=>
  array(2) {
    [0]=>
    string(8) "27454093"
    [1]=>
    string(8) "27454094"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202612754
        )

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

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience the North Shore lifestyle in this beautifully designed 2-bedroom, 2.5-bath elevated house, built in 2007 for modern island living. Located just across the street from a sandy beach, this home offers comfort, & functionality in an unbeatable setting. The ground level includes a two-car garage with extra storage. Upstairs, the open kitchen, dining, and living area features a half-bath for guests and flows to a large covered lanai, perfect for entertaining. On the top floor, you’ll find a primary suite with full bath, plus a second spacious bedroom, another full bath, and a laundry area off the hallway.    Only one block away are the playground, basketball court and picnic tables of Aweoweo Beach Park where neighbors gather to play and watch the sunset. Hop on the Waialua multi-use path nearby and bike less than 3 miles to Historic Hale?iwa Town. A great value, this home offers easy access to beaches, recreation, dining, and shopping. It has a new roof (Fall 2023) and did not flood during the recent Kona Low storms.
        )

    [ListOfficeName] => Array
        (
            [0] => Team Real Estate, Inc.
        )

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

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

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

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

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

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

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

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

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

    [StoriesType] => Array
        (
            [0] => Two
        )

    [View] => Array
        (
            [0] => Sunset
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 554-3168
        )

    [ListAgentFullName] => Array
        (
            [0] => Monique Cole
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-07-10T13:19:20.030
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-07-03
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 13:19:20.030
        )

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

    [listing_image] => Array
        (
            [0] => 27454093
            [1] => 27454094
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 2
• Half Baths: 1
• Land Area (sf): 2,820 sf
• Living (sf): 1,417
• Year Built: 2007

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 4
• View: Sunset
• Listing Office: Team Real Estate, Inc.

FINANCIAL INFO

• Maintenance Fees: $200
• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Waialua
• Middle School: Waialua
• High School: Waialua

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 July 10, 2026 - 1:19 PM Information is deemed reliable but not guaranteed. Copyright: 2026 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.