Two-Unit Duplex with Second-Floor
For Sale
$399,900
140 Blue Barns Road, Rexford, NY 12148
MULTI_FAMILY - Other - Rexford, NY
Property Size2,912 SF
Lot Size1.06 Acres
Price / SF$137.33
Days on Market46
Property Features for 140 Blue Barns Road
General Information
Property type
Residential Multi Family
Property subtype
Duplex
Bedrooms
7
Bathrooms
3
Full bathrooms
3
Rooms
Bathroom 1, Bedroom 7, Bathroom 2, Bedroom 3, Bedroom 5, Bedroom 2, Bathroom 3, Bedroom 6, Bedroom 1, Bedroom 4
Parking
15
Parking features
Off Street, Driveway
Patio and Porch features
Porch
Interior features
Paddle Fan, High Speed Internet
Basement
Full
Lot features
Private, Level, Landscaped, Cleared
High school
Burnt Hills-Ballston Lake HS
Elementary school district
Burnt Hills-Ballston Lake CSD (BHBL)
Middle school district
Burnt Hills-Ballston Lake CSD (BHBL)
High school district
Burnt Hills-Ballston Lake CSD (BHBL)
Directions
Take Blue Barns Road, it's the house on the right after Rustic Bridge Road
Standard status
Active
APN
412400 263.-1-9.2
Size
2,912 SF
Lot size
1.06 Acres
Taxes and HOA fees
Tax Annual Amount
6982
Utilities
Sewer type
Septic Tank
Heating system
Electric (Heating), Baseboard
Cooling system
Wall Unit(s)
Water source
Well
Building Details
Year built
1870
Number of units
2
Building materials
Vinyl Siding
Roof type
Shingle, Asphalt
Architectural style
Other
Listing Agency:
KW Platform · Keller Williams Realty
(518) 724-5800
Listed By:
Robert L Taylor · License #10401227306
(518) 331-8442
Added: Jul 6
Changed: Aug 18
Last Checked: Aug 20 at 8:06PM
MLS# 202621067
Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Investment Insights
Based on property information with market context.
This two-unit duplex offers two separate living spaces with in-unit laundry. The lower unit has 3 bedrooms and 2 full bathrooms, including a large primary suite with a private full bath, plus an open-concept living area. The upper unit includes 4 bedrooms and 1 bathroom, with an open-concept living area that extends to a spacious second-floor deck for additional outdoor living. The property sits on 1.06 acres and includes separate parking areas for each unit.
Located at 140 Blue Barns Road in Rexford, NY, the duplex is noted as being within the Burnt Hills School District. It is a residential income property configured as two units, with each unit designed to function independently.
For owner-occupants, this layout can support living in one unit while renting the other, with laundry and parking conveniences kept separate. For investors, the property’s two-unit configuration and distinct unit features may appeal to those seeking a straightforward duplex structure with dedicated parking for each unit.
Located at 140 Blue Barns Road in Rexford, NY, the duplex is noted as being within the Burnt Hills School District. It is a residential income property configured as two units, with each unit designed to function independently.
For owner-occupants, this layout can support living in one unit while renting the other, with laundry and parking conveniences kept separate. For investors, the property’s two-unit configuration and distinct unit features may appeal to those seeking a straightforward duplex structure with dedicated parking for each unit.
Key Highlights
- Two‑unit property with separate parking areas for each unit
- Lower unit layout: 3 bedrooms and 2 full bathrooms, including a primary suite with private full bath
- Upper unit layout: 4 bedrooms and 1 bathroom with an open‑concept living space
Financial Insights
Estimated NOI and Cap Rate
NOI = area × lease_rate × (100 − vacancy) / 100 × (1 − expense_ratio). Net Operating Income — what the owner takes home each year before mortgage payments and income tax. Effective rent (asking rent minus vacancy losses) minus operating costs (taxes, insurance, maintenance, management).
NOI / Yr
$33,163
Cap rate = NOI / list price × 100. Capitalization rate — annual return on a fully cash purchase, before financing. NOI divided by price. Higher means more income per dollar invested, but usually also more risk or older condition. 5–8% is typical for stabilized commercial property; double digits often signal distressed deals.
Cap Rate
8.29%
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$663,260
$663.3K
Cap Rate 7%
$473,757
$473.8K
Cap Rate 9%
$368,478
$368.5K
Market Conditions
NOI Build-Up for 2,912 SF
Vacancy — income lost from leasable area expected to sit empty during the year, subtracted from gross rent.
EGI (Effective Gross Income) — gross rent minus vacancy losses, the realistic income before paying operating costs.
OpEx (Operating Expenses) — recurring costs to operate the property (property tax, insurance, utilities, maintenance, management); excludes financing and capital improvements.
NOI (Net Operating Income) — income a property generates after operating costs but before financing and taxes.
Gross rent
$50.7K $17.40/SF
− Vacancy
−$3.3K −$1.13/SF
EGI
$47.4K $16.27/SF
− OpEx
−$14.2K −$4.88/SF
NOI
$33.2K $11.39/SF
Area
Schenectady County, NY
Vacancy
6.50%
Lease Rate
$17.40 /SF/Yr
Expense Ratio
30.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap rates vary significantly by property type, market, and asset quality.
Typical U.S. stable-market ranges:
Multifamily — 4.5% to 6.5% (Class A in primary markets often sub-5%; Class C in secondary markets 6%+)
Industrial / Logistics — 5.0% to 7.0% (compressed heavily in recent years due to e-commerce demand)
Office — 6.5% to 9%+ (wide spread post-2020; CBD Class A vs. suburban Class B varies dramatically)
Retail — 5.5% to 8.5% (grocery-anchored on the low end, unanchored strip centers higher)
Hospitality / Hotels — 7.5% to 10%+ (higher due to operational risk)
Self-Storage — 5.5% to 7.5%
Medical Office — 6.0% to 7.5%
Net Lease (single tenant, credit) — 5.0% to 7.0% depending on tenant credit and lease term
Rules of thumb:
Primary markets (NYC, SF, LA, Boston, DC) trade at lower cap rates than secondary/tertiary markets, often by 100–200 bps (bps, aka basis points; 1 bp = 0.01%).
Class A assets trade ~50–150 bps tighter than Class B, and Class B tighter than Class C.
Cap rates move inversely with price — a lower cap rate means a higher price for the same NOI.
Spread to the 10-year Treasury is a common benchmark; historically 200–400 bps over the 10-year.
Cap Rate 5%
$663,260
Cap Rate 7%
$473,757
Cap Rate 9%
$368,478
Alternative Uses
Best Use
Multifamily LT 5
$473.8K
$414.5K – $552.7K
NOI $33,163 @ 7.0% cap · market cap 8.29%
Second Best
Apartment 5plus
$424.9K
$371.8K – $495.8K
NOI $29,746 @ 7.0% cap · market cap 7.44%
Theoretical Best
Office A
$871.6K
$762.7K – $1.02M
NOI $61,012 @ 7.0% cap · market cap 15.26%
Zoning and permitted uses should be independently verified with authorities.
Property Analytics
Property Profile
Current Use
Lease Details
2
Residential units
Location Intelligence
Trade Area within ½ mile
15
Businesses Nearby
Explore this area
Business Placement
Demographics for 12148, NY
4,935
Population
1,949
Households
2.5
Avg Household Size
47
Median Age
58%
College-Educated
95%
High-School Grad
15.6 sq mi
ZIP Area
316
Density / Sq Mi
$135,694
Median Household Income
$103,654
Median Earnings
$1,134
Median Rent
$406,100
Median Home Value
Market
Vacancy Rate% for Multifamily in Northeast region
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.
Frequently Asked Questions
What type of property is this?
Duplex - Two separate units offer in-unit laundry and separate parking, providing flexibility for owner-occupant or income uses.
Where is this duplex located?
The property is located at 140 Blue Barns Road Rexford, NY.
What is the asking price?
The asking price for this property is $399,900.
What are key features of this property?
This property features: Two‑unit property with separate parking areas for each unit; Lower unit layout: 3 bedrooms and 2 full bathrooms, including a primary suite with private full bath; Upper unit layout: 4 bedrooms and 1 bathroom with an open‑concept living space
