3147 Hayden Street Honolulu, HI 96815

Take a Virtual Tour

Listing
Overview

Price: $1,295,000
Area: KAPAHULU
Status: Active Under Contract

Rarely available two detached dwellings on clear level lot. Few blocks to Kapahulu and Diamond Head shops & restaurants from this gem. Front house is a 2 bedrm 1 bath classic charmer and back house is a 1 bdrm 1 bath cottage with an attached carport. Back house is an opportunity to realize your creative ideas, bring your contractor to explore possibilities. Property is fenced for privacy with multi-vehicle parking. Front house features newer windows and roof, well laid out floor plan with eat-in kitchen and ample size bedrooms. Views of Diamond Head with a spacious yard on a desirable street. To be sold strictly "AS IS" and Buyer to do their own due dilligence. Property has not been rented out. Pending approval by Land Court for Petition for Amendment of Land Court Certificate of Title which has been filed. Listing by: BHGRE Advantage Realty (808) 738-3600

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202504464"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "3147"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(12) "Multi-Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Hayden"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["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) "96815"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(59) "https://listings.hetproductions.com/sites/wezolev/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1295000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "KAPAHULU"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(818) "Rarely available two detached dwellings on clear level lot. Few blocks to Kapahulu and Diamond Head shops & restaurants from this gem. Front house is a 2 bedrm 1 bath classic charmer and back house is a 1 bdrm 1 bath cottage with an attached carport. Back house is an opportunity to realize your creative ideas, bring your contractor to explore possibilities. Property is fenced for privacy with multi-vehicle parking. Front house features newer windows and roof, well laid out floor plan with eat-in kitchen and ample size bedrooms. Views of Diamond Head with a spacious yard on a desirable street. To be sold strictly "AS IS" and Buyer to do their own due dilligence. Property has not been rented out. Pending approval by Land Court for Petition for Amendment of Land Court Certificate of Title which has been filed."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "BHGRE Advantage Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5455.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1120"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1951"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(26) "Average,Needs Major Repair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(17) "City,Diamond Head"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Waikiki"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kalani"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "ADVG"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "AnnieK@BetterHawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 738-3600"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Annie H Kim"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18541450"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-21T09:56:51.427"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-02-13"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:56:51.427"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26879292"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26879292"
    [1]=>
    string(8) "26879293"
    [2]=>
    string(8) "26879294"
    [3]=>
    string(8) "26879295"
    [4]=>
    string(8) "26879296"
    [5]=>
    string(8) "26879297"
    [6]=>
    string(8) "26879298"
    [7]=>
    string(8) "26879299"
    [8]=>
    string(8) "26879300"
    [9]=>
    string(8) "26879301"
    [10]=>
    string(8) "26879302"
    [11]=>
    string(8) "26879303"
    [12]=>
    string(8) "26879304"
    [13]=>
    string(8) "26879305"
    [14]=>
    string(8) "26879306"
    [15]=>
    string(8) "26879307"
    [16]=>
    string(8) "26879308"
    [17]=>
    string(8) "26879309"
    [18]=>
    string(8) "26879310"
    [19]=>
    string(8) "26879311"
    [20]=>
    string(8) "26879312"
    [21]=>
    string(8) "26879313"
    [22]=>
    string(8) "26879314"
    [23]=>
    string(8) "26879315"
    [24]=>
    string(8) "26879316"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202504464
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://listings.hetproductions.com/sites/wezolev/unbranded
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Rarely available two detached dwellings on clear level lot. Few blocks to Kapahulu and Diamond Head shops & restaurants from this gem. Front house is a 2 bedrm 1 bath classic charmer and back house is a 1 bdrm 1 bath cottage with an attached carport. Back house is an opportunity to realize your creative ideas, bring your contractor to explore possibilities. Property is fenced for privacy with multi-vehicle parking. Front house features newer windows and roof, well laid out floor plan with eat-in kitchen and ample size bedrooms. Views of Diamond Head with a spacious yard on a desirable street. To be sold strictly "AS IS" and Buyer to do their own due dilligence. Property has not been rented out. Pending approval by Land Court for Petition for Amendment of Land Court Certificate of Title which has been filed.
        )

    [ListOfficeName] => Array
        (
            [0] => BHGRE Advantage Realty
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Average,Needs Major Repair
        )

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

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

    [View] => Array
        (
            [0] => City,Diamond Head
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => AnnieK@BetterHawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 738-3600
        )

    [ListAgentFullName] => Array
        (
            [0] => Annie H Kim
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-21T09:56:51.427
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:56:51.427
        )

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

    [listing_image] => Array
        (
            [0] => 26879292
            [1] => 26879293
            [2] => 26879294
            [3] => 26879295
            [4] => 26879296
            [5] => 26879297
            [6] => 26879298
            [7] => 26879299
            [8] => 26879300
            [9] => 26879301
            [10] => 26879302
            [11] => 26879303
            [12] => 26879304
            [13] => 26879305
            [14] => 26879306
            [15] => 26879307
            [16] => 26879308
            [17] => 26879309
            [18] => 26879310
            [19] => 26879311
            [20] => 26879312
            [21] => 26879313
            [22] => 26879314
            [23] => 26879315
            [24] => 26879316
        )

)

  • Land Area (sf): 5,455 sf
  • Living (sf): 1,120
  • Year Built: 1951

  • Property Condition: Average,Needs Major Repair
  • Number of Parking Spaces: 3
  • View: City,Diamond Head
  • Listing Office: BHGRE Advantage Realty

  • Land Tenure: FS - Fee Simple

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

CONTACT US

Marcus Realty

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