Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
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) "2250000.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-12-14T17:00:01.350"
}
["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.350"
}
["_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] => 2250000.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-12-14T17:00:01.350
)
[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.350
)
[_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
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 14, 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.
