94-508 Mahoe Street Waipahu, HI 96797
Listing
Overview
Price: $1,299,999
Area: WAIPAHU-LOWER
Status: Active
BACK ON MARKET** Perfect for generational living and/or investment possibilities with NO Maintenance Fees or Association Fee!. In the heart of Waipahu, this two-story home on 6024 sqft. lot has 7 bedrooms and 5 bathrooms with 6 cars parking. The lower level offers 3 bedrooms, 2 bathrooms which awaits your personal touch and the second floor offers 4 bedrooms, 3 bathrooms, repainted interior, new vinyl flooring and butcher block countertop. Washer/Dryer hookup outside with solar panels unit (owned). Bring your ideas to enjoy the homes spacious backyard for possible workspace, playing, gardening and a mature Kahulu’u avocado tree, casually known as the butter avocado. Conveniently located close to schools, shopping center, golf course, great restaurant, grocery stores and more. Easy access to H1& H2 freeway. Please allow 24 hours’ notice for showing. Listing by: Homequest LLC
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202301310"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-508"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Mahoe"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["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(10) "1299999.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1299999.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(864) "BACK ON MARKET** Perfect for generational living and/or investment possibilities with NO Maintenance Fees or Association Fee!. In the heart of Waipahu, this two-story home on 6024 sqft. lot has 7 bedrooms and 5 bathrooms with 6 cars parking. The lower level offers 3 bedrooms, 2 bathrooms which awaits your personal touch and the second floor offers 4 bedrooms, 3 bathrooms, repainted interior, new vinyl flooring and butcher block countertop. Washer/Dryer hookup outside with solar panels unit (owned). Bring your ideas to enjoy the homes spacious backyard for possible workspace, playing, gardening and a mature Kahulu’u avocado tree, casually known as the butter avocado. Conveniently located close to schools, shopping center, golf course, great restaurant, grocery stores and more. Easy access to H1& H2 freeway. Please allow 24 hours’ notice for showing."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Homequest LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "7"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6024.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4610"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1957"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "6"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(13) "August Ahrens"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "HOMQ"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "lynhirealtor@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(0) ""
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Lyn Lamoreaux"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2023-08-18T16:30:01.080"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17095149"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-01-23T20:41:23.663"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25836659"
}
["listing_image"]=>
array(17) {
[0]=>
string(8) "25836659"
[1]=>
string(8) "25836660"
[2]=>
string(8) "25836661"
[3]=>
string(8) "25836662"
[4]=>
string(8) "25836663"
[5]=>
string(8) "25836664"
[6]=>
string(8) "25836665"
[7]=>
string(8) "25836666"
[8]=>
string(8) "25836667"
[9]=>
string(8) "25836668"
[10]=>
string(8) "25836669"
[11]=>
string(8) "25836670"
[12]=>
string(8) "25836671"
[13]=>
string(8) "25836672"
[14]=>
string(8) "25836673"
[15]=>
string(8) "25836674"
[16]=>
string(8) "25836675"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202301310
)
[StreetNumber] => Array
(
[0] => 94-508
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Mahoe
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 1299999.00
)
[CurrentPrice] => Array
(
[0] => 1299999.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => BACK ON MARKET** Perfect for generational living and/or investment possibilities with NO Maintenance Fees or Association Fee!. In the heart of Waipahu, this two-story home on 6024 sqft. lot has 7 bedrooms and 5 bathrooms with 6 cars parking. The lower level offers 3 bedrooms, 2 bathrooms which awaits your personal touch and the second floor offers 4 bedrooms, 3 bathrooms, repainted interior, new vinyl flooring and butcher block countertop. Washer/Dryer hookup outside with solar panels unit (owned). Bring your ideas to enjoy the homes spacious backyard for possible workspace, playing, gardening and a mature Kahulu’u avocado tree, casually known as the butter avocado. Conveniently located close to schools, shopping center, golf course, great restaurant, grocery stores and more. Easy access to H1& H2 freeway. Please allow 24 hours’ notice for showing.
)
[ListOfficeName] => Array
(
[0] => Homequest LLC
)
[BedsTotal] => Array
(
[0] => 7
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6024.00
)
[SqftTotal] => Array
(
[0] => 4610
)
[YearBuilt] => Array
(
[0] => 1957
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 6
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => August Ahrens
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[ListOfficeMLSID] => Array
(
[0] => HOMQ
)
[ListAgentEmail] => Array
(
[0] => lynhirealtor@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] =>
)
[ListAgentFullName] => Array
(
[0] => Lyn Lamoreaux
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2023-08-18T16:30:01.080
)
[Matrix_Unique_ID] => Array
(
[0] => 17095149
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-01-23T20:41:23.663
)
[_thumbnail_id] => Array
(
[0] => 25836659
)
[listing_image] => Array
(
[0] => 25836659
[1] => 25836660
[2] => 25836661
[3] => 25836662
[4] => 25836663
[5] => 25836664
[6] => 25836665
[7] => 25836666
[8] => 25836667
[9] => 25836668
[10] => 25836669
[11] => 25836670
[12] => 25836671
[13] => 25836672
[14] => 25836673
[15] => 25836674
[16] => 25836675
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- BedsTotal: 7
- Full Baths: 5
- Land Area (sf): 6,024
- Living (sf): 4,610
- Year Built: 1957
- Property Condition: Average
- Number of Parking Spaces: 6
- View: Mountain
- Listing Office: Homequest LLC
- Land Tenure: FS - Fee Simple
- Elementary School: August Ahrens
- Middle School: Waipahu
- High School: Waipahu
