A rare two-unit opportunity in Burnt Hills School District! These units are huge making each unit spacious enough to feel like its own home. The lower unit features 3 bedrooms and 2 full bathrooms, including a large primary suite with a private full bath. The open-concept living area offers functional flow, and updated appliances plus in-unit laundry add everyday convenience. The upper unit includes 4 generously sized bedrooms and 1 bathroom. Its open-concept living space extends to a spacious second-floor deck, creating additional outdoor living space, and it also has separate in-unit laundry. This home offers spacious living on over 1 acre of land. Ideal for multi-generational living, owner-occupancy with income potential, or investment use, this property offers a flexible layout providing many uses. The property includes separate parking areas for each unit for added convenience and privacy. Spacious, versatile, and hard to find, this property is an absolute MUST SEE!
Active
$399,900
140 Blue Barns Road, Rexford, NY 12148
7beds
2,912sqft
Duplex, Multi Family
Built in 1870
-- sqft lot
$397,000 Zestimate®
$137/sqft
$-- HOA
What's special
Spacious second-floor deckUpdated appliancesIn-unit laundry
- 1 day |
- 145 |
- 13 |
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
KW Platform 518-724-5800,
Robert L Taylor 518-331-8442
Source: Global MLS,MLS#: 202621067
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 7
- Bathrooms: 3
- Full bathrooms: 3
Heating
- Baseboard, Electric, Other
Cooling
- Wall Unit(s)
Appliances
- Laundry: Main Level
Features
- Ceiling Fan(s), High Speed Internet
- Doors: Sliding Doors
- Basement: Full
Interior area
- Total structure area: 2,912
- Total interior livable area: 2,912 sqft
- Finished area above ground: 2,912
- Finished area below ground: 0
Video & virtual tour
Property
Parking
- Total spaces: 15
- Parking features: Off Street, Paved, Driveway
- Has uncovered spaces: Yes
Features
- Patio & porch: Side Porch
- Exterior features: None
- Fencing: Other
Lot
- Size: 1.06 Acres
- Features: Private, Level, Landscaped, Cleared
Details
- Parcel number: 412400 263.19.2
- Special conditions: Standard
Construction
Type & style
- Home type: MultiFamily
- Architectural style: Traditional
- Property subtype: Duplex, Multi Family
- Attached to another structure: Yes
Materials
- Vinyl Siding
- Foundation: Block
- Roof: Shingle,Asphalt
Condition
- Year built: 1870
Utilities & green energy
- Sewer: Septic Tank
Community & HOA
HOA
- Has HOA: No
Location
- Region: Rexford
Financial & listing details
- Price per square foot: $137/sqft
- Tax assessed value: $361,667
- Annual tax amount: $6,982
- Date on market: 8/18/2026
- Tenant pays: Heat, Cable TV, Electricity
Estimated market value
$397,000
$377,000 - $417,000
$1,898/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/18/2026 | Listed for sale | $399,900$137/sqft |
Source:  Global MLS #202621067 Report a problem | ||
| 7/20/2026 | Pending sale | $399,900$137/sqft |
Source: Global MLS #202621067 Report a problem | ||
| 7/6/2026 | Listed for sale | $399,900+42.8%$137/sqft |
Source: Global MLS #202621067 Report a problem | ||
| 11/10/2022 | Sold | $280,000+7.7%$96/sqft |
Source: Global MLS #202221988 Report a problem | ||
| 7/13/2022 | Pending sale | $260,000$89/sqft |
Source: Global MLS #202221988 Report a problem | ||
| 7/7/2022 | Listed for sale | $260,000+40.5%$89/sqft |
Source: Global MLS #202221988 Report a problem | ||
| 7/1/2017 | Listing removed | $185,000$64/sqft |
Source: RealtyUSA #201613783 Report a problem | ||
| 7/6/2016 | Listed for sale | $185,000+8.8%$64/sqft |
Source: RealtyUSA #201613783 Report a problem | ||
| 5/6/2015 | Listing removed | $170,000$58/sqft |
Source: Coldwell Banker Prime Properties #201422082 Report a problem | ||
| 10/21/2014 | Price change | $170,000-10.5%$58/sqft |
Source: Coldwell Banker Prime Properties #201422082 Report a problem | ||
| 9/29/2013 | Price change | $190,000-4.5%$65/sqft |
Source: Sterling Homes Real Estate #201329776 Report a problem | ||
| 8/7/2013 | Listed for sale | $199,000$68/sqft |
Source: Listhub #201326052 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $130,200 |
| 2024 | -- | $130,200 |
| 2023 | -- | $130,200 |
| 2022 | -- | $130,200 |
| 2021 | -- | $130,200 |
| 2020 | -- | $130,200 |
| 2019 | -- | $130,200 |
| 2018 | -- | $130,200 |
| 2017 | $5,761 +462.2% | $130,200 |
| 2016 | $1,025 -0.1% | $130,200 |
| 2015 | $1,026 +2.8% | $130,200 |
| 2014 | $998 | $130,200 |
| 2013 | -- | $130,200 |
| 2012 | -- | $130,200 |
| 2011 | -- | $130,200 |
| 2010 | -- | $130,200 |
| 2009 | -- | $130,200 |
| 2008 | -- | $130,200 |
| 2007 | -- | $130,200 |
| 2006 | -- | $130,200 |
| 2005 | -- | $130,200 |
| 2004 | -- | $130,200 |
| 2003 | -- | $130,200 |
| 2002 | -- | $130,200 |
| 2001 | -- | $130,200 |
| 2000 | -- | $130,200 |
Find assessor info on the county website
Monthly payment
Climate risks
Neighborhood: 12148
Nearby schools
GreatSchools rating
- 7/10Francis L Stevens Elementary SchoolGrades: K-5Distance: 1.5 mi
- 8/10Richard H O Rourke Middle SchoolGrades: 6-8Distance: 1.6 mi
- 9/10Burnt Hills Ballston Lake Senior High SchoolGrades: 9-12Distance: 1.6 mi
Schools provided by the listing agent
- High: Burnt Hills-Ballston Lake HS
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $--3 bd2 ba-- sqft140 Blue Barns Rd #1, Rexford, NY 12148Off Market
- $208,333-- bd-- ba-- sqftE Blue Barns Rd, Ballston Lake, NY 12019Off Market
- $238,6002 bd1 ba1.1k sqft2 Rustic Bridge Rd, Rexford, NY 12148Off Market
- $503,1004 bd2 ba-- sqft1 Rustic Bridge Rd, Rexford, NY 12148Off Market
- $408,3003 bd2 ba1.5k sqft144 Blue Barns Rd, Rexford, NY 12148Sold
- $304,5003 bd1 ba1k sqft4 Rustic Bridge Rd, Rexford, NY 12148Off Market
- $267,0003 bd1 ba1.2k sqft6 Rustic Bridge Rd, Rexford, NY 12148Off Market
- $312,1003 bd1 ba1.7k sqft8 Rustic Bridge Rd, Rexford, NY 12148Off Market
A local agent can set up tours, give advice and negotiate with sellers.
Similar homes
- $469,0004 bd2 ba2k sqft969 Grooms Road, Rexford, NY 12148Active
MLS ID #202623579, Genevieve Suguitan, Listing by: Signature One Realty Group LLC. Global MLS - $385,0004 bd3 ba2k sqft5 Pine Hill Bend, Ballston Lake, NY 12019Active
MLS ID #202623898, Rebekah O'Neil, Listing by: Howard Hanna Capital Inc. Global MLS - $399,9004 bd3 ba3.5k sqft151 Wood Dale Drive, Clifton Park, NY 12019Active
MLS ID #202623824, Kevin Clancy, Listing by: Clancy Real Estate. Global MLS - $435,0007 bd3 ba3.6k sqft1109 Glenwood Boulevard, Schenectady, NY 12308Active
MLS ID #202623312, Moonrani G Gumani, Listing by: Miranda Real Estate Group Inc. Global MLS - $449,9994 bd3 ba2.4k sqft1270 Palmer Avenue, Niskayuna, NY 12309ActiveMLS ID #202623912, Joseph Amiccuci, Listing by: J Paul Realty Group LLC. Global MLS
- $425,0004 bd2 ba2.3k sqft457 N Creek Road, Greenfield, NY 12833ActiveMLS ID #202624007, Heather Casaw, Listing by: Coldwell Banker Prime Properties. Global MLS
- $385,0004 bd4 ba2k sqft4550-4552 Duanesburg Road, Duanesburg, NY 12056ActiveMLS ID #202623256, Jennifer C Whipple, Listing by: Miranda Real Estate Group Inc. Global MLS
- $435,0004 bd2 ba1.9k sqft17 Berwyn Street, Schenectady, NY 12304ActiveMLS ID #202623658, James W Rosenberger, Listing by: Falvey Real Estate Group Ltd. Global MLS
- $395,0004 bd2 ba2.5k sqft53 Tallmadge Place, Mechanicville, NY 12118ActiveMLS ID #202623539, Brandi Weis, Listing by: Capital Realty Experts. Global MLS
- $394,9005 bd3 ba2.4k sqft1117 Balltown Road, Niskayuna, NY 12309ActiveMLS ID #202620725, Heather A Perry, Listing by: Red Door Realty NY Inc. Global MLS
- $449,9994 bd2 ba2.2k sqft7283 Skyline Drive, Delanson, NY 12053ActiveMLS ID #202617617, Derek Greene, Listing by: The Greene Realty Group. Global MLS
- $459,0004 bd3 ba2.2k sqft1009 Cheyenne Road, Glenville, NY 12302ActiveMLS ID #202623893, Claudine D Hodge, Listing by: Berkshire Hathaway Home Services Blake. Global MLS
- $429,9004 bd2 ba2.2k sqft301 Old Ballston Avenue, Ballston Spa, NY 12020ActiveMLS ID #202623854, Melissa C Cartier, Listing by: Cartier Real Estate Group LLC. Global MLS
- $389,9004 bd2 ba1.8k sqft211 W Duane Lake Road, Duanesburg, NY 12056ActiveMLS ID #202623896, Christine Frith, Listing by: Coldwell Banker Prime Properties. Global MLS
- $339,0006 bd2 ba2.7k sqft1030 Delamont Avenue, Schenectady, NY 12307ActiveMLS ID #202623648, Victoria McLaughlin, Listing by: Howard Hanna Capital Inc. Global MLS
- $419,9004 bd2 ba2k sqft29 Northern Court, Troy, NY 12180ActiveMLS ID #202622979, Kristina Gross, Listing by: Gucciardo Real Estate Group LLC. Global MLS
- $449,9004 bd3 ba2.2k sqft14 Rolling Brook Drive, Clifton Park, NY 12065ActiveMLS ID #202622772, Brandi Weis, Listing by: Capital Realty Experts. Global MLS
- $449,9004 bd3 ba1.8k sqft20 Van Brummel Lane, Ballston Spa, NY 12020ActiveMLS ID #202623917, Robert Saumell Jr., Listing by: KW Platform. Global MLS
- $599,0006 bd4 ba2.4k sqft1 Dowling Road, Albany, NY 12205ActiveMLS ID #202623879, Caitlin C Montalvo, Listing by: Howard Hanna Capital Inc. Global MLS
- $449,9994 bd2 ba2.1k sqft5 Anita Drive, Glenville, NY 12302ActiveMLS ID #202622491, Raymond Boyce, Listing by: Scott Ronda Realty LLC. Global MLS
