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

1730 Pearce Circle
Salem, OH 44460
Cindy Lautzenheiser with Howard Hanna, original listing - (330) 702-8400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,295,000
Beds: 5
Baths: Full: 3, ½: 2
Status: Active
SqFt: 8490 Square Feet
Agency: Howard Hanna
Agency Phone: (330) 702-8400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Step into timeless elegance with this magnificent stone-built masterpiece, offering over 8,000 square feet of pure luxury. Sited on a pristine 2 Acre lot in a desirable neighborhood, this three-story home redefines opulence. With 5 bedrooms, 4 fireplaces, and a thoughtfully designed open floor plan, this residence is an entertainer's dream, perfect for family living and accommodating guests with ease. Every inch of this solid stone home radiates grandeur, from the sprawling first floor to the expansive lower-level walk-out, providing exceptional spaces for living, leisure, and more. The first floor features an open layout, highlighted by a dynamic kitchen w/ a massive center island, bar seating, double ovens, double refrigerators, walk-in pantry, and a sunlit breakfast room. This space flows seamlessly into a cozy family room overlooking the covered back deck, enhanced by a charming beamed pergola. The formal dining room, adorned w/hickory flooring, and a grand foyer open to dramatic upper and lower staircases, exude sophistication. The first-floor primary bedroom wing is a true retreat, featuring walk-in closets, fireplace, and a newly renovated spa-like bath with a walk-in shower and soaking tub. A first-floor laundry room rounds out this level. The second-floor offers a loft for flexible living space, two spacious bedrooms, a full bath, and plenty of storage. The walk-out lower level is filled with natural light and provides additional living options, including a rec room w/fireplace, a media or billiards room, 2 large bedrooms, a full bath, a half bath, a gym, an office with built-ins, and a 2nd laundry room designed for a future second kitchen, & additional storage space for your convenience. Outside, enjoy the 3-car garage, a covered back deck, stamped concrete side patio, and lush landscaping. Cypress trees provide privacy, and a brand-new roof ensures worry-free living for years to come. This is a one-of-a-kind residence where luxury meets functionality.
MlsNumber: --
ListingId: 11367007


Listing Provided By: Howard Hanna, original listing
Phone: (330) 565-3712
Office Phone: (330) 702-8400
Agent Name: Cindy Lautzenheiser
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 = 2052 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 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 Ryan Grim
Ryan Grim
ASCIIWeichert, Realtors - Welcome Agency
Call Today!: (330) 503-8418

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App