174 Beekman Dr, #174
Agawam, MA 01001
$349,900
Prepare to be impressed—this 6-room, 3-bedroom, 1.5-bath Agawam condo is pristine and turnkey perfection! Meticulously updated from top to bottom with premium finishes and thoughtful design, it may be the most pristine and beautiful condo in all of Agawam. The sun-splashed main level offers easy flow for living and dining, plus a chef-inspired kitchen with sleek cabinetry, stone counters, and stainless appliances. Upstairs, three generous bedrooms pair with a spa-like full bath. The gorgeous walk-out, fully finished basement expands your living space—ideal for a media room, gym, or office—with direct access to the outdoors. No expense spared. No detail overlooked. Modern lighting, custom trim, flawless flooring—updated to the fullest. Turn the key and love where you live. The location of this unit is right across the street from the beautiful complex pool for summertime fun!
| Listing ID: | 73453819 |
|---|---|
| List Price: | $349,900 |
| Property Type: | Residential |
| Property Sub Type: | Condominium |
| Status: | Active |
| Lender Owned: | No |
| Bedrooms Total: | 3 |
| Bathrooms Full: | 1 |
| Bathrooms Half: | 1 |
| Living Area: | 1,600 |
| Association Fee: | $299 |
| Tax Annual Amount: | $2,840 |
| Waterfront?: | No |
| City: | Agawam |
| County Or Parish: | Hampden |
| Postal Code: | 01001 |
| Year Built: | 1973 |
| Number Of Units Total: | 176 |
| Appliances: | Range, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer |
| Cooling: | Central Air |
| Flooring: | Tile |
| Heating: | Forced Air, Natural Gas |
| Parking Features: | Assigned, Guest |
| Status: | Active |
| State Or Province: | MA |
| Water Source: | Public |
| Association Fee Frequency: | Monthly |
| Roof: | Shingle |
| Laundry Features: | In Basement |
| Postal Code Plus4: | 2605 |
| Electric: | Circuit Breakers |
| Construction Materials: | Frame |
| Fireplace Features: | Living Room |
| Listing Contract Date: | 2025-11-12 |
| Cooling?: | Yes |
| Fireplace?: | Yes |
| Heating?: | Yes |
| Fireplaces Total: | 1 |
| Rooms Total: | 6 |
| Association Fee Includes: | Insurance, Maintenance Structure, Maintenance Grounds, Snow Removal |
| Bathrooms Total Integer: | 2 |
| Basement: | false |
| Basement: | Y |
| Building Area Source: | Public Records |
| Building Area Total: | 1,600 |
| Exterior Features: | Deck, Patio |
| Living Area Units: | Square Feet |
| Lot Size Units: | Acres |
| Parcel Number: | M:0L11 B:0006 L:174, 2485185 |
| Patio And Porch Features: | Deck, Patio |
| Sewer: | Public Sewer |
| Structure Type: | Townhouse |
| Utilities: | for Gas Range |
| Zoning: | RA3 |
| Stories Total: | 3 |
| Year Built Source: | Public Records |
| Entry Level: | 1 |
| Entry Location: | Unit Placement(Street) |
| Farm Land Area Units: | Square Feet |
| Mh:Cooling Zones, Cc:Cooling Zones, Mf:Cooling Zones, Sf:Cooling Zones: | 1 |
| Disclosure: | No |
| Dpr Flag: | Yes |
| Heat Zones: | 1 |
| Lead Paint: | Unknown |
| Listing Alert: | No |
| List Price Per Sqft: | $218.69 |
| Management: | Professional - Off Site |
| Page: | 145 |
| Price Per Sqft: | $218.69 |
| Square Feet Disclosures: | Finished walk out basement approx 400 sq ft |
| Square Feet Incl Base: | No |
| Unit Building: | 174 |
| Original List Price: | $349,900 |
| Parking Total: | 2 |
| Room Bathroom1 Features: | Bathroom - Half, Flooring - Stone/Ceramic Tile |
| Room Bathroom1 Level: | First |
| Room Bathroom2 Features: | Bathroom - Full |
| Room Bathroom2 Level: | Second |
| Room Bedroom2 Features: | Ceiling Fan(s), Flooring - Stone/Ceramic Tile |
| Room Bedroom2 Level: | Second |
| Room Bedroom3 Features: | Ceiling Fan(s), Flooring - Stone/Ceramic Tile |
| Room Bedroom3 Level: | Second |
| Room Family Room Features: | Flooring - Stone/Ceramic Tile, Slider |
| Room Family Room Level: | Basement |
| Room Kitchen Features: | Flooring - Stone/Ceramic Tile, Countertops - Upgraded, Cabinets - Upgraded, Exterior Access, Open Floorplan, Recessed Lighting, Remodeled, Stainless Steel Appliances, Washer Hookup |
| Room Kitchen Level: | First |
| Room Living Room Features: | Flooring - Stone/Ceramic Tile, Balcony / Deck, Exterior Access, Open Floorplan, Slider |
| Room Living Room Level: | First |
| Room Master Bedroom Features: | Bathroom - Full, Ceiling Fan(s), Flooring - Stone/Ceramic Tile |
| Room Master Bedroom Level: | Second |
| Tax Assessed Value: | $194,000 |
| Tax Year: | 2025 |
| Year Built Details: | Approximate |
| Above Grade Finished Area: | 1,600 |
| Living Area Source: | Public Record |
| Open Parking Spaces: | 2 |
Listing Courtesy of: Benton Real Estate Company
Listing Agent: Benjamin J Benton
413-348-4877
Mortgage Calculator
The data on this website relating to real estate for sale comes in part from the IDX Program of the MLSPIN.
All information is believed accurate but not guaranteed. The properties displayed may not be all of the properties available through the IDX Program. Any use of this site other than by potential buyers or sellers is strictly prohibited.
© 2026 MLSPIN.
MLSPIN data last updated on May 07, 2026 12:24 PM - ET.
Property Last Updated: November 17, 2025 09:38 PM - ET
