Listing
Overview
Price: $365,000
Area: DOWNTOWN
Status: Active
Great price reduction today! Don’t miss your chance to own this high floor and beautifully remodeled 1 bed/1 bath/1 covered parking unit nestled in the Heart of Honolulu. This Queen Tower unit offers a new open floor plan, new kitchen with crown molding, quartz counter tops, service island, new appliances, new vinyl plank flooring, fresh paint. Enjoy the abundance of amenities throughout this tropical garden complex offering a pet friendly environment with BBQ areas, swimming pool, wading pool, playground, walking paths, guest parking, & renovated Tea Houses overlooking Koi pond for private functions. The convenience of this location is unmatched and the management of Queen Emma Gardens is top notch! Call your Agent to see today ~ easy to show! Listing by: Kang Realty LLC (808) 951-5264
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202412177"
}
["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) "2054"
}
["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(42) "http://www.hirephoto.com/qeg2054/slideshow"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "365000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "365000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(757) "Great price reduction today! Don’t miss your chance to own this high floor and beautifully remodeled 1 bed/1 bath/1 covered parking unit nestled in the Heart of Honolulu. This Queen Tower unit offers a new open floor plan, new kitchen with crown molding, quartz counter tops, service island, new appliances, new vinyl plank flooring, fresh paint. Enjoy the abundance of amenities throughout this tropical garden complex offering a pet friendly environment with BBQ areas, swimming pool, wading pool, playground, walking paths, guest parking, & renovated Tea Houses overlooking Koi pond for private functions. The convenience of this location is unmatched and the management of Queen Emma Gardens is top notch! Call your Agent to see today ~ easy to show!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(15) "Kang Realty LLC"
}
["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(9) "354186.00"
}
["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(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(33) "City,Garden,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "915.00"
}
["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) "YKAN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "sondrabarino@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 951-5264"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Sondra Barino"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-01T07:18:01.127"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18031810"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-07T08:34:36.473"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26571352"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "26571352"
[1]=>
string(8) "26571353"
[2]=>
string(8) "26571354"
[3]=>
string(8) "26571355"
[4]=>
string(8) "26571356"
[5]=>
string(8) "26571357"
[6]=>
string(8) "26571358"
[7]=>
string(8) "26571359"
[8]=>
string(8) "26571360"
[9]=>
string(8) "26571361"
[10]=>
string(8) "26571362"
[11]=>
string(8) "26571363"
[12]=>
string(8) "26571364"
[13]=>
string(8) "26571365"
[14]=>
string(8) "26571366"
[15]=>
string(8) "26571367"
[16]=>
string(8) "26571368"
[17]=>
string(8) "26571369"
[18]=>
string(8) "26571370"
[19]=>
string(8) "26571371"
[20]=>
string(8) "26571372"
[21]=>
string(8) "26571373"
[22]=>
string(8) "26571374"
[23]=>
string(8) "26571375"
[24]=>
string(8) "26571376"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202412177
)
[StreetNumber] => Array
(
[0] => 1515
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 2054
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => http://www.hirephoto.com/qeg2054/slideshow
)
[ListPrice] => Array
(
[0] => 365000.00
)
[CurrentPrice] => Array
(
[0] => 365000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Great price reduction today! Don’t miss your chance to own this high floor and beautifully remodeled 1 bed/1 bath/1 covered parking unit nestled in the Heart of Honolulu. This Queen Tower unit offers a new open floor plan, new kitchen with crown molding, quartz counter tops, service island, new appliances, new vinyl plank flooring, fresh paint. Enjoy the abundance of amenities throughout this tropical garden complex offering a pet friendly environment with BBQ areas, swimming pool, wading pool, playground, walking paths, guest parking, & renovated Tea Houses overlooking Koi pond for private functions. The convenience of this location is unmatched and the management of Queen Emma Gardens is top notch! Call your Agent to see today ~ easy to show!
)
[ListOfficeName] => Array
(
[0] => Kang Realty LLC
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 354186.00
)
[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] => 21+
)
[View] => Array
(
[0] => City,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 915.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Royal
)
[MiddleOrJuniorSchool] => Array
(
[0] => Keelikolani
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => YKAN
)
[ListAgentEmail] => Array
(
[0] => sondrabarino@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 951-5264
)
[ListAgentFullName] => Array
(
[0] => Sondra Barino
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-01T07:18:01.127
)
[Matrix_Unique_ID] => Array
(
[0] => 18031810
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-07T08:34:36.473
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26571352
)
[listing_image] => Array
(
[0] => 26571352
[1] => 26571353
[2] => 26571354
[3] => 26571355
[4] => 26571356
[5] => 26571357
[6] => 26571358
[7] => 26571359
[8] => 26571360
[9] => 26571361
[10] => 26571362
[11] => 26571363
[12] => 26571364
[13] => 26571365
[14] => 26571366
[15] => 26571367
[16] => 26571368
[17] => 26571369
[18] => 26571370
[19] => 26571371
[20] => 26571372
[21] => 26571373
[22] => 26571374
[23] => 26571375
[24] => 26571376
)
)
- BedsTotal: 1
- Full Baths: 1
- Land Area (sf): 354,186
- Living (sf): 574
- Year Built: 1963
- Building Name: Queen Emma Gardens
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: City,Garden,Mountain,Ocean,Sunset
- Listing Office: Kang Realty LLC
- Maintenance Fees: $915
- Land Tenure: FS - Fee Simple
- Elementary School: Royal
- Middle School: Keelikolani
- High School: Mckinley