68-090 Au Street Unit 312E Waialua, HI 96791

Listing
Overview

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

Rarely Available - 2 Bedroom, 1 Bath Corner Unit in Waialua. Located just steps away from the beautiful shores of Aweoweo Beach, this gorgeous 2 bedroom, 1 bath corner unit in the highly desirable Ono Vista offers an unparalleled opportunity to experience North Shore living at its finest. As you step into the main living area you'll be greeted by a bright and airy living space adorned with new large windows and sliding glass doors, allowing natural light to flood in. You can hear the gentle sound of the waves crashing against the shore from your private and spacious lanai and master bedroom. Sip on your coffee and check out the waves from the Peak-a-boo ocean view from your kitchen window. Owners also have access to their own salt water pool and sauna. Convenience is at your fingertips in this prime location. Located away from the hustle of Haleiwa Town, and the busyness of the North Shore, but less than 10 minutes away, you'll have access to everything you need without having to deal with the traffic. Don't miss this chance to experience North Shore living at an affordable price. Schedule a private showing today and be prepared to fall in love with this beachside beauty! Listing by: Fathom Realty HI LLC

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202314459"
  }
  ["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) "312E"
  }
  ["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) "569000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "569000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1190) "Rarely Available - 2 Bedroom, 1 Bath Corner Unit in Waialua. Located just steps away from the beautiful shores of Aweoweo Beach, this gorgeous 2 bedroom, 1 bath corner unit in the highly desirable Ono Vista offers an unparalleled opportunity to experience North Shore living at its finest. As you step into the main living area you'll be greeted by a bright and airy living space adorned with new large windows and sliding glass doors, allowing natural light to flood in. You can hear the gentle sound of the waves crashing against the shore from your private and spacious lanai and master bedroom. Sip on your coffee and check out the waves from the Peak-a-boo ocean view from your kitchen window. Owners also have access to their own salt water pool and sauna. Convenience is at your fingertips in this prime location. Located away from the hustle of Haleiwa Town, and the busyness of the North Shore, but less than 10 minutes away, you'll have access to everything you need without having to deal with the traffic. Don't miss this chance to experience North Shore living at an affordable price. Schedule a private showing today and be prepared to fall in love with this beachside beauty!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(20) "Fathom Realty HI LLC"
  }
  ["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(6) "930.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) "PAKU"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "sloane@kinirealestateco.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Sloane P Ketcham"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-07-31T08:06:56.500"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17404477"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-06-26T15:10:25.003"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25861039"
  }
  ["listing_image"]=>
  array(16) {
    [0]=>
    string(8) "25861039"
    [1]=>
    string(8) "25861040"
    [2]=>
    string(8) "25861041"
    [3]=>
    string(8) "25861042"
    [4]=>
    string(8) "25861043"
    [5]=>
    string(8) "25861044"
    [6]=>
    string(8) "25861045"
    [7]=>
    string(8) "25861046"
    [8]=>
    string(8) "25861047"
    [9]=>
    string(8) "25861048"
    [10]=>
    string(8) "25861049"
    [11]=>
    string(8) "25861050"
    [12]=>
    string(8) "25861051"
    [13]=>
    string(8) "25861052"
    [14]=>
    string(8) "25861053"
    [15]=>
    string(8) "25861054"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202314459
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => 312E
        )

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

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

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

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

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

    [CurrentPrice] => Array
        (
            [0] => 569000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Rarely Available - 2 Bedroom, 1 Bath Corner Unit in Waialua. Located just steps away from the beautiful shores of Aweoweo Beach, this gorgeous 2 bedroom, 1 bath corner unit in the highly desirable Ono Vista offers an unparalleled opportunity to experience North Shore living at its finest. As you step into the main living area you'll be greeted by a bright and airy living space adorned with new large windows and sliding glass doors, allowing natural light to flood in. You can hear the gentle sound of the waves crashing against the shore from your private and spacious lanai and master bedroom. Sip on your coffee and check out the waves from the Peak-a-boo ocean view from your kitchen window. Owners also have access to their own salt water pool and sauna. Convenience is at your fingertips in this prime location. Located away from the hustle of Haleiwa Town, and the busyness of the North Shore, but less than 10 minutes away, you'll have access to everything you need without having to deal with the traffic. Don't miss this chance to experience North Shore living at an affordable price. Schedule a private showing today and be prepared to fall in love with this beachside beauty!
        )

    [ListOfficeName] => Array
        (
            [0] => Fathom Realty HI LLC
        )

    [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] => 930.00
        )

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => sloane@kinirealestateco.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Sloane P Ketcham
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-07-31T08:06:56.500
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-06-26T15:10:25.003
        )

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

    [listing_image] => Array
        (
            [0] => 25861039
            [1] => 25861040
            [2] => 25861041
            [3] => 25861042
            [4] => 25861043
            [5] => 25861044
            [6] => 25861045
            [7] => 25861046
            [8] => 25861047
            [9] => 25861048
            [10] => 25861049
            [11] => 25861050
            [12] => 25861051
            [13] => 25861052
            [14] => 25861053
            [15] => 25861054
        )

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

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

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Land Area (sf): 51,662
  • Living (sf): 864
  • Year Built: 1975
  • Building Name: Ono Vista

  • Property Condition: Excellent
  • Number of Parking Spaces: 1
  • View: Mountain,Ocean
  • Listing Office: Fathom Realty HI LLC

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

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

CONTACT US

Marcus Realty

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