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

6923 Woodwalk Drive
Brecksville, OH 44141
Suzanne Lambert with Howard Hanna, original listing - (440) 526-1800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $575,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3288 Square Feet
Agency: Howard Hanna
Agency Phone: (440) 526-1800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Condominium
Year Built: 1980
Notes: Designed by architect William Morris and located in the heart of Brecksville is this UNIQUE, EXQUISITE, SPACIOUS and PRISTINE FREE-STANDING Windward Hills MAINTENANCE-FREE condo situated on a PICTURESQUE PRIVATE WOODED lot accommodating MULTIPLE LIFESTYLE options with THREE Levels of Living space with FINISHED WALKOUT with ALL levels with Full Bath with an OPEN floor plan w/FANTASTIC windows providing scenic views w/MAGAZINE-WORTHY DÉCOR! You are immediately impressed with the SPECTACULAR TOWERING Great Room w/21 feet WOOD ceiling w/FULL Wall of Windows & Distinctive fireplace providing relaxing living space w/great nature views. The Dining Room overlooking Great Room is currently used as TV area w/real wood beam is adjacent to the WELL-APPOINTED Kitchen w/Granite counters w/Breakfast Bar, appealing cabinetry, NEWER stainless appliances w/Insta-Hot & large Pantry area. When ready to relax and enjoy nature, step out to the vaulted 4 Season Room w/indirect mood lighting SURROUNDED BY WINDOWS providing FANTASTIC views or cookout on your composite deck. The FIRST-FLOOR Den which is currently being used as a bedroom. First Floor Laundry w/NEWER Washer & Dryer. An OPEN staircase leads to the Second level overlooking Great Room leading to the vaulted Owner Suite w/Glamour Bath w/deep jetted tub, Walk in closet & HUGE Bonus Room, currently used as your DREAM closet, but provides for many options The Finished WALKOUT Lower level provides an additional area of living space complete with Family Room with windows with access to Patio, TWO bedrooms and Full Bath PLUS plenty of room for storage with the Unfinished area with built-in shelving and 4-Person Sauna. Home has an Oversized heated garage with storage pad. FANTASTIC LOCATION close to all downtown amenities, National Forest and Metroparks, Rec Center, Golf Course, Valor Acres and MORE, all with easy highway access. New Furnace with mobile control, New HWT, New Garage Door.
MlsNumber: --
ListingId: 11367115


Listing Provided By: Howard Hanna, original listing
Phone: (440) 364-4545
Office Phone: (440) 526-1800
Agent Name: Suzanne Lambert
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 = 3477 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 Ray Sohrabi - Serving NE Ohio since 1987
Ray Sohrabi - Serving NE Ohio since 1987
ASCIIeXp Realty
Call Today!: (216) 269-2333

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App