Listing
Overview
Price: $1,425,888
Area: NIU VALLEY
Status: Active
Looking for a charming move-in ready AND single-level residence in the highly desirable NIU VALLEY? Look no further! 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 paint, newer kitchen and baths. Functional floorplan with endless possibilities! The main house includes 4 bed/2 bath. Generous 7,500 sf level lot closer to the entrance into the highly desirable Niu Valley neighborhood of East Oahu. 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) 429-0341
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202406899"
}
["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) "1425888.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1425888.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(10) "NIU VALLEY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1093) "Looking for a charming move-in ready AND single-level residence in the highly desirable NIU VALLEY? Look no further! 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 paint, newer kitchen and baths. Functional floorplan with endless possibilities! The main house includes 4 bed/2 bath. Generous 7,500 sf level lot closer to the entrance into the highly desirable Niu Valley neighborhood of East Oahu. 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) 429-0341"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Will Tanaka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-07-15T22:32:37.827"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17902269"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-15T09:26:09.520"
}
["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) "26204362"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26204362"
[1]=>
string(8) "26204363"
[2]=>
string(8) "26204364"
[3]=>
string(8) "26204365"
[4]=>
string(8) "26204366"
[5]=>
string(8) "26204367"
[6]=>
string(8) "26204368"
[7]=>
string(8) "26204369"
[8]=>
string(8) "26204370"
[9]=>
string(8) "26204371"
[10]=>
string(8) "26204372"
[11]=>
string(8) "26204373"
[12]=>
string(8) "26204374"
[13]=>
string(8) "26204375"
[14]=>
string(8) "26204376"
[15]=>
string(8) "26204377"
[16]=>
string(8) "26204378"
[17]=>
string(8) "26204379"
[18]=>
string(8) "26204380"
[19]=>
string(8) "26204381"
[20]=>
string(8) "26204382"
[21]=>
string(8) "26204383"
[22]=>
string(8) "26204384"
[23]=>
string(8) "26204385"
[24]=>
string(8) "26204386"
[25]=>
string(8) "26204387"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202406899
)
[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] => 1425888.00
)
[CurrentPrice] => Array
(
[0] => 1425888.00
)
[Neighbourhood] => Array
(
[0] => NIU VALLEY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Looking for a charming move-in ready AND single-level residence in the highly desirable NIU VALLEY? Look no further! 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 paint, newer kitchen and baths. Functional floorplan with endless possibilities! The main house includes 4 bed/2 bath. Generous 7,500 sf level lot closer to the entrance into the highly desirable Niu Valley neighborhood of East Oahu. 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) 429-0341
)
[ListAgentFullName] => Array
(
[0] => Will Tanaka
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-07-15T22:32:37.827
)
[Matrix_Unique_ID] => Array
(
[0] => 17902269
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-15T09:26:09.520
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26204362
)
[listing_image] => Array
(
[0] => 26204362
[1] => 26204363
[2] => 26204364
[3] => 26204365
[4] => 26204366
[5] => 26204367
[6] => 26204368
[7] => 26204369
[8] => 26204370
[9] => 26204371
[10] => 26204372
[11] => 26204373
[12] => 26204374
[13] => 26204375
[14] => 26204376
[15] => 26204377
[16] => 26204378
[17] => 26204379
[18] => 26204380
[19] => 26204381
[20] => 26204382
[21] => 26204383
[22] => 26204384
[23] => 26204385
[24] => 26204386
[25] => 26204387
)
)
- 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
