1751 Ahuula Street Honolulu, HI 96819
Listing
Overview
Price: $798,000
Area: KAPALAMA
Status: Active Under Contract
It is a fantastic property in town to revitalize, extend, build up, or build a new house to generate more living spaces for families. You can make it 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, Aloha Tower, and three (3) blocks from the rail station. It is a few minutes' drive to Waikiki, UH, 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. Listing by: Harper Island Realty LLC (808) 397-9894
array(45) {
["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) "798000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "798000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(8) "KAPALAMA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(671) "It is a fantastic property in town to revitalize, extend, build up, or build a new house to generate more living spaces for families. You can make it 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, Aloha Tower, and three (3) blocks from the rail station. It is a few minutes' drive to Waikiki, UH, 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."
}
["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(18) "Needs Major Repair"
}
["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) 397-9894"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Armi Oliver Harper"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-08-30T12:38:08.690"
}
["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"
}
}
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] => 798000.00
)
[CurrentPrice] => Array
(
[0] => 798000.00
)
[Neighbourhood] => Array
(
[0] => KAPALAMA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => It is a fantastic property in town to revitalize, extend, build up, or build a new house to generate more living spaces for families. You can make it 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, Aloha Tower, and three (3) blocks from the rail station. It is a few minutes' drive to Waikiki, UH, 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.
)
[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
)
[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) 397-9894
)
[ListAgentFullName] => Array
(
[0] => Armi Oliver Harper
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-08-30T12:38:08.690
)
[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
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 5,000
- Living (sf): 560
- Year Built: 1982
- Property Condition: Needs Major Repair
- Number of Parking Spaces: 3
- View: None
- Listing Office: Harper Island Realty LLC
- Land Tenure: FS - Fee Simple
