40 Squirrel Run, Yarmouth Port, MA 02675

40 Squirrel Run Yarmouth Port MA 02675
Click to view the Official Assessors Field Card Print Report
Owner Information
Owner 1
Douglas T Campbell
Owner 2
Jeanne M Campbell
Owner's Address
40 Squirrel Run Yarmouth Port, MA 02675-1836
Market Sale Information
Most recent sale date
5/30/1997
Previous sale date
Transfer document #
10777-0187
Previous transfer document
Grantor
Kenneth D Cahoon
Previous grantor
Most recent sale price
$125,000.00
Previous sale price
$0.00
Site Information
Property ID
123-88
Lot Size
0.3
Use Code
101 - Residential, single family
Zoning
Building Style
Ranch
Number of Rooms
Stories
1
Number of Beds
2
Year Built
1977
Number of full baths
2
Condition
Number of half baths
0
Finished Area
1200
Number of Kitchen
Gross Living Area
3148
Number of Fireplaces
Bsmnt floot
Number of parking
Interior walls
Drywall/Sheet
Floor type
Hardwood, Carpet
Solar Hot Water
No
Roof Structure
Gable/Hip
Heating type
Gas
Roof Cover
Asph/F Gls/Cmp
Heating fuel
Forced Air-Duc
Frame type
Air Condition (%)
Sidings
Wood Shingle
Assessment Information
Fiscal Year
2025
Land Value
$191,700.00
Total value
$591,100.00
Building value
$399,400.00
Estimated tax
$4,184.00
Yard improvement value
$0.00
Flood Map MassMapper Google Street View
Certified Mass Appraisal
Comparable Properties
Mailing Labels $Valuation Report
  • Total Appraisal
  • Building Appraisal
  • Land Appraisal
  • Last Sale Price
  • Net Living Area
  • Number of Bedrooms
  • Lot Size
  • Year Built
Address 40 Squirrel Run Photo Plan Map Proximity Last Sold Price Net Living Area Stories Sale Price/sft $104.17 Style Ranch Age 1977 Rooms Bedrooms 2 Full baths 2 Half baths 0 Gross Living Area 3148 Heating Fuel Forced Air-Duc Detached Garage Lot Size 0.3 Roof Cover Asph/F Gls/Cmp AEM Value - Building $399,400.00 AEM Value - Land $191,700.00 AEM Value - Other $0.00 AEM Value - Total $591,100.00
A) 19 Union Street 0.3 11/22/2024 $485,000 1,028 1 $471.79 Cape Cod 1977 3 1 0 2844 Forced Air-Duc 0.26 Asph/F Gls/Cmp $322,000 $140,500 $0 $462,500
B) 32 Homestead Lane 0.4 7/19/2024 $689,000 1,492 1 $461.80 Ranch 1970 3 1 1 3746 Hot Water 0.46 Asph/F Gls/Cmp $402,800 $309,700 $0 $712,500
C) 81 Shaker House Road 0.4 8/5/2024 $610,000 1,292 1 $472.14 Ranch 1968 2 1 1 3296 Forced Air-Duc 0.31 Asph/F Gls/Cmp $381,900 $192,000 $0 $573,900
D) 110 White Rock Road 0.5 8/26/2024 $625,000 1,278 1 $489.05 Ranch 1977 2 2 0 2938 Hot Water 0.39 Asph/F Gls/Cmp $407,700 $195,100 $0 $602,800
E) 49 Shaker House Road 0.5 11/25/2024 $623,246 1,330 1 $468.61 Ranch 1968 5 2 1 1 2952 Forced Air-Duc 0.32 Asph/F Gls/Cmp $375,000 $192,400 $0 $567,400
F) 23 Skipper Lane 0.5 10/30/2024 $600,500 1,336 1 $449.48 Ranch 1970 3 1 1 3206 Forced Air-Duc 0.23 Asph/F Gls/Cmp $412,500 $189,000 $0 $601,500
G) 17 Arrowhead Drive 0.7 9/10/2024 $562,500 1,248 1 $450.72 Ranch 1974 3 1 1 2809 Hot Water 0.3 Asph/F Gls/Cmp $323,100 $180,000 $0 $503,100
H) 6 Frances Helen Road 0.8 11/1/2024 $556,000 1,104 1 $503.62 Ranch 1977 3 2 0 1164 Forced Air-Duc 0.2 Asph/F Gls/Cmp $278,900 $125,200 $0 $404,100
I) 102 Starbuck Lane 0.8 11/15/2024 $427,500 912 1 $468.75 Ranch 1968 0 2 1 0 1944 Forced Air-Duc 0.31 Asph/F Gls/Cmp $236,100 $180,400 $0 $416,500
J) 49 Seminole Drive 0.9 8/23/2024 $325,000 1,056 1 $307.77 Ranch 1978 2 1 0 2368 Hot Water 0.23 Asph/F Gls/Cmp $315,600 $164,300 $0 $479,900
K) 8 Flintlock Way 0.9 8/21/2024 $780,000 1,175 1 $663.83 Cape Cod 1985 1 2 0 2090 Hot Water 0.25 Asph/F Gls/Cmp $403,100 $391,900 $0 $795,000
L) 7 Jasmine Street 0.9 11/12/2024 $559,000 1,152 1 $485.24 Ranch 1970 3 1 1 2828 Hot Water 0.26 Asph/F Gls/Cmp $301,200 $140,500 $0 $441,700
M) 30 Clinton Drive 0.9 9/23/2024 $810,000 1,325 1 $611.32 Cape Cod 1985 3 2 0 2901 Hot Water 1.03 Asph/F Gls/Cmp $472,500 $187,700 $0 $660,200
N) 41 Knollwood Drive 1.0 9/13/2024 $750,000 1,340 1 $559.70 Ranch 1982 0 3 3 0 3120 Hot Water 0.29 Asph/F Gls/Cmp $509,700 $166,300 $0 $676,000
O) 90 Freeman Road 1.0 12/30/2024 $668,000 1,404 1 $475.78 Cape Cod 1971 4 3 0 3276 Hot Water 0.26 Asph/F Gls/Cmp $365,000 $190,100 $0 $555,100
# Address Last Sold Sale Price Dist(m) Style LA (sq ft) Lot(ac) BR F-HB
@ 40 Squirrel Run 5/30/1997 $125,000 0 Ranch 1,200 0.3 2 2-0 -
  Criteria
A 19 Union Street 11/22/2024 $485,000 0.3 Cape Cod 1,028 0.26 3 1-0
B 32 Homestead Lane 7/19/2024 $689,000 0.4 Ranch 1,492 0.46 3 1-1
C 81 Shaker House Road 8/5/2024 $610,000 0.4 Ranch 1,292 0.31 2 1-1
D 110 White Rock Road 8/26/2024 $625,000 0.5 Ranch 1,278 0.39 2 2-0
E 49 Shaker House Road 11/25/2024 $623,246 0.5 Ranch 1,330 0.32 2 1-1
F 23 Skipper Lane 10/30/2024 $600,500 0.5 Ranch 1,336 0.23 3 1-1
G 17 Arrowhead Drive 9/10/2024 $562,500 0.7 Ranch 1,248 0.3 3 1-1
H 6 Frances Helen Road 11/1/2024 $556,000 0.8 Ranch 1,104 0.2 3 2-0
I 102 Starbuck Lane 11/15/2024 $427,500 0.8 Ranch 912 0.31 2 1-0
J 49 Seminole Drive 8/23/2024 $325,000 0.9 Ranch 1,056 0.23 2 1-0
K 8 Flintlock Way 8/21/2024 $780,000 0.9 Cape Cod 1,175 0.25 1 2-0
L 7 Jasmine Street 11/12/2024 $559,000 0.9 Ranch 1,152 0.26 3 1-1
M 30 Clinton Drive 9/23/2024 $810,000 0.9 Cape Cod 1,325 1.03 3 2-0
N 41 Knollwood Drive 9/13/2024 $750,000 1.0 Ranch 1,340 0.29 3 3-0
O 90 Freeman Road 12/30/2024 $668,000 1.0 Cape Cod 1,404 0.26 4 3-0
Averages 107 days $604,716 0.69 --- 1,231 0.34 --- ---  

Estimation of Market Value - $611,811

As of today, 01/19/2025, the estimated market value of 40 Squirrel Run, Yarmouth Port considering the above 15 comparable properties is $611,811.

 

In estimating the current market value, RealtyInSite follows the sales comparison (market) approach which is an approach based on the principles of supply and demand (principle of change) and the principle of substitution. The principle of substitution assumes that a prudent person will pay no more for a property than it would cost to purchase a comparable substitute property.

 

Comparable sales data are applied to arrive at an estimate of value. By default, comparable properties are those properties located within 1 mile of the subject property that have sold within the last 6 months and have a similar size of living area. The table shown above lists the comparable properties that were considered. Note that which properties are considered comparables can be adjusted by varying the selection criteria or deleting non-representative properties.

Neighboring Properties
Mailing Labels
  • Total Appraisal
  • Building Appraisal
  • Land Appraisal
  • Last Sale Price
  • Net Living Area
  • Number of Bedrooms
  • Lot Size
  • Year Built
# Address Last Sold Sale Price Dist(m) Style LA (sq ft) Lot(ac) BR F-HB
@ 40 Squirrel Run 5/30/1997 $125,000 0 Ranch 1,200 0.3 2 2-0 -
  Criteria
A 46 Squirrel Run 2/25/2015 $274,000 0.0 Ranch 1,368 0.28 2 2-0
B 58 Amy Lane 8/19/2022 $726,100 0.0 Ranch 1,432 0.3 3 2-0
C 52 Amy Lane 8/15/2003 $410,000 0.0 Colonial 2,296 0.47 3 3-0
D 33 Squirrel Run 6/8/2006 $430,000 0.0 Multi Family 1,652 0.54 3 2-0
E 50 Squirrel Run 10/18/2022 $685,000 0.0 Ranch 1,560 0.27 2 2-0
F 46 Amy Lane 1/11/2019 $360,000 0.0 Colonial 1,344 0.3 2 1-1
G 39 Squirrel Run 11/25/2015 $100 0.0 Cape Cod 1,791 0.55 3 2-0
H 7 Woodside Circle 8/11/2020 $495,000 0.0 Ranch 1,786 0.92 3 2-1
I 27 Squirrel Run 4/30/2019 $100 0.0 Cape Cod 2,389 0.53 3 3-0
J 28 Squirrel Run 6/10/2013 $100 0.0 Ranch 1,972 0.3 2 1-0
K 51 Amy Lane 5/9/2016 $259,000 0.1 Ranch 1,142 0.3 2 1-1
L 45 Squirrel Run 10/15/2020 $475,000 0.1 Ranch 1,338 0.56 2 2-1
M 56 Squirrel Run 5/21/2014 $315,000 0.1 Ranch 1,368 0.26 2 2-0
N 9 Woodside Circle 2/12/2002 $395,000 0.1 Cape Cod 2,042 0.92 3 2-1
O 40 Amy Lane 6/15/2020 $444,000 0.1 Cape Cod 1,604 0.28 4 1-1
P 41 Amy Lane 8/12/2010 $298,750 0.1 Ranch 1,196 0.29 2 1-1
Q 25 Squirrel Run 10/18/2021 $611,000 0.1 Conventional 2,282 0.51 3 2-1
R 22 Squirrel Run 9/12/2005 $100 0.1 Ranch 1,368 0.32 2 2-0
S 61 Randolph Road 12/23/2019 $100 0.1 Ranch 1,296 0.28 2 2-0
T 84 Pine Street 2/26/1998 $295,000 0.1 Conventional 2,276 1.68 3 2-2
U 66 Randolph Road 3/21/2022 $665,000 0.1 Ranch 1,499 0.31 3 2-0
V 53 Squirrel Run 6/3/2015 $100 0.1 Cape Cod 2,833 0.66 2 3-0
W 62 Squirrel Run 2/24/2017 $100 0.1 Ranch 1,368 0.26 2 2-0
X 11 Woodside Circle 7/22/2019 $100 0.1 Colonial 2,202 0.92 3 3-0
Y 18 Squirrel Run 6/27/2017 $100 0.1 Ranch 1,200 0.33 2 2-0
Z 15 Squirrel Run 8/25/2016 $100 0.1 Ranch 1,368 0.5 2 1-1
- 76 Pine Street 6/14/2022 $1,250,000 0.1 Cape Cod 2,341 0.92 4 3-1
- 35 Amy Lane 6/29/2023 $595,000 0.1 Ranch 1,392 0.36 2 1-1
- 55 Randolph Road 9/3/2015 $100 0.1 Ranch 1,368 0.28 2 3-0
- 62 Randolph Road 7/27/2020 $10 0.1 Colonial 2,016 0.34 3 2-1
- 4 Woodside Circle 11/6/2014 $240,000 0.1 Cape Cod 1,524 0.33 3 1-1
- 68 Pine Street 11/1/2016 $100 0.1 Colonial 5,397 1.08 5 3-1
- 10 Woodside Circle 4/17/2018 $100 0.1 Ranch 1,552 0.92 3 2-0
- 6 Woodside Circle 10/13/1989 $0 0.1 Colonial 2,518 0.92 3 2-1
- 53 Arthur Lane 6/4/2020 $10 0.1 Ranch 1,298 0.32 3 2-1
- 66 Squirrel Run 1/31/2019 $322,000 0.1 Ranch 1,368 0.24 2 2-0
- 12 Squirrel Run 8/26/2009 $115,000 0.1 Ranch 1,026 0.34 2 1-0
- 57 Squirrel Run 10/2/2015 $100 0.1 Cape Cod 1,588 1.01 3 2-0
- 56 Randolph Road 3/16/2004 $441,345 0.1 Cape Cod 2,163 0.37 3 2-1
- 51 Randolph Road 5/24/2010 $245,000 0.1 Ranch 1,244 0.28 2 2-0
- 7 Squirrel Run 11/30/2015 $452,500 0.1 Cape Cod 1,696 0.62 4 2-0
- 8 Woodside Circle 10/18/2017 $100 0.1 Cape Cod 1,610 0.92 3 2-1
- 28 Amy Lane 1/16/2013 $100 0.1 Ranch 1,236 0.32 2 1-1
- 49 Arthur Lane 5/25/2016 $376,000 0.1 Cape Cod 1,529 0.35 2 1-1
- 50 Pine Street 3/8/2019 $100 0.1 Cape Cod 2,377 0.63 3 2-1
- 46 Pine Street 10/7/2021 $165,000 0.1 Cape Cod 1,990 0.6 3 2-1
- 40 Pine Street 5/8/2013 $100 0.1 Cape Cod 1,684 0.57 2 2-0
- 59 Squirrel Run 6/15/2023 $1,175,000 0.1 Old Style 2,798 1.36 3 3-0
- 26 Richard Road 2/21/2003 $277,500 0.1 Cape Cod 1,176 0.37 3 2-0
- 6 Squirrel Run 11/4/2016 $328,500 0.1 Ranch 1,224 0.34 2 2-0
- 25 Amy Lane 8/3/2021 $410,000 0.1 Ranch 1,578 0.31 2 2-0
- 26 Fortune Road 5/13/2021 $100 0.1 Ranch 1,114 0.26 2 1-0
- 34 Pine Street 12/19/2011 $100 0.1 Cape Cod 1,868 0.53 3 2-0
- 58 Pine Street 11/4/1994 $42,000 0.1 Cape Cod 2,281 0.52 3 3-1
- 28 Fortune Road 10/4/2012 $290,000 0.1 Cape Cod 1,170 0.27 2 1-0
Averages 3687 days $252,086 0.08 --- 1,747 0.52 --- ---  
DISCLAIMER: The information in this report was collected from the concerned Assessors Office and Registry of Deeds.  Compu-Links disclaims any and all representations or warranties as to the accuracy of this information
123 88 40 Squirrel Run