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
Don’t miss this rarely available corner end unit in the Queen Tower at Queen Emma Gardens. This spacious 2 bedroom, 1 bathroom home with 1 covered parking stall has been beautifully renovated with a modern kitchen featuring stainless steel appliances, quartz countertops, new cabinets, and a stylish backsplash. Laminate wood flooring flows throughout the unit, adding a clean and contemporary feel.
Adding to its unique appeal, this was historically the one-of-a-kind unit where the original developer and resident manager resided, featuring ornate double doors that set it apart.
Take in the beautiful 20th floor city and mountain views overlooking Foster Botanical Gardens. Queen Emma Gardens is a pet-friendly community offering wonderful amenities, including Japanese-style tea-houses, swimming and wading pools, a tranquil koi pond, BBQ area, and picnic sites, all in a convenient location near downtown Honolulu, shopping, and dining. Put this on your must-see list! One or more photos have been enhanced. Listing by: Redfin Corporation (808) 201-2821
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202525530"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1515"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Nuuanu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Avenue"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "2050"
}
["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(51) "https://my.matterport.com/show/?m=xokyEEMvrt4&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "400000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1020) "Don’t miss this rarely available corner end unit in the Queen Tower at Queen Emma Gardens. This spacious 2 bedroom, 1 bathroom home with 1 covered parking stall has been beautifully renovated with a modern kitchen featuring stainless steel appliances, quartz countertops, new cabinets, and a stylish backsplash. Laminate wood flooring flows throughout the unit, adding a clean and contemporary feel.
Adding to its unique appeal, this was historically the one-of-a-kind unit where the original developer and resident manager resided, featuring ornate double doors that set it apart.
Take in the beautiful 20th floor city and mountain views overlooking Foster Botanical Gardens. Queen Emma Gardens is a pet-friendly community offering wonderful amenities, including Japanese-style tea-houses, swimming and wading pools, a tranquil koi pond, BBQ area, and picnic sites, all in a convenient location near downtown Honolulu, shopping, and dining. Put this on your must-see list! One or more photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "354186.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "821"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Queen Emma Gardens"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(21) "City,Coastline,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1322.30"
}
["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) "RFIN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "mike.demello@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 201-2821"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Michael D DeMello"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19121175"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-30T18:00:01.613"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-19"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "18:00:01.613"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27224682"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27224682"
[1]=>
string(8) "27224683"
[2]=>
string(8) "27224684"
[3]=>
string(8) "27224685"
[4]=>
string(8) "27224686"
[5]=>
string(8) "27224687"
[6]=>
string(8) "27224688"
[7]=>
string(8) "27224689"
[8]=>
string(8) "27224690"
[9]=>
string(8) "27224691"
[10]=>
string(8) "27224692"
[11]=>
string(8) "27224693"
[12]=>
string(8) "27224694"
[13]=>
string(8) "27224695"
[14]=>
string(8) "27224696"
[15]=>
string(8) "27224697"
[16]=>
string(8) "27224698"
[17]=>
string(8) "27224699"
[18]=>
string(8) "27224700"
[19]=>
string(8) "27224701"
[20]=>
string(8) "27224702"
[21]=>
string(8) "27224703"
[22]=>
string(8) "27224704"
[23]=>
string(8) "27224705"
[24]=>
string(8) "27224706"
[25]=>
string(8) "27224707"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202525530
)
[StreetNumber] => Array
(
[0] => 1515
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 2050
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=xokyEEMvrt4&mls=1
)
[ListPrice] => Array
(
[0] => 400000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Don’t miss this rarely available corner end unit in the Queen Tower at Queen Emma Gardens. This spacious 2 bedroom, 1 bathroom home with 1 covered parking stall has been beautifully renovated with a modern kitchen featuring stainless steel appliances, quartz countertops, new cabinets, and a stylish backsplash. Laminate wood flooring flows throughout the unit, adding a clean and contemporary feel.
Adding to its unique appeal, this was historically the one-of-a-kind unit where the original developer and resident manager resided, featuring ornate double doors that set it apart.
Take in the beautiful 20th floor city and mountain views overlooking Foster Botanical Gardens. Queen Emma Gardens is a pet-friendly community offering wonderful amenities, including Japanese-style tea-houses, swimming and wading pools, a tranquil koi pond, BBQ area, and picnic sites, all in a convenient location near downtown Honolulu, shopping, and dining. Put this on your must-see list! One or more photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 354186.00
)
[SqftTotal] => Array
(
[0] => 821
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] => Queen Emma Gardens
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => City,Coastline,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1322.30
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => mike.demello@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 201-2821
)
[ListAgentFullName] => Array
(
[0] => Michael D DeMello
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19121175
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-30T18:00:01.613
)
[ListingContractDate] => Array
(
[0] => 2025-11-19
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 18:00:01.613
)
[_thumbnail_id] => Array
(
[0] => 27224682
)
[listing_image] => Array
(
[0] => 27224682
[1] => 27224683
[2] => 27224684
[3] => 27224685
[4] => 27224686
[5] => 27224687
[6] => 27224688
[7] => 27224689
[8] => 27224690
[9] => 27224691
[10] => 27224692
[11] => 27224693
[12] => 27224694
[13] => 27224695
[14] => 27224696
[15] => 27224697
[16] => 27224698
[17] => 27224699
[18] => 27224700
[19] => 27224701
[20] => 27224702
[21] => 27224703
[22] => 27224704
[23] => 27224705
[24] => 27224706
[25] => 27224707
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 30, 2025 - 6:00 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.
