1687 Pensacola Street Unit 1004 Honolulu, HI 96822

Take a Virtual Tour

Listing
Overview

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

Welcome to this hidden gem in Rose Terrace! A diamond in the rough, this unit offers solid bones as well as incredible potential for buyers looking to customize by adding their own personal touches. Appealing features such as covered parking, secured building entry, community washer and dryer on each floor and lush mountain views from your open lanai make this one not to miss! Conveniently located in Makiki, you'll be just minutes from Downtown Honolulu, nearby banks, hospitals, shopping, and dining. This property is being conveyed "As Is." The seller will not agree to credits, concessions, or repairs. Tax assessed values based on year 2025, tax amount monthly year 2024. Listing by: Engel & Volkers Honolulu (808) 277-7335

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202514732"
  }
  ["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(4) "1004"
  }
  ["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(41) "https://player.vimeo.com/video/1096432601"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "233000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "MAKIKI"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(679) "Welcome to this hidden gem in Rose Terrace! A diamond in the rough, this unit offers solid bones as well as incredible potential for buyers looking to customize by adding their own personal touches. Appealing features such as covered parking, secured building entry, community washer and dryer on each floor and lush mountain views from your open lanai make this one not to miss! Conveniently located in Makiki, you'll be just minutes from Downtown Honolulu, nearby banks, hospitals, shopping, and dining. This property is being conveyed "As Is." The seller will not agree to credits, concessions, or repairs. Tax assessed values based on year 2025, tax amount monthly year 2024."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Engel & Volkers Honolulu"
  }
  ["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(0) ""
  }
  ["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(23) "Fair,Needs Major Repair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "PPRO"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(29) "Ally.Uyehara@evrealestate.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 277-7335"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Ally M Uyehara"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18826398"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-25T14:36:46.713"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-24"
  }
  ["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) "14:36:46.713"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27042815"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "27042815"
    [1]=>
    string(8) "27042816"
    [2]=>
    string(8) "27042817"
    [3]=>
    string(8) "27042818"
    [4]=>
    string(8) "27042819"
    [5]=>
    string(8) "27042820"
    [6]=>
    string(8) "27042821"
    [7]=>
    string(8) "27042822"
    [8]=>
    string(8) "27042823"
    [9]=>
    string(8) "27042824"
    [10]=>
    string(8) "27042825"
    [11]=>
    string(8) "27042826"
    [12]=>
    string(8) "27042827"
    [13]=>
    string(8) "27042828"
    [14]=>
    string(8) "27042829"
    [15]=>
    string(8) "27042830"
    [16]=>
    string(8) "27042831"
    [17]=>
    string(8) "27042832"
    [18]=>
    string(8) "27042833"
    [19]=>
    string(8) "27042834"
    [20]=>
    string(8) "27042835"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202514732
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://player.vimeo.com/video/1096432601
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to this hidden gem in Rose Terrace! A diamond in the rough, this unit offers solid bones as well as incredible potential for buyers looking to customize by adding their own personal touches. Appealing features such as covered parking, secured building entry, community washer and dryer on each floor and lush mountain views from your open lanai make this one not to miss! Conveniently located in Makiki, you'll be just minutes from Downtown Honolulu, nearby banks, hospitals, shopping, and dining. This property is being conveyed "As Is." The seller will not agree to credits, concessions, or repairs. Tax assessed values based on year 2025, tax amount monthly year 2024.
        )

    [ListOfficeName] => Array
        (
            [0] => Engel & Volkers Honolulu
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Fair,Needs Major Repair
        )

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

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

    [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] => PPRO
        )

    [ListAgentEmail] => Array
        (
            [0] => Ally.Uyehara@evrealestate.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 277-7335
        )

    [ListAgentFullName] => Array
        (
            [0] => Ally M Uyehara
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-25T14:36:46.713
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-24
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 14:36:46.713
        )

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

    [listing_image] => Array
        (
            [0] => 27042815
            [1] => 27042816
            [2] => 27042817
            [3] => 27042818
            [4] => 27042819
            [5] => 27042820
            [6] => 27042821
            [7] => 27042822
            [8] => 27042823
            [9] => 27042824
            [10] => 27042825
            [11] => 27042826
            [12] => 27042827
            [13] => 27042828
            [14] => 27042829
            [15] => 27042830
            [16] => 27042831
            [17] => 27042832
            [18] => 27042833
            [19] => 27042834
            [20] => 27042835
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Living (sf): 697
  • Year Built: 1975
  • Building Name: Rose Terrace

  • Property Condition: Fair,Needs Major Repair
  • Number of Parking Spaces: 1
  • View: Mountain
  • Listing Office: Engel & Volkers Honolulu

  • 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 June 25, 2025 - 2:36 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.