Previous Next

2004 Ahuula Street Honolulu, HI 96819

Listing
Overview

Price: $1,260,000
Area: KAPALAMA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202611737"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "2004"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Ahuula"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96819"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "1260000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "KAPALAMA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(753) "Spacious 8 bedrooms and 4.50 bath home with ample parking.  Great opportunity for multi-generational living.  Two-story dwelling with hollow tiles exterior wall down stairs.  Upstairs has 3 bedrooms, 1 full bath and a half bath.  First level features 3 bedrooms, 2 full baths, and a family room while rear portion of the lower level has 2 bedrooms, 1 full bath and a rec room - renovated a year ago.  Driveway on the side of the carport can accommodate additional 2 cars.  Short distance from bus route, schools and more. Monthly property tax is based on year 2025. Property to be Sold In As Is Condition.  Number of bedroom and bathroom may not match Public Tax Office Record. Please DO NOT Disturb Tenant. Listing agent must be there for all showings."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Honland Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5000.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "2879"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1971"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(10) "Kalihi Kai"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(8) "Kalakaua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(10) "Farrington"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "HONR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "honlandrealty@hawaii.rr.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 479-0895"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Wilson U Pascua"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19523964"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-06-17T23:18:26.037"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-06-15"
  }
  ["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) "23:18:26.037"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27427466"
  }
  ["listing_image"]=>
  array(24) {
    [0]=>
    string(8) "27427466"
    [1]=>
    string(8) "27427467"
    [2]=>
    string(8) "27427468"
    [3]=>
    string(8) "27427469"
    [4]=>
    string(8) "27427470"
    [5]=>
    string(8) "27427471"
    [6]=>
    string(8) "27427472"
    [7]=>
    string(8) "27427473"
    [8]=>
    string(8) "27427474"
    [9]=>
    string(8) "27427475"
    [10]=>
    string(8) "27427476"
    [11]=>
    string(8) "27427477"
    [12]=>
    string(8) "27427478"
    [13]=>
    string(8) "27427479"
    [14]=>
    string(8) "27427480"
    [15]=>
    string(8) "27427481"
    [16]=>
    string(8) "27427482"
    [17]=>
    string(8) "27427483"
    [18]=>
    string(8) "27427484"
    [19]=>
    string(8) "27427485"
    [20]=>
    string(8) "27427486"
    [21]=>
    string(8) "27427487"
    [22]=>
    string(8) "27427488"
    [23]=>
    string(8) "27427489"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202611737
        )

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

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Spacious 8 bedrooms and 4.50 bath home with ample parking.  Great opportunity for multi-generational living.  Two-story dwelling with hollow tiles exterior wall down stairs.  Upstairs has 3 bedrooms, 1 full bath and a half bath.  First level features 3 bedrooms, 2 full baths, and a family room while rear portion of the lower level has 2 bedrooms, 1 full bath and a rec room - renovated a year ago.  Driveway on the side of the carport can accommodate additional 2 cars.  Short distance from bus route, schools and more. Monthly property tax is based on year 2025. Property to be Sold In As Is Condition.  Number of bedroom and bathroom may not match Public Tax Office Record. Please DO NOT Disturb Tenant. Listing agent must be there for all showings.
        )

    [ListOfficeName] => Array
        (
            [0] => Honland Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => honlandrealty@hawaii.rr.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 479-0895
        )

    [ListAgentFullName] => Array
        (
            [0] => Wilson U Pascua
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-06-17T23:18:26.037
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-06-15
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 23:18:26.037
        )

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

    [listing_image] => Array
        (
            [0] => 27427466
            [1] => 27427467
            [2] => 27427468
            [3] => 27427469
            [4] => 27427470
            [5] => 27427471
            [6] => 27427472
            [7] => 27427473
            [8] => 27427474
            [9] => 27427475
            [10] => 27427476
            [11] => 27427477
            [12] => 27427478
            [13] => 27427479
            [14] => 27427480
            [15] => 27427481
            [16] => 27427482
            [17] => 27427483
            [18] => 27427484
            [19] => 27427485
            [20] => 27427486
            [21] => 27427487
            [22] => 27427488
            [23] => 27427489
        )

)

PROPERTY INFO

• BedsTotal: 8
• Full Baths: 4
• Half Baths: 1
• Land Area (sf): 5,000 sf
• Living (sf): 2,879
• Year Built: 1971

KEY FEATURES

• Property Condition: Average
• Number of Parking Spaces: 2
• View: None
• Listing Office: Honland Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Kalihi Kai
• Middle School: Kalakaua
• High School: Farrington

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 17, 2026 - 11:18 PM Information is deemed reliable but not guaranteed. Copyright: 2026 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.