Previous Next

1751 Ahuula Street Honolulu, HI 96819

Listing
Overview

Price: $785,000
Area: KAPALAMA
Status: Active

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202415768"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "1751"
  }
  ["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(9) "785000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "798000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "KAPALAMA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(760) "Available Again!!  3rd chance to get a fantastic property in town to revitalize, extend, build up, or build a new Care Home, house to generate more living spaces for families. You can make new home a care home or foster home downstairs and live upstairs at the convenience of your home. It is near Costco, schools, Ala Moana, the airport, Tripler Hospital, and Aloha Tower, three (3) blocks from the rail station. It is a few minutes' drive to Waikiki, the University of Hawaii, and malls. It is in an excellent location to avoid traffic to the Ewa side. Land value sale only. Vacant; however, please DRIVE BY ONLY—no showings inside the home or on the property. It's a land-value sale at assessed value. Offers are presented upon receipt. Seller motivated!!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Harper Island Realty LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5000.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "560"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1982"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(28) "Needs Major Repair,Tear Down"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["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(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(10) "Farrington"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "HIRR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(17) "armiof1@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 221-0667"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Armi Oliver Harper"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-06T18:32:28.187"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18119833"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-07-09T12:52:23.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) "26615253"
  }
  ["listing_image"]=>
  array(3) {
    [0]=>
    string(8) "26615253"
    [1]=>
    string(8) "26615254"
    [2]=>
    string(8) "26615255"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-07-09"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "18:32:28.187"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202415768
        )

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

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

    [CurrentPrice] => Array
        (
            [0] => 798000.00
        )

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

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

    [PublicRemarks] => Array
        (
            [0] => Available Again!!  3rd chance to get a fantastic property in town to revitalize, extend, build up, or build a new Care Home, house to generate more living spaces for families. You can make new home a care home or foster home downstairs and live upstairs at the convenience of your home. It is near Costco, schools, Ala Moana, the airport, Tripler Hospital, and Aloha Tower, three (3) blocks from the rail station. It is a few minutes' drive to Waikiki, the University of Hawaii, and malls. It is in an excellent location to avoid traffic to the Ewa side. Land value sale only. Vacant; however, please DRIVE BY ONLY—no showings inside the home or on the property. It's a land-value sale at assessed value. Offers are presented upon receipt. Seller motivated!!
        )

    [ListOfficeName] => Array
        (
            [0] => Harper Island Realty LLC
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => armiof1@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 221-0667
        )

    [ListAgentFullName] => Array
        (
            [0] => Armi Oliver Harper
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-06T18:32:28.187
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-07-09T12:52:23.720
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26615253
            [1] => 26615254
            [2] => 26615255
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-07-09
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 18:32:28.187
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 1
• Land Area (sf): 5,000 sf
• Living (sf): 560
• Year Built: 1982

KEY FEATURES

• Property Condition: Needs Major Repair,Tear Down
• Number of Parking Spaces: 3
• View: None
• Listing Office: Harper Island Realty LLC

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• 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 May 6, 2025 - 6:32 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.