Listing
Overview
Price: $1,150,000
Area: WAIPAHU ESTATES
Status: Pending
Waipahu Estates – fantastic LOCATION and first time offered on the market! Very spacious NINE-bedroom, FIVE-bathroom prime cul-de-sac home offering additional privacy and minimal traffic. Full kitchen PLUS TWO additional wet bars offering an exceptional lifestyle tailored for entertainment, multi-generational living and/or rental income. The generous level 6,856 sq ft lot allows for indoor/outdoor living with expansive covered parking areas perfect for hosting and entertaining gatherings. Enjoy lots of SINGLE-LEVEL living space (over 1,900 sq ft) on the 1st story with 1,020 sq ft on the second floor with lanai. Please do not let this one pass you by, it is this is the best value in Waipahu Estates! Listing by: BHGRE Advantage Realty (808) 429-0341
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501443"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "94-1026"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Ulieo"
}
["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(59) "https://listings.hetproductions.com/sites/zekpnln/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1150000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "WAIPAHU ESTATES"
}
["Status"]=>
array(1) {
[0]=>
string(7) "Pending"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(710) "Waipahu Estates – fantastic LOCATION and first time offered on the market! Very spacious NINE-bedroom, FIVE-bathroom prime cul-de-sac home offering additional privacy and minimal traffic. Full kitchen PLUS TWO additional wet bars offering an exceptional lifestyle tailored for entertainment, multi-generational living and/or rental income. The generous level 6,856 sq ft lot allows for indoor/outdoor living with expansive covered parking areas perfect for hosting and entertaining gatherings. Enjoy lots of SINGLE-LEVEL living space (over 1,900 sq ft) on the 1st story with 1,020 sq ft on the second floor with lanai. Please do not let this one pass you by, it is this is the best value in Waipahu Estates!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(22) "BHGRE Advantage Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "9"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "5"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6856.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "3587"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1977"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "5"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "willt@betterhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 429-0341"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Will Tanaka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18477797"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-01-27T08:41:03.447"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-09"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "08:41:03.447"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26833134"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26833134"
[1]=>
string(8) "26833135"
[2]=>
string(8) "26833136"
[3]=>
string(8) "26833137"
[4]=>
string(8) "26833138"
[5]=>
string(8) "26833139"
[6]=>
string(8) "26833140"
[7]=>
string(8) "26833141"
[8]=>
string(8) "26833142"
[9]=>
string(8) "26833143"
[10]=>
string(8) "26833144"
[11]=>
string(8) "26833145"
[12]=>
string(8) "26833146"
[13]=>
string(8) "26833147"
[14]=>
string(8) "26833148"
[15]=>
string(8) "26833149"
[16]=>
string(8) "26833150"
[17]=>
string(8) "26833151"
[18]=>
string(8) "26833152"
[19]=>
string(8) "26833153"
[20]=>
string(8) "26833154"
[21]=>
string(8) "26833155"
[22]=>
string(8) "26833156"
[23]=>
string(8) "26833157"
[24]=>
string(8) "26833158"
[25]=>
string(8) "26833159"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501443
)
[StreetNumber] => Array
(
[0] => 94-1026
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Ulieo
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/zekpnln/unbranded
)
[ListPrice] => Array
(
[0] => 1150000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU ESTATES
)
[Status] => Array
(
[0] => Pending
)
[PublicRemarks] => Array
(
[0] => Waipahu Estates – fantastic LOCATION and first time offered on the market! Very spacious NINE-bedroom, FIVE-bathroom prime cul-de-sac home offering additional privacy and minimal traffic. Full kitchen PLUS TWO additional wet bars offering an exceptional lifestyle tailored for entertainment, multi-generational living and/or rental income. The generous level 6,856 sq ft lot allows for indoor/outdoor living with expansive covered parking areas perfect for hosting and entertaining gatherings. Enjoy lots of SINGLE-LEVEL living space (over 1,900 sq ft) on the 1st story with 1,020 sq ft on the second floor with lanai. Please do not let this one pass you by, it is this is the best value in Waipahu Estates!
)
[ListOfficeName] => Array
(
[0] => BHGRE Advantage Realty
)
[BedsTotal] => Array
(
[0] => 9
)
[BathsFull] => Array
(
[0] => 5
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6856.00
)
[SqftTotal] => Array
(
[0] => 3587
)
[YearBuilt] => Array
(
[0] => 1977
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 5
)
[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] => ADVG
)
[ListAgentEmail] => Array
(
[0] => willt@betterhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 429-0341
)
[ListAgentFullName] => Array
(
[0] => Will Tanaka
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18477797
)
[MatrixModifiedDT] => Array
(
[0] => 2025-01-27T08:41:03.447
)
[ListingContractDate] => Array
(
[0] => 2025-01-09
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 08:41:03.447
)
[_thumbnail_id] => Array
(
[0] => 26833134
)
[listing_image] => Array
(
[0] => 26833134
[1] => 26833135
[2] => 26833136
[3] => 26833137
[4] => 26833138
[5] => 26833139
[6] => 26833140
[7] => 26833141
[8] => 26833142
[9] => 26833143
[10] => 26833144
[11] => 26833145
[12] => 26833146
[13] => 26833147
[14] => 26833148
[15] => 26833149
[16] => 26833150
[17] => 26833151
[18] => 26833152
[19] => 26833153
[20] => 26833154
[21] => 26833155
[22] => 26833156
[23] => 26833157
[24] => 26833158
[25] => 26833159
)
)
- BedsTotal: 9
- Full Baths: 5
- Land Area (sf): 6,856 sf
- Living (sf): 3,587
- Year Built: 1977
- Property Condition: Fair
- Number of Parking Spaces: 5
- View: Mountain
- Listing Office: BHGRE Advantage Realty
- Land Tenure: FS - Fee Simple
