Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
1506 Frear Street Unit A Honolulu, HI 96813
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. Save $12,000+ annually while enjoying freedoms condo living cannot provide. Location is unbeatable: walk to Queen's Medical Center in five minutes, reach Downtown offices in 15+ minutes, & get to UH campus in 20. The home has been completely refreshed—brand-new appliances shine in the kitchen, renovated bathrooms feature contemporary finishes that rival new construction, and individual AC units in all three bedrooms keep everyone comfortable year-round. 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, & freeway access. Here's what high-rises can't offer: your own yard for morning coffee or evening barbecues and the financial freedom of single-family ownership where you call the shots. Downtown living on your terms. Listing by: Talk Realty LLC (808) 282-8907
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202525397"
}
["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(1150) "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. Save $12,000+ annually while enjoying freedoms condo living cannot provide. Location is unbeatable: walk to Queen's Medical Center in five minutes, reach Downtown offices in 15+ minutes, & get to UH campus in 20. The home has been completely refreshed—brand-new appliances shine in the kitchen, renovated bathrooms feature contemporary finishes that rival new construction, and individual AC units in all three bedrooms keep everyone comfortable year-round. 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, & freeway access. Here's what high-rises can't offer: your own yard for morning coffee or evening barbecues and the financial freedom of single-family ownership where you call the shots. Downtown living on your terms."
}
["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) 282-8907"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Bonnie Walker"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19116905"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-12T16:33:04.020"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-12"
}
["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) "16:33:04.020"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27217910"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "27217910"
[1]=>
string(8) "27217911"
[2]=>
string(8) "27217912"
[3]=>
string(8) "27217913"
[4]=>
string(8) "27217914"
[5]=>
string(8) "27217915"
[6]=>
string(8) "27217916"
[7]=>
string(8) "27217917"
[8]=>
string(8) "27217918"
[9]=>
string(8) "27217919"
[10]=>
string(8) "27217920"
[11]=>
string(8) "27217921"
[12]=>
string(8) "27217922"
[13]=>
string(8) "27217923"
[14]=>
string(8) "27217924"
[15]=>
string(8) "27217925"
[16]=>
string(8) "27217926"
[17]=>
string(8) "27217927"
[18]=>
string(8) "27217928"
[19]=>
string(8) "27217929"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202525397
)
[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] => 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. Save $12,000+ annually while enjoying freedoms condo living cannot provide. Location is unbeatable: walk to Queen's Medical Center in five minutes, reach Downtown offices in 15+ minutes, & get to UH campus in 20. The home has been completely refreshed—brand-new appliances shine in the kitchen, renovated bathrooms feature contemporary finishes that rival new construction, and individual AC units in all three bedrooms keep everyone comfortable year-round. 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, & freeway access. Here's what high-rises can't offer: your own yard for morning coffee or evening barbecues and the financial freedom of single-family ownership where you call the shots. Downtown living on your terms.
)
[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) 282-8907
)
[ListAgentFullName] => Array
(
[0] => Bonnie Walker
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19116905
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-12T16:33:04.020
)
[ListingContractDate] => Array
(
[0] => 2025-11-12
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:33:04.020
)
[_thumbnail_id] => Array
(
[0] => 27217910
)
[listing_image] => Array
(
[0] => 27217910
[1] => 27217911
[2] => 27217912
[3] => 27217913
[4] => 27217914
[5] => 27217915
[6] => 27217916
[7] => 27217917
[8] => 27217918
[9] => 27217919
[10] => 27217920
[11] => 27217921
[12] => 27217922
[13] => 27217923
[14] => 27217924
[15] => 27217925
[16] => 27217926
[17] => 27217927
[18] => 27217928
[19] => 27217929
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 12, 2025 - 4:33 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.
