Listing
Overview
Price: $1,399,000
Area: HAUULA
Status: Active
Live cool and comfortably in this spacious 5-bedroom, 4-bathroom home with Nest controlled central AC. Located in Hau'ula, just a minute's drive from groceries, restaurants, medical and post offices you're always close to the necessities. As a bonus, you're only a minute away from Hau'ula and Kakela Beach Parks for sunrise/sunset walks or family days at the beach. This gem of a home offers the perfect blend of convenience, comfort and coastal charm. Enjoy the rare luxury of central AC—ideal for staying cool and relaxed even during those hot and humid summer days. Double your AC pleasure knowing that your 20 owned photovoltaic panels are subsidizing your cool. The home also features ample storage for all your beach gear and more, plus a convenient two-car garage with extra driveway parking. Rental income while living in the home is possible too with a separate entrance to a 1 bedroom space. With its close proximity to the beach and a layout designed for easy living, this house is perfect for anyone craving that laid-back island lifestyle. Don’t miss your chance to make it yours—see the virtual tour, layout (in pics) and come see it today! Listing by: Staples Realty, Inc. (808) 428-1975
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202420779"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-298"
}
["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(1) "B"
}
["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(71) "https://unbranded.youriguide.com/54_298b_hauula_homestead_rd_hauula_hi/"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1399000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1399000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1161) "Live cool and comfortably in this spacious 5-bedroom, 4-bathroom home with Nest controlled central AC. Located in Hau'ula, just a minute's drive from groceries, restaurants, medical and post offices you're always close to the necessities. As a bonus, you're only a minute away from Hau'ula and Kakela Beach Parks for sunrise/sunset walks or family days at the beach. This gem of a home offers the perfect blend of convenience, comfort and coastal charm. Enjoy the rare luxury of central AC—ideal for staying cool and relaxed even during those hot and humid summer days. Double your AC pleasure knowing that your 20 owned photovoltaic panels are subsidizing your cool. The home also features ample storage for all your beach gear and more, plus a convenient two-car garage with extra driveway parking. Rental income while living in the home is possible too with a separate entrance to a 1 bedroom space. With its close proximity to the beach and a layout designed for easy living, this house is perfect for anyone craving that laid-back island lifestyle. Don’t miss your chance to make it yours—see the virtual tour, layout (in pics) and come see it today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "Staples Realty, Inc."
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5300.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3900"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2006"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Hauula"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "STAP"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "jeremy@stapleshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 428-1975"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Jeremy J Moncur"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-14T17:00:01.817"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18254153"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-11T08:56:42.123"
}
["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) "26690021"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26690021"
[1]=>
string(8) "26690022"
[2]=>
string(8) "26690023"
[3]=>
string(8) "26690024"
[4]=>
string(8) "26690025"
[5]=>
string(8) "26690026"
[6]=>
string(8) "26690027"
[7]=>
string(8) "26690028"
[8]=>
string(8) "26690029"
[9]=>
string(8) "26690030"
[10]=>
string(8) "26690031"
[11]=>
string(8) "26690032"
[12]=>
string(8) "26690033"
[13]=>
string(8) "26690034"
[14]=>
string(8) "26690035"
[15]=>
string(8) "26690036"
[16]=>
string(8) "26690037"
[17]=>
string(8) "26690038"
[18]=>
string(8) "26690039"
[19]=>
string(8) "26690040"
[20]=>
string(8) "26690041"
[21]=>
string(8) "26690042"
[22]=>
string(8) "26690043"
[23]=>
string(8) "26690044"
[24]=>
string(8) "26690045"
[25]=>
string(8) "26690046"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202420779
)
[StreetNumber] => Array
(
[0] => 54-298
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hauula Homestead
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] => B
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://unbranded.youriguide.com/54_298b_hauula_homestead_rd_hauula_hi/
)
[ListPrice] => Array
(
[0] => 1399000.00
)
[CurrentPrice] => Array
(
[0] => 1399000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Live cool and comfortably in this spacious 5-bedroom, 4-bathroom home with Nest controlled central AC. Located in Hau'ula, just a minute's drive from groceries, restaurants, medical and post offices you're always close to the necessities. As a bonus, you're only a minute away from Hau'ula and Kakela Beach Parks for sunrise/sunset walks or family days at the beach. This gem of a home offers the perfect blend of convenience, comfort and coastal charm. Enjoy the rare luxury of central AC—ideal for staying cool and relaxed even during those hot and humid summer days. Double your AC pleasure knowing that your 20 owned photovoltaic panels are subsidizing your cool. The home also features ample storage for all your beach gear and more, plus a convenient two-car garage with extra driveway parking. Rental income while living in the home is possible too with a separate entrance to a 1 bedroom space. With its close proximity to the beach and a layout designed for easy living, this house is perfect for anyone craving that laid-back island lifestyle. Don’t miss your chance to make it yours—see the virtual tour, layout (in pics) and come see it today!
)
[ListOfficeName] => Array
(
[0] => Staples Realty, Inc.
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5300.00
)
[SqftTotal] => Array
(
[0] => 3900
)
[YearBuilt] => Array
(
[0] => 2006
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] => 0.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Hauula
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => STAP
)
[ListAgentEmail] => Array
(
[0] => jeremy@stapleshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 428-1975
)
[ListAgentFullName] => Array
(
[0] => Jeremy J Moncur
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-14T17:00:01.817
)
[Matrix_Unique_ID] => Array
(
[0] => 18254153
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-11T08:56:42.123
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26690021
)
[listing_image] => Array
(
[0] => 26690021
[1] => 26690022
[2] => 26690023
[3] => 26690024
[4] => 26690025
[5] => 26690026
[6] => 26690027
[7] => 26690028
[8] => 26690029
[9] => 26690030
[10] => 26690031
[11] => 26690032
[12] => 26690033
[13] => 26690034
[14] => 26690035
[15] => 26690036
[16] => 26690037
[17] => 26690038
[18] => 26690039
[19] => 26690040
[20] => 26690041
[21] => 26690042
[22] => 26690043
[23] => 26690044
[24] => 26690045
[25] => 26690046
)
)
- BedsTotal: 5
- Full Baths: 4
- Land Area (sf): 5,300
- Living (sf): 3,900
- Year Built: 2006
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 3
- View: Mountain,Ocean
- Listing Office: Staples Realty, Inc.
- Maintenance Fees: $0
- Land Tenure: FS - Fee Simple
- Elementary School: Hauula
- Middle School: Kahuku
- High School: Kahuku
