Title Page Background
DEBUG FN args: Array ( [0] => 2949 [1] => [2] => [3] => agent ) BEFORE: Site: 2949 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2949 Igate: njhud LocID: 2949 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2949 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2949 [1] => [2] => [3] => lender ) BEFORE: Site: 2949 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2949 Igate: njhud LocID: 2949 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2949 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2949 [1] => [2] => [3] => other ) BEFORE: Site: 2949 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2949 Igate: njhud LocID: 2949 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2949 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

15468 N Duck Lake Lamona
Harrington, WA 99134

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $477,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1400 Square Feet
Agency: Kelly Right Real Estate of Spo

Map Details Show Map | Show StreetView




House Features

Appliances: Range, Refrigerator
Architectural Style: Other
Cooling: Central A/C
Heating: Baseboard
Interior Features: Wood Floors, 3 Phase
Rooms: Basement, Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Dining Room, Kitchen, Family Room

Window Features

Exterior Features: Shop, Barn, Stge Shd, Septic Sys, well Installed
Other Features: Barn(s)
Roof: Metal
View: Territorial

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 20 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1940
Notes: Nestled in the outskirts of the charming town of Harrington on 20 acres. 3-bed, 2-bath home holds immense potential for those seeking to infuse it with new life and character. With hobby shop in the bsmt. Step into a world of possibilities with a 40x60 Industrial Metal Bldg. with a 12 ft ceiling and insulated doors, meticulously designed to cater to your woodworking and hobby needs. Spacious & versatile shop features 3-phase power, ensuring ample electricity for all your machinery & tools. Fully insulated & heated with a bathroom & office area, plumbed and wired for a kitchen. Offers the perfect setting for creativity to flourish. Plenty of storage & work areas. It was built for a CNC Machine shop. With air filtration & an air compressor system, including an air dryer, lining the entire shop with numerous drops. 40x60 shed for all of your toys & a 3-car garage providing ample space for storage & projects. Seize this opportunity to transform this property into a cozy haven that reflects your personal style.
MlsNumber: --


Listing Provided By: Kelly Right Real Estate of Spo, original listing
Phone: (509) 904-4663
Office Phone: (509) 904-4663
Agent Name: Anne Shaw
Disclaimer: Copyright © 2024 Spokane Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App