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 = 2089 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 = 2089 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 = 2089 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;

408 Sharon Falls Drive
Wadsworth, OH 44281
Shana Kim with Engel & Völkers Cleveland, original listing - (440) 568-0400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,150,000
Beds: 5
Baths: Full: 4, ½: 2
Status: Active
SqFt: 10085 Square Feet
Agency: Engel & Völkers Cleveland
Agency Phone: (440) 568-0400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Other-Single Family Residence
Year Built: 2018
Notes: Welcome to this Luxurious home that is located in the Exclusive, Woodlands of Sharon Falls in Highland Schools. This Masterpiece boasts Custom Finishes & Elevated attention to Detail inside & also in the surrounding 2 acre Oasis with Summer Kitchen. Over 10,000 SqFt of living space, the Elegant features of this home begin w/a Barrel Vaulted Ceiling in the Grand Foyer. As you enter the home, you are greeted w/the Great Room that has Vaulted Ceilings, Hand Scraped Beams, Built-Ins, & a Stone Surround Fireplace. The Chef's Inspired eat-in Kitchen has High-End Finishes & includes Top of the Line Built-in Appliances, including a Thermador Range/Cooktop w/a Pot Filler, an Electrolux Refrigerator, Pantry, Copper Sink, & Quartz Countertops. The Beautiful Butlers Pantry with Granite Counters, Wall Ovens & a Second Refrigerator are convenient for prepping. The Home Office is a Private & Light Filled Space just beyond the Butlers Pantry. The main living floor also has an "Entertainment Wing" that consists of a Theater Room, Bar Area, & Billiard Room. The 1st Floor Primary Suite is True Luxury as there are His & Her walk-in Closets and an En-suite Bath w/a Stunning Barrel Vaulted Ceiling with Chandeliers, Double Vanity, Makeup Vanity, & a Gorgeous Shower with a Moen Smart Shower System. All three Spacious Bedrooms on the second floor have En-suite Baths & Walk-in closets as well. The Finished Walk-Out Basement features the 5th Bedrm w/additional Egress Windows, Half bath that is Plumbed for a Full Bath, Large Light filled Exercise room, more walk-out access & so much storage space. The Screened & Terraced Patios provide Pvt Outdoor Areas for Guests. This home features a Porte-cochère that leads to a total of 5 Heated garages tall enough for your custom car lift. Included are all kitchen appliances, washer/dryer, built-in grill, pool table, theater room screen, wine fridge/ice maker in wet bar, & all window treatments. This home is a must see & a true display of warm luxury...
MlsNumber: --
ListingId: 5075154


Listing Provided By: Engel & Völkers Cleveland, original listing
Phone: (440) 568-0400
Office Phone: (440) 568-0400
Agent Name: Shana Kim
Disclaimer: Copyright © 2024 Engel & Völkers. 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 = 2089 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;
Mary J. Martin
ASCIILoFaso Real Estate Services
Call Today!: (440) 570-9388

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App