225 Queen Street Unit 9G Honolulu, HI 96813

Listing
Overview

Price: $457,500
Area: DOWNTOWN
Status: Active Under Contract

Be a part of the downtown renaissance! Welcome to Harbor Square, your urban oasis in downtown Honolulu. This beautifully renovated and fully furnished 2/2 corner end unit is truly turnkey. Every part of the unit was touched during the 2022 renovation, from the smooth ceilings to the luxury vinyl plank flooring, all new modern light fixtures, and new central AC and electric panel. Other features include an open kitchen with eat in counter, all new cabinetry, Samsung appliances and TV, closet organizers, and adjustable beds in both bedrooms. Floor to ceiling windows bathe the unit in natural light, and you can enjoy the cityscape and harbor view from the spacious lanai. A storage locker just down the hall is included for your convenience. Building amenities include a pool, barbecue area, community laundry on premises, and 24 hour security. HOA fee covers ALL utilities including cable and internet. With everything you need within walking distance, this prime location offers the perfect blend of work, play, and relaxation. For those that need it, on-site parking is available for rent. Don't miss the opportunity to own this stunning condo in Honolulu--an incredible value! Listing by: Coldwell Banker Realty (808) 738-3904

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202418801"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "225"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(5) "Queen"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(2) "9G"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96813"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "457500.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "457500.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "DOWNTOWN"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1185) "Be a part of the downtown renaissance! Welcome to Harbor Square, your urban oasis in downtown Honolulu. This beautifully renovated and fully furnished 2/2 corner end unit is truly turnkey. Every part of the unit was touched during the 2022 renovation, from the smooth ceilings to the luxury vinyl plank flooring, all new modern light fixtures, and new central AC and electric panel. Other features include an open kitchen with eat in counter, all new cabinetry, Samsung appliances and TV, closet organizers, and adjustable beds in both bedrooms. Floor to ceiling windows bathe the unit in natural light, and you can enjoy the cityscape and harbor view from the spacious lanai. A storage locker just down the hall is included for your convenience. Building amenities include a pool, barbecue area, community laundry on premises, and 24 hour security. HOA fee covers ALL utilities including cable and internet. With everything you need within walking distance, this prime location offers the perfect blend of work, play, and relaxation. For those that need it, on-site parking is available for rent. Don't miss the opportunity to own this stunning condo in Honolulu--an incredible value!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "67910.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "740"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1971"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(13) "Harbor Square"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "21+"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "City"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1167.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(6) "CBPP02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "LaurieM@cbpacific.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 738-3904"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Laurie Chang Murphy"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-26T15:42:22.720"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18216518"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-08-28T10:36:01.270"
  }
  ["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) "26674457"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26674457"
    [1]=>
    string(8) "26674458"
    [2]=>
    string(8) "26674459"
    [3]=>
    string(8) "26674460"
    [4]=>
    string(8) "26674461"
    [5]=>
    string(8) "26674462"
    [6]=>
    string(8) "26674463"
    [7]=>
    string(8) "26674464"
    [8]=>
    string(8) "26674465"
    [9]=>
    string(8) "26674466"
    [10]=>
    string(8) "26674467"
    [11]=>
    string(8) "26674468"
    [12]=>
    string(8) "26674469"
    [13]=>
    string(8) "26674470"
    [14]=>
    string(8) "26674471"
    [15]=>
    string(8) "26674472"
    [16]=>
    string(8) "26674473"
    [17]=>
    string(8) "26674474"
    [18]=>
    string(8) "26674475"
    [19]=>
    string(8) "26674476"
    [20]=>
    string(8) "26674477"
    [21]=>
    string(8) "26674478"
    [22]=>
    string(8) "26674479"
    [23]=>
    string(8) "26674480"
    [24]=>
    string(8) "26674481"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202418801
        )

    [StreetNumber] => Array
        (
            [0] => 225
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Queen
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 9G
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96813
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 457500.00
        )

    [CurrentPrice] => Array
        (
            [0] => 457500.00
        )

    [Neighbourhood] => Array
        (
            [0] => DOWNTOWN
        )

    [Status] => Array
        (
            [0] => Active Under Contract
        )

    [PublicRemarks] => Array
        (
            [0] => Be a part of the downtown renaissance! Welcome to Harbor Square, your urban oasis in downtown Honolulu. This beautifully renovated and fully furnished 2/2 corner end unit is truly turnkey. Every part of the unit was touched during the 2022 renovation, from the smooth ceilings to the luxury vinyl plank flooring, all new modern light fixtures, and new central AC and electric panel. Other features include an open kitchen with eat in counter, all new cabinetry, Samsung appliances and TV, closet organizers, and adjustable beds in both bedrooms. Floor to ceiling windows bathe the unit in natural light, and you can enjoy the cityscape and harbor view from the spacious lanai. A storage locker just down the hall is included for your convenience. Building amenities include a pool, barbecue area, community laundry on premises, and 24 hour security. HOA fee covers ALL utilities including cable and internet. With everything you need within walking distance, this prime location offers the perfect blend of work, play, and relaxation. For those that need it, on-site parking is available for rent. Don't miss the opportunity to own this stunning condo in Honolulu--an incredible value!
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [BedsTotal] => Array
        (
            [0] => 2
        )

    [BathsFull] => Array
        (
            [0] => 2
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 67910.00
        )

    [SqftTotal] => Array
        (
            [0] => 740
        )

    [YearBuilt] => Array
        (
            [0] => 1971
        )

    [BuildingName] => Array
        (
            [0] => Harbor Square
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

    [ParkingTotal] => Array
        (
            [0] => 0
        )

    [StoriesType] => Array
        (
            [0] => 21+
        )

    [View] => Array
        (
            [0] => City
        )

    [MaintenanceExpense] => Array
        (
            [0] => 1167.00
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Royal
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => Keelikolani
        )

    [HighSchool] => Array
        (
            [0] => Mckinley
        )

    [ListOfficeMLSID] => Array
        (
            [0] => CBPP02
        )

    [ListAgentEmail] => Array
        (
            [0] => LaurieM@cbpacific.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 738-3904
        )

    [ListAgentFullName] => Array
        (
            [0] => Laurie Chang Murphy
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-26T15:42:22.720
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18216518
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-08-28T10:36:01.270
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26674457
        )

    [listing_image] => Array
        (
            [0] => 26674457
            [1] => 26674458
            [2] => 26674459
            [3] => 26674460
            [4] => 26674461
            [5] => 26674462
            [6] => 26674463
            [7] => 26674464
            [8] => 26674465
            [9] => 26674466
            [10] => 26674467
            [11] => 26674468
            [12] => 26674469
            [13] => 26674470
            [14] => 26674471
            [15] => 26674472
            [16] => 26674473
            [17] => 26674474
            [18] => 26674475
            [19] => 26674476
            [20] => 26674477
            [21] => 26674478
            [22] => 26674479
            [23] => 26674480
            [24] => 26674481
        )

)

  • BedsTotal: 2
  • Full Baths: 2
  • Land Area (sf): 67,910
  • Living (sf): 740
  • Year Built: 1971
  • Building Name: Harbor Square

  • Property Condition: Excellent
  • View: City
  • Listing Office: Coldwell Banker Realty

  • Maintenance Fees: $1,167
  • 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