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 = 2294 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2294 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2294 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;

684 Miller Picking Rd
Davidsville, PA 15928

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,199,000
Beds: --
Baths: 2
Status: Active
SqFt: --
Agency: Mossy Oak Properties Pennsylvania Land Professiona

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25 acre(s)
Property Type: Residential
Year Built: --
Notes: Bruce Nurseries has called Davidsville, PA home for more than 75 years. Serving garden centers, nurseries, and landscapers since 1945, Bruce Nurseries has cultivated a following of loyal customers throughout Southwest PA. Since opening it's doors in 1945, the business has proudly provided the highest quality weed disease-free, professionally pruned nursery stock to its clients. Boasting varieties ranging from old-time favorites to new, unique varieties of plants. The nursery sits on 25 +/- acres and is highlighted by the 2,378 sq ft home, workshop, office, heated greenhouse and so much more. Features Of The Home Include: 2,378 sq ft 3 bed, 1.5 bath with a basement Spacious floorplan Kitchen and Laundry located on the main floor Covered front and side porch Wood burning stove on the main floor Bedrooms located on the top level Landscaped yard Features Of The Nursery Include: Nursery stock - Planted Field 27 Poly Hoop houses 38,300 Sq Ft Heated Greenhouse 18x60 Barn/Garage 38x56 Office 16x29 Workshop 22x22 Equipment Includes: 2015 Ford F350 dump truck 24k miles John Deere 5300 hilift Cat 242 B Skidloader (bucket forks) Red Boss Treespade 28" Steiner 440 Diesel Tractor Int. Cub Cultivator Brush Hog Mower Christmas Tree planter 2 Bottom Plow Harrow Hyd. Sprayer 2 Honda Water pump 3" Miscellaneous tools, potting soil, burlap, pots, chemicals *Financials available upon proof of funds*
MlsNumber: 11222527


Listing Provided By: Mossy Oak Properties Pennsylvania Land Professiona, original listing
Name: Mossy Oak Properties Pennsylvania Land Professiona
Phone: (724) 678-1232
Office Name: Mossy Oak Properties Pennsylvania Land Profes
Office Phone: (724) 678-1232
Agent Name: Benjamin Beck
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2294 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;
Real Estate Expert Photo for Sarah J Mazurkiewicz
Sarah J Mazurkiewicz
ASCIIHoward Hanna Bardell Realty
Call Today!: (219) 241-6977

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App