Listing
Overview
Price: $459,000
Area: DOWNTOWN
Status: Active
Welcome to this wonderful high floor, preferred B stack unit with endless views from every direction. Experience the sunrise over Ko'olau Ridge from your living room & enjoy the sunset & expansive Ocean Views from your bedrooms. Whatever your preference in view you have it in this unit!! City, Mountain, Ocean, Downtown, Sunrise & Sunset it's truly stunning. This well cared for home is updated & functional. Boasting 2 bedrooms & 2 full bathrooms this unit provides options for your ideal setup. The B stack also boasts additional square footage with an expansive entryway to allow for additional storage space as you enter the front door. Use it for shoes, tote bags or even pantry items. Whatever your need get creative with this extra space & use it for your best & highest use. Maintenance fee includes ALL your necessities, even electricity & central AC. New AC Unit to keep you cool! So many great things going on in Downtown this is your chance to live in the heart of it all. Consider this unit as an investment, the short 30 day rent minimum approved in this building allows you to rent it out on shorter leases. Need parking? Parking is available for monthly rent in the garage. Listing by: Real Broker, LLC (855) 450-0442
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202419087"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "225"
}
["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(3) "23B"
}
["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(41) "https://player.vimeo.com/video/1007192817"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "459000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "459000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "DOWNTOWN"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1198) "Welcome to this wonderful high floor, preferred B stack unit with endless views from every direction. Experience the sunrise over Ko'olau Ridge from your living room & enjoy the sunset & expansive Ocean Views from your bedrooms. Whatever your preference in view you have it in this unit!! City, Mountain, Ocean, Downtown, Sunrise & Sunset it's truly stunning. This well cared for home is updated & functional. Boasting 2 bedrooms & 2 full bathrooms this unit provides options for your ideal setup. The B stack also boasts additional square footage with an expansive entryway to allow for additional storage space as you enter the front door. Use it for shoes, tote bags or even pantry items. Whatever your need get creative with this extra space & use it for your best & highest use. Maintenance fee includes ALL your necessities, even electricity & central AC. New AC Unit to keep you cool! So many great things going on in Downtown this is your chance to live in the heart of it all. Consider this unit as an investment, the short 30 day rent minimum approved in this building allows you to rent it out on shorter leases. Need parking? Parking is available for monthly rent in the garage."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Real Broker, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "67910.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "825"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1971"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Harbor Square"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(44) "City,Coastline,Mountain,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1289.56"
}
["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(17) "Jodi@Jodimews.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(855) 450-0442"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Jodi Mews"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-15T16:00:01.560"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18224681"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-01T15:16:52.720"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(5) "Metro"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26678730"
}
["listing_image"]=>
array(14) {
[0]=>
string(8) "26678730"
[1]=>
string(8) "26678731"
[2]=>
string(8) "26678732"
[3]=>
string(8) "26678733"
[4]=>
string(8) "26678734"
[5]=>
string(8) "26678735"
[6]=>
string(8) "26678736"
[7]=>
string(8) "26678737"
[8]=>
string(8) "26678738"
[9]=>
string(8) "26678739"
[10]=>
string(8) "26678740"
[11]=>
string(8) "26678741"
[12]=>
string(8) "26678742"
[13]=>
string(8) "26684696"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202419087
)
[StreetNumber] => Array
(
[0] => 225
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Queen
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 23B
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96813
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1007192817
)
[ListPrice] => Array
(
[0] => 459000.00
)
[CurrentPrice] => Array
(
[0] => 459000.00
)
[Neighbourhood] => Array
(
[0] => DOWNTOWN
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to this wonderful high floor, preferred B stack unit with endless views from every direction. Experience the sunrise over Ko'olau Ridge from your living room & enjoy the sunset & expansive Ocean Views from your bedrooms. Whatever your preference in view you have it in this unit!! City, Mountain, Ocean, Downtown, Sunrise & Sunset it's truly stunning. This well cared for home is updated & functional. Boasting 2 bedrooms & 2 full bathrooms this unit provides options for your ideal setup. The B stack also boasts additional square footage with an expansive entryway to allow for additional storage space as you enter the front door. Use it for shoes, tote bags or even pantry items. Whatever your need get creative with this extra space & use it for your best & highest use. Maintenance fee includes ALL your necessities, even electricity & central AC. New AC Unit to keep you cool! So many great things going on in Downtown this is your chance to live in the heart of it all. Consider this unit as an investment, the short 30 day rent minimum approved in this building allows you to rent it out on shorter leases. Need parking? Parking is available for monthly rent in the garage.
)
[ListOfficeName] => Array
(
[0] => Real Broker, LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 67910.00
)
[SqftTotal] => Array
(
[0] => 825
)
[YearBuilt] => Array
(
[0] => 1971
)
[BuildingName] => Array
(
[0] => Harbor Square
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 0
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => City,Coastline,Mountain,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 1289.56
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RBLL
)
[ListAgentEmail] => Array
(
[0] => Jodi@Jodimews.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (855) 450-0442
)
[ListAgentFullName] => Array
(
[0] => Jodi Mews
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-15T16:00:01.560
)
[Matrix_Unique_ID] => Array
(
[0] => 18224681
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-01T15:16:52.720
)
[MLSAreaMajor] => Array
(
[0] => Metro
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26678730
)
[listing_image] => Array
(
[0] => 26678730
[1] => 26678731
[2] => 26678732
[3] => 26678733
[4] => 26678734
[5] => 26678735
[6] => 26678736
[7] => 26678737
[8] => 26678738
[9] => 26678739
[10] => 26678740
[11] => 26678741
[12] => 26678742
[13] => 26684696
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 67,910
- Living (sf): 825
- Year Built: 1971
- Building Name: Harbor Square
- Property Condition: Excellent,Above Average
- View: City,Coastline,Mountain,Ocean,Sunrise,Sunset
- Listing Office: Real Broker, LLC
- Maintenance Fees: $1,290
- Land Tenure: FS - Fee Simple
