600 Queen Street Unit 3509 Honolulu, HI 96813
Listing
Overview
Price: $1,300,000
Area: KAKAAKO
Status: Active
” Spectacular panoramic ocean, harbor, city & mountain views from this beautiful wrap-around end-residence. Spacious High 8’6” ceilings floorplan with over 1,400 sq.ft. of living area in this price range.Quality granite countertops, solid wood cabinetry and stainless steel appliances. Great amenities with Fitness Center, Pool, Jacuzzi, BBQ. Move in condition, sold AS-IS. Convenient full size side-by-side parking stalls and 23 guest parking stalls!.Pet-friendly too. Listing by: Green Tree Realty (808) 778-5124
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407660"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "600"
}
["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(4) "3509"
}
["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(10) "1300000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1300000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "KAKAAKO"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(476) "” Spectacular panoramic ocean, harbor, city & mountain views from this beautiful wrap-around end-residence. Spacious High 8’6” ceilings floorplan with over 1,400 sq.ft. of living area in this price range.Quality granite countertops, solid wood cabinetry and stainless steel appliances. Great amenities with Fitness Center, Pool, Jacuzzi, BBQ. Move in condition, sold AS-IS. Convenient full size side-by-side parking stalls and 23 guest parking stalls!.Pet-friendly too."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(17) "Green Tree Realty"
}
["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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1498"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2008"
}
["BuildingName"]=>
array(1) {
[0]=>
string(9) "Keola Lai"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "21+"
}
["View"]=>
array(1) {
[0]=>
string(46) "Coastline,Diamond Head,Mountain,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1467.44"
}
["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) "GREE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "syhawaii@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 778-5124"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Soon Jung Yun"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-04-10T12:51:23.833"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17922871"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-05T10:13:29.467"
}
["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) "26154507"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26154507"
[1]=>
string(8) "26154508"
[2]=>
string(8) "26154509"
[3]=>
string(8) "26154510"
[4]=>
string(8) "26154511"
[5]=>
string(8) "26154512"
[6]=>
string(8) "26154513"
[7]=>
string(8) "26154514"
[8]=>
string(8) "26154515"
[9]=>
string(8) "26154516"
[10]=>
string(8) "26154517"
[11]=>
string(8) "26154518"
[12]=>
string(8) "26154519"
[13]=>
string(8) "26154520"
[14]=>
string(8) "26154521"
[15]=>
string(8) "26154522"
[16]=>
string(8) "26154523"
[17]=>
string(8) "26154524"
[18]=>
string(8) "26160942"
[19]=>
string(8) "26160943"
[20]=>
string(8) "26160944"
[21]=>
string(8) "26160945"
[22]=>
string(8) "26160946"
[23]=>
string(8) "26160947"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407660
)
[StreetNumber] => Array
(
[0] => 600
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 3509
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96813
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1300000.00
)
[CurrentPrice] => Array
(
[0] => 1300000.00
)
[Neighbourhood] => Array
(
[0] => KAKAAKO
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => ” Spectacular panoramic ocean, harbor, city & mountain views from this beautiful wrap-around end-residence. Spacious High 8’6” ceilings floorplan with over 1,400 sq.ft. of living area in this price range.Quality granite countertops, solid wood cabinetry and stainless steel appliances. Great amenities with Fitness Center, Pool, Jacuzzi, BBQ. Move in condition, sold AS-IS. Convenient full size side-by-side parking stalls and 23 guest parking stalls!.Pet-friendly too.
)
[ListOfficeName] => Array
(
[0] => Green Tree Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 1498
)
[YearBuilt] => Array
(
[0] => 2008
)
[BuildingName] => Array
(
[0] => Keola Lai
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 21+
)
[View] => Array
(
[0] => Coastline,Diamond Head,Mountain,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1467.44
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => GREE
)
[ListAgentEmail] => Array
(
[0] => syhawaii@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 778-5124
)
[ListAgentFullName] => Array
(
[0] => Soon Jung Yun
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-04-10T12:51:23.833
)
[Matrix_Unique_ID] => Array
(
[0] => 17922871
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-05T10:13:29.467
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26154507
)
[listing_image] => Array
(
[0] => 26154507
[1] => 26154508
[2] => 26154509
[3] => 26154510
[4] => 26154511
[5] => 26154512
[6] => 26154513
[7] => 26154514
[8] => 26154515
[9] => 26154516
[10] => 26154517
[11] => 26154518
[12] => 26154519
[13] => 26154520
[14] => 26154521
[15] => 26154522
[16] => 26154523
[17] => 26154524
[18] => 26160942
[19] => 26160943
[20] => 26160944
[21] => 26160945
[22] => 26160946
[23] => 26160947
)
)
- BedsTotal: 3
- Full Baths: 2
- Living (sf): 1,498
- Year Built: 2008
- Building Name: Keola Lai
- Property Condition: Excellent
- Number of Parking Spaces: 2
- View: Coastline,Diamond Head,Mountain,Sunrise,Sunset
- Listing Office: Green Tree Realty
- Maintenance Fees: $1,467
- Land Tenure: FS - Fee Simple
