29 Highland Ave

$915,000
Last Sold Price
9
Beds
5,512 Sq. Ft.
$166 / Sq. Ft.
5,512
Sq. Ft.
$166
per Sq. Ft.

Description

Welcome to the Brandt House. Located in the historically prestigious neighborhood of Highland Park, this elegant property is currently being used as a B&B. With 9 grand bedrooms, 10 bathrooms, and a dramatic multi-level 2-bedroom apartment, this gracious home lends itself to multi-generational living. Set high above the road, with views of the valley, the opulence of this property is clear before you even step inside. From the wrap-around porch, sizable covered deck, and stone patio that all lead...Welcome to the Brandt House. Located in the historically prestigious neighborhood of Highland Park, this elegant property is currently being used as a B&B. With 9 grand bedrooms, 10 bathrooms, and a dramatic multi-level 2-bedroom apartment, this gracious home lends itself to multi-generational living. Set high above the road, with views of the valley, the opulence of this property is clear before you even step inside. From the wrap-around porch, sizable covered deck, and stone patio that all lead to the professionally landscaped grounds, there is no shortage of sophisticated outdoor entertaining/living space, surrounded by conservation land and miles of hiking trails. Inside are bright spacious rooms, including a living room with coffered ceilings and extraordinary library, both with fireplaces and pocket doors, a dining room surrounded by windows, and a stunning sunroom. Located less than a mile from the center of town and near many private schools!
  1. Listed by Carrie Duda • Coldwell Banker Community REALTORS®

Property Details for 29 Highland Avenue

Town
Greenfield
Area
MA-Greenfield
Architectural Style
Colonial, Gambrel /Dutch
Style
Colonial, Gambrel /Dutch
Garage Spaces
0
Parking Spaces
8.00
Parking Spaces Total
8
LISTING UPDATED: 08/15/2022 04:17 PM

Property Details for 29 Highland Avenue

StatusSold
MLS #72951937
Days on Market124
Taxes$16,101 / year
HOA Fees-
Compass TypeSingle Family
MLS TypeSingle Family / Detached
Year Built1890
CountyFranklin County

Location

Listing Courtesy of Coldwell Banker Community REALTORS®, Carrie Duda

Sold By Maple and Main Realty, LLC, Mark Carmien

Add your commute

Building Information for 29 Highland Avenue

Stories-Year Built1890Building Size-Lot Size2.83 AC / 123,274 SF

Payment Calculator

$6,136 per month

30 year fixed, 6.845% Interest

Principal and Interest

$4,794

Property Taxes

$1,342

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 29 Highland Avenue

General Details
Property Details
  • Building Area Units: Square Feet
  • Community Features: Public Transportation, Shopping, Tennis Court, Park, Walk/Jog Trails, Stables, Golf Course, Medical Facility, Laundromat, Bike Path, Conservation Area, Highway Access, House of Worship, Private School, Public School, Sidewalks
  • Current Financing: Conv. Fixed
  • Living Area: 5512.0
  • Color: Beige
  • SqFt with Basement: No
  • Property Attached: No
  • Single Family Type: Detached
  • Waterfront: No
  • Water View: No
  • Year Built Details: Actual,Renovated Since
  • Year Built Source: Public Records
Location/School
  • Grade School: Federal St Elem
  • High School: Ghs
  • Middle School: Gms
  • Neighborhood: Highland Park
Features
Interior Features
  • Appliances: Range, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer, Gas Water Heater, Utility Connections for Gas Range, Utility Connections for Gas Dryer
  • Basement Features: Full, Partially Finished, Interior Access, Concrete Floor
  • Num of Baths: 10.0
  • Num of Full Baths: 8
  • Num of Half Baths: 2
  • Bathrooms Total Decimal: 9.00
  • Bathrooms Total Integer: 10
  • DoorFeatures: French Doors
  • FireplaceFeatures: Living Room, Master Bedroom, Bedroom
  • FireplaceYN: Yes
  • Fireplaces: 4
  • Flooring: Tile, Hardwood, Flooring - Stone/Ceramic Tile, Flooring - Hardwood
  • Interior Features: Bathroom - Full, Closet, Ceiling Fan(s), Crown Molding, Wainscoting, Bathroom - With Tub & Shower, Ceiling - Cathedral, Dining Area, Balcony - Interior, Recessed Lighting, Pedestal Sink, Closet - Double, Bedroom, Library, Sun Room, Accessory Apt., Wetbar, Internet Available - Broadband
  • Interior Features: Wetbar, Internet Available - Broadband, French Doors, Whole House Fan
  • Laundry Features: Bathroom - Half, Closet - Linen, Gas Dryer Hookup, Washer Hookup, First Floor
  • Primary Bath: Yes
  • Spa Features: Jacuzzi / Whirlpool Soaking Tub
  • SpaYN: Yes
  • Window Features: Skylight(s), Window(s) - Picture, Skylight, Window(s) - Stained Glass, Screens
Exterior Features
  • Construction: Frame
  • Exterior Features: Balcony, Professional Landscaping, Sprinkler System, Decorative Lighting
  • Exterior Features: Screens, Balcony, Professional Landscaping, Sprinkler System, Decorative Lighting, Deck, Patio, Covered Patio/Deck
  • Lot Description: Cleared, Level, Sloped
  • Patio And Porch Features: Deck - Exterior, Deck, Patio, Covered
  • Roof Material: Shingle
Parking Features
  • Covered Spaces: .00
  • Garage: No
  • Garage Parking: Paved Drive, Off-Street, Improved Driveway, Paved Driveway
  • Open Parking: Yes
  • Parking Features: Paved Drive, Off-Street, Improved Driveway, Paved Driveway
  • Parking Features: Off-Street, Improved Driveway, Paved Driveway
Utilities
  • Cooling: Central Air, Ductless Mini-Split System, Whole House Fan
  • Cooling: Yes
  • Electric: Circuit Breakers, 200+ Amp Service
  • Heating: Hot Water, Natural Gas, Fireplace
  • Heating: Yes
  • Sewer: City/Town Sewer
  • Utility Connections: for Gas Range, for Gas Dryer, Washer Hookup
  • Water: Public
Room Information
Primary Bedroom
  • Room Primary Bedroom Features: Bathroom - Full,Closet,Flooring - Hardwood,Crown Molding
  • Primary Bedroom Level: Second Floor
Bedroom 2
  • Bedroom2 Features: Bathroom - Full,Flooring - Hardwood,Closet - Double
  • Bedroom2 Level: Second
Bedroom 3
  • Bedroom3 Features: Bathroom - Full,Closet,Flooring - Hardwood,Crown Molding
  • Bedroom3 Level: Second
Bedroom 4
  • Bedroom4 Features: Bathroom - Full,Closet,Flooring - Hardwood,Crown Molding
  • Bedroom4 Level: Second
Bedroom 5
  • Bedroom5 Features: Bathroom - Full,Skylight,Ceiling Fan(s),Closet,Flooring - Hardwood,Crown Molding
  • Bedroom5 Level: Third
Bathroom 1
  • Bathroom1 Features: Bathroom - Half,Flooring - Stone/Ceramic Tile
  • Bathroom1 Level: First
Bathroom 2
  • Bathroom2 Features: Bathroom - Full,Bathroom - With Tub & Shower,Flooring - Hardwood
  • Bathroom2 Level: Third
Dining Room
  • Dining Room Features: Flooring - Hardwood,Window(s) - Picture,French Doors,Exterior Access,Wainscoting,Crown Molding
  • Dining Room Level: First
Kitchen
  • Kitchen Features: Ceiling Fan(s),Flooring - Hardwood,Window(s) - Bay/Bow/Box,Pantry,Kitchen Island,Wet Bar,Deck - Exterior,Recessed Lighting,Stainless Steel Appliances,Storage,Gas Stove
  • Kitchen Level: First
Living Room
  • Room Living Room Features: Coffered Ceiling(s),Flooring - Hardwood,Deck - Exterior,Recessed Lighting,Wainscoting,Crown Molding
  • Room Living Room Level: First
Property Information
Property Info
  • Farm Land Area Units: Square Feet
  • WARRANTY: No
  • Lot Size Units: Acres
  • Road Frontage Type: Public
  • Road Responsibility: Public Maintained Road
  • Road Surface Type: Paved
Tax Information
  • Tax ID: M:0053 B:0008 L:0,3095187
  • Assessments: $693,400
  • Book: 6817
  • Tax Year: 2021
  • Zoning: Comm & Res
Building / Association Information
Living Characteristics
  • Beds Total: 9
Other Building Characteristics
  • Foundation: Stone
  • Cooling Zones: 3
  • Heat Zones: 4
Market and Agent Information
Sale Info
  • Buyer Broker Comp: 2
  • Other Agent Compensation: 1

Property History for 29 Highland Avenue

DateEvent & SourcePriceAppreciation
Jul 15, 2025

Sold

MLS PIN #73366407

$940,000
Jul 15, 2025

Sold

Berkshire County Board of REALTORS #246170

$940,000
Jun 10, 2025

Under Agreement

MLS PIN #73366407

May 27, 2025

Contingent

Berkshire County Board of REALTORS #246170

May 25, 2025

Contingent

MLS PIN #73366407

May 24, 2025

Under Agreement

Berkshire County Board of REALTORS #246170

Apr 29, 2025

Listed (Active)

MLS PIN #73366407

$940,000
Apr 29, 2025

Listed (Active)

Berkshire County Board of REALTORS #246170

$940,000
Aug 12, 2022

Sold (Public Record)

Public Record #1495715578

$915,000

+1.8% / yr

Aug 12, 2022

Sold

MLS PIN #72951937

$915,000
Jul 13, 2022

Under Agreement

MLS PIN #72951937

Jul 13, 2022

Contingent

MLS PIN #72951937

Mar 11, 2022

Listed (Active)

MLS PIN #72951937

$945,000
Nov 30, 2021

Expired

Berkshire County Board of REALTORS #235035

Nov 30, 2021

Expired

MLS PIN #72839853

$915,000
Aug 17, 2021

Price Change

Berkshire County Board of REALTORS #235035

$945,000
May 31, 2021

Listed (Active)

Berkshire County Board of REALTORS #235035

$995,000
May 31, 2021

Listed (Active)

MLS PIN #72839853

$995,000
Jul 1, 2004

Sold (Public Record)

Public Record #139059370

$660,000
DateEvent & SourcePrice
07/15/2025

Sold

MLS PIN #73366407

$940,000
07/15/2025

Sold

Berkshire County Board of REALTORS #246170

$940,000
06/10/2025

Under Agreement

MLS PIN #73366407

05/27/2025

Contingent

Berkshire County Board of REALTORS #246170

05/25/2025

Contingent

MLS PIN #73366407

05/24/2025

Under Agreement

Berkshire County Board of REALTORS #246170

04/29/2025

Listed (Active)

MLS PIN #73366407

$940,000
04/29/2025

Listed (Active)

Berkshire County Board of REALTORS #246170

$940,000
08/12/2022

Sold (Public Record)

Public Record #1495715578

$915,000

+1.8% / yr

08/12/2022

Sold

MLS PIN #72951937

$915,000
07/13/2022

Under Agreement

MLS PIN #72951937

07/13/2022

Contingent

MLS PIN #72951937

03/11/2022

Listed (Active)

MLS PIN #72951937

$945,000
11/30/2021

Expired

Berkshire County Board of REALTORS #235035

11/30/2021

Expired

MLS PIN #72839853

$915,000
08/17/2021

Price Change

Berkshire County Board of REALTORS #235035

$945,000
05/31/2021

Listed (Active)

Berkshire County Board of REALTORS #235035

$995,000
05/31/2021

Listed (Active)

MLS PIN #72839853

$995,000
07/01/2004

Sold (Public Record)

Public Record #139059370

$660,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 29 Highland Avenue

Taxable ValueLand$86,300Additions$814,500Total$900,800
Tax Record2025$17,620 ($1,468 / month)
Home Facts
Baths9Total Finished SqFt5,512 SqFtAbove Grade Finished SqFt5,512 SqFtUnfinished Basement SqFt1,728 SqFtStories3Lot Size90,814 SqFtStyleOffice BuildingYear Built1890ZoningRACountyFRANKLINAPNGRFL M:0053 B:0008 L:0Fireplace TypeHas Fireplace

Schools near 29 Highland Avenue

This home is within Greenfield School District.
Rating
School
Type
Grades
Distance
Public - K to 4
Public - 5 to 7
Public - 8 to 12
Public - K to 4
Rating
School
Distance
Federal Street Elementary
PublicK to 4

Greenfield Middle School
Public5 to 7

Greenfield High School
Public8 to 12

Newton School
PublicK to 4

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Community REALTORS®, Carrie Duda

The property listing data and information, or the images, set forth herein were provided to MLS Property Information Network, Inc., Martha's Vineyard MLS, CCIMLS, Link MLS, and Berkshire County Board of REALTORS from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc., Martha's Vineyard MLS, CCIMLS, Link MLS, and Berkshire County Board of REALTORS. The property listing data and information, and the images, are for the personal, non-commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing or leasing. MLS Property Information Network, Inc., Martha's Vineyard MLS, CCIMLS, Link MLS, and Berkshire County Board of REALTORS and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information, or as to the accuracy of any of the images, set forth herein.