3316 Campbell Avenue Honolulu, HI 96815

Listing
Overview

Price: $2,460,000
Area: KAPAHULU
Status: Active Under Contract

Rarely available opportunity in Kapahulu! Priced attractively at tax-assessed value. B-2 Zoned with 3 structures & 4 units: a 957 sf Retail Shop, a 780 sf 2/1 Single Family Home, and a 1,276 sf Duplex with two 638 sf 2/1 units. Two carports with a total of 5 parking, plus street parking. Ready to go with 5 electrical meters. Super convenient and desirable location only 0.9 miles to the closest freeway onramp, and 0.9 miles to "walls" at world famous Waikiki Beach, plus a plethora of eateries in the immediate area. All units are vacant except for Duplex A; tenant will vacate at closing. Make use of the property quickly with a few repairs, make some upgrades for increased revenue, or explore the option to redevelop affordable rental units under Bill 7 to maximize the property’s highest & best use. Historical income numbers are below market, as family has lived in 2 units rent-free for years, leaving you plenty of upside. Property is being sold Strictly As-Is. Bath count (3.5) does not match city records (3). Structures have deferred maintenance, buyers to conduct their own due diligence. Please do not disturb tenants. Act quickly. Don’t miss your chance to own this amazing property! Listing by: Keller Williams Honolulu (808) 343-3695

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202320512"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "3316"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Campbell"
  }
  ["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) "96815"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2460000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2460000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "KAPAHULU"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1204) "Rarely available opportunity in Kapahulu! Priced attractively at tax-assessed value. B-2 Zoned with 3 structures & 4 units: a 957 sf Retail Shop, a 780 sf 2/1 Single Family Home, and a 1,276 sf Duplex with two 638 sf 2/1 units. Two carports with a total of 5 parking, plus street parking. Ready to go with 5 electrical meters. Super convenient and desirable location only 0.9 miles to the closest freeway onramp, and 0.9 miles to "walls" at world famous Waikiki Beach, plus a plethora of eateries in the immediate area. All units are vacant except for Duplex A; tenant will vacate at closing.  Make use of the property quickly with a few repairs, make some upgrades for increased revenue, or explore the option to redevelop affordable rental units under Bill 7 to maximize the property’s highest & best use. Historical income numbers are below market, as family has lived in 2 units rent-free for years, leaving you plenty of upside. Property is being sold Strictly As-Is. Bath count (3.5) does not match city records (3). Structures have deferred maintenance, buyers to conduct their own due diligence. Please do not disturb tenants. Act quickly. Don’t miss your chance to own this amazing property!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Keller Williams Honolulu"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6914.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3013"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1949"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "KWPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "listing@iharateam.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 343-3695"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Daniel K Ihara"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-09-22T14:56:41.280"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17545971"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-09-06T19:22:12.477"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25949364"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "25949364"
    [1]=>
    string(8) "25949365"
    [2]=>
    string(8) "25949366"
    [3]=>
    string(8) "25949367"
    [4]=>
    string(8) "25949368"
    [5]=>
    string(8) "25949369"
    [6]=>
    string(8) "25949370"
    [7]=>
    string(8) "25949371"
    [8]=>
    string(8) "25949372"
    [9]=>
    string(8) "25949373"
    [10]=>
    string(8) "25949374"
    [11]=>
    string(8) "25949375"
    [12]=>
    string(8) "25949376"
    [13]=>
    string(8) "25949377"
    [14]=>
    string(8) "25949378"
    [15]=>
    string(8) "25949379"
    [16]=>
    string(8) "25949380"
    [17]=>
    string(8) "25949381"
    [18]=>
    string(8) "25949382"
    [19]=>
    string(8) "25949383"
    [20]=>
    string(8) "25949384"
    [21]=>
    string(8) "25949385"
    [22]=>
    string(8) "25949386"
    [23]=>
    string(8) "25949387"
    [24]=>
    string(8) "25949388"
    [25]=>
    string(8) "25949389"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202320512
        )

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

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Rarely available opportunity in Kapahulu! Priced attractively at tax-assessed value. B-2 Zoned with 3 structures & 4 units: a 957 sf Retail Shop, a 780 sf 2/1 Single Family Home, and a 1,276 sf Duplex with two 638 sf 2/1 units. Two carports with a total of 5 parking, plus street parking. Ready to go with 5 electrical meters. Super convenient and desirable location only 0.9 miles to the closest freeway onramp, and 0.9 miles to "walls" at world famous Waikiki Beach, plus a plethora of eateries in the immediate area. All units are vacant except for Duplex A; tenant will vacate at closing.  Make use of the property quickly with a few repairs, make some upgrades for increased revenue, or explore the option to redevelop affordable rental units under Bill 7 to maximize the property’s highest & best use. Historical income numbers are below market, as family has lived in 2 units rent-free for years, leaving you plenty of upside. Property is being sold Strictly As-Is. Bath count (3.5) does not match city records (3). Structures have deferred maintenance, buyers to conduct their own due diligence. Please do not disturb tenants. Act quickly. Don’t miss your chance to own this amazing property!
        )

    [ListOfficeName] => Array
        (
            [0] => Keller Williams Honolulu
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => listing@iharateam.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 343-3695
        )

    [ListAgentFullName] => Array
        (
            [0] => Daniel K Ihara
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-09-22T14:56:41.280
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-09-06T19:22:12.477
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25949364
            [1] => 25949365
            [2] => 25949366
            [3] => 25949367
            [4] => 25949368
            [5] => 25949369
            [6] => 25949370
            [7] => 25949371
            [8] => 25949372
            [9] => 25949373
            [10] => 25949374
            [11] => 25949375
            [12] => 25949376
            [13] => 25949377
            [14] => 25949378
            [15] => 25949379
            [16] => 25949380
            [17] => 25949381
            [18] => 25949382
            [19] => 25949383
            [20] => 25949384
            [21] => 25949385
            [22] => 25949386
            [23] => 25949387
            [24] => 25949388
            [25] => 25949389
        )

)

  • BedsTotal: 6
  • Full Baths: 3
  • Land Area (sf): 6,914
  • Living (sf): 3,013
  • Year Built: 1949

  • Property Condition: Average
  • Number of Parking Spaces: 5
  • View: Mountain
  • Listing Office: Keller Williams Honolulu

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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