Listing
Overview
Price: $3,468,000
Area: HAUULA
Status: Active
Wake to the soothing rhythmic sounds of the Pacific Ocean in the paradise of Hawaii. This beautiful and rare single level custom home built in 2008 with a 3055 square foot interior was constructed to maximize the unparalleled direct ocean views and cool island breezes. Extra high vaulted ceilings lend added grandeur to the living and dining spaces. This gorgeous and immaculate residence is just waiting for your to move right in. Enjoy the island lifestyle of sipping a mug of Kona coffee while watching the beautiful island sunrise, swimming in the cool Pacific Ocean, counting the stars at night, entertaining your guests with an oceanside BBQ, and exploring all that the island has to offer. The location of this prime beachfront property is extremely convenient directly across from Hauula Kai Shopping Center with Dominos, CVS Long's Drugs, Tamura's Market with their famous fresh from the sea Poke, Hauula Post Office, everyone's favorite Papa Ole's Kitchen, and just a short jaunt to the Polynesian Cultural Center and Laie Shopping Center with even more wonderful island style eateries and entertainment. One or more photos have been enhanced. SEE VIDEO IN REELS Listing by: The Agency-Oahu (808) 728-1698
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202407677"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-327"
}
["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(2) "1B"
}
["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(85) "https://drive.google.com/file/d/1jHxA3-ZoeSt1gRz20Waob2q_9T_QJpEN/view?usp=drive_link"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3468000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "3468000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1173) "Wake to the soothing rhythmic sounds of the Pacific Ocean in the paradise of Hawaii. This beautiful and rare single level custom home built in 2008 with a 3055 square foot interior was constructed to maximize the unparalleled direct ocean views and cool island breezes. Extra high vaulted ceilings lend added grandeur to the living and dining spaces. This gorgeous and immaculate residence is just waiting for your to move right in. Enjoy the island lifestyle of sipping a mug of Kona coffee while watching the beautiful island sunrise, swimming in the cool Pacific Ocean, counting the stars at night, entertaining your guests with an oceanside BBQ, and exploring all that the island has to offer. The location of this prime beachfront property is extremely convenient directly across from Hauula Kai Shopping Center with Dominos, CVS Long's Drugs, Tamura's Market with their famous fresh from the sea Poke, Hauula Post Office, everyone's favorite Papa Ole's Kitchen, and just a short jaunt to the Polynesian Cultural Center and Laie Shopping Center with even more wonderful island style eateries and entertainment. One or more photos have been enhanced. SEE VIDEO IN REELS"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(15) "The Agency-Oahu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "31091.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3055"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2008"
}
["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(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(39) "Coastline,Garden,Mountain,Ocean,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "327.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) "GROW"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "owentherealtor@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 728-1698"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Owen T Kashiwamura"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-19T20:13:32.450"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17923260"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-04T14:17:23.937"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(17) "Ocean,Sandy Beach"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26153748"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "26153748"
[1]=>
string(8) "26153749"
[2]=>
string(8) "26153750"
[3]=>
string(8) "26153751"
[4]=>
string(8) "26153752"
[5]=>
string(8) "26153753"
[6]=>
string(8) "26153754"
[7]=>
string(8) "26153755"
[8]=>
string(8) "26153756"
[9]=>
string(8) "26153757"
[10]=>
string(8) "26672693"
[11]=>
string(8) "26672694"
[12]=>
string(8) "26672695"
[13]=>
string(8) "26672696"
[14]=>
string(8) "26672697"
[15]=>
string(8) "26672698"
[16]=>
string(8) "26672699"
[17]=>
string(8) "26673636"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202407677
)
[StreetNumber] => Array
(
[0] => 54-327
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kamehameha
)
[StreetSuffix] => Array
(
[0] => Highway
)
[UnitNumber] => Array
(
[0] => 1B
)
[City] => Array
(
[0] => Hauula
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96717
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://drive.google.com/file/d/1jHxA3-ZoeSt1gRz20Waob2q_9T_QJpEN/view?usp=drive_link
)
[ListPrice] => Array
(
[0] => 3468000.00
)
[CurrentPrice] => Array
(
[0] => 3468000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Wake to the soothing rhythmic sounds of the Pacific Ocean in the paradise of Hawaii. This beautiful and rare single level custom home built in 2008 with a 3055 square foot interior was constructed to maximize the unparalleled direct ocean views and cool island breezes. Extra high vaulted ceilings lend added grandeur to the living and dining spaces. This gorgeous and immaculate residence is just waiting for your to move right in. Enjoy the island lifestyle of sipping a mug of Kona coffee while watching the beautiful island sunrise, swimming in the cool Pacific Ocean, counting the stars at night, entertaining your guests with an oceanside BBQ, and exploring all that the island has to offer. The location of this prime beachfront property is extremely convenient directly across from Hauula Kai Shopping Center with Dominos, CVS Long's Drugs, Tamura's Market with their famous fresh from the sea Poke, Hauula Post Office, everyone's favorite Papa Ole's Kitchen, and just a short jaunt to the Polynesian Cultural Center and Laie Shopping Center with even more wonderful island style eateries and entertainment. One or more photos have been enhanced. SEE VIDEO IN REELS
)
[ListOfficeName] => Array
(
[0] => The Agency-Oahu
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 31091.00
)
[SqftTotal] => Array
(
[0] => 3055
)
[YearBuilt] => Array
(
[0] => 2008
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunrise
)
[MaintenanceExpense] => Array
(
[0] => 327.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Hauula
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => GROW
)
[ListAgentEmail] => Array
(
[0] => owentherealtor@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 728-1698
)
[ListAgentFullName] => Array
(
[0] => Owen T Kashiwamura
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-19T20:13:32.450
)
[Matrix_Unique_ID] => Array
(
[0] => 17923260
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-04T14:17:23.937
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26153748
)
[listing_image] => Array
(
[0] => 26153748
[1] => 26153749
[2] => 26153750
[3] => 26153751
[4] => 26153752
[5] => 26153753
[6] => 26153754
[7] => 26153755
[8] => 26153756
[9] => 26153757
[10] => 26672693
[11] => 26672694
[12] => 26672695
[13] => 26672696
[14] => 26672697
[15] => 26672698
[16] => 26672699
[17] => 26673636
)
)
- BedsTotal: 3
- Full Baths: 3
- Half Baths: 1
- Land Area (sf): 31,091
- Living (sf): 3,055
- Year Built: 2008
- Property Condition: Excellent
- Number of Parking Spaces: 4
- View: Coastline,Garden,Mountain,Ocean,Sunrise
- Listing Office: The Agency-Oahu
- Maintenance Fees: $327
- Land Tenure: FS - Fee Simple
- Elementary School: Hauula
- Middle School: Kahuku
- High School: Kahuku
