"We Sell the Lakes Region!"™

Meredith, NH Office: (603) 279-7046

Facebook-f Twitter Instagram
Broker Information
Office Attribution
{property.system.OfficeAttribution}
Listing Agent
{property.system.ListingAgentName}
Listing Office
{property.system.OfficeListingName}
Selling Office
{property.system.SellingOfficeName}
School Information
School District
{property.system.SchoolDistrict}
High School
{property.feed.LM_Char25_8}
Junior High School
{property.feed.LM_Char25_7}
Elementary School
{property.feed.LM_Char25_6}

Agent Remarks for {property.system.DisplayAddress}

{property.extra.comment}

Public Remarks for {property.system.DisplayAddress}

{property.system.PublicRemarks}

Features for {property.system.DisplayAddress}

Property Information
  • Address: {property.feed.L_Address}
  • Unit/Lot #: {property.feed.L_Address2}
  • City: {property.feed.L_City}
  • State: {property.feed.L_State}
  • Zip: {property.feed.L_Zip}
  • County: {property.feed.L_Area}
  • MLS #: {property.feed.L_DisplayId}
  • Property Class: {property.feed.L_Class}
  • Property Type: {property.feed.L_Type_}
  • Listing Status: {property.feed.L_Status}
  • Lot size (Acres): {property.feed.L_NumAcres}
  • Zoning: {property.feed.LM_Char25_17}
  • Construction Status: {property.feed.LM_char50_8}
  • Pre-Construction: {property.feed.LM_char1_54}
  • SqFt-Apx Total: {property.feed.LM_Int4_5}
  • SqFt-Apx Fin Above Grade: {property.feed.LM_Dec_21}
  • SqFt-Apx Fin Below Grade: {property.feed.LM_Dec_22}
  • Seasonal: {property.feed.LM_char5_60}
  • Roads: {property.feed.LFD_Roads_28}
  • Roads Frontage: {property.feed.LM_char1_60}
  • Road Frontage Length: {property.feed.LM_Int4_7}
  • Development / Subdivision: {property.feed.LM_Char50_4}
  • Condo Name: {property.feed.LM_Char25_8}
  • Mobile Park Name: {property.feed.LM_char50_16}
  • Units Per Building: {property.feed.L_NumUnits}
  • Amenities: {property.feed.LFD_Amenities_1}
  • Covenants: {property.feed.LM_Char1_12}
Land / Water Body
  • Lot Description: {property.feed.LFD_LotDescription_24}
  • Current Use: {property.feed.LM_char1_44}
  • Area Description: {property.feed.LFD_AreaDescription_203}
  • Suitable Use: {property.feed.LFD_SuitableUse_33}
  • Surveyed: {property.feed.LM_char1_26}
  • Water Body Access: {property.feed.LM_char10_55}
  • Water Body Name: {property.feed.LM_char50_25}
  • Water Body Type: {property.feed.LM_char10_54}
  • Water Frontage Length: {property.feed.LM_int4_40}
Building
  • Style: {property.feed.LFD_Style_32}
  • Total Stories: {property.feed.LM_char5_54}
  • Year Built: {property.feed.LM_Int2_4}
  • Exterior: {property.feed.LFD_Exterior_12}
  • Color: {property.feed.LM_Char10_16}
  • Roof: {property.feed.LFD_Roof_29}
  • Construction: {property.feed.LFD_Construction_4}
  • Foundation: {property.feed.LFD_Foundation_20}
  • Basement: {property.feed.LM_Char1_6}
  • Basement Access Type: {property.feed.LM_Char10_5}
  • Basement Description: {property.feed.LFD_BasementDescription_3}
  • Exterior Features: {property.feed.LFD_FeaturesExterior_14}
  • Interior Features: {property.feed.LFD_FeaturesInterior_15}
  • Flooring: {property.feed.LFD_Flooring_19}
  • Appliances: {property.feed.LFD_Appliances_2}
  • Features - Accessibility: {property.feed.LFD_FeaturesAccessibility_13}
Garage / Parking / Easements
  • Garage: {property.feed.LM_Char1_2}
  • Garage Type: {property.feed.LM_Char10_26}
  • Garage Description: {property.feed.LFD_GarageDescription_21}
  • Garage Capacity: {property.feed.LM_Dec_8}
  • Driveway: {property.feed.LFD_Driveway_8}
  • Parking: {property.feed.LFD_Parking_25}
  • ROW - Parcel Access: {property.feed.LM_char1_39}
  • ROW to other Parcel: {property.feed.LM_char1_40}
  • Easements: {property.feed.LM_Char1_17}
Rooms
  • Rooms - Total: {property.feed.LM_Int1_16}
  • Total Bedrooms: {property.feed.LM_Int1_6}
  • Total Bathrooms: {property.feed.LM_int4_36}
  • Full Bathrooms: {property.feed.LM_Int1_1}
  • Rooms Level 1: {property.feed.LFD_RoomsLevel1_274}
  • Rooms Level 2: {property.feed.LFD_RoomsLevel2_275}
  • Rooms Level 3: {property.feed.LFD_RoomsLevel3_276}
  • Rooms Level 4: {property.feed.LFD_RoomsLevel4_277}
  • Rooms Level B: {property.feed.LFD_RoomsLevelB_273}
  • Room 1 Type: {property.feed.LM_char5_14}
  • Room 1 Level: {property.feed.LM_char5_34}
  • Room 1 Dimensions: {property.feed.LM_char30_11}
  • Room 2 Type: {property.feed.LM_char5_15}
  • Room 2 Level: {property.feed.LM_char5_35}
  • Room 2 Dimensions: {property.feed.LM_char30_12}
  • Room 3 Type: {property.feed.LM_char5_16}
  • Room 3 Level: {property.feed.LM_char5_36}
  • Room 3 Dimensions: {property.feed.LM_char30_13}
  • Room 4 Type: {property.feed.LM_char5_17}
  • Room 4 Level: {property.feed.LM_char5_37}
  • Room 4 Dimensions: {property.feed.LM_char30_14}
  • Room 5 Type: {property.feed.LM_char5_18}
  • Room 5 Level: {property.feed.LM_char5_38}
  • Room 5 Dimensions: {property.feed.LM_char30_15}
  • Room 6 Type: {property.feed.LM_char5_19}
  • Room 6 Level: {property.feed.LM_char5_39}
  • Room 6 Dimensions: {property.feed.LM_char30_16}
  • Room 7 Type: {property.feed.LM_char5_20}
  • Room 7 Level: {property.feed.LM_char5_40}
  • Room 7 Dimensions: {property.feed.LM_char30_17}
  • Room 8 Type: {property.feed.LM_char5_21}
  • Room 8 Level: {property.feed.LM_char5_41}
  • Room 8 Dimensions: {property.feed.LM_char30_18}
  • Room 9 Type: {property.feed.LM_char5_22}
  • Room 9 Level: {property.feed.LM_char5_42}
  • Room 9 Dimensions: {property.feed.LM_char30_19}
  • Room 10 Type: {property.feed.LM_char5_23}
  • Room 10 Level: {property.feed.LM_char5_43}
  • Room 10 Dimensions: {property.feed.LM_char30_20}
  • Room 11 Type: {property.feed.LM_char5_24}
  • Room 11 Level: {property.feed.LM_char5_44}
  • Room 11 Dimensions: {property.feed.LM_char30_21}
  • Room 12 Type: {property.feed.LM_char5_25}
  • Room 12 Level: {property.feed.LM_char5_45}
  • Room 12 Dimensions: {property.feed.LM_char30_22}
  • Room 13 Type: {property.feed.LM_char5_26}
  • Room 13 Level: {property.feed.LM_char5_46}
  • Room 13 Dimensions: {property.feed.LM_char30_23}
  • Room 14 Type: {property.feed.LM_char5_27}
  • Room 14 Level: {property.feed.LM_char5_47}
  • Room 14 Dimensions: {property.feed.LM_char30_24}
  • Room 15 Type: {property.feed.LM_char5_28}
  • Room 15 Level: {property.feed.LM_char5_48}
  • Room 15 Dimensions: {property.feed.LM_char30_25}
  • Room 16 Type: {property.feed.LM_char5_29}
  • Room 16 Level: {property.feed.LM_char5_49}
  • Room 16 Dimensions: {property.feed.LM_Char25_1}
  • Room 17 Type: {property.feed.LM_char5_30}
  • Room 17 Level: {property.feed.LM_char5_51}
  • Room 17 Dimensions: {property.feed.LM_Char25_9}
  • Room 18 Type: {property.feed.LM_char5_50}
  • Room 18 Level: {property.feed.LM_char5_31}
  • Room 18 Dimensions: {property.feed.LM_Char25_20}
  • Room 19 Type: {property.feed.LM_char5_32}
  • Room 19 Level: {property.feed.LM_char5_52}
  • Room 19 Dimensions: {property.feed.LM_Char25_21}
  • Room 20 Type: {property.feed.LM_char5_33}
  • Room 20 Level: {property.feed.LM_char5_53}
  • Room 20 Dimensions: {property.feed.LM_Char25_23}
  • Room 21 Type: {property.feed.LM_char5_10}
  • Room 21 Level: {property.feed.LM_char5_1}
  • Room 21 Dimensions: {property.feed.LM_Char25_29}
  • Room 22 Type: {property.feed.LM_char5_6}
  • Room 22 Level: {property.feed.LM_char5_11}
  • Room 22 Dimensions: {property.feed.LM_char30_3}
Mechanicals
  • Water: {property.feed.LFD_Water_35}
  • Sewer: {property.feed.LFD_Sewer_30}
  • Electric: {property.feed.LFD_Electric_9}
  • Heating: {property.feed.LFD_Heating_23}
  • Heat Fuel Type: {property.feed.LFD_HeatFuel_22}
  • Water Heater: {property.feed.LFD_WaterHeater_36}
  • Cooling: {property.feed.LFD_Cooling_6}
  • Utilities: {property.feed.LFD_Utilities_200}
  • Equipment: {property.feed.LFD_Equipment_10}
School Information
  • School District: {property.feed.LM_char10_32}
  • Elementary School: {property.feed.LM_char10_68}
  • High School: {property.feed.LM_Char10_2}
  • Middle / Jr. High School {property.feed.LM_char10_69}
Financial Information
  • Tax Rate: {property.feed.LM_Dec_2}%
  • Tax Year: {property.feed.LM_int4_41}
  • Taxes TBD: {property.feed.LM_char1_27}
  • Tax - Gross Amount: ${as_dollars(property.feed.LM_Dec_29)}
  • Price Per SQFT: ${as_dollars(property.feed.PricePerSF)}
  • Price Per SqFt: ${as_dollars(property.feed.LM_Dec_26)}
  • Price SqFt: ${as_dollars(property.feed.PriceSF)}
  • Fee: ${as_dollars(property.feed.LM_Dec_10)}
  • Fee Frequency: {property.feed.LM_char5_5}
  • TenantPays: ${as_dollars(property.feed.LFD_TenantPays_270)}
  • Tenant Pays: ${as_dollars(property.feed.LFD_TenantPays_271)}
  • RentIncludes: {property.feed.LFD_RentIncludes_132}
  • Rent Includes: {property.feed.LFD_RentIncludes_186}
  • Gross Income: ${as_dollars(property.feed.LM_Int4_11)}
  • Monthly Lease Amount: ${as_dollars(property.feed.LseAmt)}
  • Foreclosed/Bank-Owned/REO: {property.feed.LM_char30_28}
  • Assessment Amount: ${as_dollars(property.feed.LM_Int4_1)}
  • Assessment Year: {property.feed.LM_Int2_1}
  • Assessments - Special: {property.feed.LM_Char1_16}

54 Sycamore, Farmington, NH 03835

MLS #5037222

City:Farmington, State:NH

Price: $99000

MOTIVATED SELLER! HUGE PRICE REDUCTION! Welcome to your new home on a peaceful street in charming Farmington, NH! This well-maintained 2-bedroom, 2-bathroom home offers an ideal layout with an open-concept living area and bedrooms thoughtfully placed on opposite ends for added privacy. The spacious primary bedroom includes a dedicated water closet, providing a private and comfortable retreat. The eat-in kitchen is equipped with a dishwasher and modern stainless steel appliances—including a stove, and refrigerator—making meal prep and cleanup a breeze. Enjoy gatherings with family and friends on either the front or rear deck, or take advantage of the large yard for play, gardening, or relaxing under the open sky. Nestled in a quiet neighborhood, you're just 40 minutes from the vibrant seacoast city of Portsmouth and about an hour from the scenic White Mountains in Conway—perfect for weekend getaways and day trips. Don't miss the opportunity to make this lovely home yours! Schedule your showing today.

68078c8734e2b564cb6e0be2 281100 0 0 1 1 2 2 924 Farmington RE_1 NH-Strafford Take Elm St to Dick Dame Ln, left onto Grandview Ln and then left onto Sycamore Blvd. 54 Sycamore Boulevard neren3 505 Monthly 68078aed34e2b5649a577362 1 1 1748479161 1745324779 99000 Boyd Watkins 5037222 Active Under Contract Level 5037222 2413 54 Sycamore, Farmington, NH 03835 1755037382 KW Coastal and Lakes & Mountains Realty 20 107 Mobile Home Residential MOTIVATED SELLER! HUGE PRICE REDUCTION! Welcome to your new home on a peaceful street in charming Farmington, NH! This well-maintained 2-bedroom, 2-bathroom home offers an ideal layout with an open-concept living area and bedrooms thoughtfully placed on opposite ends for added privacy. The spacious primary bedroom includes a dedicated water closet, providing a private and comfortable retreat. The eat-in kitchen is equipped with a dishwasher and modern stainless steel appliances—including a stove, and refrigerator—making meal prep and cleanup a breeze. Enjoy gatherings with family and friends on either the front or rear deck, or take advantage of the large yard for play, gardening, or relaxing under the open sky. Nestled in a quiet neighborhood, you're just 40 minutes from the vibrant seacoast city of Portsmouth and about an hour from the scenic White Mountains in Conway—perfect for weekend getaways and day trips. Don't miss the opportunity to make this lovely home yours! Schedule your showing today. Private Valley View Community Elem Farmington Senior High School Henry Wilson Memorial School NH 1754956800 1 Sycamore 54 Manuf/Mobile 1755037990 1987 03835 ListPrice 99000 1753463590 99000 1750447991 117900 1746793992 129000 1745325191 139000 ListingStatus Active Under Contract 1755037990 Active Under Contract 1745325191 Active https://s3.us-central-1.wasabisys.com/apiv1.photos.master/ecac-5037222-1-neren3.jpg 1 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/a777-5037222-2-neren3.jpg 2 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/1e4b-5037222-3-neren3.jpg 3 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/4d58-5037222-4-neren3.jpg 4 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/1004-5037222-5-neren3.jpg 5 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/7f73-5037222-6-neren3.jpg 6 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/efec-5037222-7-neren3.jpg 7 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/3982-5037222-8-neren3.jpg 8 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/85ee-5037222-9-neren3.jpg 9 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/330b-5037222-10-neren3.jpg 10 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/0f7a-5037222-11-neren3.jpg 11 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/9e76-5037222-12-neren3.jpg 12 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/6819-5037222-13-neren3.jpg 13 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/da1a-5037222-14-neren3.jpg 14 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/26f8-5037222-15-neren3.jpg 15 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/3efa-5037222-16-neren3.jpg 16 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/6928-5037222-17-neren3.jpg 17 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/4691-5037222-18-neren3.jpg 18 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/b74d-5037222-19-neren3.jpg 19 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/3d19-5037222-20-neren3.jpg 20 1748479414 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/3425-5037222-21-neren3.jpg 21 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/f439-5037222-22-neren3.jpg 22 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/9f43-5037222-23-neren3.jpg 23 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/4576-5037222-24-neren3.jpg 24 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/35ff-5037222-25-neren3.jpg 25 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/c41d-5037222-26-neren3.jpg 26 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/0e96-5037222-27-neren3.jpg 27 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/8b64-5037222-28-neren3.jpg 28 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/8a3b-5037222-29-neren3.jpg 29 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/3108-5037222-30-neren3.jpg 30 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/c4bc-5037222-31-neren3.jpg 31 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/c4b9-5037222-32-neren3.jpg 32 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/d2d2-5037222-33-neren3.jpg 33 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/d6f1-5037222-34-neren3.jpg 34 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/fd36-5037222-35-neren3.jpg 35 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/bfbb-5037222-36-neren3.jpg 36 1748478862 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/0176-5037222-37-neren3.jpg 37 1748478862 1748479414 1748479494 43.3957290 -71.0571520 Point -71.057152 43.395729 RETS -19.09 1753463590
Roche Realty Group Meredith Office

MEREDITH, NH OFFICE:
97 Daniel Webster Highway
(603) 279-7046
toll free (800) 926-5253

Connect with us!

Facebook-f Twitter Instagram

"We Sell the Lakes Region!"™

Roche Realty Group

Independently owned & operated,
since 1992!

© Roche Realty Group, Inc.

Agent Login