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.
