Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
54-16 Ahinalu Place Hauula, HI 96717
Listing Overview
Price: $640,000 Area: HAUULA Status: Active
Don’t miss your chance to own a piece of paradise in the beautiful town of Hau'ula! Perfect for investors or DIY enthusiasts, this home is priced below tax-assessed value and features a spacious 6,050 sq ft lot with stunning views. Ideally situated between Hau'ula Shopping Center and public beach access, this is your chance to create the ultimate dream home, vacation getaway, or income-generating oasis. Experience the charm of this coastal community, pristine beaches, and the best of island living. Schedule your showing with us today! Listing by: Locations LLC (808) 488-7700
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423947"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(5) "54-16"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Ahinalu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(6) "Hauula"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96717"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "640000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "640000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(542) "Don’t miss your chance to own a piece of paradise in the beautiful town of Hau'ula! Perfect for investors or DIY enthusiasts, this home is priced below tax-assessed value and features a spacious 6,050 sq ft lot with stunning views. Ideally situated between Hau'ula Shopping Center and public beach access, this is your chance to create the ultimate dream home, vacation getaway, or income-generating oasis. Experience the charm of this coastal community, pristine beaches, and the best of island living. Schedule your showing with us today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Locations 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) "6050.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1112"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1966"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(18) "Needs Major Repair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(25) "Coastline,Garden,Mountain"
}
["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(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "LOCA03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(32) "sean.santoki@locationshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 488-7700"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Sean H Santoki"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-21T16:24:38.357"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18325420"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-21T06:25:19.403"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26739065"
}
["listing_image"]=>
array(11) {
[0]=>
string(8) "26739065"
[1]=>
string(8) "26739066"
[2]=>
string(8) "26739067"
[3]=>
string(8) "26739068"
[4]=>
string(8) "26739069"
[5]=>
string(8) "26739070"
[6]=>
string(8) "26739071"
[7]=>
string(8) "26739072"
[8]=>
string(8) "26739073"
[9]=>
string(8) "26739074"
[10]=>
string(8) "26739075"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423947
)
[StreetNumber] => Array
(
[0] => 54-16
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ahinalu
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 640000.00
)
[CurrentPrice] => Array
(
[0] => 640000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Don’t miss your chance to own a piece of paradise in the beautiful town of Hau'ula! Perfect for investors or DIY enthusiasts, this home is priced below tax-assessed value and features a spacious 6,050 sq ft lot with stunning views. Ideally situated between Hau'ula Shopping Center and public beach access, this is your chance to create the ultimate dream home, vacation getaway, or income-generating oasis. Experience the charm of this coastal community, pristine beaches, and the best of island living. Schedule your showing with us today!
)
[ListOfficeName] => Array
(
[0] => Locations LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6050.00
)
[SqftTotal] => Array
(
[0] => 1112
)
[YearBuilt] => Array
(
[0] => 1966
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Needs Major Repair
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Garden,Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LOCA03
)
[ListAgentEmail] => Array
(
[0] => sean.santoki@locationshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 488-7700
)
[ListAgentFullName] => Array
(
[0] => Sean H Santoki
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-21T16:24:38.357
)
[Matrix_Unique_ID] => Array
(
[0] => 18325420
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-21T06:25:19.403
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26739065
)
[listing_image] => Array
(
[0] => 26739065
[1] => 26739066
[2] => 26739067
[3] => 26739068
[4] => 26739069
[5] => 26739070
[6] => 26739071
[7] => 26739072
[8] => 26739073
[9] => 26739074
[10] => 26739075
)
)