Listing
Overview
Price: $2,498,000
Area: HAUULA
Status: Active
Experience the ultimate in oceanfront living on Oahu’s east side. This stunning 4-bedroom, 4-bath residence blends modern elegance with island charm, showcasing panoramic ocean and mountain views from nearly every level. Thoughtfully remodeled in 2019, the home offers a flexible floor plan with multiple living spaces: a spacious recreation room with separate entry and bath on the first floor, a light-filled main living area and chef-inspired kitchen on the second, and a serene primary suite with loft/office retreat on the top level. High-end finishes, and tasteful furnishings create a refined yet welcoming atmosphere. Step outside to enjoy direct water access, gentle trade winds, and endless sunrises over the Pacific. Built in 2003 with updated amenities and stylish design, this rare oceanfront gem delivers the perfect balance of sophistication, comfort, and the relaxed pace of island life. An exceptional opportunity to own a piece of paradise in Hauula. Listing by: Compass (808) 825-4277
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202518843"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "53-853"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(10) "Kamehameha"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(7) "Highway"
}
["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(61) "https://www.youtube.com/embed/P6lfPmOqi9A?si=qyWLbSHNKmr2efHg"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2498000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(970) "Experience the ultimate in oceanfront living on Oahu’s east side. This stunning 4-bedroom, 4-bath residence blends modern elegance with island charm, showcasing panoramic ocean and mountain views from nearly every level. Thoughtfully remodeled in 2019, the home offers a flexible floor plan with multiple living spaces: a spacious recreation room with separate entry and bath on the first floor, a light-filled main living area and chef-inspired kitchen on the second, and a serene primary suite with loft/office retreat on the top level. High-end finishes, and tasteful furnishings create a refined yet welcoming atmosphere. Step outside to enjoy direct water access, gentle trade winds, and endless sunrises over the Pacific. Built in 2003 with updated amenities and stylish design, this rare oceanfront gem delivers the perfect balance of sophistication, comfort, and the relaxed pace of island life. An exceptional opportunity to own a piece of paradise in Hauula."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(7) "Compass"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5052.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2606"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2003"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(6) "Three+"
}
["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(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "COHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "stephanie@hawaiidreamhomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 825-4277"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Stephanie Rae Band"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18946916"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-02T17:00:01.753"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-09-29"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.753"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27167275"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27167275"
[1]=>
string(8) "27167276"
[2]=>
string(8) "27167277"
[3]=>
string(8) "27167278"
[4]=>
string(8) "27167279"
[5]=>
string(8) "27167280"
[6]=>
string(8) "27167281"
[7]=>
string(8) "27167282"
[8]=>
string(8) "27167283"
[9]=>
string(8) "27167284"
[10]=>
string(8) "27167285"
[11]=>
string(8) "27167286"
[12]=>
string(8) "27167287"
[13]=>
string(8) "27167288"
[14]=>
string(8) "27167289"
[15]=>
string(8) "27167290"
[16]=>
string(8) "27167291"
[17]=>
string(8) "27167292"
[18]=>
string(8) "27167293"
[19]=>
string(8) "27167294"
[20]=>
string(8) "27167295"
[21]=>
string(8) "27167296"
[22]=>
string(8) "27167297"
[23]=>
string(8) "27167298"
[24]=>
string(8) "27167299"
[25]=>
string(8) "27167300"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202518843
)
[StreetNumber] => Array
(
[0] => 53-853
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/P6lfPmOqi9A?si=qyWLbSHNKmr2efHg
)
[ListPrice] => Array
(
[0] => 2498000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Experience the ultimate in oceanfront living on Oahu’s east side. This stunning 4-bedroom, 4-bath residence blends modern elegance with island charm, showcasing panoramic ocean and mountain views from nearly every level. Thoughtfully remodeled in 2019, the home offers a flexible floor plan with multiple living spaces: a spacious recreation room with separate entry and bath on the first floor, a light-filled main living area and chef-inspired kitchen on the second, and a serene primary suite with loft/office retreat on the top level. High-end finishes, and tasteful furnishings create a refined yet welcoming atmosphere. Step outside to enjoy direct water access, gentle trade winds, and endless sunrises over the Pacific. Built in 2003 with updated amenities and stylish design, this rare oceanfront gem delivers the perfect balance of sophistication, comfort, and the relaxed pace of island life. An exceptional opportunity to own a piece of paradise in Hauula.
)
[ListOfficeName] => Array
(
[0] => Compass
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5052.00
)
[SqftTotal] => Array
(
[0] => 2606
)
[YearBuilt] => Array
(
[0] => 2003
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Three+
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => COHI
)
[ListAgentEmail] => Array
(
[0] => stephanie@hawaiidreamhomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 825-4277
)
[ListAgentFullName] => Array
(
[0] => Stephanie Rae Band
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18946916
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-02T17:00:01.753
)
[ListingContractDate] => Array
(
[0] => 2025-09-29
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.753
)
[_thumbnail_id] => Array
(
[0] => 27167275
)
[listing_image] => Array
(
[0] => 27167275
[1] => 27167276
[2] => 27167277
[3] => 27167278
[4] => 27167279
[5] => 27167280
[6] => 27167281
[7] => 27167282
[8] => 27167283
[9] => 27167284
[10] => 27167285
[11] => 27167286
[12] => 27167287
[13] => 27167288
[14] => 27167289
[15] => 27167290
[16] => 27167291
[17] => 27167292
[18] => 27167293
[19] => 27167294
[20] => 27167295
[21] => 27167296
[22] => 27167297
[23] => 27167298
[24] => 27167299
[25] => 27167300
)
)
- BedsTotal: 4
- Full Baths: 4
- Land Area (sf): 5,052 sf
- Living (sf): 2,606
- Year Built: 2003
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Coastline,Mountain,Ocean,Sunrise
- Listing Office: Compass
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 2, 2025 - 5:00 PM
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.