Listing
Overview
Price: $1,298,000
Area: WAIPAHU ESTATES
Status: Active Under Contract
Recently Appraised at $1.3M & Offered with a $25K Seller Credit! Located in the desirable Waipahu Estates neighborhood, this spacious single-family home is designed to accommodate multi-family living or serve as a versatile investment opportunity. Boasting 8 bedrooms and 4.5 bathrooms, the layout features separate upstairs and downstairs living areas, each with its own entrance and kitchen, offering privacy and flexibility. The property has four parking spots along with a storage shed out back. Comfort is ensured with split AC upstairs and window units downstairs. Exterior highlights include a durable tile roof and stylish stucco walls, enhancing curb appeal. Inside, the primary bathroom features a relaxing jacuzzi tub, while multiple covered lanais and large living areas provide ample space for relaxation & entertaining. Situated just minutes from the freeway entrance and Waikele Shopping Center, residents enjoy easy access to shopping, dining, & more. With opportunities to personalize areas, this home offers both comfort and potential. Don’t miss the chance to make this versatile and beautifully appointed home yours! Listing by: Real Broker, LLC (808) 699-4202
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501330"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-559"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Anaaina"
}
["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(45) "https://my.matterport.com/show/?m=m6VX2XaJT9T"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1298000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "WAIPAHU ESTATES"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1138) "Recently Appraised at $1.3M & Offered with a $25K Seller Credit! Located in the desirable Waipahu Estates neighborhood, this spacious single-family home is designed to accommodate multi-family living or serve as a versatile investment opportunity. Boasting 8 bedrooms and 4.5 bathrooms, the layout features separate upstairs and downstairs living areas, each with its own entrance and kitchen, offering privacy and flexibility. The property has four parking spots along with a storage shed out back. Comfort is ensured with split AC upstairs and window units downstairs. Exterior highlights include a durable tile roof and stylish stucco walls, enhancing curb appeal. Inside, the primary bathroom features a relaxing jacuzzi tub, while multiple covered lanais and large living areas provide ample space for relaxation & entertaining. Situated just minutes from the freeway entrance and Waikele Shopping Center, residents enjoy easy access to shopping, dining, & more. With opportunities to personalize areas, this home offers both comfort and potential. Don’t miss the chance to make this versatile and beautifully appointed home yours!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(16) "Real Broker, LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "8"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "5052.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3336"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1986"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["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(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "RBLL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(32) "anthony@oceantomountainhomes.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 699-4202"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Anthony James Cox"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18475129"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-15T09:08:10.320"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-06"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "09:08:10.320"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26829153"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26829153"
[1]=>
string(8) "26829154"
[2]=>
string(8) "26829155"
[3]=>
string(8) "26829156"
[4]=>
string(8) "26829157"
[5]=>
string(8) "26829158"
[6]=>
string(8) "26829159"
[7]=>
string(8) "26829160"
[8]=>
string(8) "26829161"
[9]=>
string(8) "26829162"
[10]=>
string(8) "26829163"
[11]=>
string(8) "26829164"
[12]=>
string(8) "26829165"
[13]=>
string(8) "26829166"
[14]=>
string(8) "26829167"
[15]=>
string(8) "26829168"
[16]=>
string(8) "26829169"
[17]=>
string(8) "26829170"
[18]=>
string(8) "26829171"
[19]=>
string(8) "26829172"
[20]=>
string(8) "26829173"
[21]=>
string(8) "26829174"
[22]=>
string(8) "26829175"
[23]=>
string(8) "26829176"
[24]=>
string(8) "26829177"
[25]=>
string(8) "26829178"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501330
)
[StreetNumber] => Array
(
[0] => 94-559
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Anaaina
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=m6VX2XaJT9T
)
[ListPrice] => Array
(
[0] => 1298000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU ESTATES
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Recently Appraised at $1.3M & Offered with a $25K Seller Credit! Located in the desirable Waipahu Estates neighborhood, this spacious single-family home is designed to accommodate multi-family living or serve as a versatile investment opportunity. Boasting 8 bedrooms and 4.5 bathrooms, the layout features separate upstairs and downstairs living areas, each with its own entrance and kitchen, offering privacy and flexibility. The property has four parking spots along with a storage shed out back. Comfort is ensured with split AC upstairs and window units downstairs. Exterior highlights include a durable tile roof and stylish stucco walls, enhancing curb appeal. Inside, the primary bathroom features a relaxing jacuzzi tub, while multiple covered lanais and large living areas provide ample space for relaxation & entertaining. Situated just minutes from the freeway entrance and Waikele Shopping Center, residents enjoy easy access to shopping, dining, & more. With opportunities to personalize areas, this home offers both comfort and potential. Don’t miss the chance to make this versatile and beautifully appointed home yours!
)
[ListOfficeName] => Array
(
[0] => Real Broker, LLC
)
[BedsTotal] => Array
(
[0] => 8
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 5052.00
)
[SqftTotal] => Array
(
[0] => 3336
)
[YearBuilt] => Array
(
[0] => 1986
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => RBLL
)
[ListAgentEmail] => Array
(
[0] => anthony@oceantomountainhomes.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 699-4202
)
[ListAgentFullName] => Array
(
[0] => Anthony James Cox
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18475129
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-15T09:08:10.320
)
[ListingContractDate] => Array
(
[0] => 2025-01-06
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 09:08:10.320
)
[_thumbnail_id] => Array
(
[0] => 26829153
)
[listing_image] => Array
(
[0] => 26829153
[1] => 26829154
[2] => 26829155
[3] => 26829156
[4] => 26829157
[5] => 26829158
[6] => 26829159
[7] => 26829160
[8] => 26829161
[9] => 26829162
[10] => 26829163
[11] => 26829164
[12] => 26829165
[13] => 26829166
[14] => 26829167
[15] => 26829168
[16] => 26829169
[17] => 26829170
[18] => 26829171
[19] => 26829172
[20] => 26829173
[21] => 26829174
[22] => 26829175
[23] => 26829176
[24] => 26829177
[25] => 26829178
)
)
- BedsTotal: 8
- Full Baths: 4
- Half Baths: 1
- Land Area (sf): 5,052 sf
- Living (sf): 3,336
- Year Built: 1986
- Property Condition: Average
- Number of Parking Spaces: 4
- View: Mountain
- Listing Office: Real Broker, LLC
- Land Tenure: FS - Fee Simple
