Search
Duplex with In-Law Suite

3248 Lockport Olcott Road, Newfane, NY 14108

For Sale
$1,350,000

Residential, Newfane, NY

Property Size5,306 SF
Lot Size14.80 Acres
Price / SF$254.43
Days on Market528

Property Features for 3248 Lockport Olcott Road

General Information

Property type Residential Multi Family
Property subtype Other
Bedrooms 6
Bathrooms 5
Full bathrooms 4
Half bathrooms 1
Rooms Bathroom 4, Bathroom 3, Bedroom 2, Bathroom 5, Bedroom 3, Bedroom 6, Basement, Bedroom 1, Bathroom 1, Bathroom 2, Bedroom 4, Bedroom 5
Spa 1
Patio and Porch features Patio
Interior features AirFiltration, ProgrammableThermostat
Exterior features Barbecue, HotTubSpa, Pool, Patio
Fireplace 1
Appliances GasWaterHeater, Humidifier
Lot features Irregular Lot, Secluded, Wooded
Elementary school district Newfane
Middle school district Newfane
High school district Newfane
Directions North on Transit Rd., right on Grand St., Left on Clinton St., Left on Lake Ave., Keep left on Rt. 78, house on left, set back
Subdivision Newfane-292800
Standard status Active
APN 292800-053-013-0001-050-001
Size 5,306 SF
Lot size 14.80 Acres

Taxes and HOA fees

Tax Annual Amount 18816

Utilities

Heating system Natural Gas, Forced Air, Zoned
Cooling system Zoned, Central Air
Water source Public
Water front features River Access, Stream

Amenities

inground pool
hot tub
outdoor kitchen
pergola dining area
pool house
basketball court
expansive patios
private gym
chef's kitchen

Building Details

Year built 1997
Floors in Building 1
Number of units 2
Flooring type Varies, Hardwood, Tile
Building materials Stone, Stucco, VinylSiding
Roof type Asphalt
Listing Agency: WNY Metro Roberts Realty
Listed By: Michelle Petrie · License NY #10401343898
Added: Jun 10, 2025 Changed: Nov 17 Last Checked: Nov 19 at 7:06AM
MLS# B1613565

Copyright © 2026 New York State Alliance of MLSs, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

This 5,306-square-foot duplex estate, built in 1997, includes a four-bedroom, three-bath main residence and a separate in-law suite with two bedrooms, a full bath, and its own living area. Interior features include a chef’s kitchen, dining room, finished basement gym, spa-style primary bathroom, and walk-in closet. Construction incorporates stone, stucco, and vinyl siding, with hardwood and tile flooring, natural-gas forced-air heating, zoned systems, and central air.

Set on 14.8 acres at 3248 Lockport Olcott Road in Newfane, the property includes mature trees, a stream, and river access. Exterior amenities include an inground pool, hot tub, outdoor kitchen, pergola dining area, pool house, basketball court, patio areas, and a barbecue. Recent improvements include new garage doors and AC condensers. Public water serves the property.

Key Highlights

  • 5,306‑square‑foot duplex estate on 14.8 acres
  • Main residence offers 4 bedrooms and 3 baths
  • Separate in‑law suite includes 2 bedrooms, full bath, and living area

Financial Insights

Estimated NOI and Cap Rate

NOI / Yr
$46,599
Cap Rate
3.45%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$931,980 $932.0K
Cap Rate 7%
$665,700 $665.7K
Cap Rate 9%
$517,767 $517.8K
NOI Build-Up for 5,306 SF
Gross rent
$71.3K
($13.44/SF)
Vacancy
−$4.7K
(−$0.89/SF)
EGI
$66.6K
($12.55/SF)
OpEx
−$20.0K
(−$3.76/SF)
NOI
$46.6K
($8.78/SF)
Market Conditions
Area
Niagara County, NY
Vacancy
6.65%
Lease Rate
$13.44 /SF/Yr
Expense Ratio
30.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$931,980
Cap Rate 7%
$665,700
Cap Rate 9%
$517,767

Alternative Uses

Best Use
Multifamily LT 5
$665.7K
$582.5K – $776.7K (±1% cap)
NOI $46,599 @ 7.0% cap · market cap 3.45%
Second Best
Apartment 5plus
$590.9K
$517.0K – $689.4K (±1% cap)
NOI $41,362 @ 7.0% cap · market cap 3.06%
Theoretical Best
Office A
$1.43M
$1.25M – $1.67M (±1% cap)
NOI $100,054 @ 7.0% cap · market cap 7.41%
Zoning and permitted uses should be independently verified with authorities. How Realmo checks its estimates

Property Analytics

Who owns this building? See the owner, sales and loan history
Open Analytics

Lease Details

2
Residential units

Location Intelligence

Trade Area within ½ mile

11
Businesses Nearby

Demographics for 14108, NY

5,654
Population
2,354
Households
2.4
Avg Household Size
47
Median Age
27%
College-Educated
92%
High-School Grad
24.8 sq mi
ZIP Area
228
Density / Sq Mi
$72,977
Median Household Income
$46,936
Median Earnings
$853
Median Rent
$146,100
Median Home Value
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

Market

Average Price Trend$/SF for Duplexes in Niagara County, NY

$85.72 Jul
$88.46 Aug
$92.41 Sep
$83.95 Oct

Properties on Market for Duplexes in Niagara County

Jul
Aug
Sep
Oct

Vacancy Rate% for Multifamily in Northeast region

4% 2022
4.6% 2023
5.3% 2024
5.6% 2025

Frequently Asked Questions

What type of property is this?
Duplex - Custom-built duplex estate with separate guest accommodations, recreational amenities, and stream access on a wooded Niagara County property.
Where is this duplex located?
The property is located at 3248 Lockport Olcott Road Newfane, NY.
What is the asking price?
The asking price for this property is $1,350,000.
What are key features of this property?
This property features: 5,306‑square‑foot duplex estate on 14.8 acres; Main residence offers 4 bedrooms and 3 baths; Separate in‑law suite includes 2 bedrooms, full bath, and living area
Research This Page with AI

Rey answers here. ChatGPT, Grok and Claude get the same data packet.

Includes: Price & PSF · Cap rate · Location · Zoning

Ask Rey → ChatGPT Grok Claude
Preferred Make Realmo a preferred source.

Our comps and market reports get this label in your Google results.

Add as a preferred source on Google One click on Google
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message
Why this one?
Why hide this one?