Listing
Overview
Price: $1,500,000
Area: NIU VALLEY
Status: Active
NEW LISTING!! Discover this peaceful 5 bdrm + den/3 bath SINGLE-LEVEL home in much sought after Niu Valley. Situated down a quiet street on a 7,646 sq. ft. lot, this residence features over 2,200 sq. ft. of interior living space, fresh interior paint, new carpet, vaulted ceilings, and updated baths. The landscaped entryway and tranquil koi pond create a serene welcome, while the gated backyard offers privacy and relaxation. Conveniently located near shopping, restaurants, and entertainment. A must see!! Listing by: BHGRE Advantage Realty (808) 738-3633
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202504952"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "364"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Mamaki"
}
["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(92) "https://listings.hetproductions.com/sites/364-mamaki-st-honolulu-hi-96821-13972252/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1500000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(10) "NIU VALLEY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(508) "NEW LISTING!! Discover this peaceful 5 bdrm + den/3 bath SINGLE-LEVEL home in much sought after Niu Valley. Situated down a quiet street on a 7,646 sq. ft. lot, this residence features over 2,200 sq. ft. of interior living space, fresh interior paint, new carpet, vaulted ceilings, and updated baths. The landscaped entryway and tranquil koi pond create a serene welcome, while the gated backyard offers privacy and relaxation. Conveniently located near shopping, restaurants, and entertainment. A must see!!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7646.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "2422"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1962"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(15) "Garden,Mountain"
}
["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(23) "MyronK@BetterHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3633"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Myron N Kiriu"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18555242"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-23T17:00:01.507"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-02-14"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(9) "DiamondHd"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.507"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26881878"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26881878"
[1]=>
string(8) "26881879"
[2]=>
string(8) "26881880"
[3]=>
string(8) "26881881"
[4]=>
string(8) "26881882"
[5]=>
string(8) "26881883"
[6]=>
string(8) "26881884"
[7]=>
string(8) "26881885"
[8]=>
string(8) "26881886"
[9]=>
string(8) "26881887"
[10]=>
string(8) "26881888"
[11]=>
string(8) "26881889"
[12]=>
string(8) "26881890"
[13]=>
string(8) "26881891"
[14]=>
string(8) "26881892"
[15]=>
string(8) "26881893"
[16]=>
string(8) "26881894"
[17]=>
string(8) "26881895"
[18]=>
string(8) "26881896"
[19]=>
string(8) "26881897"
[20]=>
string(8) "26881898"
[21]=>
string(8) "26881899"
[22]=>
string(8) "26881900"
[23]=>
string(8) "26881901"
[24]=>
string(8) "26881902"
[25]=>
string(8) "26881903"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202504952
)
[StreetNumber] => Array
(
[0] => 364
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Mamaki
)
[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/364-mamaki-st-honolulu-hi-96821-13972252/unbranded
)
[ListPrice] => Array
(
[0] => 1500000.00
)
[Neighbourhood] => Array
(
[0] => NIU VALLEY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => NEW LISTING!! Discover this peaceful 5 bdrm + den/3 bath SINGLE-LEVEL home in much sought after Niu Valley. Situated down a quiet street on a 7,646 sq. ft. lot, this residence features over 2,200 sq. ft. of interior living space, fresh interior paint, new carpet, vaulted ceilings, and updated baths. The landscaped entryway and tranquil koi pond create a serene welcome, while the gated backyard offers privacy and relaxation. Conveniently located near shopping, restaurants, and entertainment. A must see!!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 5
)
[BathsFull] => Array
(
[0] => 3
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7646.00
)
[SqftTotal] => Array
(
[0] => 2422
)
[YearBuilt] => Array
(
[0] => 1962
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Mountain
)
[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] => MyronK@BetterHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3633
)
[ListAgentFullName] => Array
(
[0] => Myron N Kiriu
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18555242
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-23T17:00:01.507
)
[ListingContractDate] => Array
(
[0] => 2025-02-14
)
[MLSAreaMajor] => Array
(
[0] => DiamondHd
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.507
)
[_thumbnail_id] => Array
(
[0] => 26881878
)
[listing_image] => Array
(
[0] => 26881878
[1] => 26881879
[2] => 26881880
[3] => 26881881
[4] => 26881882
[5] => 26881883
[6] => 26881884
[7] => 26881885
[8] => 26881886
[9] => 26881887
[10] => 26881888
[11] => 26881889
[12] => 26881890
[13] => 26881891
[14] => 26881892
[15] => 26881893
[16] => 26881894
[17] => 26881895
[18] => 26881896
[19] => 26881897
[20] => 26881898
[21] => 26881899
[22] => 26881900
[23] => 26881901
[24] => 26881902
[25] => 26881903
)
)
- BedsTotal: 5
- Full Baths: 3
- Land Area (sf): 7,646 sf
- Living (sf): 2,422
- Year Built: 1962
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Garden,Mountain
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
