Title Page Background
HFQUERY 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 = 2963 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2963 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2963 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

14787 Dodd Rd.
Burbank, WA 99323
Flo Sayre with Land and Wildlife LLC - Pasco, original listing - (509) 539-3161

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 4737 Square Feet
Agency: Land and Wildlife LLC - Pasco
Agency Phone: (509) 539-3161

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: Industrial Zoning Acres, Multi-Use, Business Potential... This is MORE than a ranchette! It's a custom brick Tudor home on a small cherry orchard overlooking the mighty Columbia River to thewest! Orchard is Bing cherries w/ Rainier pollinators, 2 wind machines, leased propane tanks, & trees are 25 & 35 years old. There is afruit stand with cold room and plenty of parking for a roadside farmers' market set-up. It has the lighted pedestal sign for advertising andenough room for large vehicles to pull off or turn around. The home is 4737 sq.ft. with 4 bedrooms, 3 bathrooms, 3 fireplaces, formaldining and breakfast bar, family room, living room, custom office and gourmet kitchen! An abundance of custom woodwork is in thishome. Except for the stairs to the upper level, the home meets ADA qualifications. Outside there's an in-ground pool, pool house with 3/4 bath, hot tub & gazebo and fenced yard. Then you'll find a block shop large enough to work on big equipment, trucks, etc., as well asroom to park rolling stock. Keep the cherries or pull them out for a large truck garden! Lots of traffic on Dodd Rd for customers, andthe store is next door! Don't miss this one if you want the custom home on a few acres of privacy.
MlsNumber: --
ListingId: 66863


Listing Provided By: Land and Wildlife LLC - Pasco, original listing
Phone: (509) 544-8944
Office Phone: (509) 539-3161
Agent Name: Flo Sayre
Disclaimer: Copyright © 2024 LandLeader. 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