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

Listing
Overview

Price: $499,500
Area: WAIALUA
Status: Active Under Contract

Rarely Available - Split level home, 2 Bedroom, 1 Bath Unit in Waialua located just steps away from the beautiful shores of Aweoweo Beach. Highly desirable Ono Vista offers an unparalleled opportunity to experience North Shore living at its finest and at a value! Main living area has bright floor-to-ceiling large windows and sliding glass doors allowing natural light to flood in. Hear the gentle sound of the waves crashing against the shore from your private spacious lanai and master bedroom. Building amenities include salt water pool, sauna. Convenience is at your fingertips in this prime location. Located minutes away from the trending food and shopping of Haleiwa Town, but quiet living awaits in this part of Waialua. Experience beach living, country shops at your convenience. Don't miss this chance to enjoy North Shore living at an affordable price. Brand new water heater, new slide-in range. Easy to schedule a private showing and have the luxury to customize your beachside beauty today! Seller has an assumable loan at 2.25% rate...unbeatable deal altogether. Listing by: eXp Realty (808) 725-2794

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202403770"
  }
  ["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) "303E"
  }
  ["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) "499500.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "499500.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1081) "Rarely Available - Split level home, 2 Bedroom, 1 Bath Unit in Waialua located just steps away from the beautiful shores of Aweoweo Beach. Highly desirable Ono Vista offers an unparalleled opportunity to experience North Shore living at its finest and at a value! Main living area has bright floor-to-ceiling large windows and sliding glass doors allowing natural light to flood in. Hear the gentle sound of the waves crashing against the shore from your private spacious lanai and master bedroom. Building amenities include salt water pool, sauna. Convenience is at your fingertips in this prime location. Located minutes away from the trending food and shopping of Haleiwa Town, but quiet living awaits in this part of Waialua.  Experience beach living, country shops at your convenience.  Don't miss this chance to enjoy North Shore living at an affordable price.  Brand new water heater, new slide-in range. Easy to schedule a private showing and have the luxury to customize your beachside beauty today! Seller has an assumable loan at 2.25% rate...unbeatable deal altogether."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(10) "eXp Realty"
  }
  ["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(0) ""
  }
  ["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(12) "Average,Fair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(15) "Two,Split Level"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1079.96"
  }
  ["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) "EXPI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "suzie.mai@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 725-2794"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Suzie T Mai-French"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-23T06:01:44.387"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17835413"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-02-22T13:38:34.493"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26118430"
  }
  ["listing_image"]=>
  array(9) {
    [0]=>
    string(8) "26118430"
    [1]=>
    string(8) "26118431"
    [2]=>
    string(8) "26118432"
    [3]=>
    string(8) "26118433"
    [4]=>
    string(8) "26118434"
    [5]=>
    string(8) "26118435"
    [6]=>
    string(8) "26118436"
    [7]=>
    string(8) "26118437"
    [8]=>
    string(8) "26118438"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202403770
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Rarely Available - Split level home, 2 Bedroom, 1 Bath Unit in Waialua located just steps away from the beautiful shores of Aweoweo Beach. Highly desirable Ono Vista offers an unparalleled opportunity to experience North Shore living at its finest and at a value! Main living area has bright floor-to-ceiling large windows and sliding glass doors allowing natural light to flood in. Hear the gentle sound of the waves crashing against the shore from your private spacious lanai and master bedroom. Building amenities include salt water pool, sauna. Convenience is at your fingertips in this prime location. Located minutes away from the trending food and shopping of Haleiwa Town, but quiet living awaits in this part of Waialua.  Experience beach living, country shops at your convenience.  Don't miss this chance to enjoy North Shore living at an affordable price.  Brand new water heater, new slide-in range. Easy to schedule a private showing and have the luxury to customize your beachside beauty today! Seller has an assumable loan at 2.25% rate...unbeatable deal altogether.
        )

    [ListOfficeName] => Array
        (
            [0] => eXp Realty
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Average,Fair
        )

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

    [StoriesType] => Array
        (
            [0] => Two,Split Level
        )

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 725-2794
        )

    [ListAgentFullName] => Array
        (
            [0] => Suzie T Mai-French
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-08-23T06:01:44.387
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-02-22T13:38:34.493
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26118430
            [1] => 26118431
            [2] => 26118432
            [3] => 26118433
            [4] => 26118434
            [5] => 26118435
            [6] => 26118436
            [7] => 26118437
            [8] => 26118438
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Living (sf): 864
  • Year Built: 1975
  • Building Name: Ono Vista

  • Property Condition: Average,Fair
  • Number of Parking Spaces: 1
  • View: Mountain
  • Listing Office: eXp Realty

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

CONTACT US

Marcus Realty

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