Listing
Overview
Price: $1,495,000
Area: HAUULA
Status: Active Under Contract
THE PERFECT BEACH HOUSE! Experience oceanfront living at its finest with this newly renovated single-level home in Oahu's North Shore town of Hauula. Located on a spacious lot in a quiet cul-de-sac, this rare gem offers a prime beachfront location with direct access to the coast within walking distance to Hau'ula Kai shopping center. Enjoy absolutely stunning ocean and mountain views from every room, making each day feel like a vacation. This charming 2 bedroom 2 bathroom cottage offers open concept living while taking advantage of the spectacular views. The primary bedroom includes an ensuite bath, walk-in closet and picturesque reading nook overlooking the serene water. Step outside to your large private beachfront yard, an idyllic setting to relax and entertain. Rinse off in the private outdoor shower after a day on the water and at the beach. With a legal seawall in place, your property is protected while preserving the natural beauty. Walk along the beautiful coast, relax in your hammock, surf, fish, dive and snorkel, embracing the oceanfront lifestyle. Don’t miss out on this incredible opportunity to own a piece of paradise perfect for weekend getaways or as a vacation home! Listing by: Corcoran Pacific Properties (808) 589-2040
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202414513"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-001"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Ahinalu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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(45) "https://my.matterport.com/show/?m=P5FuWPPKc52"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1495000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1495000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1201) "THE PERFECT BEACH HOUSE! Experience oceanfront living at its finest with this newly renovated single-level home in Oahu's North Shore town of Hauula. Located on a spacious lot in a quiet cul-de-sac, this rare gem offers a prime beachfront location with direct access to the coast within walking distance to Hau'ula Kai shopping center. Enjoy absolutely stunning ocean and mountain views from every room, making each day feel like a vacation. This charming 2 bedroom 2 bathroom cottage offers open concept living while taking advantage of the spectacular views. The primary bedroom includes an ensuite bath, walk-in closet and picturesque reading nook overlooking the serene water. Step outside to your large private beachfront yard, an idyllic setting to relax and entertain. Rinse off in the private outdoor shower after a day on the water and at the beach. With a legal seawall in place, your property is protected while preserving the natural beauty. Walk along the beautiful coast, relax in your hammock, surf, fish, dive and snorkel, embracing the oceanfront lifestyle. Don’t miss out on this incredible opportunity to own a piece of paradise perfect for weekend getaways or as a vacation home!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7597.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1063"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1965"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(39) "Coastline,Garden,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) "ELIT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "Heidi@corcoranpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Heidi G Bertucci"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-06T13:37:51.423"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18079113"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-06-18T17:37:18.077"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(16) "Ocean,Waterfront"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26591654"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26591654"
[1]=>
string(8) "26591655"
[2]=>
string(8) "26591656"
[3]=>
string(8) "26591657"
[4]=>
string(8) "26591658"
[5]=>
string(8) "26591659"
[6]=>
string(8) "26591660"
[7]=>
string(8) "26591661"
[8]=>
string(8) "26591662"
[9]=>
string(8) "26591663"
[10]=>
string(8) "26591664"
[11]=>
string(8) "26591665"
[12]=>
string(8) "26591666"
[13]=>
string(8) "26591667"
[14]=>
string(8) "26591668"
[15]=>
string(8) "26591669"
[16]=>
string(8) "26591670"
[17]=>
string(8) "26591671"
[18]=>
string(8) "26591672"
[19]=>
string(8) "26591673"
[20]=>
string(8) "26591674"
[21]=>
string(8) "26591675"
[22]=>
string(8) "26591676"
[23]=>
string(8) "26591677"
[24]=>
string(8) "26591678"
[25]=>
string(8) "26591679"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202414513
)
[StreetNumber] => Array
(
[0] => 54-001
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ahinalu
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=P5FuWPPKc52
)
[ListPrice] => Array
(
[0] => 1495000.00
)
[CurrentPrice] => Array
(
[0] => 1495000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => THE PERFECT BEACH HOUSE! Experience oceanfront living at its finest with this newly renovated single-level home in Oahu's North Shore town of Hauula. Located on a spacious lot in a quiet cul-de-sac, this rare gem offers a prime beachfront location with direct access to the coast within walking distance to Hau'ula Kai shopping center. Enjoy absolutely stunning ocean and mountain views from every room, making each day feel like a vacation. This charming 2 bedroom 2 bathroom cottage offers open concept living while taking advantage of the spectacular views. The primary bedroom includes an ensuite bath, walk-in closet and picturesque reading nook overlooking the serene water. Step outside to your large private beachfront yard, an idyllic setting to relax and entertain. Rinse off in the private outdoor shower after a day on the water and at the beach. With a legal seawall in place, your property is protected while preserving the natural beauty. Walk along the beautiful coast, relax in your hammock, surf, fish, dive and snorkel, embracing the oceanfront lifestyle. Don’t miss out on this incredible opportunity to own a piece of paradise perfect for weekend getaways or as a vacation home!
)
[ListOfficeName] => Array
(
[0] => Corcoran Pacific Properties
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7597.00
)
[SqftTotal] => Array
(
[0] => 1063
)
[YearBuilt] => Array
(
[0] => 1965
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ELIT
)
[ListAgentEmail] => Array
(
[0] => Heidi@corcoranpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 589-2040
)
[ListAgentFullName] => Array
(
[0] => Heidi G Bertucci
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-06T13:37:51.423
)
[Matrix_Unique_ID] => Array
(
[0] => 18079113
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-06-18T17:37:18.077
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Waterfront
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26591654
)
[listing_image] => Array
(
[0] => 26591654
[1] => 26591655
[2] => 26591656
[3] => 26591657
[4] => 26591658
[5] => 26591659
[6] => 26591660
[7] => 26591661
[8] => 26591662
[9] => 26591663
[10] => 26591664
[11] => 26591665
[12] => 26591666
[13] => 26591667
[14] => 26591668
[15] => 26591669
[16] => 26591670
[17] => 26591671
[18] => 26591672
[19] => 26591673
[20] => 26591674
[21] => 26591675
[22] => 26591676
[23] => 26591677
[24] => 26591678
[25] => 26591679
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 7,597
- Living (sf): 1,063
- Year Built: 1965
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 4
- View: Coastline,Garden,Mountain,Ocean,Sunrise
- Listing Office: Corcoran Pacific Properties
- Land Tenure: FS - Fee Simple
