Our office will be closed on Monday, November 11th, 2024.
94-522 Meheuheu Place Waipahu, HI 96797
Listing Overview
Price: $985,000 Area: ROYAL KUNIA Status: Active
Welcome to desirable Royal Kunia! This charming 4 bedroom, 2.5 bath home features fresh new paint, brand new carpet, new light fixtures, new ceiling fans, an open concept kitchen and a spacious back yard with a covered lanai make this dream home "Move in Ready." Enjoy the mountain views from your bedrooms and the natural lighting throughout that brings this home to life. Close proximity to tasty eateries, parks, grocery stores and freeway access make this home the perfect location. Come see all that this vibrant community has to offer! Listing by: HI Roots Realty LLC (808) 292-8071
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202421788"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-522"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Meheuheu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96797"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "985000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "985000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "ROYAL KUNIA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(546) "Welcome to desirable Royal Kunia! This charming 4 bedroom, 2.5 bath home features fresh new paint, brand new carpet, new light fixtures, new ceiling fans, an open concept kitchen and a spacious back yard with a covered lanai make this dream home "Move in Ready." Enjoy the mountain views from your bedrooms and the natural lighting throughout that brings this home to life. Close proximity to tasty eateries, parks, grocery stores and freeway access make this home the perfect location. Come see all that this vibrant community has to offer!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(19) "HI Roots Realty LLC"
}
["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(7) "4013.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1902"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "2002"
}
["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) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(9) "Kaleiopuu"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "ROOT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "peter@hirootsrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 292-8071"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Peter Enomoto-Hahn"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-30T20:18:46.403"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18282162"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-30T15:14:20.743"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26713346"
}
["listing_image"]=>
array(21) {
[0]=>
string(8) "26713346"
[1]=>
string(8) "26713347"
[2]=>
string(8) "26713348"
[3]=>
string(8) "26713349"
[4]=>
string(8) "26713350"
[5]=>
string(8) "26713351"
[6]=>
string(8) "26713352"
[7]=>
string(8) "26713353"
[8]=>
string(8) "26713354"
[9]=>
string(8) "26713355"
[10]=>
string(8) "26713356"
[11]=>
string(8) "26713357"
[12]=>
string(8) "26713358"
[13]=>
string(8) "26713359"
[14]=>
string(8) "26713360"
[15]=>
string(8) "26713824"
[16]=>
string(8) "26713825"
[17]=>
string(8) "26713826"
[18]=>
string(8) "26713827"
[19]=>
string(8) "26713828"
[20]=>
string(8) "26713829"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202421788
)
[StreetNumber] => Array
(
[0] => 94-522
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Meheuheu
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 985000.00
)
[CurrentPrice] => Array
(
[0] => 985000.00
)
[Neighbourhood] => Array
(
[0] => ROYAL KUNIA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to desirable Royal Kunia! This charming 4 bedroom, 2.5 bath home features fresh new paint, brand new carpet, new light fixtures, new ceiling fans, an open concept kitchen and a spacious back yard with a covered lanai make this dream home "Move in Ready." Enjoy the mountain views from your bedrooms and the natural lighting throughout that brings this home to life. Close proximity to tasty eateries, parks, grocery stores and freeway access make this home the perfect location. Come see all that this vibrant community has to offer!
)
[ListOfficeName] => Array
(
[0] => HI Roots Realty LLC
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 4013.00
)
[SqftTotal] => Array
(
[0] => 1902
)
[YearBuilt] => Array
(
[0] => 2002
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 0.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kaleiopuu
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[ListOfficeMLSID] => Array
(
[0] => ROOT
)
[ListAgentEmail] => Array
(
[0] => peter@hirootsrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 292-8071
)
[ListAgentFullName] => Array
(
[0] => Peter Enomoto-Hahn
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-30T20:18:46.403
)
[Matrix_Unique_ID] => Array
(
[0] => 18282162
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-30T15:14:20.743
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26713346
)
[listing_image] => Array
(
[0] => 26713346
[1] => 26713347
[2] => 26713348
[3] => 26713349
[4] => 26713350
[5] => 26713351
[6] => 26713352
[7] => 26713353
[8] => 26713354
[9] => 26713355
[10] => 26713356
[11] => 26713357
[12] => 26713358
[13] => 26713359
[14] => 26713360
[15] => 26713824
[16] => 26713825
[17] => 26713826
[18] => 26713827
[19] => 26713828
[20] => 26713829
)
)
