My Company's Active Listings

$549,600 (USD)
Contingent

Amherst Area Single Family Home

Contingent

45002 Middle Ridge Road Amherst, OH 44001

5 Bed
4 Baths
2836 sqft
MLS# 5189167
Virtual Tour
Truly magnificent & exceptional estate offering three fully finished living spaces, designed for luxury, flexibility, unforgettable entertaining. One-of-a-kind property has been completely/meticulously remodeled w/only the finest materials plus extraordinary attention to detail—creating a year-round vacation lifestyle (multi generational living option). Main residence showcases glamorous design w/soaring beamed ceilings, light-filled open rooms, high-end finishes throughout. Walk-out lower level is fully customized & ideal for entertaining, featuring a stunning kitchen/bar area, bedroom, full bath, laundry, private theatre room that opens to a resort-style patio. Outdoor living is second to none. Enjoy the covered entertaining space w/dramatic waterfall feature plus 16x18 Michael Phelps Swim Spa w/electric cover. Professionally designed acre yard creates a true resort atmosphere. Car enthusiasts/hobbyists will appreciate the heated/cooled garage space—so clean you can eat off the floors—plus parking for 6+ vehicles, premium concrete ample parking. Beautifully restored 3-story century barn blends historic charm w/functional versatility. Detached custom-built 1-bedroom home offers incredible craftsmanship/detail beyond description—perfect for guests, multigenerational living, private office/studio space. Additional detached garage/shed provides even more flexibility. Ideal for contractors, collectors, entrepreneurs, or those seeking a private compound-style property. Simply too much detail to capture here—this is a must-see estate in township (no RITA)
Listing Courtesy of YES MLS / Coldwell Banker Schmidt Realty / Christopher Frederick
$534,900 (USD)
Active

Cleveland Area Single Family Home

Active

13817 Lakewood Heights Boulevard Cleveland, OH 44107

3 Bed
3 Baths
2873 sqft
MLS# 5182784
This custom Lakewood Heights residence offers a level of design and functionality rarely found in the area. Spanning nearly 2,900 sq ft, this thoughtfully reimagined home delivers dramatic spaces, premium upgrades, and an indoor-outdoor lifestyle ideal for buyers seeking something truly unique.
At the heart of the home is a chef’s kitchen remodeled with professional-grade appliances, including a 48” refrigerator, 7-burner gas range, wine and beverage refrigeration, expansive stone countertops, and a statement island. Vaulted ceilings, skylights, and curated lighting flood the space with natural light, while the adjacent living area features a fireplace and custom built-ins for added warmth and character.
A four-season sunroom opens seamlessly to a private backyard retreat designed for entertaining, complete with a covered gazebo, built-in pizza oven, Blackstone griddle, Egg grill, and fire pit.
The primary suite is a true sanctuary with a built-in coffee bar and a spa-inspired bath renovated in 2024 featuring dual vanities and a custom walk-in shower. A lofted flex space with a Juliet balcony offers an ideal home office or creative retreat.
The lower level includes two additional bedrooms, a full bath, a large flex/media space, and a second laundry area. With abundant storage, a whole-home generator, easy highway access, and proximity to shopping and dining, this home delivers exceptional lifestyle value. Schedule your private showing today.
Listing Courtesy of YES MLS / Coldwell Banker Schmidt Family Of Companies / Brian Moran
$499,900 (USD)
Contingent

Gem Beach Area Single Family Home

Contingent

5814 E Poplar Avenue Port Clinton, OH 43452

3 Bed
2 Baths
1217 sqft
MLS# 5203213
One of the most magnificent lake retreats on the market—Exceptional Catawba Island home has been completely transformed w/no expense spared & lovingly maintained by a long-term owner. Perfect for year-round living or a luxurious getaway, this property offers unmatched amenities and is ideally located on a quiet no-outlet street, just a short walk to the private beach/lake, surrounded by other well-cared-for homes. An additional lot is also available for use for a minimal voluntary $50 annual fee. Nestled on a private lot, this home showcases a stunning open-concept high end design w/vacation-inspired cabin feel, featuring soaring volume ceilings/sun-filled living spaces throughout. Newer gourmet kitchen is a showstopper with premium cabinetry, striking granite countertops, large breakfast bar, and high-end fixtures—perfect for entertaining. Elegant owner’s suite is a true retreat, complete w/spa-like private bath featuring a luxurious walk-in shower/heated floors. Newer functional laundry room w/washer & dryer included adds convenience, updated mechanicals/electrical throughout for peace of mind. Relax & unwind in the inviting enclosed front porch or step out back to the fully fenced patio area—an entertainer’s dream. Garage has been upgraded w/Nature Stone flooring, TV entertainment setup, double doors that open to the patio, while a charming carriage house-style second-floor bedroom provides additional living space or guest accommodations. Exterior updates include beautiful shake-style vinyl siding & premium windows, excellent storage and closet space throughout. Great room features an electric fireplace, adding warmth and charm. Located just minutes from the lake, restaurants, shopping, island attractions, this one-of-a-kind property offers the perfect blend of luxury, comfort, and location. Truly a must-see—schedule your private tour today!
Listing Courtesy of YES MLS / Coldwell Banker Schmidt Realty / Christopher Frederick
$475,000 (USD)
Active

Greenhaven Area Single Family Home

Active

188 W Sturbridge Drive Medina, OH 44256

3 Bed
3 Baths
3148 sqft
MLS# 5202531
Elegant & sophisticated, beautifully remodeled Cape Cod (1st floor master) delivers dramatic design/exceptional first-floor living in a highly desirable neighborhood. Spacious .37-acre lot w/large drive, side-load garage, expansive stamped concrete patio (2024), home offers the perfect blend of style, comfort, & function. Step into the impressive two-story foyer & experience the open, light-filled layout featuring soaring ceilings plus walls of glass that bathe the home in natural sunlight. Formal dining room showcases refined trim detail, while the inviting great room offers a volume ceiling, cozy gas fireplace, finished w/expansive windows. Updated gourmet chef’s kitchen (2017) is truly the heart of the home, complete w/chef's island/breakfast bar/wine rack, premium stainless steel appliances, pantry, vaulted ceilings/light filled w/skylight, & direct access to the backyard—perfect for entertaining. Convenient first-floor laundry & half bath enhance everyday living. Retreat to the first-floor owner’s suite (slider to patio) w/multiple closets & luxurious ensuite bath featuring custom tile shower/dual sinks. Upstairs, you’ll find two additional bedrooms, full bath, dramatic lower level views. Fabulous finished basement (2023) is a must-see, spacious recreation area/theate & versatile flex room ideal as a 4th fourth bedroom, office, fitness space. Updates include roof (2023), carpet (2022), central A/C (2025), more. Quality Medina School District just minutes from Medina Square, parks, schools, etc. Bright, airy, move-in-ready home is a rare find--Exception Home!
Listing Courtesy of YES MLS / Coldwell Banker Schmidt Realty / Christopher Frederick
$469,900 (USD)
Contingent

Medina Area Single Family Home

Contingent

3169 Sharon Court Medina, OH 44256

2 Bed
2 Baths
2158 sqft
MLS# 5197205
Virtual Tour
(4k Video Available) Exceptional & elegant one-floor living at its finest in the highly desirable Enclave at Woodside Reserve. Beautifully maintained ranch offers 9-foot ceilings, light-filled open floor plan, design that blends comfort w/premium finishes. Inviting foyer welcomes you w/detailed trim work plus bathed in natural light. Spacious gathering room flows seamlessly into an upgraded gourmet kitchen that is sure to impress, featuring custom soft-close dovetail cabinetry, granite countertops, stainless steel appliances completed design w/massive walk-in pantry. Convenient butler’s pantry connects the kitchen to the office/flex space. Home offers 2 large bedrooms plus an office/flex room that could serve as a 3rd bedroom, 2 full bathrooms finished w/upgraded granite. Pamerping owner’s suite includes generous space & massive walk-in closets plus glamour style dual sink bath/makeup counter. Ample storage found throughout home/additional storage in the garage. Enjoy the impressive 3-car garage w/inset workspace w/wide 3-car driveway, situated on a premium lot w/deep setback from the road. Backyard features a concrete patio w/retractable awning (remote-controlled). Improvements include ceiling fans throughout, enhanced landscaping & lighting, irrigation system, security system. HOA provides lawn care and snow removal for true low-maintenance living. Move-in ready and meticulously cared for—don’t miss this opportunity to own a stunning home in one of the area’s most sought-after communities.
Listing Courtesy of YES MLS / Coldwell Banker Schmidt Realty / Christopher Frederick