94-105 Mui Place Unit B204 Waipahu, HI 96797
Listing
Overview
Price: $540,000
Area: WAIPIO GENTRY
Status: Active
Charming Renovated Upstairs Unit with Prime Location and Convenience!
This renovated unit comes with TWO assigned parking stalls, plus several guest parking stalls conveniently located right in front. Enjoy the newly updated kitchen and bathrooms, featuring upgraded quartz countertops, new cabinets, sinks, and plumbing fixtures. The space is further enhanced by new vinyl plank flooring and reglazed tub/shower enclosures. Freshly painted throughout, the unit also boasts brand-new stainless steel appliances in the kitchen and a new washer and dryer. A newly installed security screen door allows you to enjoy refreshing cross breezes throughout the unit, or opt for the window A/C units located in the living room and both bedrooms. Additional storage space is available in the attic, easily accessed by a pull-down door with built-in stairs in the hallway. Located in a prime spot within the complex, this unit is close to street parking, mailboxes, and offers easy access to Costco, Foodland, Kam Hwy, the freeway, and numerous restaurants. Don't miss out—schedule your showing today! Listing by: Coldwell Banker Realty (808) 676-7200
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202419103"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-105"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(3) "Mui"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "B204"
}
["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) "540000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "540000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPIO GENTRY"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1093) "Charming Renovated Upstairs Unit with Prime Location and Convenience!
This renovated unit comes with TWO assigned parking stalls, plus several guest parking stalls conveniently located right in front. Enjoy the newly updated kitchen and bathrooms, featuring upgraded quartz countertops, new cabinets, sinks, and plumbing fixtures. The space is further enhanced by new vinyl plank flooring and reglazed tub/shower enclosures. Freshly painted throughout, the unit also boasts brand-new stainless steel appliances in the kitchen and a new washer and dryer. A newly installed security screen door allows you to enjoy refreshing cross breezes throughout the unit, or opt for the window A/C units located in the living room and both bedrooms. Additional storage space is available in the attic, easily accessed by a pull-down door with built-in stairs in the hallway. Located in a prime spot within the complex, this unit is close to street parking, mailboxes, and offers easy access to Costco, Foodland, Kam Hwy, the freeway, and numerous restaurants. Don't miss out—schedule your showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "Coldwell Banker Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "144053.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "742"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1989"
}
["BuildingName"]=>
array(1) {
[0]=>
string(27) "Cliffside Village at Waipio"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "431.08"
}
["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(6) "CBPP15"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "myra.yamada671@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 676-7200"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Myra Yamada"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-27T16:00:01.230"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18225010"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-08-31T12:59:26.853"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26677729"
}
["listing_image"]=>
array(14) {
[0]=>
string(8) "26677729"
[1]=>
string(8) "26677730"
[2]=>
string(8) "26677731"
[3]=>
string(8) "26677732"
[4]=>
string(8) "26677733"
[5]=>
string(8) "26677734"
[6]=>
string(8) "26677735"
[7]=>
string(8) "26677736"
[8]=>
string(8) "26677737"
[9]=>
string(8) "26677738"
[10]=>
string(8) "26677739"
[11]=>
string(8) "26677740"
[12]=>
string(8) "26677741"
[13]=>
string(8) "26677742"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202419103
)
[StreetNumber] => Array
(
[0] => 94-105
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Mui
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => B204
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 540000.00
)
[CurrentPrice] => Array
(
[0] => 540000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO GENTRY
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Charming Renovated Upstairs Unit with Prime Location and Convenience!
This renovated unit comes with TWO assigned parking stalls, plus several guest parking stalls conveniently located right in front. Enjoy the newly updated kitchen and bathrooms, featuring upgraded quartz countertops, new cabinets, sinks, and plumbing fixtures. The space is further enhanced by new vinyl plank flooring and reglazed tub/shower enclosures. Freshly painted throughout, the unit also boasts brand-new stainless steel appliances in the kitchen and a new washer and dryer. A newly installed security screen door allows you to enjoy refreshing cross breezes throughout the unit, or opt for the window A/C units located in the living room and both bedrooms. Additional storage space is available in the attic, easily accessed by a pull-down door with built-in stairs in the hallway. Located in a prime spot within the complex, this unit is close to street parking, mailboxes, and offers easy access to Costco, Foodland, Kam Hwy, the freeway, and numerous restaurants. Don't miss out—schedule your showing today!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 144053.00
)
[SqftTotal] => Array
(
[0] => 742
)
[YearBuilt] => Array
(
[0] => 1989
)
[BuildingName] => Array
(
[0] => Cliffside Village at Waipio
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 431.08
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP15
)
[ListAgentEmail] => Array
(
[0] => myra.yamada671@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 676-7200
)
[ListAgentFullName] => Array
(
[0] => Myra Yamada
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-27T16:00:01.230
)
[Matrix_Unique_ID] => Array
(
[0] => 18225010
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-08-31T12:59:26.853
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26677729
)
[listing_image] => Array
(
[0] => 26677729
[1] => 26677730
[2] => 26677731
[3] => 26677732
[4] => 26677733
[5] => 26677734
[6] => 26677735
[7] => 26677736
[8] => 26677737
[9] => 26677738
[10] => 26677739
[11] => 26677740
[12] => 26677741
[13] => 26677742
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 144,053
- Living (sf): 742
- Year Built: 1989
- Building Name: Cliffside Village at Waipio
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 2
- View: Mountain
- Listing Office: Coldwell Banker Realty
- Maintenance Fees: $431
- Land Tenure: FS - Fee Simple
