Listing
Overview
Price: $895,000
Area: WAHIAWA AREA
Status: Active Under Contract
Single-level home with STUNNING view of Lake Wilson right from your living room! Home situated on quiet cul-de-sac where you can enjoy the privacy and beauty of living directly next to the lake with no neighbors behind you. Direct access to the lake from your backyard! Plenty of space to entertain in this 3-bedroom, 2-bath home with new carpet throughout. Two indoor living spaces and a dining area adjacent to the kitchen. Tranquil, low-maintenance landscaping. Great location close to shops/eateries with easy access to freeway. Book your private showing today! Listing by: BLUE COVE PROPERTIES LLC (808) 292-2079
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202420927"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(3) "294"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Kaliponi"
}
["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(98) "https://player.vimeo.com/video/1010077089?badge=0&autopause=0&player_id=0&app_id=58479"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "895000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "895000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(12) "WAHIAWA AREA"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(565) "Single-level home with STUNNING view of Lake Wilson right from your living room! Home situated on quiet cul-de-sac where you can enjoy the privacy and beauty of living directly next to the lake with no neighbors behind you. Direct access to the lake from your backyard! Plenty of space to entertain in this 3-bedroom, 2-bath home with new carpet throughout. Two indoor living spaces and a dining area adjacent to the kitchen. Tranquil, low-maintenance landscaping. Great location close to shops/eateries with easy access to freeway. Book your private showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "BLUE COVE PROPERTIES LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "7532.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1600"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1963"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(12) "Marina/Canal"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(5) "Kaala"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Wahiawa"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Leilehua"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "COVE"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "shannon@bluecoveproperties.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 292-2079"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Shannon R W Zerfas"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-09-23T16:41:15.697"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18258055"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-09-17T06:15:32.763"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(9) "Lake/Pond"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26697728"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26697728"
[1]=>
string(8) "26697729"
[2]=>
string(8) "26697730"
[3]=>
string(8) "26697731"
[4]=>
string(8) "26697732"
[5]=>
string(8) "26697733"
[6]=>
string(8) "26697734"
[7]=>
string(8) "26697735"
[8]=>
string(8) "26697736"
[9]=>
string(8) "26697737"
[10]=>
string(8) "26697738"
[11]=>
string(8) "26697739"
[12]=>
string(8) "26697740"
[13]=>
string(8) "26697741"
[14]=>
string(8) "26697742"
[15]=>
string(8) "26697743"
[16]=>
string(8) "26697744"
[17]=>
string(8) "26697745"
[18]=>
string(8) "26697746"
[19]=>
string(8) "26697747"
[20]=>
string(8) "26697748"
[21]=>
string(8) "26697749"
[22]=>
string(8) "26697750"
[23]=>
string(8) "26697751"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202420927
)
[StreetNumber] => Array
(
[0] => 294
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kaliponi
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Wahiawa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96786
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1010077089?badge=0&autopause=0&player_id=0&app_id=58479
)
[ListPrice] => Array
(
[0] => 895000.00
)
[CurrentPrice] => Array
(
[0] => 895000.00
)
[Neighbourhood] => Array
(
[0] => WAHIAWA AREA
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Single-level home with STUNNING view of Lake Wilson right from your living room! Home situated on quiet cul-de-sac where you can enjoy the privacy and beauty of living directly next to the lake with no neighbors behind you. Direct access to the lake from your backyard! Plenty of space to entertain in this 3-bedroom, 2-bath home with new carpet throughout. Two indoor living spaces and a dining area adjacent to the kitchen. Tranquil, low-maintenance landscaping. Great location close to shops/eateries with easy access to freeway. Book your private showing today!
)
[ListOfficeName] => Array
(
[0] => BLUE COVE PROPERTIES LLC
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 7532.00
)
[SqftTotal] => Array
(
[0] => 1600
)
[YearBuilt] => Array
(
[0] => 1963
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Marina/Canal
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kaala
)
[MiddleOrJuniorSchool] => Array
(
[0] => Wahiawa
)
[HighSchool] => Array
(
[0] => Leilehua
)
[ListOfficeMLSID] => Array
(
[0] => COVE
)
[ListAgentEmail] => Array
(
[0] => shannon@bluecoveproperties.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 292-2079
)
[ListAgentFullName] => Array
(
[0] => Shannon R W Zerfas
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-09-23T16:41:15.697
)
[Matrix_Unique_ID] => Array
(
[0] => 18258055
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-09-17T06:15:32.763
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Lake/Pond
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26697728
)
[listing_image] => Array
(
[0] => 26697728
[1] => 26697729
[2] => 26697730
[3] => 26697731
[4] => 26697732
[5] => 26697733
[6] => 26697734
[7] => 26697735
[8] => 26697736
[9] => 26697737
[10] => 26697738
[11] => 26697739
[12] => 26697740
[13] => 26697741
[14] => 26697742
[15] => 26697743
[16] => 26697744
[17] => 26697745
[18] => 26697746
[19] => 26697747
[20] => 26697748
[21] => 26697749
[22] => 26697750
[23] => 26697751
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 7,532
- Living (sf): 1,600
- Year Built: 1963
- Property Condition: Above Average,Average
- Number of Parking Spaces: 4
- View: Marina/Canal
- Listing Office: BLUE COVE PROPERTIES LLC
- Land Tenure: FS - Fee Simple
- Elementary School: Kaala
- Middle School: Wahiawa
- High School: Leilehua
