Listing
Overview
Price: $1,025,000
Area: WAHIAWA HEIGHTS
Status: Active
Make this home yours, with your added personal touches and upgrades, this charming residence becomes the perfect haven for relaxation and entertainment. Escape to a serene oasis surrounded by lush foliage and vibrant tropical flowers. This tranquil retreat boasts a private backyard with no rear neighbors, lush gardens featuring orchids and anthuriums, fragrant lychee, exotic gingers, Meyers lemons, bananas, avocados, vibrant Ti plants, and yellow trumpet flowers. It is conveniently located minutes from Schofield Barracks and Wheeler Army Airfield. Situated in close proximity to Wahiawa Botanical Gardens, Freshwater State Recreation Area, nearby hiking trails, easy access to North Shore beaches and the iconic Haleiwa town, you won't run out of things to do. Don't miss the pineapple-themed family fun and delicious treats at Dole Plantation! For an added bonus the home comes with 23 owned PV panels AND an 2018 electric Smart car with 22K+ miles. Seize this incredible opportunity to own a piece of tropical paradise! Schedule a viewing today and start living your Hawaiian dream! Listing by: Fathom Realty HI LLC (808) 675-6642
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423930"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(2) "48"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Haumalu"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96786"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(36) "https://seehouseat.com/2287213?idx=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1025000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1025000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(15) "WAHIAWA HEIGHTS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1091) "Make this home yours, with your added personal touches and upgrades, this charming residence becomes the perfect haven for relaxation and entertainment. Escape to a serene oasis surrounded by lush foliage and vibrant tropical flowers. This tranquil retreat boasts a private backyard with no rear neighbors, lush gardens featuring orchids and anthuriums, fragrant lychee, exotic gingers, Meyers lemons, bananas, avocados, vibrant Ti plants, and yellow trumpet flowers. It is conveniently located minutes from Schofield Barracks and Wheeler Army Airfield. Situated in close proximity to Wahiawa Botanical Gardens, Freshwater State Recreation Area, nearby hiking trails, easy access to North Shore beaches and the iconic Haleiwa town, you won't run out of things to do. Don't miss the pineapple-themed family fun and delicious treats at Dole Plantation! For an added bonus the home comes with 23 owned PV panels AND an 2018 electric Smart car with 22K+ miles. Seize this incredible opportunity to own a piece of tropical paradise! Schedule a viewing today and start living your Hawaiian dream!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "Fathom Realty HI LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "1"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "11563.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1456"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1966"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(14) "Mountain,Other"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(6) "Iliahi"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Leilehua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "PAKU"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(21) "deborah@mhshawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 675-6642"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Deborah L Arguello"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-13T23:09:17.467"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18324716"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-30T07:08:33.257"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26750026"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26750026"
[1]=>
string(8) "26750027"
[2]=>
string(8) "26750028"
[3]=>
string(8) "26750029"
[4]=>
string(8) "26750030"
[5]=>
string(8) "26750031"
[6]=>
string(8) "26750032"
[7]=>
string(8) "26750033"
[8]=>
string(8) "26750034"
[9]=>
string(8) "26750035"
[10]=>
string(8) "26750036"
[11]=>
string(8) "26750037"
[12]=>
string(8) "26750038"
[13]=>
string(8) "26750039"
[14]=>
string(8) "26750040"
[15]=>
string(8) "26750041"
[16]=>
string(8) "26750042"
[17]=>
string(8) "26750043"
[18]=>
string(8) "26750044"
[19]=>
string(8) "26750045"
[20]=>
string(8) "26750046"
[21]=>
string(8) "26750047"
[22]=>
string(8) "26750048"
[23]=>
string(8) "26750049"
[24]=>
string(8) "26750050"
[25]=>
string(8) "26750051"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423930
)
[StreetNumber] => Array
(
[0] => 48
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Haumalu
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Wahiawa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96786
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://seehouseat.com/2287213?idx=1
)
[ListPrice] => Array
(
[0] => 1025000.00
)
[CurrentPrice] => Array
(
[0] => 1025000.00
)
[Neighbourhood] => Array
(
[0] => WAHIAWA HEIGHTS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Make this home yours, with your added personal touches and upgrades, this charming residence becomes the perfect haven for relaxation and entertainment. Escape to a serene oasis surrounded by lush foliage and vibrant tropical flowers. This tranquil retreat boasts a private backyard with no rear neighbors, lush gardens featuring orchids and anthuriums, fragrant lychee, exotic gingers, Meyers lemons, bananas, avocados, vibrant Ti plants, and yellow trumpet flowers. It is conveniently located minutes from Schofield Barracks and Wheeler Army Airfield. Situated in close proximity to Wahiawa Botanical Gardens, Freshwater State Recreation Area, nearby hiking trails, easy access to North Shore beaches and the iconic Haleiwa town, you won't run out of things to do. Don't miss the pineapple-themed family fun and delicious treats at Dole Plantation! For an added bonus the home comes with 23 owned PV panels AND an 2018 electric Smart car with 22K+ miles. Seize this incredible opportunity to own a piece of tropical paradise! Schedule a viewing today and start living your Hawaiian dream!
)
[ListOfficeName] => Array
(
[0] => Fathom Realty HI LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 1
)
[LotSizeArea] => Array
(
[0] => 11563.00
)
[SqftTotal] => Array
(
[0] => 1456
)
[YearBuilt] => Array
(
[0] => 1966
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Mountain,Other
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Iliahi
)
[MiddleOrJuniorSchool] => Array
(
[0] => Wahiawa
)
[HighSchool] => Array
(
[0] => Leilehua
)
[ListOfficeMLSID] => Array
(
[0] => PAKU
)
[ListAgentEmail] => Array
(
[0] => deborah@mhshawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 675-6642
)
[ListAgentFullName] => Array
(
[0] => Deborah L Arguello
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-13T23:09:17.467
)
[Matrix_Unique_ID] => Array
(
[0] => 18324716
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-30T07:08:33.257
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26750026
)
[listing_image] => Array
(
[0] => 26750026
[1] => 26750027
[2] => 26750028
[3] => 26750029
[4] => 26750030
[5] => 26750031
[6] => 26750032
[7] => 26750033
[8] => 26750034
[9] => 26750035
[10] => 26750036
[11] => 26750037
[12] => 26750038
[13] => 26750039
[14] => 26750040
[15] => 26750041
[16] => 26750042
[17] => 26750043
[18] => 26750044
[19] => 26750045
[20] => 26750046
[21] => 26750047
[22] => 26750048
[23] => 26750049
[24] => 26750050
[25] => 26750051
)
)
- BedsTotal: 3
- Full Baths: 1
- Half Baths: 1
- Land Area (sf): 11,563
- Living (sf): 1,456
- Year Built: 1966
- Property Condition: Average
- Number of Parking Spaces: 3
- View: Mountain,Other
- Listing Office: Fathom Realty HI LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Iliahi
- Middle School: Wahiawa
- High School: Leilehua
