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". Note Listing Agent is also Owner. 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(991) "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".  Note Listing Agent is also Owner."
  }
  ["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-10-31T13:23:08.787"
  }
  ["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".  Note Listing Agent is also Owner.
        )

    [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-10-31T13:23:08.787
        )

    [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
        )

)

  • Full Baths: 1
  • Living (sf): 361
  • Year Built: 1963
  • Building Name: Queen Emma Gardens

  • Property Condition: Average
  • Number of Parking Spaces: 1
  • View: City
  • Listing Office: Query Properties LLC

  • Maintenance Fees: $576
  • Land Tenure: FS - Fee Simple

  • Elementary School: Royal
  • Middle School: Keelikolani
  • High School: Mckinley

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446