1687 Pensacola Street Unit 804 Honolulu, HI 96822

Listing
Overview

Price: $250,000
Area: MAKIKI
Status: Active

Move in Ready! Well maintained 1 bedroom 1 bath unit in the Rose Terrace condominium. Unit features an open concept layout with new carpet and vinyl plank flooring, window ac unit and a spacious lanai. Building has a secure entry and community laundry access on every floor. Conveniently located and within minutes from schools, Downtown Honolulu, bus lines, hospitals and more. Listing by: Coldwell Banker Realty (808) 722-9943

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202511410"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1687"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Pensacola"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "804"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96822"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "250000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "MAKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(382) "Move in Ready!  Well maintained 1 bedroom 1 bath unit in the Rose Terrace condominium.  Unit features an open concept layout with new carpet and vinyl plank flooring, window ac unit and a spacious lanai.  Building has a secure entry and community laundry access on every floor.  Conveniently located and within minutes from schools, Downtown Honolulu, bus lines, hospitals and more."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "14680.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "697"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(12) "Rose Terrace"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(21) "Above Average,Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(4) "8-14"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "912.82"
  }
  ["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) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "brian.lee@cbpacific.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 722-9943"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Brian C Lee"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18729904"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-07T04:20:31.230"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-04"
  }
  ["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) "04:20:31.230"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26984937"
  }
  ["listing_image"]=>
  array(23) {
    [0]=>
    string(8) "26984937"
    [1]=>
    string(8) "26984938"
    [2]=>
    string(8) "26984939"
    [3]=>
    string(8) "26984940"
    [4]=>
    string(8) "26984941"
    [5]=>
    string(8) "26984942"
    [6]=>
    string(8) "26984943"
    [7]=>
    string(8) "26984944"
    [8]=>
    string(8) "26984945"
    [9]=>
    string(8) "26984946"
    [10]=>
    string(8) "26984947"
    [11]=>
    string(8) "26984948"
    [12]=>
    string(8) "26984949"
    [13]=>
    string(8) "26984950"
    [14]=>
    string(8) "26984951"
    [15]=>
    string(8) "26984952"
    [16]=>
    string(8) "26984953"
    [17]=>
    string(8) "26984954"
    [18]=>
    string(8) "26984955"
    [19]=>
    string(8) "26984956"
    [20]=>
    string(8) "26984957"
    [21]=>
    string(8) "26984958"
    [22]=>
    string(8) "26984959"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202511410
        )

    [StreetNumber] => Array
        (
            [0] => 1687
        )

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

    [StreetName] => Array
        (
            [0] => Pensacola
        )

    [StreetSuffix] => Array
        (
            [0] => Street
        )

    [UnitNumber] => Array
        (
            [0] => 804
        )

    [City] => Array
        (
            [0] => Honolulu
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96822
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 250000.00
        )

    [Neighbourhood] => Array
        (
            [0] => MAKIKI
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Move in Ready!  Well maintained 1 bedroom 1 bath unit in the Rose Terrace condominium.  Unit features an open concept layout with new carpet and vinyl plank flooring, window ac unit and a spacious lanai.  Building has a secure entry and community laundry access on every floor.  Conveniently located and within minutes from schools, Downtown Honolulu, bus lines, hospitals and more.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

    [BedsTotal] => Array
        (
            [0] => 1
        )

    [BathsFull] => Array
        (
            [0] => 1
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 14680.00
        )

    [SqftTotal] => Array
        (
            [0] => 697
        )

    [YearBuilt] => Array
        (
            [0] => 1975
        )

    [BuildingName] => Array
        (
            [0] => Rose Terrace
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average,Average
        )

    [ParkingTotal] => Array
        (
            [0] => 1
        )

    [StoriesType] => Array
        (
            [0] => 8-14
        )

    [View] => Array
        (
            [0] => Mountain
        )

    [MaintenanceExpense] => Array
        (
            [0] => 912.82
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => 
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => 
        )

    [ListOfficeMLSID] => Array
        (
            [0] => CBPP
        )

    [ListAgentEmail] => Array
        (
            [0] => brian.lee@cbpacific.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 722-9943
        )

    [ListAgentFullName] => Array
        (
            [0] => Brian C Lee
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 18729904
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-07T04:20:31.230
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-04
        )

    [MLSAreaMajor] => Array
        (
            [0] => Metro
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 04:20:31.230
        )

    [_thumbnail_id] => Array
        (
            [0] => 26984937
        )

    [listing_image] => Array
        (
            [0] => 26984937
            [1] => 26984938
            [2] => 26984939
            [3] => 26984940
            [4] => 26984941
            [5] => 26984942
            [6] => 26984943
            [7] => 26984944
            [8] => 26984945
            [9] => 26984946
            [10] => 26984947
            [11] => 26984948
            [12] => 26984949
            [13] => 26984950
            [14] => 26984951
            [15] => 26984952
            [16] => 26984953
            [17] => 26984954
            [18] => 26984955
            [19] => 26984956
            [20] => 26984957
            [21] => 26984958
            [22] => 26984959
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Land Area (sf): 14,680 sf
  • Living (sf): 697
  • Year Built: 1975
  • Building Name: Rose Terrace

  • Property Condition: Above Average,Average
  • Number of Parking Spaces: 1
  • View: Mountain
  • Listing Office: Coldwell Banker Realty

  • Maintenance Fees: $913
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on May 7, 2025 - 4:20 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.