1506 Frear Street Unit A Honolulu, HI 96813

Take a Virtual Tour

Listing
Overview

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

Step into a lifestyle most downtown dwellers only dream about, a detached single-family home with private fenced yard and zero monthly HOA fees in the heart of urban Honolulu. Location is unbeatable: walk to Queen’s Medical Center in five minutes, reach Downtown offices in 15+ minutes, and get to UH campus in 20. The home has been completely refreshed with brand-new appliances in the kitchen, renovated bathrooms featuring contemporary finishes that rival new construction, and individual AC units in all three bedrooms to keep everyone comfortable. Fresh paint throughout creates that crisp, move-in-ready feel, while the flexible bonus room adapts to whatever your life demands. The single-level layout flows effortlessly, and the quiet cul-de-sac setting offers privacy without sacrificing convenience to Chinatown dining, Ala Moana shopping, and freeway access. Here’s what high-rises can’t offer: your own yard for morning coffee or evening barbecues, tandem parking with covered carport and extra storage along with the financial freedom of single-family ownership where you call the shots. Downtown living on your terms. *** Have your Realtor call to chat about FREE temp. rate buy down.*** Listing by: Talk Realty LLC (808) 282-8907

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202602160"
  }
  ["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(82) "https://drive.google.com/file/d/1aZQOL7ACf61OjMRETwn6R-ea8PRIUz55/view?usp=sharing"
  }
  ["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(1206) "Step into a lifestyle most downtown dwellers only dream about, a detached single-family home with private fenced yard and zero monthly HOA fees in the heart of urban Honolulu. Location is unbeatable: walk to Queen’s Medical Center in five minutes, reach Downtown offices in 15+ minutes, and get to UH campus in 20. The home has been completely refreshed with brand-new appliances in the kitchen, renovated bathrooms featuring contemporary finishes that rival new construction, and individual AC units in all three bedrooms to keep everyone comfortable. Fresh paint throughout creates that crisp, move-in-ready feel, while the flexible bonus room adapts to whatever your life demands. The single-level layout flows effortlessly, and the quiet cul-de-sac setting offers privacy without sacrificing convenience to Chinatown dining, Ala Moana shopping, and freeway access. Here’s what high-rises can’t offer: your own yard for morning coffee or evening barbecues, tandem parking with covered carport and extra storage along with the financial freedom of single-family ownership where you call the shots. Downtown living on your terms. *** Have your Realtor call to chat about FREE temp. rate buy down.***"
  }
  ["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(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["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(5) "Royal"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mckinley"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "TALK"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "bonnie.walker@talkrealty.co"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 282-8907"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Bonnie Walker"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19246517"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-03T15:02:22.660"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-02-04"
  }
  ["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) "15:02:22.660"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27292789"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "27292789"
    [1]=>
    string(8) "27292790"
    [2]=>
    string(8) "27292791"
    [3]=>
    string(8) "27292792"
    [4]=>
    string(8) "27292793"
    [5]=>
    string(8) "27292794"
    [6]=>
    string(8) "27292795"
    [7]=>
    string(8) "27292796"
    [8]=>
    string(8) "27292797"
    [9]=>
    string(8) "27292798"
    [10]=>
    string(8) "27292799"
    [11]=>
    string(8) "27292800"
    [12]=>
    string(8) "27292801"
    [13]=>
    string(8) "27292802"
    [14]=>
    string(8) "27292803"
    [15]=>
    string(8) "27292804"
    [16]=>
    string(8) "27292805"
    [17]=>
    string(8) "27292806"
    [18]=>
    string(8) "27292807"
    [19]=>
    string(8) "27292808"
    [20]=>
    string(8) "27292809"
    [21]=>
    string(8) "27292810"
    [22]=>
    string(8) "27292811"
    [23]=>
    string(8) "27292812"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202602160
        )

    [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] => https://drive.google.com/file/d/1aZQOL7ACf61OjMRETwn6R-ea8PRIUz55/view?usp=sharing
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Step into a lifestyle most downtown dwellers only dream about, a detached single-family home with private fenced yard and zero monthly HOA fees in the heart of urban Honolulu. Location is unbeatable: walk to Queen’s Medical Center in five minutes, reach Downtown offices in 15+ minutes, and get to UH campus in 20. The home has been completely refreshed with brand-new appliances in the kitchen, renovated bathrooms featuring contemporary finishes that rival new construction, and individual AC units in all three bedrooms to keep everyone comfortable. Fresh paint throughout creates that crisp, move-in-ready feel, while the flexible bonus room adapts to whatever your life demands. The single-level layout flows effortlessly, and the quiet cul-de-sac setting offers privacy without sacrificing convenience to Chinatown dining, Ala Moana shopping, and freeway access. Here’s what high-rises can’t offer: your own yard for morning coffee or evening barbecues, tandem parking with covered carport and extra storage along with the financial freedom of single-family ownership where you call the shots. Downtown living on your terms. *** Have your Realtor call to chat about FREE temp. rate buy down.***
        )

    [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
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 282-8907
        )

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

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-03T15:02:22.660
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-02-04
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 15:02:22.660
        )

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

    [listing_image] => Array
        (
            [0] => 27292789
            [1] => 27292790
            [2] => 27292791
            [3] => 27292792
            [4] => 27292793
            [5] => 27292794
            [6] => 27292795
            [7] => 27292796
            [8] => 27292797
            [9] => 27292798
            [10] => 27292799
            [11] => 27292800
            [12] => 27292801
            [13] => 27292802
            [14] => 27292803
            [15] => 27292804
            [16] => 27292805
            [17] => 27292806
            [18] => 27292807
            [19] => 27292808
            [20] => 27292809
            [21] => 27292810
            [22] => 27292811
            [23] => 27292812
        )

)

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

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

  • Land Tenure: FS - Fee Simple

  • Elementary School: Royal
  • High School: Mckinley

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 March 3, 2026 - 3:02 PM Information is deemed reliable but not guaranteed. Copyright: 2026 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.

© Marcus Realty. All Rights Reserved.