3208 Waialae Avenue Honolulu, HI 96816

Listing
Overview

Price: $2,799,900
Area: PALOLO
Status: Active

A historic 892 sq. ft. "VENUS" building fronting the main street - Waialae Ave. Behind the building is a 2,112 sq. ft. residential structure consisting of 1 3-bedroom/1-bath, 2 1-bedroom/1-bath, and 1 studio/1-bath 2-story structure - 3-car tandem parking. Palolo Stream runs at the end of the property. The property has 6 electric meters, 2 gas meters, and 1 water meter. All are located on a 7,457 sq. ft. fee simple parcel of land. Presently occupied. A Perfect location to run a business and live on the property or rent out for additional income. 48 hours to see the property is required, otherwise, please do not enter onto the property and disturb the occupants. The "VENUS" building is presently vacant. Sold in its WHERE IS and AS IS conditions. Combined interior sq.ft.: Residential 2,112 sq.ft. + Commercial 892 = 3004 sq.ft. Listing by: Thinc Real Estate

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202309717"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "3208"
  }
  ["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) "2799900.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "2799900.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "PALOLO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(845) "A historic 892 sq. ft. "VENUS" building fronting the main street - Waialae Ave.  Behind the building is a 2,112 sq. ft. residential structure consisting of 1 3-bedroom/1-bath, 2 1-bedroom/1-bath, and 1 studio/1-bath 2-story structure - 3-car tandem parking.  Palolo Stream runs at the end of the property. The property has 6 electric meters, 2 gas meters, and 1 water meter.  All are located on a 7,457 sq. ft. fee simple parcel of land.  Presently occupied.  A Perfect location to run a business and live on the property or rent out for additional income. 48 hours to see the property is required, otherwise, please do not enter onto the property and disturb the occupants. The "VENUS" building is presently vacant. Sold in its WHERE IS and AS IS conditions.

Combined interior sq.ft.:  Residential 2,112 sq.ft. + Commercial 892 = 3004 sq.ft."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(17) "Thinc Real Estate"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "7457.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "3004"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1941"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(4) "Fair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(7) "One,Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["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) "THIN"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "malcolmshiroma@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(17) "Malcolm S Shiroma"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-03-13T09:10:00.850"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17290524"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-04-26T10:30:02.667"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25871295"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "25871295"
    [1]=>
    string(8) "25871296"
    [2]=>
    string(8) "25871297"
    [3]=>
    string(8) "25871298"
    [4]=>
    string(8) "25871299"
    [5]=>
    string(8) "25871300"
    [6]=>
    string(8) "25871301"
    [7]=>
    string(8) "25871302"
    [8]=>
    string(8) "25871303"
    [9]=>
    string(8) "25871304"
    [10]=>
    string(8) "25871305"
    [11]=>
    string(8) "25871306"
    [12]=>
    string(8) "25871307"
    [13]=>
    string(8) "25871308"
    [14]=>
    string(8) "25871309"
    [15]=>
    string(8) "25871310"
    [16]=>
    string(8) "25871311"
    [17]=>
    string(8) "25871312"
    [18]=>
    string(8) "25871313"
    [19]=>
    string(8) "25871314"
    [20]=>
    string(8) "25871315"
    [21]=>
    string(8) "25871316"
    [22]=>
    string(8) "25871317"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202309717
        )

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

    [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] => 2799900.00
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => A historic 892 sq. ft. "VENUS" building fronting the main street - Waialae Ave.  Behind the building is a 2,112 sq. ft. residential structure consisting of 1 3-bedroom/1-bath, 2 1-bedroom/1-bath, and 1 studio/1-bath 2-story structure - 3-car tandem parking.  Palolo Stream runs at the end of the property. The property has 6 electric meters, 2 gas meters, and 1 water meter.  All are located on a 7,457 sq. ft. fee simple parcel of land.  Presently occupied.  A Perfect location to run a business and live on the property or rent out for additional income. 48 hours to see the property is required, otherwise, please do not enter onto the property and disturb the occupants. The "VENUS" building is presently vacant. Sold in its WHERE IS and AS IS conditions.

Combined interior sq.ft.:  Residential 2,112 sq.ft. + Commercial 892 = 3004 sq.ft.
        )

    [ListOfficeName] => Array
        (
            [0] => Thinc Real Estate
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentFullName] => Array
        (
            [0] => Malcolm S Shiroma
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-03-13T09:10:00.850
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-04-26T10:30:02.667
        )

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

    [listing_image] => Array
        (
            [0] => 25871295
            [1] => 25871296
            [2] => 25871297
            [3] => 25871298
            [4] => 25871299
            [5] => 25871300
            [6] => 25871301
            [7] => 25871302
            [8] => 25871303
            [9] => 25871304
            [10] => 25871305
            [11] => 25871306
            [12] => 25871307
            [13] => 25871308
            [14] => 25871309
            [15] => 25871310
            [16] => 25871311
            [17] => 25871312
            [18] => 25871313
            [19] => 25871314
            [20] => 25871315
            [21] => 25871316
            [22] => 25871317
        )

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

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

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

)

  • Land Area (sf): 7,457
  • Living (sf): 3,004
  • Year Built: 1941

  • Property Condition: Fair
  • Number of Parking Spaces: 3
  • View: None
  • Listing Office: Thinc Real Estate

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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