68-090 Au Street Unit E506 Waialua, HI 96791

Listing
Overview

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

Large Split Level 2 Bedroom, 1 Bath Unit in Ono Vista. Unit is priced to sell so Buyer can make their own improvements and make this unit their own. This unit is being sold in "As Is" Condition & Sellers will be conducting a 1031 Exhange. Listing by: Tsujimura & Associates, LLC (808) 388-3630

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202504441"
  }
  ["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) "E506"
  }
  ["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) "485000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(240) "Large Split Level 2 Bedroom, 1 Bath Unit in Ono Vista.
Unit is priced to sell so Buyer can make their own improvements and make this unit their own.
This unit is being sold in "As Is" Condition & Sellers will be conducting a 1031 Exhange."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "Tsujimura & Associates, 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(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(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(15) "Split Level,4-7"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(39) "Coastline,Mountain,Ocean,Sunrise,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1102.56"
  }
  ["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) "LTSU"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "LTSUJIMURA@TAAREALTY.COM"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 388-3630"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Lester S Tsujimura"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18540748"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-06T00:18:11.207"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-02-05"
  }
  ["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) "00:18:11.207"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26869524"
  }
  ["listing_image"]=>
  array(16) {
    [0]=>
    string(8) "26869524"
    [1]=>
    string(8) "26869525"
    [2]=>
    string(8) "26869526"
    [3]=>
    string(8) "26869527"
    [4]=>
    string(8) "26869528"
    [5]=>
    string(8) "26869529"
    [6]=>
    string(8) "26869530"
    [7]=>
    string(8) "26869531"
    [8]=>
    string(8) "26869532"
    [9]=>
    string(8) "26869533"
    [10]=>
    string(8) "26869534"
    [11]=>
    string(8) "26869535"
    [12]=>
    string(8) "26869536"
    [13]=>
    string(8) "26869537"
    [14]=>
    string(8) "26869538"
    [15]=>
    string(8) "26869539"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202504441
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Large Split Level 2 Bedroom, 1 Bath Unit in Ono Vista.
Unit is priced to sell so Buyer can make their own improvements and make this unit their own.
This unit is being sold in "As Is" Condition & Sellers will be conducting a 1031 Exhange.
        )

    [ListOfficeName] => Array
        (
            [0] => Tsujimura & Associates, LLC
        )

    [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
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => LTSUJIMURA@TAAREALTY.COM
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 388-3630
        )

    [ListAgentFullName] => Array
        (
            [0] => Lester S Tsujimura
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-06T00:18:11.207
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 00:18:11.207
        )

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

    [listing_image] => Array
        (
            [0] => 26869524
            [1] => 26869525
            [2] => 26869526
            [3] => 26869527
            [4] => 26869528
            [5] => 26869529
            [6] => 26869530
            [7] => 26869531
            [8] => 26869532
            [9] => 26869533
            [10] => 26869534
            [11] => 26869535
            [12] => 26869536
            [13] => 26869537
            [14] => 26869538
            [15] => 26869539
        )

)

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

  • Property Condition: Average
  • Number of Parking Spaces: 1
  • View: Coastline,Mountain,Ocean,Sunrise,Sunset
  • Listing Office: Tsujimura & Associates, LLC

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

CONTACT US

Marcus Realty

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