Listing
Overview
Price: $399,000
Area: DOWNTOWN
Status: Active
The well-kept and secure Queen Emma Gardens is home to this two bedroom, one bathroom condo. It has been recently renovated and now features quartz countertops, soft close drawers and cabinets, energy saving LED light fixtures, and beautiful plank floors, among other upgrades. Breezy and bright, this cozy condo makes a great home for owners or renters. The building is pet friendly and features magnificent amenities, Including a walking path, a stream complete with koi, two pools, a playground, barbecues area, and serene tea rooms for residents use. Additionally, 5 guest parking spots are available per unit. Conveniently located at the edge of Downtown, moments from Pali Highway and the H-1 Freeway. Lots of local shopping and dining nearby, too! Listing by: eXp Realty (808) 725-2794
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202321359"
}
["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(3) "153"
}
["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(54) "https://shoots.styronphoto.com/sites/dvzlwgq/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "399000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "399000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(754) "The well-kept and secure Queen Emma Gardens is home to this two bedroom, one bathroom condo. It has been recently renovated and now features quartz countertops, soft close drawers and cabinets, energy saving LED light fixtures, and beautiful plank floors, among other upgrades. Breezy and bright, this cozy condo makes a great home for owners or renters. The building is pet friendly and features magnificent amenities, Including a walking path, a stream complete with koi, two pools, a playground, barbecues area, and serene tea rooms for residents use. Additionally, 5 guest parking spots are available per unit. Conveniently located at the edge of Downtown, moments from Pali Highway and the H-1 Freeway. Lots of local shopping and dining nearby, too!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "eXp Realty"
}
["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(9) "354186.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "734"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Queen Emma Gardens"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "City"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1063.93"
}
["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(9) "Roosevelt"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "EXPI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "jasmine@hihomegroup.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 725-2794"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Jasmine Bell"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-02-20T13:15:01.740"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17569791"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-09-19T07:00:33.220"
}
["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) "25960701"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "25960701"
[1]=>
string(8) "25960702"
[2]=>
string(8) "25960703"
[3]=>
string(8) "25960704"
[4]=>
string(8) "25960705"
[5]=>
string(8) "25960706"
[6]=>
string(8) "25960707"
[7]=>
string(8) "25960708"
[8]=>
string(8) "25960709"
[9]=>
string(8) "25960710"
[10]=>
string(8) "25960711"
[11]=>
string(8) "25960712"
[12]=>
string(8) "25960713"
[13]=>
string(8) "25960714"
[14]=>
string(8) "25960715"
[15]=>
string(8) "25960716"
[16]=>
string(8) "25960717"
[17]=>
string(8) "25960718"
[18]=>
string(8) "25960719"
[19]=>
string(8) "25960720"
[20]=>
string(8) "25960721"
[21]=>
string(8) "25960722"
[22]=>
string(8) "25960723"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202321359
)
[StreetNumber] => Array
(
[0] => 1515
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 153
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://shoots.styronphoto.com/sites/dvzlwgq/unbranded
)
[ListPrice] => Array
(
[0] => 399000.00
)
[CurrentPrice] => Array
(
[0] => 399000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => The well-kept and secure Queen Emma Gardens is home to this two bedroom, one bathroom condo. It has been recently renovated and now features quartz countertops, soft close drawers and cabinets, energy saving LED light fixtures, and beautiful plank floors, among other upgrades. Breezy and bright, this cozy condo makes a great home for owners or renters. The building is pet friendly and features magnificent amenities, Including a walking path, a stream complete with koi, two pools, a playground, barbecues area, and serene tea rooms for residents use. Additionally, 5 guest parking spots are available per unit. Conveniently located at the edge of Downtown, moments from Pali Highway and the H-1 Freeway. Lots of local shopping and dining nearby, too!
)
[ListOfficeName] => Array
(
[0] => eXp Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 354186.00
)
[SqftTotal] => Array
(
[0] => 734
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] => Queen Emma Gardens
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City
)
[MaintenanceExpense] => Array
(
[0] => 1063.93
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Royal
)
[MiddleOrJuniorSchool] => Array
(
[0] => Keelikolani
)
[HighSchool] => Array
(
[0] => Roosevelt
)
[ListOfficeMLSID] => Array
(
[0] => EXPI
)
[ListAgentEmail] => Array
(
[0] => jasmine@hihomegroup.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 725-2794
)
[ListAgentFullName] => Array
(
[0] => Jasmine Bell
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-02-20T13:15:01.740
)
[Matrix_Unique_ID] => Array
(
[0] => 17569791
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-09-19T07:00:33.220
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25960701
)
[listing_image] => Array
(
[0] => 25960701
[1] => 25960702
[2] => 25960703
[3] => 25960704
[4] => 25960705
[5] => 25960706
[6] => 25960707
[7] => 25960708
[8] => 25960709
[9] => 25960710
[10] => 25960711
[11] => 25960712
[12] => 25960713
[13] => 25960714
[14] => 25960715
[15] => 25960716
[16] => 25960717
[17] => 25960718
[18] => 25960719
[19] => 25960720
[20] => 25960721
[21] => 25960722
[22] => 25960723
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 354,186
- Living (sf): 734
- Year Built: 1963
- Building Name: Queen Emma Gardens
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 1
- View: City
- Listing Office: eXp Realty
- Maintenance Fees: $1,064
- Land Tenure: FS - Fee Simple
- Elementary School: Royal
- Middle School: Keelikolani
- High School: Roosevelt
