222 Vineyard Street Unit 303 Honolulu, HI 96813

Listing
Overview

Price: $385,000
Area: DOWNTOWN
Status: Sold

Work and play! Rarely available unit in the Royal Queen Emma Condominium. A combination of residential and business use. This includes new luxury vinyl flooring in the bathroom, new carpeting in the living space, and a new range with a recently installed hood. Conveniently located near Downtown Honolulu, trendy shops, medical facilities, restaurants, and freeway access. It is a few minutes away from Safeway and Longs. Exceptional value for a spacious three bedroom unit in Honolulu, hurry and don’t miss out this rare gem! Currently being leased. Listing by: Real Broker, LLC (855) 450-0442 

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202417779"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "222"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Vineyard"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "303"
  }
  ["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) "385000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "DOWNTOWN"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(552) "Work and play! Rarely available unit in the Royal Queen Emma Condominium. A combination of residential and business use. This includes new luxury vinyl flooring in the bathroom, new carpeting in the living space, and a new range with a recently installed hood. Conveniently located near Downtown Honolulu, trendy shops, medical facilities, restaurants, and freeway access. It is a few minutes away from Safeway and Longs. Exceptional value for a spacious three bedroom unit in Honolulu, hurry and don’t miss out this rare gem! Currently being leased."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Real Broker, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "11456.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1170"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1981"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(16) "Royal Queen Emma"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "4-7"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1322.29"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "Kristinalin808@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(855) 450-0442"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Kristina Lin"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-25"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-04-27T22:55:38.443"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18187349"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(5) "Metro"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26653605"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26653605"
    [1]=>
    string(8) "26653606"
    [2]=>
    string(8) "26653607"
    [3]=>
    string(8) "26653608"
    [4]=>
    string(8) "26653609"
    [5]=>
    string(8) "26653610"
    [6]=>
    string(8) "26653611"
    [7]=>
    string(8) "26653612"
    [8]=>
    string(8) "26653613"
    [9]=>
    string(8) "26653614"
    [10]=>
    string(8) "26653615"
    [11]=>
    string(8) "26653616"
    [12]=>
    string(8) "26653617"
    [13]=>
    string(8) "26653618"
    [14]=>
    string(8) "26653619"
    [15]=>
    string(8) "26653620"
    [16]=>
    string(8) "26653621"
    [17]=>
    string(8) "26653622"
    [18]=>
    string(8) "26653623"
    [19]=>
    string(8) "26653624"
    [20]=>
    string(8) "26653625"
    [21]=>
    string(8) "26653626"
    [22]=>
    string(8) "26653627"
    [23]=>
    string(8) "26653628"
    [24]=>
    string(8) "26653629"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-08-09"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "22:55:38.443"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202417779
        )

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

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

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

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

    [UnitNumber] => Array
        (
            [0] => 303
        )

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

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

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

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

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

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

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

    [Status] => Array
        (
            [0] => Sold
        )

    [PublicRemarks] => Array
        (
            [0] => Work and play! Rarely available unit in the Royal Queen Emma Condominium. A combination of residential and business use. This includes new luxury vinyl flooring in the bathroom, new carpeting in the living space, and a new range with a recently installed hood. Conveniently located near Downtown Honolulu, trendy shops, medical facilities, restaurants, and freeway access. It is a few minutes away from Safeway and Longs. Exceptional value for a spacious three bedroom unit in Honolulu, hurry and don’t miss out this rare gem! Currently being leased.
        )

    [ListOfficeName] => Array
        (
            [0] => Real Broker, LLC
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Royal Queen Emma
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

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

    [StoriesType] => Array
        (
            [0] => 4-7
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Kristinalin808@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (855) 450-0442
        )

    [ListAgentFullName] => Array
        (
            [0] => Kristina Lin
        )

    [CloseDate] => Array
        (
            [0] => 2025-04-25
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-04-27T22:55:38.443
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26653605
            [1] => 26653606
            [2] => 26653607
            [3] => 26653608
            [4] => 26653609
            [5] => 26653610
            [6] => 26653611
            [7] => 26653612
            [8] => 26653613
            [9] => 26653614
            [10] => 26653615
            [11] => 26653616
            [12] => 26653617
            [13] => 26653618
            [14] => 26653619
            [15] => 26653620
            [16] => 26653621
            [17] => 26653622
            [18] => 26653623
            [19] => 26653624
            [20] => 26653625
            [21] => 26653626
            [22] => 26653627
            [23] => 26653628
            [24] => 26653629
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-08-09
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 22:55:38.443
        )

)

  • BedsTotal: 3
  • Full Baths: 2
  • Land Area (sf): 11,456 sf
  • Living (sf): 1,170
  • Year Built: 1981
  • Building Name: Royal Queen Emma

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: Mountain
  • Listing Office: Real Broker, LLC

  • Maintenance Fees: $1,322
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on April 27, 2025 - 10:55 PM Information is deemed reliable but not guaranteed. Copyright: 2025 by HiCentral MLS, Ltd.
Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.