Previous Next

3923 Waialae Avenue Honolulu, HI 96816

Listing
Overview

Price: $1,688,800
Area: KAIMUKI
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202407981"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "3923"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(12) "Multi-Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Waialae"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Avenue"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96816"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1688800.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "1688800.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "KAIMUKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(533) "Location! Location! Location! Great investment opportunity for 1031 exchange in popular Diamond Head offering a unique combination of 2 duplex, 1 triplex and 1 studio dwelling containing 4 rental units built in 2003. There are two-2 bedroom on downstairs and one-3 bedroom and studio on upstairs. The owner currently occupied in the studio unit. Two car garage/1 car port/ 3 open parking spaces. The Buyer could be an owner/occupant in one of the units and enjoy rental income.  Prefer using Old Republic Title & Escrow (Craig Endo)."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Moana Realty LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6634.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3624"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2003"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "City,Coastline"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialae"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kalani"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "MOAR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "hirokomiller@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 389-1902"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Hiroko O Miller"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-06-17T14:10:53.323"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17932007"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-04-17T12:34:08.490"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26169394"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26169394"
    [1]=>
    string(8) "26169395"
    [2]=>
    string(8) "26169396"
    [3]=>
    string(8) "26169397"
    [4]=>
    string(8) "26169398"
    [5]=>
    string(8) "26169399"
    [6]=>
    string(8) "26169400"
    [7]=>
    string(8) "26169401"
    [8]=>
    string(8) "26169402"
    [9]=>
    string(8) "26169403"
    [10]=>
    string(8) "26169404"
    [11]=>
    string(8) "26169405"
    [12]=>
    string(8) "26169406"
    [13]=>
    string(8) "26169407"
    [14]=>
    string(8) "26169408"
    [15]=>
    string(8) "26169409"
    [16]=>
    string(8) "26169410"
    [17]=>
    string(8) "26169411"
    [18]=>
    string(8) "26169412"
    [19]=>
    string(8) "26169413"
    [20]=>
    string(8) "26169414"
    [21]=>
    string(8) "26169415"
    [22]=>
    string(8) "26169416"
    [23]=>
    string(8) "26169417"
    [24]=>
    string(8) "26169418"
    [25]=>
    string(8) "26169419"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202407981
        )

    [StreetNumber] => Array
        (
            [0] => 3923
        )

    [PropertyType] => Array
        (
            [0] => Multi-Family
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Location! Location! Location! Great investment opportunity for 1031 exchange in popular Diamond Head offering a unique combination of 2 duplex, 1 triplex and 1 studio dwelling containing 4 rental units built in 2003. There are two-2 bedroom on downstairs and one-3 bedroom and studio on upstairs. The owner currently occupied in the studio unit. Two car garage/1 car port/ 3 open parking spaces. The Buyer could be an owner/occupant in one of the units and enjoy rental income.  Prefer using Old Republic Title & Escrow (Craig Endo).
        )

    [ListOfficeName] => Array
        (
            [0] => Moana Realty LLC
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => City,Coastline
        )

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 389-1902
        )

    [ListAgentFullName] => Array
        (
            [0] => Hiroko O Miller
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-06-17T14:10:53.323
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-04-17T12:34:08.490
        )

    [MLSAreaMajor] => Array
        (
            [0] => DiamondHd
        )

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

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

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

    [listing_image] => Array
        (
            [0] => 26169394
            [1] => 26169395
            [2] => 26169396
            [3] => 26169397
            [4] => 26169398
            [5] => 26169399
            [6] => 26169400
            [7] => 26169401
            [8] => 26169402
            [9] => 26169403
            [10] => 26169404
            [11] => 26169405
            [12] => 26169406
            [13] => 26169407
            [14] => 26169408
            [15] => 26169409
            [16] => 26169410
            [17] => 26169411
            [18] => 26169412
            [19] => 26169413
            [20] => 26169414
            [21] => 26169415
            [22] => 26169416
            [23] => 26169417
            [24] => 26169418
            [25] => 26169419
        )

)

PROPERTY INFO

• Land Area (sf): 6,634 sf
• Living (sf): 3,624
• Year Built: 2003

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 6
• View: City,Coastline
• Listing Office: Moana Realty LLC

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Waialae
• Middle School: Kaimuki
• High School: Kalani

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 June 17, 2024 - 2:10 PM 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.