Listing
Overview
Price: $379,000
Area: DOWNTOWN
Status: Active
Huge Price reduction!! Open House Sun 2/2 2-5pm. 100% Hurricane Insurance Covered!! 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!! MF is effective Jan. 1, 2025. Listing by: Savio Realty Ltd. (808) 864-1500
array(48) {
["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) "379000.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(1194) "Huge Price reduction!! Open House Sun 2/2 2-5pm. 100% Hurricane Insurance Covered!! 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!! MF is effective Jan. 1, 2025."
}
["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) "1459.61"
}
["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-02-02T17:00:01.510"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18100646"
}
["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) "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"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-07-20"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.510"
}
}
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] => 379000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Huge Price reduction!! Open House Sun 2/2 2-5pm. 100% Hurricane Insurance Covered!! 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!! MF is effective Jan. 1, 2025.
)
[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] => 1459.61
)
[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-02-02T17:00:01.510
)
[Matrix_Unique_ID] => Array
(
[0] => 18100646
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_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
)
[ListingContractDate] => Array
(
[0] => 2024-07-20
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.510
)
)
- 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,460
- 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 February 2, 2025 - 5: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.
© Marcus Realty. All Rights Reserved.
