The office will be closed on Friday, July 4th, in observance of Independence Day and will re-open on Monday.
Listing Overview
Price: $380,000
Area: DOWNTOWN
Status: Active
NEW LISTING!! Situated in the heart of Honolulu, don't miss this rarely available 2 bed/1 bath/2 covered parking preferred CORNER/END unit in Queen Emma Gardens. This bright and breezy unit features hardwood flooring, efficient floor plan and additional windows for maximum natural light. Relax on your private lanai and soak in the beautiful city views. Enjoy amazing amenities such as a swimming pool, children’s wading pool, Tea Houses, playground, BBQ areas, 24-hr security, and more! Conveniently located near Downtown Honolulu, restaurants, shopping and entertainment. Don’t miss this fantastic opportunity! Listing by: BHGRE Advantage Realty (808) 738-3633
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202514808"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "1519"
}
["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) "947"
}
["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(61) "https://www.youtube.com/embed/jqHRpGhZWI0?si=GdlmtNT3LIbldXBE"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "380000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(618) "NEW LISTING!! Situated in the heart of Honolulu, don't miss this rarely available 2 bed/1 bath/2 covered parking preferred CORNER/END unit in Queen Emma Gardens. This bright and breezy unit features hardwood flooring, efficient floor plan and additional windows for maximum natural light. Relax on your private lanai and soak in the beautiful city views. Enjoy amazing amenities such as a swimming pool, children’s wading pool, Tea Houses, playground, BBQ areas, 24-hr security, and more! Conveniently located near Downtown Honolulu, restaurants, shopping and entertainment. Don’t miss this fantastic opportunity!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["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) "947"
}
["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) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(19) "City,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1392.94"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "MyronK@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3633"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Myron N Kiriu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18828731"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-06-30T15:15:01.693"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-06-27"
}
["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) "15:15:01.693"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27047824"
}
["listing_image"]=>
array(21) {
[0]=>
string(8) "27047824"
[1]=>
string(8) "27047825"
[2]=>
string(8) "27047826"
[3]=>
string(8) "27047827"
[4]=>
string(8) "27047828"
[5]=>
string(8) "27047829"
[6]=>
string(8) "27047830"
[7]=>
string(8) "27047831"
[8]=>
string(8) "27047832"
[9]=>
string(8) "27047833"
[10]=>
string(8) "27047834"
[11]=>
string(8) "27047835"
[12]=>
string(8) "27047836"
[13]=>
string(8) "27047837"
[14]=>
string(8) "27047838"
[15]=>
string(8) "27047839"
[16]=>
string(8) "27047840"
[17]=>
string(8) "27047841"
[18]=>
string(8) "27047842"
[19]=>
string(8) "27047843"
[20]=>
string(8) "27047844"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202514808
)
[StreetNumber] => Array
(
[0] => 1519
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 947
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/jqHRpGhZWI0?si=GdlmtNT3LIbldXBE
)
[ListPrice] => Array
(
[0] => 380000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => NEW LISTING!! Situated in the heart of Honolulu, don't miss this rarely available 2 bed/1 bath/2 covered parking preferred CORNER/END unit in Queen Emma Gardens. This bright and breezy unit features hardwood flooring, efficient floor plan and additional windows for maximum natural light. Relax on your private lanai and soak in the beautiful city views. Enjoy amazing amenities such as a swimming pool, children’s wading pool, Tea Houses, playground, BBQ areas, 24-hr security, and more! Conveniently located near Downtown Honolulu, restaurants, shopping and entertainment. Don’t miss this fantastic opportunity!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 947
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] => Queen Emma Gardens
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 1392.94
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Royal
)
[MiddleOrJuniorSchool] => Array
(
[0] => Keelikolani
)
[HighSchool] => Array
(
[0] => Mckinley
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => MyronK@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3633
)
[ListAgentFullName] => Array
(
[0] => Myron N Kiriu
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18828731
)
[MatrixModifiedDT] => Array
(
[0] => 2025-06-30T15:15:01.693
)
[ListingContractDate] => Array
(
[0] => 2025-06-27
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:15:01.693
)
[_thumbnail_id] => Array
(
[0] => 27047824
)
[listing_image] => Array
(
[0] => 27047824
[1] => 27047825
[2] => 27047826
[3] => 27047827
[4] => 27047828
[5] => 27047829
[6] => 27047830
[7] => 27047831
[8] => 27047832
[9] => 27047833
[10] => 27047834
[11] => 27047835
[12] => 27047836
[13] => 27047837
[14] => 27047838
[15] => 27047839
[16] => 27047840
[17] => 27047841
[18] => 27047842
[19] => 27047843
[20] => 27047844
)
)
BedsTotal: 2
Full Baths: 1
Living (sf): 947
Year Built: 1963
Building Name: Queen Emma Gardens
Property Condition: Average
Number of Parking Spaces: 2
View: City,Mountain,Ocean
Listing Office: BHGRE Advantage Realty
Maintenance Fees: $1,393
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 June 30, 2025 - 3:15 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.
© Marcus Realty. All Rights Reserved.