504 School Street Honolulu, HI 96817

Listing
Overview

Price: $999,888
Area: LILIHA
Status: Active

HUGE PRICE REDUCTION!!! RARE B-2 Zoned property at a new price to sell! CORNER of Liliha and N. School Street. HIGH VISIBILITY with EXCELLENT STREET FRONTAGE! Great for owner/user! Listing by: Bob Tanaka Inc (808) 949-4111

array(46) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202400095"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "504"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "School"
  }
  ["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) "96817"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "999888.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "999888.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "LILIHA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(186) "HUGE PRICE REDUCTION!!!
RARE B-2 Zoned property at a new price to sell!  
CORNER of Liliha and N. School Street.  HIGH VISIBILITY with EXCELLENT STREET FRONTAGE!  Great for owner/user!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Bob Tanaka Inc"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "7627.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "City"
  }
  ["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) "TANK"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(17) "Bob@bobtanaka.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-4111"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Bob Tanaka"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-10-01T21:24:53.883"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17744130"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-01-03T11:02:57.313"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26057889"
  }
  ["listing_image"]=>
  array(7) {
    [0]=>
    string(8) "26057889"
    [1]=>
    string(8) "26057890"
    [2]=>
    string(8) "26057891"
    [3]=>
    string(8) "26057892"
    [4]=>
    string(8) "26057893"
    [5]=>
    string(8) "26057894"
    [6]=>
    string(8) "26057895"
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "21:24:53.883"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202400095
        )

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

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => HUGE PRICE REDUCTION!!!
RARE B-2 Zoned property at a new price to sell!  
CORNER of Liliha and N. School Street.  HIGH VISIBILITY with EXCELLENT STREET FRONTAGE!  Great for owner/user!
        )

    [ListOfficeName] => Array
        (
            [0] => Bob Tanaka Inc
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Bob@bobtanaka.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 949-4111
        )

    [ListAgentFullName] => Array
        (
            [0] => Bob Tanaka
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-10-01T21:24:53.883
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-01-03T11:02:57.313
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26057889
            [1] => 26057890
            [2] => 26057891
            [3] => 26057892
            [4] => 26057893
            [5] => 26057894
            [6] => 26057895
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 21:24:53.883
        )

)

  • Land Area (sf): 7,627 sf

  • View: City
  • Listing Office: Bob Tanaka Inc

  • Land Tenure: FS - Fee Simple

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 October 1, 2024 - 9:24 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.