Agent Remarks for {property.system.DisplayAddress}
{property.extra.comment}
Public Remarks for {property.system.DisplayAddress}
{property.system.PublicRemarks}
Features for {property.system.DisplayAddress}
- 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}
- 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}
- 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: {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 - 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}
- 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 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}
- 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}
63 Sycamore, Farmington, NH 03835
MLS #5095380
City:Farmington, State:NH
Price: $175000
Hidden Oasis with Peaceful Brook Views in Farmington Ridge! Nestled on one of the largest and most private lots in the Farmington Ridge community, this spacious 3-bedroom, 2-bathroom manufactured home offers a quiet retreat that perfectly blends space, comfort, and natural beauty. Inside, you'll find a bright, open-concept living area, a spacious kitchen, a comfortable primary suite, plus two additional bedrooms and a full bath. The real magic, however, awaits outside: step onto the new, expansive back deck to unwind to the peaceful sights and sounds of Dames Brook, which runs right behind your secluded yard. A garden enthusiast's dream, the property is wrapped in a landscape of perennials, flowering shrubs, and climbing flowering vines designed to provide gorgeous, year-round blooms and unmatched privacy. Blending an inviting neighborhood atmosphere with the rare luxury of a secluded brook-side backyard, this Farmington Ridge gem won't last longâschedule your tour today! First showings will be at the Open House on Saturday, June 20 from 10;30am to 1pm.
6a334f8634e2b55355685a82 0.00 16764 0 0 0 2 2 3 1296 Farmington RE_1 NH-Strafford From rt75 Elm St, turn onto Dick Dame Lane, at end, this enter Farmington Ridge, at Stop, go Left, 2nd home on the left, see sign. 63 Sycamore Boulevard neren3 580 Monthly 6a334de634e2b553221f30b2 1 1 1 1 1783350060 43.3960630 1781746879 175000 Sally Steward 5095380 Active -71.0561930 Level 5095380 2413 63 Sycamore, Farmington, NH 03835 1783350060 KW Coastal and Lakes & Mountains Realty 38 135 Mobile Home Residential Hidden Oasis with Peaceful Brook Views in Farmington Ridge! Nestled on one of the largest and most private lots in the Farmington Ridge community, this spacious 3-bedroom, 2-bathroom manufactured home offers a quiet retreat that perfectly blends space, comfort, and natural beauty. Inside, you'll find a bright, open-concept living area, a spacious kitchen, a comfortable primary suite, plus two additional bedrooms and a full bath. The real magic, however, awaits outside: step onto the new, expansive back deck to unwind to the peaceful sights and sounds of Dames Brook, which runs right behind your secluded yard. A garden enthusiast's dream, the property is wrapped in a landscape of perennials, flowering shrubs, and climbing flowering vines designed to provide gorgeous, year-round blooms and unmatched privacy. Blending an inviting neighborhood atmosphere with the rare luxury of a secluded brook-side backyard, this Farmington Ridge gem won't last longâschedule your tour today! First showings will be at the Open House on Saturday, June 20 from 10;30am to 1pm. Pets - Allowed Pets - Cats Allowed Pets - Dogs Allowed Farmington Sch Dist SAU #61 Valley View Community Elem Farmington Senior High School Henry Wilson Memorial School NH 1781913600 1 Sycamore 63 Double Wide Manuf/Mobile 1783350791 1996 03835 ListPrice 175000 1781747590 175000 ListingStatus Active 1781938991 Active 1781747590 Coming Soon https://s3.us-central-1.wasabisys.com/apiv1.photos.master/bc1b-5095380-1-neren3.jpg 1 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/b5a6-5095380-2-neren3.jpg 2 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/5609-5095380-3-neren3.jpg 3 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/f755-5095380-4-neren3.jpg 4 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/c3fd-5095380-5-neren3.jpg 5 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/81e7-5095380-6-neren3.jpg 6 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/b983-5095380-7-neren3.jpg 7 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/5464-5095380-8-neren3.jpg 8 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/353c-5095380-9-neren3.jpg 9 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/0013-5095380-10-neren3.jpg 10 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/04f6-5095380-11-neren3.jpg 11 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/b415-5095380-12-neren3.jpg 12 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/6012-5095380-13-neren3.jpg 13 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/a131-5095380-14-neren3.jpg 14 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/8adf-5095380-15-neren3.jpg 15 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/cf62-5095380-16-neren3.jpg 16 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/91bc-5095380-17-neren3.jpg 17 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/8573-5095380-18-neren3.jpg 18 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/6293-5095380-19-neren3.jpg 19 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/b468-5095380-20-neren3.jpg 20 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/2a90-5095380-21-neren3.jpg 21 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/047d-5095380-22-neren3.jpg 22 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/80e6-5095380-23-neren3.jpg 23 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/1274-5095380-24-neren3.jpg 24 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/75c5-5095380-25-neren3.jpg 25 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/af92-5095380-26-neren3.jpg 26 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/797c-5095380-27-neren3.jpg 27 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/548c-5095380-28-neren3.jpg 28 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/190a-5095380-29-neren3.jpg 29 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/6663-5095380-30-neren3.jpg 30 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/e0ba-5095380-31-neren3.jpg 31 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/2acf-5095380-32-neren3.jpg 32 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/05df-5095380-33-neren3.jpg 33 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/5837-5095380-34-neren3.jpg 34 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/db68-5095380-35-neren3.jpg 35 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/7383-5095380-36-neren3.jpg 36 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/f8c8-5095380-37-neren3.jpg 37 1783350829 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/4e0c-5095380-38-neren3.jpg 38 1783350829 1783350829 1783350885 Point -71.056193 43.396063 RETS https://tour.primemls.com/63-Sycamore-Boulevard-Farmington-NH-03835/unbranded