Listing
Overview
Price: $1,399,000
Area: NIU VALLEY
Status: Pending
Single-level residence with generous 7,500 sf level lot in the highly desirable NIU VALLEY! This recently upgraded legacy home is situated on a friendly and quiet street. Enjoy extra security and privacy - completely gated, large spacious front AND back yard spaces adorned with mature fruit trees (breadfruit, coconut, noni) perfect for gardening enthusiasts and outdoor entertaining! Recent upgrades include LVP flooring throughout, fresh exterior paint, newer kitchen and baths. Functional floorplan with endless possibilities! The main house includes 4 bed/2 bath. BONUS - Freshly renovated attached studio cottage (separate entrance) with upgraded bathroom, perfect for visiting guests, a multigenerational lifestyle or a private home office space. Ample street parking and perfectly located near beaches, Niu Valley Shopping Center, Aina Haina Shopping Center, schools, Hawaii Kai Costco, just a short drive to Kahala Mall, schools and neighborhood parks. Listing by: BHGRE Advantage Realty (808) 738-3600
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202416411"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(4) "5631"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(3) "Pia"
}
["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(59) "https://listings.hetproductions.com/sites/dwnxzvv/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1399000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1399000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(10) "NIU VALLEY"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(961) "Single-level residence with generous 7,500 sf level lot in the highly desirable NIU VALLEY! This recently upgraded legacy home is situated on a friendly and quiet street. Enjoy extra security and privacy - completely gated, large spacious front AND back yard spaces adorned with mature fruit trees (breadfruit, coconut, noni) perfect for gardening enthusiasts and outdoor entertaining! Recent upgrades include LVP flooring throughout, fresh exterior paint, newer kitchen and baths. Functional floorplan with endless possibilities! The main house includes 4 bed/2 bath. BONUS - Freshly renovated attached studio cottage (separate entrance) with upgraded bathroom, perfect for visiting guests, a multigenerational lifestyle or a private home office space. Ample street parking and perfectly located near beaches, Niu Valley Shopping Center, Aina Haina Shopping Center, schools, Hawaii Kai Costco, just a short drive to Kahala Mall, schools and neighborhood parks."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["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) "7501.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1832"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1954"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "willt@betterhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Will Tanaka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-03T16:41:10.527"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18137943"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-19T13:21:59.077"
}
["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) "26628959"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26628959"
[1]=>
string(8) "26628960"
[2]=>
string(8) "26628961"
[3]=>
string(8) "26628962"
[4]=>
string(8) "26628963"
[5]=>
string(8) "26628964"
[6]=>
string(8) "26628965"
[7]=>
string(8) "26628966"
[8]=>
string(8) "26628967"
[9]=>
string(8) "26628968"
[10]=>
string(8) "26628969"
[11]=>
string(8) "26628970"
[12]=>
string(8) "26628971"
[13]=>
string(8) "26628972"
[14]=>
string(8) "26628973"
[15]=>
string(8) "26628974"
[16]=>
string(8) "26628975"
[17]=>
string(8) "26628976"
[18]=>
string(8) "26628977"
[19]=>
string(8) "26628978"
[20]=>
string(8) "26628979"
[21]=>
string(8) "26628980"
[22]=>
string(8) "26628981"
[23]=>
string(8) "26628982"
[24]=>
string(8) "26628983"
[25]=>
string(8) "26628984"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202416411
)
[StreetNumber] => Array
(
[0] => 5631
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Pia
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Honolulu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96821
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/dwnxzvv/unbranded
)
[ListPrice] => Array
(
[0] => 1399000.00
)
[CurrentPrice] => Array
(
[0] => 1399000.00
)
[Neighbourhood] => Array
(
[0] => NIU VALLEY
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Single-level residence with generous 7,500 sf level lot in the highly desirable NIU VALLEY! This recently upgraded legacy home is situated on a friendly and quiet street. Enjoy extra security and privacy - completely gated, large spacious front AND back yard spaces adorned with mature fruit trees (breadfruit, coconut, noni) perfect for gardening enthusiasts and outdoor entertaining! Recent upgrades include LVP flooring throughout, fresh exterior paint, newer kitchen and baths. Functional floorplan with endless possibilities! The main house includes 4 bed/2 bath. BONUS - Freshly renovated attached studio cottage (separate entrance) with upgraded bathroom, perfect for visiting guests, a multigenerational lifestyle or a private home office space. Ample street parking and perfectly located near beaches, Niu Valley Shopping Center, Aina Haina Shopping Center, schools, Hawaii Kai Costco, just a short drive to Kahala Mall, schools and neighborhood parks.
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7501.00
)
[SqftTotal] => Array
(
[0] => 1832
)
[YearBuilt] => Array
(
[0] => 1954
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => willt@betterhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Will Tanaka
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-03T16:41:10.527
)
[Matrix_Unique_ID] => Array
(
[0] => 18137943
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-19T13:21:59.077
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26628959
)
[listing_image] => Array
(
[0] => 26628959
[1] => 26628960
[2] => 26628961
[3] => 26628962
[4] => 26628963
[5] => 26628964
[6] => 26628965
[7] => 26628966
[8] => 26628967
[9] => 26628968
[10] => 26628969
[11] => 26628970
[12] => 26628971
[13] => 26628972
[14] => 26628973
[15] => 26628974
[16] => 26628975
[17] => 26628976
[18] => 26628977
[19] => 26628978
[20] => 26628979
[21] => 26628980
[22] => 26628981
[23] => 26628982
[24] => 26628983
[25] => 26628984
)
)
- BedsTotal: 4
- Full Baths: 3
- Land Area (sf): 7,501
- Living (sf): 1,832
- Year Built: 1954
- Property Condition: Above Average,Average
- Number of Parking Spaces: 1
- View: None
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple