Listing
Overview
Price: $1,675,000
Area: NIU VALLEY
Status: Active Under Contract
Welcome home to your very own piece of island paradise in the highly desirable Niu Valley community! This home is a rare gem having been completely renovated and upgraded inside and out in 2024. Boasting a bright new Kitchen with large island marble counter tops, walk-in pantry, new cabinets, stainless appliances. The open floor plan is perfect for entertaining, joining the kitchen and living spaces seamlessly with the separate bar and outdoor patio areas. Boasting 4 spacious bedrooms. 3 bedrooms on the main floor. Second floor has the primary en-suite featuring a beautiful ocean view. 2 new spa-like bathrooms with custom shower and tub. Half bath. Laundry room, new plumbing and fixtures. New electric, LED light fixtures. New flooring. Split-AC. Fully insulated ceiling and walls to keep the home cool and comfortable. 2 covered patio areas perfect to relax and entertain large or small groups of family and friends. New landscaping. Lots of storage. Spacious Carport. Lots of street parking. Perfectly located near all the amenities, beaches, hiking, golf courses, schools, restaurants, shopping centers, public transportation and more. Property to be conveyed “As-Is” Listing by: OahuRE.com (808) 425-7887
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202417181"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "5847"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Haleola"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(8) "Honolulu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96821"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(61) "https://www.youtube.com/embed/Fv5Q2I704HA?si=np8AxI2dbKBeaioE"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1675000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1675000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(10) "NIU VALLEY"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1183) "Welcome home to your very own piece of island paradise in the highly desirable Niu Valley community! This home is a rare gem having been completely renovated and upgraded inside and out in 2024. Boasting a bright new Kitchen with large island marble counter tops, walk-in pantry, new cabinets, stainless appliances. The open floor plan is perfect for entertaining, joining the kitchen and living spaces seamlessly with the separate bar and outdoor patio areas. Boasting 4 spacious bedrooms. 3 bedrooms on the main floor. Second floor has the primary en-suite featuring a beautiful ocean view. 2 new spa-like bathrooms with custom shower and tub. Half bath. Laundry room, new plumbing and fixtures. New electric, LED light fixtures. New flooring. Split-AC. Fully insulated ceiling and walls to keep the home cool and comfortable. 2 covered patio areas perfect to relax and entertain large or small groups of family and friends. New landscaping. Lots of storage. Spacious Carport. Lots of street parking. Perfectly located near all the amenities, beaches, hiking, golf courses, schools, restaurants, shopping centers, public transportation and more. Property to be conveyed “As-Is”"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "OahuRE.com"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "10160.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2743"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1962"
}
["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) "Two"
}
["View"]=>
array(1) {
[0]=>
string(36) "City,Coastline,Garden,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(10) "Aina Haina"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(10) "Niu Valley"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kalani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "GIVE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(15) "bryn@oahure.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 425-7887"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(14) "Bryn W Kaufman"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-26T19:28:43.570"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18159742"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-05T10:56:25.613"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26648248"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26648248"
[1]=>
string(8) "26648249"
[2]=>
string(8) "26648250"
[3]=>
string(8) "26648251"
[4]=>
string(8) "26648252"
[5]=>
string(8) "26648253"
[6]=>
string(8) "26648254"
[7]=>
string(8) "26648255"
[8]=>
string(8) "26648256"
[9]=>
string(8) "26648257"
[10]=>
string(8) "26648258"
[11]=>
string(8) "26648259"
[12]=>
string(8) "26648260"
[13]=>
string(8) "26648261"
[14]=>
string(8) "26648262"
[15]=>
string(8) "26648263"
[16]=>
string(8) "26648264"
[17]=>
string(8) "26648265"
[18]=>
string(8) "26648266"
[19]=>
string(8) "26648267"
[20]=>
string(8) "26648268"
[21]=>
string(8) "26648269"
[22]=>
string(8) "26648270"
[23]=>
string(8) "26648271"
[24]=>
string(8) "26648272"
[25]=>
string(8) "26648273"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202417181
)
[StreetNumber] => Array
(
[0] => 5847
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Haleola
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://www.youtube.com/embed/Fv5Q2I704HA?si=np8AxI2dbKBeaioE
)
[ListPrice] => Array
(
[0] => 1675000.00
)
[CurrentPrice] => Array
(
[0] => 1675000.00
)
[Neighbourhood] => Array
(
[0] => NIU VALLEY
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Welcome home to your very own piece of island paradise in the highly desirable Niu Valley community! This home is a rare gem having been completely renovated and upgraded inside and out in 2024. Boasting a bright new Kitchen with large island marble counter tops, walk-in pantry, new cabinets, stainless appliances. The open floor plan is perfect for entertaining, joining the kitchen and living spaces seamlessly with the separate bar and outdoor patio areas. Boasting 4 spacious bedrooms. 3 bedrooms on the main floor. Second floor has the primary en-suite featuring a beautiful ocean view. 2 new spa-like bathrooms with custom shower and tub. Half bath. Laundry room, new plumbing and fixtures. New electric, LED light fixtures. New flooring. Split-AC. Fully insulated ceiling and walls to keep the home cool and comfortable. 2 covered patio areas perfect to relax and entertain large or small groups of family and friends. New landscaping. Lots of storage. Spacious Carport. Lots of street parking. Perfectly located near all the amenities, beaches, hiking, golf courses, schools, restaurants, shopping centers, public transportation and more. Property to be conveyed “As-Is”
)
[ListOfficeName] => Array
(
[0] => OahuRE.com
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 10160.00
)
[SqftTotal] => Array
(
[0] => 2743
)
[YearBuilt] => Array
(
[0] => 1962
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => City,Coastline,Garden,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Aina Haina
)
[MiddleOrJuniorSchool] => Array
(
[0] => Niu Valley
)
[HighSchool] => Array
(
[0] => Kalani
)
[ListOfficeMLSID] => Array
(
[0] => GIVE
)
[ListAgentEmail] => Array
(
[0] => bryn@oahure.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 425-7887
)
[ListAgentFullName] => Array
(
[0] => Bryn W Kaufman
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-26T19:28:43.570
)
[Matrix_Unique_ID] => Array
(
[0] => 18159742
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-05T10:56:25.613
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26648248
)
[listing_image] => Array
(
[0] => 26648248
[1] => 26648249
[2] => 26648250
[3] => 26648251
[4] => 26648252
[5] => 26648253
[6] => 26648254
[7] => 26648255
[8] => 26648256
[9] => 26648257
[10] => 26648258
[11] => 26648259
[12] => 26648260
[13] => 26648261
[14] => 26648262
[15] => 26648263
[16] => 26648264
[17] => 26648265
[18] => 26648266
[19] => 26648267
[20] => 26648268
[21] => 26648269
[22] => 26648270
[23] => 26648271
[24] => 26648272
[25] => 26648273
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 10,160
- Living (sf): 2,743
- Year Built: 1962
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 4
- View: City,Coastline,Garden,Mountain,Ocean
- Listing Office: OahuRE.com
- Land Tenure: FS - Fee Simple
- Elementary School: Aina Haina
- Middle School: Niu Valley
- High School: Kalani
