40 Squirrel Run, Yarmouth Port, MA 02675

40 Squirrel Run Yarmouth Port MA 02675
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
Certified Mass Appraisal
Comparable Properties
  • 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) 29 Fortune Road 0.2 6/28/2024 $600,000 1,196 1 $501.67 Ranch 1971 2 1 1 2748 Hot Air-No Duc 0.23 Asph/F Gls/Cmp $323,200 $189,000 $0 $512,200
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) 7 Portsmouth Terrace 0.5 4/29/2024 $682,500 1,448 1 $471.34 Ranch 1971 2 2 0 3400 Forced Air-Duc 0.27 Asph/F Gls/Cmp $460,700 $238,000 $0 $698,700
F) 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
G) 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
H) 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
I) 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
J) 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
# 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 29 Fortune Road 6/28/2024 $600,000 0.2 Ranch 1,196 0.23 2 1-1
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 7 Portsmouth Terrace 4/29/2024 $682,500 0.5 Ranch 1,448 0.27 2 2-0
F 17 Arrowhead Drive 9/10/2024 $562,500 0.7 Ranch 1,248 0.3 3 1-1
G 49 Seminole Drive 8/23/2024 $325,000 0.9 Ranch 1,056 0.23 2 1-0
H 8 Flintlock Way 8/21/2024 $780,000 0.9 Cape Cod 1,175 0.25 1 2-0
I 30 Clinton Drive 9/23/2024 $810,000 0.9 Cape Cod 1,325 1.03 3 2-0
J 41 Knollwood Drive 9/13/2024 $750,000 1.0 Ranch 1,340 0.29 3 3-0
Averages 83 days $643,400 0.62 --- 1,285 0.38 --- ---  

Estimation of Market Value - $606,419

As of today, 10/29/2024, the estimated market value of 40 Squirrel Run, Yarmouth Port considering the above 10 comparable properties is $606,419.

 

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
  • 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 3605 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