NOT LISTED FOR SALE

1 Lancelot Rd Windham, NH 03087

Estimated Value: $1,171,000 - $1,414,000

4 Beds
3.5 Baths
3,816 Sq Ft
$345/Sq Ft Est. Value

Last Sold September 12, 2017

Last sale price $730,000 $191 Per Sq Ft

Est. 80% increase in value since last sale

Current estimated payment $8,810/month

12 Days on Market

Highlights

  • Colonial Architecture
  • Deck
  • Fireplace
  • Golden Brook Elementary School Rated A-
  • Wood Flooring
  • Walk-In Closet

About This Home

As of September 2017

CAMELOT ESTATES! This meticulously designed home was created to offer a flowing floor plan ideal for grand entertaining, comfortable family living and intimate gatherings. You will be sure to appreciate the gourmet kitchen with stainless steel appliances, granite counters, gas cook top and much more! The rooms are impeccably planned to create livable spaces that temper the home's scale and afford views of a gorgeous back yard. As you follow through the first floor there is gleaming hardwood floors throughout. As you lead up the stairs you are welcomed by three generous sized bedrooms and large master suite with full spa bath. The living space does not stop here! As you head to the lower level you will find a fully finished oasis equipped with a state of the art pub, bedroom and 3/4 bath with a walk out that leads to more entertaining in the back yard where you will find an expansive deck with a large pavered patio and fire pit. Everything you could think of is offered in this prestigious home!

Last Listed By

Henry Matos

Coldwell Banker Realty Salem License #068595 Listed on: 07/20/2017

Coldwell Banker Realty Salem

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,091

Year Built

  • Built in 2001

Lot Details

  • 1.64 Acre Lot
  • Landscaped
  • Lot Sloped Up

Parking

  • 3 Car Garage

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Wood Frame Construction
  • Shingle Roof
  • Wood Siding

Interior Spaces

  • 3,816 Sq Ft Home
  • 2-Story Property
  • Fireplace
  • Interior Basement Entry

Kitchen

  • Gas Cooktop
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Outdoor Features

  • Deck
  • Patio

Utilities

  • Forced Air Heating System
  • Heating System Uses Gas
  • 200+ Amp Service
  • Private Water Source
  • Liquid Propane Gas Water Heater
  • Private Sewer

Listing and Financial Details

  • Legal Lot and Block 2559 / C

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,091

Year Built

Built in 2001

Lot Details

0

Parking

3

Listing Details

  • Status Detail: Closed
  • Style: Colonial
  • Construction: Existing
  • Total Stories: 2
  • Price Per Sq Ft: 191.3
  • Property Class: Residential
  • Property Type: Single Family
  • Year Built: 2001
  • Remarks Public: CAMELOT ESTATES! This meticulously designed home was created to offer a flowing floor plan ideal for grand entertaining, comfortable family living and intimate gatherings. You will be sure to appreciate the gourmet kitchen with stainless steel appliances, granite counters, gas cook top and much more! The rooms are impeccably planned to create livable spaces that temper the home's scale and afford views of a gorgeous back yard. As you follow through the first floor there is gleaming hardwood floors throughout. As you lead up the stairs you are welcomed by three generous sized bedrooms and large master suite with full spa bath. The living space does not stop here! As you head to the lower level you will find a fully finished oasis equipped with a state of the art pub, bedroom and 3/4 bath with a walk out that leads to more entertaining in the back yard where you will find an expansive deck with a large pavered patio and fire pit. Everything you could think of is offered in this prestigious home!
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances: Cooktop - Gas, Dishwasher, Microwave, Refrigerator
  • Features Interior: Fireplaces - 1, Walk-in Closet
  • Total Bedrooms: 4
  • Flooring: Carpet, Hardwood
  • Total Bathrooms: 4
  • Half Bathrooms: 1
  • Full Bathrooms: 3
  • Basement: Yes
  • Basement Access Type: Interior
  • Basement Description: Concrete
  • Level 1: Level 1: Dining Room, Level 1: Family Room, Level 1: Kitchen, Level 1: Kitchen - Eat-in, Level 1: Living Room, Level 1: Office/Study
  • Level 2: Level 2: Bedroom, Level 2: Master Bedroom
  • Basement Level Rooms: Level B: Office/Study, Level B: Other, Level B: Utility Room
  • Room 1: Kitchen, 19x10, On Level: 1
  • Room 2: Kitchen - Eat-in, 10x11, On Level: 1
  • Room 3: Living Room, 14x17, On Level: 1
  • Room 4: Dining Room, 14x15, On Level: 1
  • Room 5: 1, 22x33
  • Room 6: Office/Study, 12x10, On Level: 1
  • Room 7: Master Bedroom, 17x14, On Level: 2
  • Room 8: Bedroom, 13x14, On Level: 2
  • Room 9: Bedroom, 14x14, On Level: 2
  • Room 10: 2, 13x11
  • Room 11: Other, 18x25, On Level: Basement
  • Room 12: Office/Study, 17x13, On Level: Basement
  • Room 13: Utility Room, 17x13, On Level: Basement
  • Sq Ft - Apx Finished AG: 3816
  • Sq Ft - Apx Total: 3816
  • Sq Ft - Apx Total Finished: 3816

Exterior Features

  • Construction: Wood Frame
  • Driveway: Paved
  • Exterior: Wood
  • Foundation: Concrete
  • Road Frontage: TBD
  • Roads: Paved, Public
  • Roof: Shingle - Asphalt
  • Features Exterior: Deck, Patio

Garage/Parking

  • Garage Capacity: 3
  • Garage Type: Under
  • Garage: Yes

Utilities

  • Electric: 200 Amp, Circuit Breaker(s)
  • Sewer: Private
  • Water: Community, Private
  • Water Heater: Gas - LP/Bottle
  • Heating Fuel: Gas - LP/Bottle
  • Heating: Forced Air
  • Cooling: Central AC

Schools

  • School District: Windham
  • Elementary School: Golden Brook Elementary School
  • Middle School: Windham Middle School
  • High School: Windham High School

Lot Info

  • Map: 11
  • Lot: 2559
  • Lot Sq Ft: 71438
  • Lot Acres: 1.64
  • Lot Description: Landscaped
  • Surveyed: Unknown
  • Zoning: RES

Tax Info

  • Tax Gross Amount: 14091
  • Tax Year: 2016

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 20, 2017
Closed on
Sep 15, 2017
Sold by
Leare Peter D
Bought by
Ebeed Rabeh H
Seller's Agent
Henry Matos
Coldwell Banker Realty Salem
Buyer's Agent
Janos Kovacs
HomeSmart Success Realty LLC
List Price
$799,900
Sold Price
$730,000
Premium/Discount to List
-$69,900
-8.74%
Total Days on Market
12
Current Estimated Value
$1,314,669

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$584,669
Avg. Annual Appreciation
7.94%
Original Mortgage
$584,000
Outstanding Balance
$493,848
Interest Rate
3.93%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$820,821

Purchase Details

Closed on
Aug 2, 2001
Sold by
Unknown
Bought by
Leare Peter and Leare Karen

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$275,000
Interest Rate
7.14%

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Similar Homes in Windham, NH

  • 27 Mockingbird Hill Rd, Windham, NH 03087

    $1,150,000

    • 4 Beds
    • 3.5 Baths
    • 3,608 Sq Ft
    • 27 Mockingbird Hill Rd
    • Windham, NH

    **** Open House Canceled***Welcome to this spacious and well maintained 4-bedroom, 3.5-bathroom home located in one of Windham’s most sought-after neighborhoods, Castle Reach! Set on a private lot, this property offers the perfect blend of comfort, style, and functionality. The upgraded kitchen features modern finishes and flows seamlessly into the expansive great room, where a cozy wood stove

    Kerry Nicolls Foundation Brokerage Group

    Section Image
  • 7 Golfview Rd, Windham, NH 03087

    $1,499,000

    • 4 Beds
    • 4 Baths
    • 4,090 Sq Ft
    • 7 Golfview Rd
    • Windham, NH

    CANCELLED OPEN HOUSES ---Nestled at the end of a quiet cul-de-sac in the highly desirable Windham Country Club neighborhood, this home is a true showstopper. From the moment you arrive, the stunning curb appeal sets the tone for what’s inside. Thoughtfully designed for year-round resort-style living, this home is an entertainer’s dream, featuring a gorgeous built-in pool, pool house with a

    Elizabeth Smith Keller Williams Realty Evolution

    Section Image
  • 11 Midtrail Crossing Ln, Windham, NH 03087

    $1,100,000

    • 3 Beds
    • 3 Baths
    • 3,216 Sq Ft
    • 11 Midtrail Crossing Ln
    • Windham, NH

    Open House Cancelled. Welcome to your dream home in one of the area’s most sought-after 55+ luxury communities, where upscale living meets unmatched comfort and convenience. This impeccably upgraded residence offers over $100k in upgrades, customizations, high-end finishes, and thoughtful enhancements, creating a space that is both elegant & functional. The heart of the home is the upscale

    Jessica Letourneau BHHS Verani Nashua

    Section Image
  • 51 Bear Hill Rd, Windham, NH 03087

    $1,539,000

    • 4 Beds
    • 4 Baths
    • 4,519 Sq Ft
    • 51 Bear Hill Rd
    • Windham, NH

    Set in a sought-after neighborhood this beautifully designed custom home offers luxury, versatility, and breathtaking sunrises. The impressive foyer opens to a thoughtfully crafted interior featuring a gourmet kitchen adorned with high-end finishes, perfect for both everyday living and entertaining. Off the kitchen, a cozy hearth room invites relaxation or conversation by the fire. The main

    Gretchen Haga EXP Realty

    Section Image
  • 12 Settlers Ridge Rd, Windham, NH 03087

    $1,550,000

    • 4 Beds
    • 4 Baths
    • 3,612 Sq Ft
    • 12 Settlers Ridge Rd
    • Windham, NH

    Welcome to your dream home, featuring a private backyard oasis with an in-ground saltwater pool, a luxurious pool house with half bath, and a newly installed paver patio—perfect for entertaining or relaxing in style. This home boasts elegant hardwood floors throughout, and an elite-level kitchen equipped with top-of-the-line appliances and exquisite quartz countertops.Retreat to the primary

    Sarah McCoy LAER Realty Partners/Goffstown

    Section Image
  • 23 Osgood St, Windham, NH 03087

    $1,500,000

    • 4 Beds
    • 5 Baths
    • 5,344 Sq Ft
    • 23 Osgood St
    • Windham, NH

    Welcome to 23 Osgood—a stunning, custom-built home offering over 5,300 sq. ft. of thoughtfully designed living space on 1.3+ private acres. Tucked at the very end of a quiet cul-de-sac and abutting 250 acres of protected town land with trails, this is the perfect retreat for nature lovers and those seeking privacy. Inside, you'll find architect-designed soaring two-story ceilings, maple floors

    Michael Caouette Keller Williams Realty-Metropolitan

    Section Image
  • 16 Burnham Rd, Windham, NH 03087

    $1,225,000

    • 4 Beds
    • 4 Baths
    • 3,703 Sq Ft
    • 16 Burnham Rd
    • Windham, NH

    Welcome Home! This stunning 4-bedroom, 4-bath Colonial in situated in one of Windham’s most desirable neighborhoods. This spacious home features over 3,700 sq ft of living space, a 3-car garage, and beautiful hardwood floors throughout the first level. The open floor plan includes a chefs kitchen, formal dining room, living room, home office, and a sun-filled family room with a gas fireplace.

    Allison Murray Chinatti Realty Group

    Section Image
  • 20 Bramley Hill Rd, Windham, NH 03087

    $1,290,000

    • 4 Beds
    • 5 Baths
    • 5,169 Sq Ft
    • 20 Bramley Hill Rd
    • Windham, NH

    Unique 4-Bedroom, 3-Bathroom, 2 half baths Contemporary Home. This beautifully designed, home is perfect for families seeking both comfort and style. Expansive outdoor living spaces and an abundance of amenities, this property truly has it all. Enjoy the backyard featuring a heated saltwater pool, completed in Fall 2023. Unwind in the 7-person HotSpring hot tub or gather around the firepit, just

    Ana Fultz-DeSouza BHHS Verani Windham

    Section Image
  • 7 Buckhide Rd, Windham, NH 03087

    $1,475,000

    • 4 Beds
    • 3.5 Baths
    • 4,022 Sq Ft
    • 7 Buckhide Rd
    • Windham, NH

    EXCEPTIONAL DESIGN | Step into timeless elegance with this stunning four-bedroom, four-bath home, offering a unique and thoughtfully designed floor plan perfect for modern living. From the moment you enter, you’ll be captivated by the two-story family room, featuring a grand fireplace and expansive windows that bathe the space in natural light. The first-floor primary suite is a true retreat,

    Shannon DiPietro DiPietro Group Real Estate

    Section Image

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Ebeed Rabeh H $730,000 --
Leare Peter $570,000 --
Unknown $140,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ebeed Rabeh H $584,000
Previous Owner Unknown $283,500
Previous Owner Unknown $310,000
Previous Owner Unknown $275,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/12/2017 09/12/17 Sold $730,000 -8.7% $191 / Sq Ft
08/01/2017 08/01/17 Pending -- -- --
07/20/2017 07/20/17 For Sale $799,900 -- $210 / Sq Ft
Source: PrimeMLS

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $17,417 $769,300 $215,900 $553,400
2023 $16,463 $769,300 $215,900 $553,400
2022 $15,201 $769,300 $215,900 $553,400
2021 $14,324 $769,300 $215,900 $553,400
2020 $14,717 $769,300 $215,900 $553,400
2019 $14,563 $645,800 $197,800 $448,000
2018 $15,041 $645,800 $197,800 $448,000
2017 $13,045 $645,800 $197,800 $448,000
2016 $14,091 $645,800 $197,800 $448,000
2015 $14,003 $644,700 $197,800 $446,900
2014 $14,038 $584,900 $213,000 $371,900
2013 $14,313 $606,500 $213,000 $393,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: PrimeMLS

MLS Number: 4648589

PrimeMLS

APN: WNDM-000011-C000000-002559