94-1023 Maiau Street Unit 172 Waipahu, HI 96797
Listing
Overview
Price: $998,000
Area: WAIKELE
Status: Active
Welcome to this stunning 4 bedroom 2.5 bath home which has just been beautifully remodeled throughout and is ready to move right in. Upstairs you will find all 4 bedrooms and 2 full baths which provide foe ample privacy. The main floor boasts a bright and open concept kitchen (complete with modern appliances, sleek granite counters, and stylish cabinetry) and living area perfect for entertaining as well as easy indoor/outdoor feel as it flows graciously into the fully fenced backyard. Recent upgrades include new flooring, new showers, and paint, just to name a few. Situated in a prime Waikele location, this home is one light to the freeway making for an ideal commute. The elementary school is right around the corner as well the Waikele Premier outlets and all it has to offer. Enjoy this perfect blend of comfort, style, and convenience, all at this affordable price. Listing by: Keller Williams Honolulu (808) 439-8250
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202416579"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1023"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Maiau"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(3) "172"
}
["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) "998000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "998000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(877) "Welcome to this stunning 4 bedroom 2.5 bath home which has just been beautifully remodeled throughout and is ready to move right in. Upstairs you will find all 4 bedrooms and 2 full baths which provide foe ample privacy. The main floor boasts a bright and open concept kitchen (complete with modern appliances, sleek granite counters, and stylish cabinetry) and living area perfect for entertaining as well as easy indoor/outdoor feel as it flows graciously into the fully fenced backyard. Recent upgrades include new flooring, new showers, and paint, just to name a few. Situated in a prime Waikele location, this home is one light to the freeway making for an ideal commute. The elementary school is right around the corner as well the Waikele Premier outlets and all it has to offer. Enjoy this perfect blend of comfort, style, and convenience, all at this affordable price."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["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) "3174.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1472"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1997"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "224.00"
}
["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) "KWPP04"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(20) "erin@erin-cooper.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 439-8250"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Erin Cooper"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-27T09:30:01.373"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18142552"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-07-22T11:48:59.093"
}
["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) "26631754"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26631754"
[1]=>
string(8) "26631755"
[2]=>
string(8) "26631756"
[3]=>
string(8) "26631757"
[4]=>
string(8) "26631758"
[5]=>
string(8) "26631759"
[6]=>
string(8) "26631760"
[7]=>
string(8) "26631761"
[8]=>
string(8) "26631762"
[9]=>
string(8) "26631763"
[10]=>
string(8) "26631764"
[11]=>
string(8) "26631765"
[12]=>
string(8) "26631766"
[13]=>
string(8) "26631767"
[14]=>
string(8) "26631768"
[15]=>
string(8) "26631769"
[16]=>
string(8) "26631770"
[17]=>
string(8) "26631771"
[18]=>
string(8) "26631772"
[19]=>
string(8) "26631773"
[20]=>
string(8) "26631774"
[21]=>
string(8) "26631775"
[22]=>
string(8) "26631776"
[23]=>
string(8) "26631777"
[24]=>
string(8) "26631778"
[25]=>
string(8) "26631779"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202416579
)
[StreetNumber] => Array
(
[0] => 94-1023
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Maiau
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => 172
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 998000.00
)
[CurrentPrice] => Array
(
[0] => 998000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to this stunning 4 bedroom 2.5 bath home which has just been beautifully remodeled throughout and is ready to move right in. Upstairs you will find all 4 bedrooms and 2 full baths which provide foe ample privacy. The main floor boasts a bright and open concept kitchen (complete with modern appliances, sleek granite counters, and stylish cabinetry) and living area perfect for entertaining as well as easy indoor/outdoor feel as it flows graciously into the fully fenced backyard. Recent upgrades include new flooring, new showers, and paint, just to name a few. Situated in a prime Waikele location, this home is one light to the freeway making for an ideal commute. The elementary school is right around the corner as well the Waikele Premier outlets and all it has to offer. Enjoy this perfect blend of comfort, style, and convenience, all at this affordable price.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 3174.00
)
[SqftTotal] => Array
(
[0] => 1472
)
[YearBuilt] => Array
(
[0] => 1997
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 224.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP04
)
[ListAgentEmail] => Array
(
[0] => erin@erin-cooper.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 439-8250
)
[ListAgentFullName] => Array
(
[0] => Erin Cooper
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-27T09:30:01.373
)
[Matrix_Unique_ID] => Array
(
[0] => 18142552
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-07-22T11:48:59.093
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26631754
)
[listing_image] => Array
(
[0] => 26631754
[1] => 26631755
[2] => 26631756
[3] => 26631757
[4] => 26631758
[5] => 26631759
[6] => 26631760
[7] => 26631761
[8] => 26631762
[9] => 26631763
[10] => 26631764
[11] => 26631765
[12] => 26631766
[13] => 26631767
[14] => 26631768
[15] => 26631769
[16] => 26631770
[17] => 26631771
[18] => 26631772
[19] => 26631773
[20] => 26631774
[21] => 26631775
[22] => 26631776
[23] => 26631777
[24] => 26631778
[25] => 26631779
)
)
- BedsTotal: 4
- Full Baths: 2
- Half Baths: 1
- Land Area (sf): 3,174
- Living (sf): 1,472
- Year Built: 1997
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 2
- View: None
- Listing Office: Keller Williams Honolulu
- Maintenance Fees: $224
- Land Tenure: FS - Fee Simple
