Listing
Overview
Price: $435,000
Area: DOWNTOWN
Status: Active
Open House Sunday 8/11, 2:00-5:00PM. Beautifully upgraded, spacious 2 BR/1 BATH unit on the high floor of the Queen Tower facing Diamond Head, with large lanai and rarely available 1 covered parking. Enjoy spectacular views of Honolulu, with a partial ocean view by day, city lights at night and Hilton Hotel fireworks every Friday! Beautifully landscaped and well-maintained 8-acre gardens, with koi ponds, BBQ grills, swimming pools (adult and kiddie), children’s play areas, lawns and walking/jogging paths. Two tea houses with kitchen and bathroom can be reserved on request for large gatherings and celebrations. Pet friendly (verify). Community laundry rooms, meeting room and mini-library are available to all residents. Security office equipped with closed-circuit cameras is staffed 24/7 for safety of residents. Super convenient location, just a few blocks from Chinatown, Downtown Business District, Foster Botanical Garden, shopping (Safeway, Longs, and Starbucks just across the street), medical care (Queens Hospital, Kuakini Medical Center), and freeway entrances going in both directions. Must See!! Listing by: Savio Realty Ltd. (808) 864-1500
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202415116"
}
["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) "2051"
}
["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/2258643?idx=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "435000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "435000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1117) "Open House Sunday 8/11, 2:00-5:00PM. Beautifully upgraded, spacious 2 BR/1 BATH unit on the high floor of the Queen Tower facing Diamond Head, with large lanai and rarely available 1 covered parking. Enjoy spectacular views of Honolulu, with a partial ocean view by day, city lights at night and Hilton Hotel fireworks every Friday! Beautifully landscaped and well-maintained 8-acre gardens, with koi ponds, BBQ grills, swimming pools (adult and kiddie), children’s play areas, lawns and walking/jogging paths. Two tea houses with kitchen and bathroom can be reserved on request for large gatherings and celebrations. Pet friendly (verify). Community laundry rooms, meeting room and mini-library are available to all residents. Security office equipped with closed-circuit cameras is staffed 24/7 for safety of residents. Super convenient location, just a few blocks from Chinatown, Downtown Business District, Foster Botanical Garden, shopping (Safeway, Longs, and Starbucks just across the street), medical care (Queens Hospital, Kuakini Medical Center), and freeway entrances going in both directions. Must See!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Savio Realty Ltd."
}
["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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "785"
}
["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(5) "15-20"
}
["View"]=>
array(1) {
[0]=>
string(27) "City,Coastline,Diamond Head"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1251.91"
}
["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-09-25T18:45:01.630"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18100646"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-20T15:31:55.453"
}
["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) "26630090"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26630090"
[1]=>
string(8) "26630091"
[2]=>
string(8) "26630092"
[3]=>
string(8) "26630093"
[4]=>
string(8) "26630094"
[5]=>
string(8) "26630095"
[6]=>
string(8) "26630096"
[7]=>
string(8) "26630097"
[8]=>
string(8) "26630098"
[9]=>
string(8) "26630099"
[10]=>
string(8) "26630100"
[11]=>
string(8) "26630101"
[12]=>
string(8) "26630102"
[13]=>
string(8) "26630103"
[14]=>
string(8) "26630104"
[15]=>
string(8) "26630105"
[16]=>
string(8) "26630106"
[17]=>
string(8) "26630107"
[18]=>
string(8) "26630108"
[19]=>
string(8) "26630109"
[20]=>
string(8) "26630110"
[21]=>
string(8) "26630111"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202415116
)
[StreetNumber] => Array
(
[0] => 1515
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 2051
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://view.property/2258643?idx=1
)
[ListPrice] => Array
(
[0] => 435000.00
)
[CurrentPrice] => Array
(
[0] => 435000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Open House Sunday 8/11, 2:00-5:00PM. Beautifully upgraded, spacious 2 BR/1 BATH unit on the high floor of the Queen Tower facing Diamond Head, with large lanai and rarely available 1 covered parking. Enjoy spectacular views of Honolulu, with a partial ocean view by day, city lights at night and Hilton Hotel fireworks every Friday! Beautifully landscaped and well-maintained 8-acre gardens, with koi ponds, BBQ grills, swimming pools (adult and kiddie), children’s play areas, lawns and walking/jogging paths. Two tea houses with kitchen and bathroom can be reserved on request for large gatherings and celebrations. Pet friendly (verify). Community laundry rooms, meeting room and mini-library are available to all residents. Security office equipped with closed-circuit cameras is staffed 24/7 for safety of residents. Super convenient location, just a few blocks from Chinatown, Downtown Business District, Foster Botanical Garden, shopping (Safeway, Longs, and Starbucks just across the street), medical care (Queens Hospital, Kuakini Medical Center), and freeway entrances going in both directions. Must See!!
)
[ListOfficeName] => Array
(
[0] => Savio Realty Ltd.
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 785
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] => Queen Emma Gardens
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 15-20
)
[View] => Array
(
[0] => City,Coastline,Diamond Head
)
[MaintenanceExpense] => Array
(
[0] => 1251.91
)
[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-09-25T18:45:01.630
)
[Matrix_Unique_ID] => Array
(
[0] => 18100646
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-20T15:31:55.453
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26630090
)
[listing_image] => Array
(
[0] => 26630090
[1] => 26630091
[2] => 26630092
[3] => 26630093
[4] => 26630094
[5] => 26630095
[6] => 26630096
[7] => 26630097
[8] => 26630098
[9] => 26630099
[10] => 26630100
[11] => 26630101
[12] => 26630102
[13] => 26630103
[14] => 26630104
[15] => 26630105
[16] => 26630106
[17] => 26630107
[18] => 26630108
[19] => 26630109
[20] => 26630110
[21] => 26630111
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 785
- Year Built: 1963
- Building Name: Queen Emma Gardens
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Coastline,Diamond Head
- Listing Office: Savio Realty Ltd.
- Maintenance Fees: $1,252
- Land Tenure: FS - Fee Simple
- Elementary School: Royal
- Middle School: Keelikolani
- High School: Mckinley
