Our office will be closed on Monday, November 11th, 2024.
54-238 Hauula Homestead Road Hauula, HI 96717
Listing Overview
Price: $1,560,000 Area: HAUULA Status: Active
Featuring a gated entry for privacy, the home boasts breathtaking ocean and mountain views on an expansive 18,991 square foot lot zoned R-5, offering the potential to build another home or two. This charming residence provides a serene escape with stunning views of the lush surroundings, set in a peaceful community perfect for families and nature lovers alike.This property offers a prime, convenient location with just a 30-minute drive to the new Target in Kaneohe, a quick 3-minute trip to CVS and Tamura's Market, and only a 5-minute walk to the local beach park and Hauula Loop Trail. Nestled on a quiet back road in the beautiful Hauula area, it’s perfect for extended families or investors with excellent rental income potential.
With proximity to pristine beaches, hiking trails, and local parks, residents can enjoy endless outdoor activities. The welcoming neighborhood fosters strong connections among neighbors, and nearby shops and dining options add convenience. Whether you’re seeking a tranquil place to call home or a lucrative investment opportunity, the possibilities here are endless. Listing by: Keller Williams Honolulu (808) 551-2704
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421784"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-238"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(16) "Hauula Homestead"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["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(10) "1560000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1560000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1111) "Featuring a gated entry for privacy, the home boasts breathtaking ocean and mountain views on an expansive 18,991 square foot lot zoned R-5, offering the potential to build another home or two. This charming residence provides a serene escape with stunning views of the lush surroundings, set in a peaceful community perfect for families and nature lovers alike.This property offers a prime, convenient location with just a 30-minute drive to the new Target in Kaneohe, a quick 3-minute trip to CVS and Tamura's Market, and only a 5-minute walk to the local beach park and Hauula Loop Trail. Nestled on a quiet back road in the beautiful Hauula area, it’s perfect for extended families or investors with excellent rental income potential.
With proximity to pristine beaches, hiking trails, and local parks, residents can enjoy endless outdoor activities. The welcoming neighborhood fosters strong connections among neighbors, and nearby shops and dining options add convenience. Whether you’re seeking a tranquil place to call home or a lucrative investment opportunity, the possibilities here are endless."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "18991.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3466"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1991"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(20) "Mountain,Ocean,Other"
}
["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(4) "KWPP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "david.cordeiro@kw.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 551-2704"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "David Cordeiro"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-05T17:42:20.813"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18282081"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-25T05:11:41.180"
}
["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) "26711490"
}
["listing_image"]=>
array(23) {
[0]=>
string(8) "26711490"
[1]=>
string(8) "26711491"
[2]=>
string(8) "26711492"
[3]=>
string(8) "26711493"
[4]=>
string(8) "26711494"
[5]=>
string(8) "26711495"
[6]=>
string(8) "26711496"
[7]=>
string(8) "26711497"
[8]=>
string(8) "26711498"
[9]=>
string(8) "26711499"
[10]=>
string(8) "26711500"
[11]=>
string(8) "26711501"
[12]=>
string(8) "26711502"
[13]=>
string(8) "26711503"
[14]=>
string(8) "26711504"
[15]=>
string(8) "26711505"
[16]=>
string(8) "26711506"
[17]=>
string(8) "26712001"
[18]=>
string(8) "26712002"
[19]=>
string(8) "26712003"
[20]=>
string(8) "26712004"
[21]=>
string(8) "26712005"
[22]=>
string(8) "26712006"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421784
)
[StreetNumber] => Array
(
[0] => 54-238
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hauula Homestead
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1560000.00
)
[CurrentPrice] => Array
(
[0] => 1560000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Featuring a gated entry for privacy, the home boasts breathtaking ocean and mountain views on an expansive 18,991 square foot lot zoned R-5, offering the potential to build another home or two. This charming residence provides a serene escape with stunning views of the lush surroundings, set in a peaceful community perfect for families and nature lovers alike.This property offers a prime, convenient location with just a 30-minute drive to the new Target in Kaneohe, a quick 3-minute trip to CVS and Tamura's Market, and only a 5-minute walk to the local beach park and Hauula Loop Trail. Nestled on a quiet back road in the beautiful Hauula area, it’s perfect for extended families or investors with excellent rental income potential.
With proximity to pristine beaches, hiking trails, and local parks, residents can enjoy endless outdoor activities. The welcoming neighborhood fosters strong connections among neighbors, and nearby shops and dining options add convenience. Whether you’re seeking a tranquil place to call home or a lucrative investment opportunity, the possibilities here are endless.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 18991.00
)
[SqftTotal] => Array
(
[0] => 3466
)
[YearBuilt] => Array
(
[0] => 1991
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP
)
[ListAgentEmail] => Array
(
[0] => david.cordeiro@kw.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 551-2704
)
[ListAgentFullName] => Array
(
[0] => David Cordeiro
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-05T17:42:20.813
)
[Matrix_Unique_ID] => Array
(
[0] => 18282081
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-25T05:11:41.180
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26711490
)
[listing_image] => Array
(
[0] => 26711490
[1] => 26711491
[2] => 26711492
[3] => 26711493
[4] => 26711494
[5] => 26711495
[6] => 26711496
[7] => 26711497
[8] => 26711498
[9] => 26711499
[10] => 26711500
[11] => 26711501
[12] => 26711502
[13] => 26711503
[14] => 26711504
[15] => 26711505
[16] => 26711506
[17] => 26712001
[18] => 26712002
[19] => 26712003
[20] => 26712004
[21] => 26712005
[22] => 26712006
)
)
