Listing
Overview
Price: $2,300,000
Area: HAUULA
Status: Active
Experience the best of island living with this stunning oceanfront compound, featuring two separate homes on one spacious lot. Enjoy breathtaking panoramic ocean views and the majestic Windward coastline, all nestled on a quiet loop in Hauula. This rarely available property offers a total of 7 bedrooms and 4 bathrooms, with tasteful renovations completed in 2022. The roadside includes 3 bedrooms and 2 bathrooms, while the oceanfront unit offers 4 bedrooms and 2 bathrooms. The versatile layout offers a range of living options, including multigenerational living, a primary residence with rental income, or a long-term investment. Don't miss this one-of-a-kind opportunity-schedule your private tour today! Listing by: Forward Realty (808) 206-2793
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202514428"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-257"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Kaipapau"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["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(102) "https://www.hommati.com/3DTour-AerialVideo/unbranded/54-257-Kaipapau-Loop-Hauula-Hi-96717--HPI57732964"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2300000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(710) "Experience the best of island living with this stunning oceanfront compound, featuring two separate homes on one spacious lot. Enjoy breathtaking panoramic ocean views and the majestic Windward coastline, all nestled on a quiet loop in Hauula. This rarely available property offers a total of 7 bedrooms and 4 bathrooms, with tasteful renovations completed in 2022. The roadside includes 3 bedrooms and 2 bathrooms, while the oceanfront unit offers 4 bedrooms and 2 bathrooms. The versatile layout offers a range of living options, including multigenerational living, a primary residence with rental income, or a long-term investment. Don't miss this one-of-a-kind opportunity-schedule your private tour today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(14) "Forward Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10000.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3150"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(7) "One,Two"
}
["View"]=>
array(1) {
[0]=>
string(32) "Coastline,Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["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) "BENN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(29) "hungerfords@forwardrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 206-2793"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(15) "Sean Hungerford"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18817198"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-07-03T08:45:02.037"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-06-30"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(16) "Ocean,Waterfront"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:45:02.037"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27050189"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27050189"
[1]=>
string(8) "27050190"
[2]=>
string(8) "27050191"
[3]=>
string(8) "27050192"
[4]=>
string(8) "27050193"
[5]=>
string(8) "27050194"
[6]=>
string(8) "27050195"
[7]=>
string(8) "27050196"
[8]=>
string(8) "27050197"
[9]=>
string(8) "27050198"
[10]=>
string(8) "27050199"
[11]=>
string(8) "27050200"
[12]=>
string(8) "27050201"
[13]=>
string(8) "27050202"
[14]=>
string(8) "27050203"
[15]=>
string(8) "27050204"
[16]=>
string(8) "27050205"
[17]=>
string(8) "27050206"
[18]=>
string(8) "27050207"
[19]=>
string(8) "27050208"
[20]=>
string(8) "27050209"
[21]=>
string(8) "27050210"
[22]=>
string(8) "27050211"
[23]=>
string(8) "27050212"
[24]=>
string(8) "27050213"
[25]=>
string(8) "27050214"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202514428
)
[StreetNumber] => Array
(
[0] => 54-257
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kaipapau
)
[StreetSuffix] => Array
(
[0] => Loop
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.hommati.com/3DTour-AerialVideo/unbranded/54-257-Kaipapau-Loop-Hauula-Hi-96717--HPI57732964
)
[ListPrice] => Array
(
[0] => 2300000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Experience the best of island living with this stunning oceanfront compound, featuring two separate homes on one spacious lot. Enjoy breathtaking panoramic ocean views and the majestic Windward coastline, all nestled on a quiet loop in Hauula. This rarely available property offers a total of 7 bedrooms and 4 bathrooms, with tasteful renovations completed in 2022. The roadside includes 3 bedrooms and 2 bathrooms, while the oceanfront unit offers 4 bedrooms and 2 bathrooms. The versatile layout offers a range of living options, including multigenerational living, a primary residence with rental income, or a long-term investment. Don't miss this one-of-a-kind opportunity-schedule your private tour today!
)
[ListOfficeName] => Array
(
[0] => Forward Realty
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 10000.00
)
[SqftTotal] => Array
(
[0] => 3150
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => One,Two
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Hauula
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => BENN
)
[ListAgentEmail] => Array
(
[0] => hungerfords@forwardrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 206-2793
)
[ListAgentFullName] => Array
(
[0] => Sean Hungerford
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18817198
)
[MatrixModifiedDT] => Array
(
[0] => 2025-07-03T08:45:02.037
)
[ListingContractDate] => Array
(
[0] => 2025-06-30
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:45:02.037
)
[_thumbnail_id] => Array
(
[0] => 27050189
)
[listing_image] => Array
(
[0] => 27050189
[1] => 27050190
[2] => 27050191
[3] => 27050192
[4] => 27050193
[5] => 27050194
[6] => 27050195
[7] => 27050196
[8] => 27050197
[9] => 27050198
[10] => 27050199
[11] => 27050200
[12] => 27050201
[13] => 27050202
[14] => 27050203
[15] => 27050204
[16] => 27050205
[17] => 27050206
[18] => 27050207
[19] => 27050208
[20] => 27050209
[21] => 27050210
[22] => 27050211
[23] => 27050212
[24] => 27050213
[25] => 27050214
)
)
- BedsTotal: 7
- Full Baths: 4
- Land Area (sf): 10,000 sf
- Living (sf): 3,150
- Year Built: 1963
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 6
- View: Coastline,Mountain,Ocean,Sunrise
- Listing Office: Forward Realty
- Land Tenure: FS - Fee Simple
- Elementary School: Hauula
- Middle School: Kahuku
- High School: Kahuku
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 3, 2025 - 8:45 AM
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.
© Marcus Realty. All Rights Reserved.
