Listing
Overview
Price: $395,000
Area: DOWNTOWN
Status: Active
Price adjustment! Convenience and turn-key in the Queen Emma Gardens' 8 acre park-like setting! This furnished 2 bed 1 bath, 674 sqft condo has a covered, assigned parking stall and is set in the Prince building. Just bring your toothbrush! You will love the beautiful and private grounds which include koi ponds, a playground, two tea houses, BBQ areas, a resident manager, security and 2 swimming pools. There is an abundance of guest parking and convenient community laundry. This building is pet-friendly (confirm). Centrally located and close to hospitals, Downtown, Chinatown, bus routes and highway access taking you in all directions. Listing by: BHGRE Advantage Realty (808) 223-4719
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202320129"
}
["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) "138"
}
["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(59) "https://listings.hetproductions.com/sites/ypjzlkx/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "395000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "395000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(642) "Price adjustment! Convenience and turn-key in the Queen Emma Gardens' 8 acre park-like setting! This furnished 2 bed 1 bath, 674 sqft condo has a covered, assigned parking stall and is set in the Prince building. Just bring your toothbrush! You will love the beautiful and private grounds which include koi ponds, a playground, two tea houses, BBQ areas, a resident manager, security and 2 swimming pools. There is an abundance of guest parking and convenient community laundry. This building is pet-friendly (confirm). Centrally located and close to hospitals, Downtown, Chinatown, bus routes and highway access taking you in all directions."
}
["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) "740"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(18) "Queen Emma Gardens"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "991.74"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "MichelleV@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 223-4719"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(26) "Michelle Doo Van Rafelghem"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-11-24T16:49:58.437"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17525588"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-08-30T21:42:29.880"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25937778"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "25937778"
[1]=>
string(8) "25937779"
[2]=>
string(8) "25937780"
[3]=>
string(8) "25937781"
[4]=>
string(8) "25937782"
[5]=>
string(8) "25937783"
[6]=>
string(8) "25937784"
[7]=>
string(8) "25937785"
[8]=>
string(8) "25937786"
[9]=>
string(8) "25937787"
[10]=>
string(8) "25937788"
[11]=>
string(8) "25937789"
[12]=>
string(8) "25937790"
[13]=>
string(8) "25937791"
[14]=>
string(8) "25937792"
[15]=>
string(8) "25937793"
[16]=>
string(8) "25937794"
[17]=>
string(8) "25937795"
[18]=>
string(8) "25937796"
[19]=>
string(8) "25937797"
[20]=>
string(8) "25937798"
[21]=>
string(8) "25937799"
[22]=>
string(8) "25937800"
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "16:49:58.437"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202320129
)
[StreetNumber] => Array
(
[0] => 1511
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Nuuanu
)
[StreetSuffix] => Array
(
[0] => Avenue
)
[UnitNumber] => Array
(
[0] => 138
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96817
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/ypjzlkx/unbranded
)
[ListPrice] => Array
(
[0] => 395000.00
)
[CurrentPrice] => Array
(
[0] => 395000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Price adjustment! Convenience and turn-key in the Queen Emma Gardens' 8 acre park-like setting! This furnished 2 bed 1 bath, 674 sqft condo has a covered, assigned parking stall and is set in the Prince building. Just bring your toothbrush! You will love the beautiful and private grounds which include koi ponds, a playground, two tea houses, BBQ areas, a resident manager, security and 2 swimming pools. There is an abundance of guest parking and convenient community laundry. This building is pet-friendly (confirm). Centrally located and close to hospitals, Downtown, Chinatown, bus routes and highway access taking you in all directions.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 740
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] => Queen Emma Gardens
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 991.74
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => MichelleV@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 223-4719
)
[ListAgentFullName] => Array
(
[0] => Michelle Doo Van Rafelghem
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-11-24T16:49:58.437
)
[Matrix_Unique_ID] => Array
(
[0] => 17525588
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-08-30T21:42:29.880
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 25937778
)
[listing_image] => Array
(
[0] => 25937778
[1] => 25937779
[2] => 25937780
[3] => 25937781
[4] => 25937782
[5] => 25937783
[6] => 25937784
[7] => 25937785
[8] => 25937786
[9] => 25937787
[10] => 25937788
[11] => 25937789
[12] => 25937790
[13] => 25937791
[14] => 25937792
[15] => 25937793
[16] => 25937794
[17] => 25937795
[18] => 25937796
[19] => 25937797
[20] => 25937798
[21] => 25937799
[22] => 25937800
)
[MatrixModifiedTime] => Array
(
[0] => 16:49:58.437
)
)
- BedsTotal: 2
- Full Baths: 1
- Living (sf): 740
- Year Built: 1963
- Building Name: Queen Emma Gardens
- Property Condition: Above Average
- Number of Parking Spaces: 1
- View: None
- Listing Office: BHGRE Advantage Realty
- Maintenance Fees: $992
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 24, 2023 - 4:49 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.