Previous Next

1506 Frear Street Unit A Honolulu, HI 96813

Listing
Overview

Price: $859,000
Area: PUNCHBOWL-LOWER
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202511688"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1506"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Frear"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "A"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96813"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "859000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(15) "PUNCHBOWL-LOWER"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1078) "DOWNTOWN LIVING WITH A BACKYARD? Work from home in style! This single-level home offers what high-rise condos can't: a private fenced yard for your pets, dedicated office/studio space, and ZERO HOA fees. Perfect for remote professionals, medical staff, or small business owners who want urban convenience without condo constraints. The separate bonus room makes an ideal home office, creative studio, or consultation space. Walk to Queen's Hospital in 5 minutes, Downtown offices in 7 minutes, or UH campus in 10 minutes. This 3 bed/2 bath single-level layout features brand-new appliances, renovated bathrooms with contemporary finishes, individual AC units in every bedroom, and fresh paint throughout. The quiet cul-de-sac location provides privacy while keeping you minutes from Chinatown dining, Ala Moana shopping, and freeway access. Here's the rare part: private fenced yard in urban Honolulu plus no monthly HOA fees plus covered parking plus flexible bonus space. This combination doesn't exist in downtown condos. SEE SUPPLEMENTS FOR $12,000 ANNUAL SAVINGS BREAKDOWN!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(15) "Talk Realty LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "1600.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1002"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1941"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(21) "Above Average,Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["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(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "TALK"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "bonnie.walker@talkrealty.co"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 400-8853"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Bonnie Walker"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18736639"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-11-03T06:01:36.070"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-08"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "06:01:36.070"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26989443"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "26989443"
    [1]=>
    string(8) "26989444"
    [2]=>
    string(8) "26989445"
    [3]=>
    string(8) "26989446"
    [4]=>
    string(8) "26989447"
    [5]=>
    string(8) "26989448"
    [6]=>
    string(8) "26989449"
    [7]=>
    string(8) "26989450"
    [8]=>
    string(8) "26989451"
    [9]=>
    string(8) "26989452"
    [10]=>
    string(8) "26989453"
    [11]=>
    string(8) "26989454"
    [12]=>
    string(8) "26989455"
    [13]=>
    string(8) "26989456"
    [14]=>
    string(8) "26989457"
    [15]=>
    string(8) "26989458"
    [16]=>
    string(8) "26989459"
    [17]=>
    string(8) "26989460"
    [18]=>
    string(8) "26989461"
    [19]=>
    string(8) "26989462"
    [20]=>
    string(8) "26991900"
    [21]=>
    string(8) "26991901"
    [22]=>
    string(8) "26991902"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202511688
        )

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

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => PUNCHBOWL-LOWER
        )

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

    [PublicRemarks] => Array
        (
            [0] => DOWNTOWN LIVING WITH A BACKYARD? Work from home in style! This single-level home offers what high-rise condos can't: a private fenced yard for your pets, dedicated office/studio space, and ZERO HOA fees. Perfect for remote professionals, medical staff, or small business owners who want urban convenience without condo constraints. The separate bonus room makes an ideal home office, creative studio, or consultation space. Walk to Queen's Hospital in 5 minutes, Downtown offices in 7 minutes, or UH campus in 10 minutes. This 3 bed/2 bath single-level layout features brand-new appliances, renovated bathrooms with contemporary finishes, individual AC units in every bedroom, and fresh paint throughout. The quiet cul-de-sac location provides privacy while keeping you minutes from Chinatown dining, Ala Moana shopping, and freeway access. Here's the rare part: private fenced yard in urban Honolulu plus no monthly HOA fees plus covered parking plus flexible bonus space. This combination doesn't exist in downtown condos. SEE SUPPLEMENTS FOR $12,000 ANNUAL SAVINGS BREAKDOWN!
        )

    [ListOfficeName] => Array
        (
            [0] => Talk Realty LLC
        )

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => bonnie.walker@talkrealty.co
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 400-8853
        )

    [ListAgentFullName] => Array
        (
            [0] => Bonnie Walker
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-11-03T06:01:36.070
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-08
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 06:01:36.070
        )

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

    [listing_image] => Array
        (
            [0] => 26989443
            [1] => 26989444
            [2] => 26989445
            [3] => 26989446
            [4] => 26989447
            [5] => 26989448
            [6] => 26989449
            [7] => 26989450
            [8] => 26989451
            [9] => 26989452
            [10] => 26989453
            [11] => 26989454
            [12] => 26989455
            [13] => 26989456
            [14] => 26989457
            [15] => 26989458
            [16] => 26989459
            [17] => 26989460
            [18] => 26989461
            [19] => 26989462
            [20] => 26991900
            [21] => 26991901
            [22] => 26991902
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Land Area (sf): 1,600 sf
• Living (sf): 1,002
• Year Built: 1941

KEY FEATURES

• Property Condition: Above Average,Average
• Number of Parking Spaces: 1
• View: None
• Listing Office: Talk Realty LLC

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

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 November 3, 2025 - 6:01 AM 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.