The office will be closed on Friday, July 4th, in observance of Independence Day and will re-open on Monday.
Listing Overview
Price: $335,000
Area: DOWNTOWN
Status: Active
100% Hurricane Insurance Covered!! Nicely renovated High Floor in Desirable Queen Tower, breathtaking DH and partial ocean view. Spacious 1/1 with 1 covered parking. Pet friendly (verify). Enjoy secured 8-acres well maintained garden with 8 BBQ areas, jogging/walking path, Dog walking with dog waste bins, 2 pools including kiddie pool, 2 of Tea Houses are available for social occasions, with bathrooms, full kitchen, tables and chairs. Nice Koi Pond, birds gathering peacefully. Super convenient location, walking distance to Downtown Business District, Nice upscale restaurants and enjoy First Friday art district, Chinatown for shopping. Safeway/Longs Drugs are just across, Starbucks, Poke store, Local restaurants are also across. Queens Medical Center, Kuakini Hospital are only couple blocks away. Close to H-1 Freeway entrance both East and West bound. You will enjoy the sophisticated property. Don’t miss this Gem-like life. Listing by: Savio Realty Ltd. (808) 864-1500
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202412627"
}
["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) "2155"
}
["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(35) "https://view.property/2251315?idx=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "335000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(939) "100% Hurricane Insurance Covered!! Nicely renovated High Floor in Desirable Queen Tower, breathtaking DH and partial ocean view. Spacious 1/1 with 1 covered parking. Pet friendly (verify). Enjoy secured 8-acres well maintained garden with 8 BBQ areas, jogging/walking path, Dog walking with dog waste bins, 2 pools including kiddie pool, 2 of Tea Houses are available for social occasions, with bathrooms, full kitchen, tables and chairs. Nice Koi Pond, birds gathering peacefully. Super convenient location, walking distance to Downtown Business District, Nice upscale restaurants and enjoy First Friday art district, Chinatown for shopping. Safeway/Longs Drugs are just across, Starbucks, Poke store, Local restaurants are also across. Queens Medical Center, Kuakini Hospital are only couple blocks away. Close to H-1 Freeway entrance both East and West bound. You will enjoy the sophisticated property. Don’t miss this Gem-like life."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Savio Realty Ltd."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "574"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Queen Emma Gardens"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(17) "City,Diamond Head"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1067.48"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(5) "Royal"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(11) "Keelikolani"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mckinley"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "HIHL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(16) "barryk@savio.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 864-1500"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Barry D Kaplan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-05-06T10:48:06.420"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18043842"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26571230"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26571230"
[1]=>
string(8) "26571231"
[2]=>
string(8) "26571232"
[3]=>
string(8) "26571233"
[4]=>
string(8) "26571234"
[5]=>
string(8) "26571235"
[6]=>
string(8) "26571236"
[7]=>
string(8) "26571237"
[8]=>
string(8) "26571238"
[9]=>
string(8) "26571239"
[10]=>
string(8) "26571240"
[11]=>
string(8) "26571241"
[12]=>
string(8) "26571242"
[13]=>
string(8) "26571243"
[14]=>
string(8) "26571244"
[15]=>
string(8) "26571245"
[16]=>
string(8) "26571246"
[17]=>
string(8) "26571247"
[18]=>
string(8) "26571248"
[19]=>
string(8) "26571249"
[20]=>
string(8) "26571250"
[21]=>
string(8) "26571251"
[22]=>
string(8) "26571252"
[23]=>
string(8) "26571253"
[24]=>
string(8) "26571254"
[25]=>
string(8) "26571255"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-06-07"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "10:48:06.420"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202412627
)
[StreetNumber] => Array
(
[0] => 1515
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 2155
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://view.property/2251315?idx=1
)
[ListPrice] => Array
(
[0] => 335000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => 100% Hurricane Insurance Covered!! Nicely renovated High Floor in Desirable Queen Tower, breathtaking DH and partial ocean view. Spacious 1/1 with 1 covered parking. Pet friendly (verify). Enjoy secured 8-acres well maintained garden with 8 BBQ areas, jogging/walking path, Dog walking with dog waste bins, 2 pools including kiddie pool, 2 of Tea Houses are available for social occasions, with bathrooms, full kitchen, tables and chairs. Nice Koi Pond, birds gathering peacefully. Super convenient location, walking distance to Downtown Business District, Nice upscale restaurants and enjoy First Friday art district, Chinatown for shopping. Safeway/Longs Drugs are just across, Starbucks, Poke store, Local restaurants are also across. Queens Medical Center, Kuakini Hospital are only couple blocks away. Close to H-1 Freeway entrance both East and West bound. You will enjoy the sophisticated property. Don’t miss this Gem-like life.
)
[ListOfficeName] => Array
(
[0] => Savio Realty Ltd.
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 574
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] => Queen Emma Gardens
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City,Diamond Head
)
[MaintenanceExpense] => Array
(
[0] => 1067.48
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Royal
)
[MiddleOrJuniorSchool] => Array
(
[0] => Keelikolani
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => HIHL
)
[ListAgentEmail] => Array
(
[0] => barryk@savio.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 864-1500
)
[ListAgentFullName] => Array
(
[0] => Barry D Kaplan
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-05-06T10:48:06.420
)
[Matrix_Unique_ID] => Array
(
[0] => 18043842
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26571230
)
[listing_image] => Array
(
[0] => 26571230
[1] => 26571231
[2] => 26571232
[3] => 26571233
[4] => 26571234
[5] => 26571235
[6] => 26571236
[7] => 26571237
[8] => 26571238
[9] => 26571239
[10] => 26571240
[11] => 26571241
[12] => 26571242
[13] => 26571243
[14] => 26571244
[15] => 26571245
[16] => 26571246
[17] => 26571247
[18] => 26571248
[19] => 26571249
[20] => 26571250
[21] => 26571251
[22] => 26571252
[23] => 26571253
[24] => 26571254
[25] => 26571255
)
[ListingContractDate] => Array
(
[0] => 2024-06-07
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 10:48:06.420
)
)
BedsTotal: 1
Full Baths: 1
Living (sf): 574
Year Built: 1963
Building Name: Queen Emma Gardens
Property Condition: Above Average
Number of Parking Spaces: 1
View: City,Diamond Head
Listing Office: Savio Realty Ltd.
Maintenance Fees: $1,067
Land Tenure: FS - Fee Simple
Elementary School: Royal
Middle School: Keelikolani
High School: Mckinley
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on May 6, 2025 - 10:48 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.
© Marcus Realty. All Rights Reserved.