Listing
Overview
Price: $675,000
Area: DOWNTOWN
Status: Active
Space is currently configured as a large office with storage, conference rooms and reception area. Building is BMX zoning, so residential or office use. PH-3 and PH-4 were combined into 1 large, 2,438 sq ft space with all office furniture, partitions and equipment as seen, included. To be sold together with MLS 202518474 (PH-4) - asking cumulative $1.4m. Reconfigure... live on one side, work on the other.... Each unit has 2 parking, total contiguous 4 stalls. Owner rented additional parking from nearby St Andrews school/church for staff. Simple, no amenities project with quiet street front across from the Pacific Club. Vineyard St is off of Queen Emma St and runs parallel with Vineyard Blvd - right behind the gas station. Attractive building for either residential or office usage. Listing by: REMAX Hawaii (808) 384-1875
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202518471"
}
["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) "PH3"
}
["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(60) "https://my.matterport.com/show/?m=6WbCxU3JxUd&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "675000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(799) "Space is currently configured as a large office with storage, conference rooms and reception area. Building is BMX zoning, so residential or office use. PH-3 and PH-4 were combined into 1 large, 2,438 sq ft space with all office furniture, partitions and equipment as seen, included. To be sold together with MLS 202518474 (PH-4) - asking cumulative $1.4m. Reconfigure... live on one side, work on the other.... Each unit has 2 parking, total contiguous 4 stalls. Owner rented additional parking from nearby St Andrews school/church for staff. Simple, no amenities project with quiet street front across from the Pacific Club. Vineyard St is off of Queen Emma St and runs parallel with Vineyard Blvd - right behind the gas station. Attractive building for either residential or office usage."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(12) "REMAX Hawaii"
}
["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(4) "1104"
}
["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) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(4) "8-14"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "981.34"
}
["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) "ADVG02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "Grace.Koreyasu@remaxhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 384-1875"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Grace M Koreyasu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18936155"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-08-21T11:14:59.373"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-08-19"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "11:14:59.373"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27116880"
}
["listing_image"]=>
array(20) {
[0]=>
string(8) "27116880"
[1]=>
string(8) "27116881"
[2]=>
string(8) "27116882"
[3]=>
string(8) "27116883"
[4]=>
string(8) "27116884"
[5]=>
string(8) "27116885"
[6]=>
string(8) "27116886"
[7]=>
string(8) "27116887"
[8]=>
string(8) "27116888"
[9]=>
string(8) "27116889"
[10]=>
string(8) "27116890"
[11]=>
string(8) "27116891"
[12]=>
string(8) "27116892"
[13]=>
string(8) "27116893"
[14]=>
string(8) "27116894"
[15]=>
string(8) "27116895"
[16]=>
string(8) "27116896"
[17]=>
string(8) "27116897"
[18]=>
string(8) "27116898"
[19]=>
string(8) "27116899"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202518471
)
[StreetNumber] => Array
(
[0] => 222
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Vineyard
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => PH3
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96813
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=6WbCxU3JxUd&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 675000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Space is currently configured as a large office with storage, conference rooms and reception area. Building is BMX zoning, so residential or office use. PH-3 and PH-4 were combined into 1 large, 2,438 sq ft space with all office furniture, partitions and equipment as seen, included. To be sold together with MLS 202518474 (PH-4) - asking cumulative $1.4m. Reconfigure... live on one side, work on the other.... Each unit has 2 parking, total contiguous 4 stalls. Owner rented additional parking from nearby St Andrews school/church for staff. Simple, no amenities project with quiet street front across from the Pacific Club. Vineyard St is off of Queen Emma St and runs parallel with Vineyard Blvd - right behind the gas station. Attractive building for either residential or office usage.
)
[ListOfficeName] => Array
(
[0] => REMAX Hawaii
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1104
)
[YearBuilt] => Array
(
[0] => 1981
)
[BuildingName] => Array
(
[0] => Royal Queen Emma
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 8-14
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 981.34
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Royal
)
[MiddleOrJuniorSchool] => Array
(
[0] => Keelikolani
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => ADVG02
)
[ListAgentEmail] => Array
(
[0] => Grace.Koreyasu@remaxhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 384-1875
)
[ListAgentFullName] => Array
(
[0] => Grace M Koreyasu
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18936155
)
[MatrixModifiedDT] => Array
(
[0] => 2025-08-21T11:14:59.373
)
[ListingContractDate] => Array
(
[0] => 2025-08-19
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 11:14:59.373
)
[_thumbnail_id] => Array
(
[0] => 27116880
)
[listing_image] => Array
(
[0] => 27116880
[1] => 27116881
[2] => 27116882
[3] => 27116883
[4] => 27116884
[5] => 27116885
[6] => 27116886
[7] => 27116887
[8] => 27116888
[9] => 27116889
[10] => 27116890
[11] => 27116891
[12] => 27116892
[13] => 27116893
[14] => 27116894
[15] => 27116895
[16] => 27116896
[17] => 27116897
[18] => 27116898
[19] => 27116899
)
)
- Full Baths: 1
- Living (sf): 1,104
- Year Built: 1981
- Building Name: Royal Queen Emma
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Mountain
- Listing Office: REMAX Hawaii
- Maintenance Fees: $981
- Land Tenure: FS - Fee Simple
- Elementary School: Royal
- Middle School: Keelikolani
- High School: Mckinley
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 21, 2025 - 11:14 AM
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.
© Marcus Realty. All Rights Reserved.
