Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
1511 Nuuanu Avenue Unit 636 Honolulu, HI 96817
Listing Overview
Price: $285,000 Area: DOWNTOWN Status: Active
This Rarely available Studio unit with one covered assigned parking stall is located in the Prince Tower of Queen Emma Gardens, a highly desirable and secure property known for it's rich history and for it's lush, 8 acre park-like surroundings where tranquil living meets central convenience! Located near downtown Honolulu, shopping, dining, schools, entertainment, hospitals and freeway access & transportation. An affordable starter home or investment property. Last tenant stayed for over 11 years! Enjoy the beautiful serene paths, swimming pool and separate children's wading pool, BBQ alcove areas w/ separate charcoal grills and picnic tables, various sitting areas, two tea houses set near abundant koi ponds and beautiful birds enjoying the gardens. Truly a hidden oasis with plenty of guest parking,on site security, located near to all your needs. Remodel this unit to your taste. Unit has new interior paint throughout. To be sold "As Is". Listing by: Query Properties LLC (808) 222-0074
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202424141"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1511"
}
["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) "636"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "285000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "285000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(956) "This Rarely available Studio unit with one covered assigned parking stall is located in the Prince Tower of Queen Emma Gardens, a highly desirable and secure property known for it's rich history and for it's lush, 8 acre park-like surroundings where tranquil living meets central convenience! Located near downtown Honolulu, shopping, dining, schools, entertainment, hospitals and freeway access & transportation. An affordable starter home or investment property. Last tenant stayed for over 11 years! Enjoy the beautiful serene paths, swimming pool and separate children's wading pool, BBQ alcove areas w/ separate charcoal grills and picnic tables, various sitting areas, two tea houses set near abundant koi ponds and beautiful birds enjoying the gardens. Truly a hidden oasis with plenty of guest parking,on site security, located near to all your needs. Remodel this unit to your taste. Unit has new interior paint throughout. To be sold "As Is"."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "Query Properties LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["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) "361"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Queen Emma Gardens"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(4) "City"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "575.85"
}
["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) "QUER"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(28) "kathleen@queryproperties.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 222-0074"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Kathleen L Query"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-02T08:16:00.040"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18330718"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-17T17:01:05.387"
}
["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) "26741185"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26741185"
[1]=>
string(8) "26741186"
[2]=>
string(8) "26741187"
[3]=>
string(8) "26741188"
[4]=>
string(8) "26741189"
[5]=>
string(8) "26741190"
[6]=>
string(8) "26741191"
[7]=>
string(8) "26741192"
[8]=>
string(8) "26741193"
[9]=>
string(8) "26741194"
[10]=>
string(8) "26741195"
[11]=>
string(8) "26741196"
[12]=>
string(8) "26741197"
[13]=>
string(8) "26741198"
[14]=>
string(8) "26741199"
[15]=>
string(8) "26741200"
[16]=>
string(8) "26741201"
[17]=>
string(8) "26741202"
[18]=>
string(8) "26741203"
[19]=>
string(8) "26741204"
[20]=>
string(8) "26741205"
[21]=>
string(8) "26741206"
[22]=>
string(8) "26741207"
[23]=>
string(8) "26741208"
[24]=>
string(8) "26741209"
[25]=>
string(8) "26741210"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202424141
)
[StreetNumber] => Array
(
[0] => 1511
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 636
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 285000.00
)
[CurrentPrice] => Array
(
[0] => 285000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => This Rarely available Studio unit with one covered assigned parking stall is located in the Prince Tower of Queen Emma Gardens, a highly desirable and secure property known for it's rich history and for it's lush, 8 acre park-like surroundings where tranquil living meets central convenience! Located near downtown Honolulu, shopping, dining, schools, entertainment, hospitals and freeway access & transportation. An affordable starter home or investment property. Last tenant stayed for over 11 years! Enjoy the beautiful serene paths, swimming pool and separate children's wading pool, BBQ alcove areas w/ separate charcoal grills and picnic tables, various sitting areas, two tea houses set near abundant koi ponds and beautiful birds enjoying the gardens. Truly a hidden oasis with plenty of guest parking,on site security, located near to all your needs. Remodel this unit to your taste. Unit has new interior paint throughout. To be sold "As Is".
)
[ListOfficeName] => Array
(
[0] => Query Properties LLC
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 361
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] => Queen Emma Gardens
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City
)
[MaintenanceExpense] => Array
(
[0] => 575.85
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Royal
)
[MiddleOrJuniorSchool] => Array
(
[0] => Keelikolani
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => QUER
)
[ListAgentEmail] => Array
(
[0] => kathleen@queryproperties.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 222-0074
)
[ListAgentFullName] => Array
(
[0] => Kathleen L Query
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-02T08:16:00.040
)
[Matrix_Unique_ID] => Array
(
[0] => 18330718
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-17T17:01:05.387
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26741185
)
[listing_image] => Array
(
[0] => 26741185
[1] => 26741186
[2] => 26741187
[3] => 26741188
[4] => 26741189
[5] => 26741190
[6] => 26741191
[7] => 26741192
[8] => 26741193
[9] => 26741194
[10] => 26741195
[11] => 26741196
[12] => 26741197
[13] => 26741198
[14] => 26741199
[15] => 26741200
[16] => 26741201
[17] => 26741202
[18] => 26741203
[19] => 26741204
[20] => 26741205
[21] => 26741206
[22] => 26741207
[23] => 26741208
[24] => 26741209
[25] => 26741210
)
)
