3248 Lockport Olcott Road
Property Description
Experience resort-style living every day in this extraordinary estate, perfectly designed for extended guests and those seeking flexible space for events. Nestled on over 14 acres of private sanctuary-surrounded by mature trees and a peaceful creek-this custom-built mansion offers unmatched luxury, privacy, and versatility. The main residence features 4 spacious bedrooms and 3 elegant baths, including a primary suite with a spa-inspired bathroom and a walk-in closet designed for ultimate comfort. The heart of the home is an oversized chef's kitchen and a beautifully appointed dining room-ideal for family gatherings and celebrations. What truly sets this property apart is the separate in-law suite, complete with 2 bedrooms, a full bath, and its own living area. Whether you're accommodating parents, adult children, or long-term guests, this private space offers independence and comfort while keeping loved ones close. The finished basement boasts a private gym, and the backyard is an entertainer's dream: enjoy an inground pool, hot tub, outdoor kitchen, pergola dining area, pool house, basketball court, and expansive patios-perfect for making memories across generations. Recent upgrades include brand new garage doors and new AC condensers for modern convenience and peace of mind. This estate is truly a rare find for families looking to live, entertain, and thrive together-all within their own private resort. Schedule your private tour today and discover the endless possibilities for multigenerational living! Also listed under ML B1613553
Broker Details
WNY METRO ROBERTS REALTY (716) 891-1710
MLS ID: KRENZERM State License Number: 10401343898
Key Property Information
| Listing Status: | Available |
|---|---|
| Listing Type: | Call for offers |
| Property Types: | 2-4 Units |
| Price: | $1,350,000 |
| No. of Units: | 2 |
| Year Built: | 1997 |
| Lot Size: | 5,306.00 Sq ft |
| Opportunity Zone: | No |
| Price per unit: | $675,000 |
| Property Website | Click Here |
| Number of Bedrooms: | 6 |
| Number of Bathrooms: | 5 |
ID: 3yd-BNARNY-B1613565
Investment Analyzer
Sponsored by:
Step 1Financing Calculation
Step 2Gross Rent Analysis
Please enter annual amounts.
Step 3Final Deal Analysis
Similar Properties in the Area
225-227 E 16th Ave
Homestead, Pennsylvania
Brokers
View All-
Remax Real Estate Professionals
Re/Max Real Estate Professionals
-
Jared Ennis
Central CA Commercial | California
-
Rick Recckio
Recckio Real Estate & Development
-
Greg Corbin
Northgate Real Estate Group
Lenders
View AllManagement
View All-
Essex Property Trust, Inc.
California
-
Josh A
California
-
Bob Tuteur
-
Andrew Schildcrout