Welcome to this exceptional custom-built lakefront estate in the highly desirable Via Avellino development, located in the coveted South Range School District. Built in 2014 by Master Plan Builders, this architectural masterpiece offers over 4,811 square feet above grade plus an additional living quarters in the finished walkout lower level, combining timeless elegance with modern functionality.
From the moment you arrive, the striking curb appeal, grand gables, stone accents, and manicured landscaping set the tone for what lies within. Step inside to discover a sophisticated interior featuring soaring ceilings, a dramatic 20' floor-to-ceiling stone fireplace and windows, wide-plank flooring, and an open-concept layout flooded with natural light. The gourmet kitchen is a showpiece, offering high-end cabinetry with integrated appliances, a massive waterfall island, double ovens, and panoramic views of the lake. The spacious dining area, and seamless access to the outdoor terrace make this home ideal for entertaining.
The primary suite is a true retreat, with tray ceilings, a private sitting area, and a spa-like bath with a clawfoot tub, oversized walk-in shower, dual vanities, and a beverage station/coffee bar. Additional 3 bedrooms upstairs, each with their own bathrooms are equally impressive, with designer finishes and custom storage throughout.
The lower level features a hidden man cave 26x30 accessible through a murphy door, with 10" sound-proof walls, and windows where you can still enjoy the gorgeous scenic views. Additionally, the walk out lower level offers a second living quarters with a full kitchen, dining and living areas rounded out by a bedroom and full bathroom.
Private fenced yard, peaceful lakeside ambiance, and awe-inspiring sunsets from your own upper balcony, with every detail thoughtfully designed and executed, this lakefront masterpiece blends timeless architecture with modern comfort for a lifestyle that’s second to none.
For sale
$2,300,000
455 Via Avelino St, North Lima, OH 44452
6beds
7,704sqft
Est.:
Single Family Residence
Built in 2014
1.29 Acres Lot
$-- Zestimate®
$299/sqft
$85/mo HOA
What's special
Lakefront estateMassive waterfall islandDesigner finishesUpper balconyTray ceilingsAwe-inspiring sunsetsPrimary suite
- 32 days
- on Zillow |
- 4,689 |
- 130 |
Zillow last checked: 7 hours ago
Listing updated: August 04, 2025 at 11:34am
Listing Provided by:
Jen Jordan 330-565-6158 jenjordan@kw.com,
Keller Williams Chervenic Rlty
Source: MLS Now,MLS#: 5142931
Originating MLS: Youngstown Columbiana Association of REALTORS
Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 7
- Full bathrooms: 5
- 1/2 bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 2
Primary bedroom
- Description: Flooring: Tile
- Level: First
- Dimensions: 17.1 x 14.9
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 14.1 x 14
Bedroom
- Description: Flooring: Luxury Vinyl Tile
- Level: Lower
- Dimensions: 17.11 x 25.5
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 11.3 x 14.3
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 12.7 x 14.11
Bedroom
- Description: Flooring: Tile
- Level: First
- Dimensions: 13.6 x 12.11
Primary bathroom
- Description: Flooring: Tile
- Level: First
- Dimensions: 20.11 x 11.1
Bathroom
- Description: Flooring: Luxury Vinyl Tile
- Level: Lower
- Dimensions: 9.1 x 10.4
Dining room
- Description: Flooring: Tile
- Level: First
- Dimensions: 15.3 x 18.8
Dining room
- Description: Flooring: Tile
- Level: First
- Dimensions: 16.9 x 17.6
Great room
- Description: Flooring: Tile
- Level: First
- Dimensions: 18.7 x 19
Kitchen
- Description: Flooring: Luxury Vinyl Tile
- Level: Lower
- Dimensions: 17.7 x 19
Kitchen
- Description: Flooring: Tile
- Level: First
- Dimensions: 19.5 x 16.8
Laundry
- Description: Flooring: Tile
- Level: Second
- Dimensions: 10.7 x 5.11
Laundry
- Description: Flooring: Tile
- Level: First
- Dimensions: 13.9 x 12.2
Office
- Description: Flooring: Luxury Vinyl Tile
- Level: Lower
- Dimensions: 24.1 x 22.1
Other
- Description: Flooring: Luxury Vinyl Tile
- Level: Lower
- Dimensions: 10.11 x 9.1
Other
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 14.11 x 8.4
Other
- Description: Flooring: Tile
- Level: First
- Dimensions: 11.11 x 10.4
Recreation
- Description: Flooring: Luxury Vinyl Tile
- Level: Lower
- Dimensions: 36.5 x 22.8
Heating
- Forced Air, Gas
Cooling
- Central Air
Appliances
- Included: Built-In Oven, Cooktop, Dryer, Dishwasher, Microwave, Refrigerator, Washer
- Laundry: Main Level, Multiple Locations, Upper Level
Features
- Breakfast Bar, Built-in Features, Tray Ceiling(s), Ceiling Fan(s), Chandelier, Crown Molding, Cathedral Ceiling(s), Double Vanity, Granite Counters, High Ceilings, His and Hers Closets, Kitchen Island, Multiple Closets, Open Floorplan, Recessed Lighting, Soaking Tub, Vaulted Ceiling(s), Walk-In Closet(s)
- Windows: ENERGY STAR Qualified Windows
- Basement: Finished,Storage Space,Walk-Out Access
- Number of fireplaces: 1
- Fireplace features: Gas, Great Room
Interior area
- Total structure area: 7,704
- Total interior livable area: 7,704 sqft
- Finished area above ground: 4,811
- Finished area below ground: 2,893
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: Attached, Detached, Garage
- Attached garage spaces: 4
Features
- Levels: Three Or More
- Patio & porch: Rear Porch, Enclosed, Patio, Porch, Balcony
- Exterior features: Balcony, Sprinkler/Irrigation
- Pool features: None
- Fencing: Wrought Iron
- Has view: Yes
- View description: Lake, Panoramic
- Has water view: Yes
- Water view: Lake
- Waterfront features: Lake Front
- Frontage type: Lakefront
Lot
- Size: 1.29 Acres
- Features: Lake Front
Details
- Parcel number: 050230001.060
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Conventional
- Property subtype: Single Family Residence
Materials
- Stone, Stucco
- Roof: Asphalt
Condition
- Year built: 2014
Details
- Builder name: Master Plan
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Features: Lake
- Subdivision: Via Avellino 2
HOA
- Has HOA: Yes
- Services included: Common Area Maintenance, Snow Removal, See Remarks, Trash
- HOA fee: $85 monthly
- HOA name: Via Avellino
Location
- Region: North Lima
Financial & listing details
- Price per square foot: $299/sqft
- Tax assessed value: $870,410
- Annual tax amount: $14,769
- Date on market: 7/31/2025
- Cumulative days on market: 33 days
- Listing terms: Cash,Conventional
- Loading
- Loading