Listing
Overview
Price: $1,195,000
Area: HAUULA
Status: Active Under Contract
The call of the ocean is just a minutes walk away from this gem in the heart of Hau'ula! The flat and gated lot is great for BBQ's and the ample carport provides covered parking with room for more on the side of the home. Perfect space for you boat, toys, or projects! Upper and lower level living areas have separate entries with vinyl plank flooring throughout. Lower level features a bedroom with full bath and walk-in shower, living area with access to the yard, and a spacious laundry room with storage. Upper level of the home features a large open chefs kitchen with granite counter tops, stone backsplash, and stainless appliances. Enjoy morning sunrise coffee on the large covered lanai or set up a table to dine al fresco! Large open main living area offers many possibilities while the main bedroom features a retreat to a beautiful walk-in shower and tub for some quiet time. Feeling adventurous? Beach access is just a minute away with a nice sandy beach, tide pools, and great fishing from the water or shore! Don't feel like catching your own dinner? Walk across the street to Tamura's or Papa Ole's for a quick bite with Longs Drugs next door as well! Photos have been enhanced. Listing by: Redfin Corporation (808) 276-9186
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408752"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "54-339"
}
["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(51) "https://my.matterport.com/show/?m=LWmz66KZnNi&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1195000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1195000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(6) "HAUULA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1194) "The call of the ocean is just a minutes walk away from this gem in the heart of Hau'ula! The flat and gated lot is great for BBQ's and the ample carport provides covered parking with room for more on the side of the home. Perfect space for you boat, toys, or projects! Upper and lower level living areas have separate entries with vinyl plank flooring throughout. Lower level features a bedroom with full bath and walk-in shower, living area with access to the yard, and a spacious laundry room with storage. Upper level of the home features a large open chefs kitchen with granite counter tops, stone backsplash, and stainless appliances. Enjoy morning sunrise coffee on the large covered lanai or set up a table to dine al fresco! Large open main living area offers many possibilities while the main bedroom features a retreat to a beautiful walk-in shower and tub for some quiet time. Feeling adventurous? Beach access is just a minute away with a nice sandy beach, tide pools, and great fishing from the water or shore! Don't feel like catching your own dinner? Walk across the street to Tamura's or Papa Ole's for a quick bite with Longs Drugs next door as well! Photos have been enhanced."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(18) "Redfin Corporation"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5001.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1948"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2017"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(16) "Mountain,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) "RFIN"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "gene.neal@redfin.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 276-9186"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(9) "Gene Neal"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-03T10:18:27.823"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17953981"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-25T16:54:44.193"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Kaneohe"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26179846"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26179846"
[1]=>
string(8) "26179847"
[2]=>
string(8) "26179848"
[3]=>
string(8) "26179849"
[4]=>
string(8) "26179850"
[5]=>
string(8) "26179851"
[6]=>
string(8) "26179852"
[7]=>
string(8) "26179853"
[8]=>
string(8) "26179854"
[9]=>
string(8) "26179855"
[10]=>
string(8) "26179856"
[11]=>
string(8) "26179857"
[12]=>
string(8) "26179858"
[13]=>
string(8) "26179859"
[14]=>
string(8) "26179860"
[15]=>
string(8) "26179861"
[16]=>
string(8) "26179862"
[17]=>
string(8) "26179863"
[18]=>
string(8) "26179864"
[19]=>
string(8) "26179865"
[20]=>
string(8) "26179866"
[21]=>
string(8) "26179867"
[22]=>
string(8) "26179868"
[23]=>
string(8) "26179869"
[24]=>
string(8) "26179870"
[25]=>
string(8) "26179871"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408752
)
[StreetNumber] => Array
(
[0] => 54-339
)
[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://my.matterport.com/show/?m=LWmz66KZnNi&mls=1
)
[ListPrice] => Array
(
[0] => 1195000.00
)
[CurrentPrice] => Array
(
[0] => 1195000.00
)
[Neighbourhood] => Array
(
[0] => HAUULA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => The call of the ocean is just a minutes walk away from this gem in the heart of Hau'ula! The flat and gated lot is great for BBQ's and the ample carport provides covered parking with room for more on the side of the home. Perfect space for you boat, toys, or projects! Upper and lower level living areas have separate entries with vinyl plank flooring throughout. Lower level features a bedroom with full bath and walk-in shower, living area with access to the yard, and a spacious laundry room with storage. Upper level of the home features a large open chefs kitchen with granite counter tops, stone backsplash, and stainless appliances. Enjoy morning sunrise coffee on the large covered lanai or set up a table to dine al fresco! Large open main living area offers many possibilities while the main bedroom features a retreat to a beautiful walk-in shower and tub for some quiet time. Feeling adventurous? Beach access is just a minute away with a nice sandy beach, tide pools, and great fishing from the water or shore! Don't feel like catching your own dinner? Walk across the street to Tamura's or Papa Ole's for a quick bite with Longs Drugs next door as well! Photos have been enhanced.
)
[ListOfficeName] => Array
(
[0] => Redfin Corporation
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 5001.00
)
[SqftTotal] => Array
(
[0] => 1948
)
[YearBuilt] => Array
(
[0] => 2017
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 5
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain,Sunrise
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RFIN
)
[ListAgentEmail] => Array
(
[0] => gene.neal@redfin.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 276-9186
)
[ListAgentFullName] => Array
(
[0] => Gene Neal
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-03T10:18:27.823
)
[Matrix_Unique_ID] => Array
(
[0] => 17953981
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-25T16:54:44.193
)
[MLSAreaMajor] => Array
(
[0] => Kaneohe
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26179846
)
[listing_image] => Array
(
[0] => 26179846
[1] => 26179847
[2] => 26179848
[3] => 26179849
[4] => 26179850
[5] => 26179851
[6] => 26179852
[7] => 26179853
[8] => 26179854
[9] => 26179855
[10] => 26179856
[11] => 26179857
[12] => 26179858
[13] => 26179859
[14] => 26179860
[15] => 26179861
[16] => 26179862
[17] => 26179863
[18] => 26179864
[19] => 26179865
[20] => 26179866
[21] => 26179867
[22] => 26179868
[23] => 26179869
[24] => 26179870
[25] => 26179871
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 5,001
- Living (sf): 1,948
- Year Built: 2017
- Property Condition: Above Average
- Number of Parking Spaces: 5
- View: Mountain,Sunrise
- Listing Office: Redfin Corporation
- Land Tenure: FS - Fee Simple
