Listing
Overview
Price: $349,000
Area: DOWNTOWN
Status: Active
Desirable Queen Tower, breathtaking DH and partial ocean view. Fully remodeled in 2024. 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(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202412571"
}
["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) "2355"
}
["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/2250510?idx=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "349000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "349000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(898) "Desirable Queen Tower, breathtaking DH and partial ocean view. Fully remodeled in 2024. 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(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(17) "City,Diamond Head"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "915.58"
}
["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) "2024-08-01T20:00:42.260"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18042168"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-07T07:46:51.060"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26571203"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26571203"
[1]=>
string(8) "26571204"
[2]=>
string(8) "26571205"
[3]=>
string(8) "26571206"
[4]=>
string(8) "26571207"
[5]=>
string(8) "26571208"
[6]=>
string(8) "26571209"
[7]=>
string(8) "26571210"
[8]=>
string(8) "26571211"
[9]=>
string(8) "26571212"
[10]=>
string(8) "26571213"
[11]=>
string(8) "26571214"
[12]=>
string(8) "26571215"
[13]=>
string(8) "26571216"
[14]=>
string(8) "26571217"
[15]=>
string(8) "26571218"
[16]=>
string(8) "26571219"
[17]=>
string(8) "26571220"
[18]=>
string(8) "26571221"
[19]=>
string(8) "26571222"
[20]=>
string(8) "26571223"
[21]=>
string(8) "26571224"
[22]=>
string(8) "26571225"
[23]=>
string(8) "26571226"
[24]=>
string(8) "26571227"
[25]=>
string(8) "26571228"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202412571
)
[StreetNumber] => Array
(
[0] => 1515
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 2355
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://view.property/2250510?idx=1
)
[ListPrice] => Array
(
[0] => 349000.00
)
[CurrentPrice] => Array
(
[0] => 349000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Desirable Queen Tower, breathtaking DH and partial ocean view. Fully remodeled in 2024. 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] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City,Diamond Head
)
[MaintenanceExpense] => Array
(
[0] => 915.58
)
[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] => 2024-08-01T20:00:42.260
)
[Matrix_Unique_ID] => Array
(
[0] => 18042168
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-07T07:46:51.060
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26571203
)
[listing_image] => Array
(
[0] => 26571203
[1] => 26571204
[2] => 26571205
[3] => 26571206
[4] => 26571207
[5] => 26571208
[6] => 26571209
[7] => 26571210
[8] => 26571211
[9] => 26571212
[10] => 26571213
[11] => 26571214
[12] => 26571215
[13] => 26571216
[14] => 26571217
[15] => 26571218
[16] => 26571219
[17] => 26571220
[18] => 26571221
[19] => 26571222
[20] => 26571223
[21] => 26571224
[22] => 26571225
[23] => 26571226
[24] => 26571227
[25] => 26571228
)
)
- BedsTotal: 1
- Full Baths: 1
- Living (sf): 574
- Year Built: 1963
- Building Name: Queen Emma Gardens
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Diamond Head
- Listing Office: Savio Realty Ltd.
- Maintenance Fees: $916
- Land Tenure: FS - Fee Simple
- Elementary School: Royal
- Middle School: Keelikolani
- High School: Mckinley
