Skip main navigation
Pending
  • $799,900

    195 College Farm Rd, Waltham, MA 02451

    3beds
    1,920sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1980
    3,598 Square Feet Lot
    $813,600 Zestimate®
    $417/sqft
    $-- HOA

    What's special

    Elegant tile finishesBright open-concept layoutDining areaFinished walk-out lower levelGranite countertopsPeaceful tree-lined viewsConvenient half bath
    Welcome to this beautifully renovated, naturally lit, modern 3-bedroom,2-bath Colonial offering 3 levels of stylish, functional living. The main level features a bright open-concept layout with a hardwood-floor living room, a dining area, and a designer island kitchen complete with custom cabinetry, granite countertops, and elegant tile finishes. A convenient half bath and seamless access to a spacious deck create the perfect setup for effortless indoor-outdoor living and entertaining. Upstairs, you’ll find three well-proportioned bedrooms and a designer full bath, all framed by peaceful tree-lined views. The finished walk-out lower level offers versatile bonus space ideal for a media room, home office, gym, or guest suite. Enjoy a fully fenced backyard designed for comfort and ease, along with two off-street parking spaces. A newer roof adds peace of mind. Close to all shopping, restaurants, and a major highway. A modern take on classic Colonial living that you don't want to miss!!!
    23 days
    |
    1,731
    |
    134
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Zahra Zoglauer 617-320-5815,

    Coldwell Banker Realty - Boston 617-266-4430

    Source: MLS PIN,MLS#: 73522053

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 1
      • 1/2 bathrooms: 1
      Primary bedroom
      • Features: Closet, Flooring - Hardwood, Window(s) - Bay/Bow/Box, Remodeled
      • Level: Second
      Bedroom 2
      • Features: Closet, Flooring - Hardwood, Recessed Lighting, Remodeled
      • Level: Second
      Bedroom 3
      • Features: Closet, Flooring - Hardwood, Recessed Lighting
      • Level: Second
      Primary bathroom
      • Features: No
      Bathroom 1
      • Features: Bathroom - Half, Closet, Flooring - Stone/Ceramic Tile, Remodeled
      • Level: First
      Bathroom 2
      • Features: Bathroom - Tiled With Shower Stall, Flooring - Stone/Ceramic Tile, Remodeled
      • Level: Second
      Dining room
      • Features: Bathroom - Half, Flooring - Stone/Ceramic Tile, Balcony / Deck, Breakfast Bar / Nook, Open Floorplan, Recessed Lighting, Remodeled
      • Level: First
      Family room
      • Features: Flooring - Laminate, Window(s) - Picture, Exterior Access, Remodeled
      • Level: Basement
      Kitchen
      • Features: Flooring - Stone/Ceramic Tile, Window(s) - Bay/Bow/Box, Dining Area, Balcony / Deck, Breakfast Bar / Nook, Recessed Lighting, Remodeled
      • Level: First
      Living room
      • Features: Flooring - Hardwood, Window(s) - Bay/Bow/Box, Open Floorplan, Recessed Lighting, Remodeled
      • Level: First
      Heating
      • Central, Natural Gas, Electric
      Cooling
      • Ductless
      Appliances
      • Included: Gas Water Heater, Disposal, Microwave, ENERGY STAR Qualified Refrigerator, ENERGY STAR Qualified Dryer, ENERGY STAR Qualified Dishwasher, ENERGY STAR Qualified Washer, Range Hood, Cooktop, Range
      • Laundry: In Basement
      Features
      • Flooring: Tile, Hardwood
      • Windows: Insulated Windows
      • Basement: Full,Finished,Walk-Out Access,Interior Entry
      • Has fireplace: No
      Interior area
      • Total structure area: 1,920
      • Total interior livable area: 1,920 sqft
      • Finished area above ground: 1,296
      • Finished area below ground: 624

      Property

      Parking
      • Total spaces: 2
      • Parking features: Off Street, Paved
      • Uncovered spaces: 2
      Features
      • Patio & porch: Porch, Deck
      • Exterior features: Porch, Deck, Fenced Yard, Garden
      • Fencing: Fenced
      • Has view: Yes
      • View description: Scenic View(s), Water, Lake
      • Has water view: Yes
      • Water view: Lake,Water
      Lot
      • Size: 3,598 Square Feet
      Details
      • Parcel number: 828966
      • Zoning: 1

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial,Garrison
      • Property subtype: Single Family Residence
      Materials
      • Stone
      • Foundation: Concrete Perimeter
      • Roof: Shingle
      Condition
      • Year built: 1980

      Utilities & green energy

      • Electric: 220 Volts
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: for Gas Range, for Gas Oven

      Community & HOA

      Community
      • Features: Public Transportation, Shopping, Park, Walk/Jog Trails, Medical Facility, Bike Path, Highway Access, House of Worship
      HOA
      • Has HOA: No
      Location
      • Region: Waltham

      Financial & listing details

      • Price per square foot: $417/sqft
      • Tax assessed value: $604,100
      • Annual tax amount: $5,932
      • Date on market: 5/20/2026
      Get pre-qualifiedBe ready to make an offer.
      Connect with an agentGet info on this home, tour, and more.
      Calculate monthly paymentSee if you can afford this home.

        Estimated market value

        $813,600

        $773,000 - $854,000

        $3,560/mo

        Price history

        DateEventPrice
        6/10/2026Pending sale$799,900$417/sqft
        Source: MLS PIN #73522053 Report a problem
        5/29/2026Contingent$799,900$417/sqft
        Source: MLS PIN #73522053 Report a problem
        5/20/2026Listed for sale$799,900+39.4%$417/sqft
        Source: MLS PIN #73522053 Report a problem
        2/15/2023Sold$574,000-1%$299/sqft
        Source: MLS PIN #73052464 Report a problem
        11/7/2022Price change$579,900-3.3%$302/sqft
        Source: MLS PIN #73052464 Report a problem
        10/27/2022Listed for sale$599,900+72.4%$312/sqft
        Source: MLS PIN #73052464 Report a problem
        3/24/2021Listing removed--
        Source: Owner Report a problem
        8/27/2019Listing removed$2,700$1/sqft
        Source: Owner Report a problem
        5/8/2019Listed for rent$2,700+3.8%$1/sqft
        Source: Owner Report a problem
        6/16/2017Listing removed$2,600$1/sqft
        Source: Owner Report a problem
        6/3/2017Price change$2,600-1.9%$1/sqft
        Source: Owner Report a problem
        5/17/2017Price change$2,650-1.9%$1/sqft
        Source: Owner Report a problem
        4/22/2017Price change$2,700-3.6%$1/sqft
        Source: Owner Report a problem
        3/2/2017Listed for rent$2,800+12%$1/sqft
        Source: Owner Report a problem
        2/20/2013Listing removed$2,500$1/sqft
        Source: Owner Report a problem
        1/6/2013Listed for rent$2,500$1/sqft
        Source: Owner Report a problem
        7/31/2003Sold$348,000+22.1%$181/sqft
        Source: Public Record Report a problem
        5/18/2001Sold$285,000+116.3%$148/sqft
        Source: Public Record Report a problem
        2/11/1992Sold$131,750$69/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$5,932 +5.1%$604,100 +3.2%
        2024$5,645 +1.1%$585,600 +8.2%
        2023$5,585 -0.2%$541,200 +7.8%
        2022$5,595 +1.3%$502,200 +2.9%
        2021$5,524 -0.7%$488,000 +4.8%
        2020$5,564 +6.3%$465,600 +12.6%
        2019$5,234 +10%$413,400 +9.5%
        2018$4,759 +5.9%$377,400 +5.4%
        2017$4,495 +6.4%$357,900 +3.7%
        2016$4,225 -1.1%$345,200 +6.2%
        2015$4,270 +0.9%$325,200 +3.2%
        2014$4,232 -1.7%$315,100 -1.3%
        2013$4,305 +0.2%$319,100 -0.8%
        2012$4,296 +2%$321,800
        2011$4,212 -1.8%$321,800 -5.9%
        2010$4,289 +12.4%$342,000 +1.3%
        2009$3,815 +4.3%$337,600 -2.6%
        2008$3,658 +3.2%$346,700 -2.4%
        2007$3,543 +3.4%$355,400 +7.1%
        2006$3,426 +10.1%$331,700 +5.4%
        2005$3,112 +7.4%$314,700
        2004$2,898 +10.4%$314,700 +16%
        2003$2,624 +2.4%$271,400 +10.9%
        2002$2,563 +18.5%$244,800 +32.6%
        2000$2,162 +1.3%$184,600 +10.2%
        1999$2,134 $167,500

        Find assessor info on the county website

        Monthly payment

        Est. payment

          Payment breakdown

          Explore the cost of this home by adjusting the details. Changes won't be saved.
          All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
          HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
          Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
          See how much you could borrow to make a competitive offer.

          Climate risks

          Neighborhood: 02451

          Getting around

          39 / 100
          Car-Dependent
          23 / 100
          Minimal Transit
          20 / 100
          Somewhat Bikeable

          Nearby schools

          GreatSchools rating

          A local agent can set up tours, give advice and negotiate with sellers.

          Browse local experts

          Similar homes

          Skip to the end of the carouselSkip to the beginning of the carousel