Previous Next

3208 Waialae Avenue Honolulu, HI 96816

Listing
Overview

Price: $2,550,000
Area: PALOLO
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202508053"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "3208"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single 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) "2550000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "PALOLO"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1098) "Rare opportunity for an owner-user or investor to have multiple revenue streams with both commercial and residential applications! Prime location, including the former Venus Building, that encompasses 7,457 square feet of land and features an 892 square foot retail space and a residential home used as a 4-unit rental apartment. Property is strategically located along bustling Waialae Avenue, granting maximum exposure and accessibility. Property also includes a 2,112 square foot residential structure housing multiple units: one 3-bedroom/1-bath, two 1-bedroom/1-bath, and one studio/1-bath. This combination of residential and commercial units presents an attractive investment opportunity for buyers looking to capitalize on the growing demand for mixed-use properties in the area. As part of the Kaimuki/Palolo/Waialae neighborhood, 3208 Waialae Avenue also benefits from a vibrant community atmosphere and close proximity to many schools, the University of Hawaii at Manoa, St. Louis and Chaminade, phenomenal local eateries, shops and businesses. Sold in its WHERE IS and AS IS conditions."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "Bratton Realty Advisors Ltd"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "7457.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2112"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1942"
  }
  ["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(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(9) "Aliiolani"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Jarrett"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Kaimuki"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "BRAT"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "mark.bratton@colliers.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 523-9708"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Mark D Bratton"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18652191"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-17T18:40:02.830"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-07"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "18:40:02.830"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26951818"
  }
  ["listing_image"]=>
  array(14) {
    [0]=>
    string(8) "26951818"
    [1]=>
    string(8) "26951819"
    [2]=>
    string(8) "26951820"
    [3]=>
    string(8) "26951821"
    [4]=>
    string(8) "26951822"
    [5]=>
    string(8) "26951823"
    [6]=>
    string(8) "26951824"
    [7]=>
    string(8) "26951825"
    [8]=>
    string(8) "26951826"
    [9]=>
    string(8) "26951827"
    [10]=>
    string(8) "26951828"
    [11]=>
    string(8) "26951829"
    [12]=>
    string(8) "26951830"
    [13]=>
    string(8) "26951831"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202508053
        )

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

    [PropertyType] => Array
        (
            [0] => Single 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] => 2550000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Rare opportunity for an owner-user or investor to have multiple revenue streams with both commercial and residential applications! Prime location, including the former Venus Building, that encompasses 7,457 square feet of land and features an 892 square foot retail space and a residential home used as a 4-unit rental apartment. Property is strategically located along bustling Waialae Avenue, granting maximum exposure and accessibility. Property also includes a 2,112 square foot residential structure housing multiple units: one 3-bedroom/1-bath, two 1-bedroom/1-bath, and one studio/1-bath. This combination of residential and commercial units presents an attractive investment opportunity for buyers looking to capitalize on the growing demand for mixed-use properties in the area. As part of the Kaimuki/Palolo/Waialae neighborhood, 3208 Waialae Avenue also benefits from a vibrant community atmosphere and close proximity to many schools, the University of Hawaii at Manoa, St. Louis and Chaminade, phenomenal local eateries, shops and businesses. Sold in its WHERE IS and AS IS conditions.
        )

    [ListOfficeName] => Array
        (
            [0] => Bratton Realty Advisors Ltd
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => mark.bratton@colliers.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 523-9708
        )

    [ListAgentFullName] => Array
        (
            [0] => Mark D Bratton
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-17T18:40:02.830
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-04-07
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 18:40:02.830
        )

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

    [listing_image] => Array
        (
            [0] => 26951818
            [1] => 26951819
            [2] => 26951820
            [3] => 26951821
            [4] => 26951822
            [5] => 26951823
            [6] => 26951824
            [7] => 26951825
            [8] => 26951826
            [9] => 26951827
            [10] => 26951828
            [11] => 26951829
            [12] => 26951830
            [13] => 26951831
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 4
• Land Area (sf): 7,457 sf
• Living (sf): 2,112
• Year Built: 1942

KEY FEATURES

• Property Condition: Fair
• Number of Parking Spaces: 3
• View: None
• Listing Office: Bratton Realty Advisors Ltd

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Aliiolani
• Middle School: Jarrett
• High School: Kaimuki

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, 2025 - 6:40 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.