For Sale
For Rent
Blog
Property Records
Schools
SEARCH
Property Records
For Sale
For Rent
MORE
Blog
Schools
See Home Value
Otsego 13320
242 CAMPBELL Road
Photo of 242 CAMPBELL Road
Sold on Jan 4, 2022

1

Map

$500,000
● House - Off Market

242 CAMPBELL Road

Cherry Valley, NY 13320
bedrooms
5 Beds
bathrooms
4 Baths, 1 Half Bath
square feet
3,676 Ft²
$567,863
RealtyHop Estimate
8.16%
Since Feb 1, 2022
National-US
Primary Model

About This Property

Welcome to Lindesay Cottage in the Lindesay Patent Rural Historic District of Cherry Valley. Listed on the National Register of Historic Places, the property was one of the first European Settlements in the mid-1700's. Situated in a most Bucolic Setting, the Colonial Revival Style Home, with it's Grand Porch offers majestic views of the Valley below. Double entry glass doors set the tone for this charming home with hardwoods throughout, high ceilings, large, overflowing rooms, four fireplaces, five bedrooms, 4.5 updated baths. Fabulous kitchen/great room for gatherings. It's a perfect place to work from home, entertain, have as a second home or airbnb. Just 15 minutes to Cooperstown, home of the National Baseball Hall of Fame, Glimmerglass Opera and the Otesaga Resort on Lake Otsego. Excellent Condition
Unit Size
3,676 Ft²
Days on Market
238 days
Land Size
1.26 acres
Price per sqft
$143
Property Type
House
Property Taxes
$399
HOA Dues
-
Year Built
1920

Payment Calculator

Home Price
Down Payment
%
Loan Term
Interest %

Your Estimated Monthly Payment

Principal + Interest:
Property Tax:
HOA:
Home Insurance:
Mortgage Insurance:

Cap Rate Calculator

Purchase Price
Monthly Property Taxes
Monthly Rental Income
Maintenance & HOA
Income Per Year
Expenses Per Year
Operating Profit Per Year
Cap Rate 100% Occupancy
N/A (extreme outlier)

What does this mean?

Based on our analysis, the cap rate of this property is 1.25%. A negative cap rate indicates that the property might not be feasible as an income-producing asset. The median cap rate for a near zip code 11238 is 4.23%.

How much can I actually make?

Actual monthly rental income may vary between $4,760 and $7,140 depending on unit-specific characteristics. You can change the amount using the slider to further explore.

How is cap rate calculated?

Cap Rate = Net Operating Income (NOI) / Property Asset Value.

When calculating the cap rate, we assume 100% occupancy. Leverage (mortgage) is not considered.

Cap Rate provided by RealtyHop and RentHop, learn more about cap rate here.

Last updated: 2 days ago (Global MLS #202118027)

Price History

Date / Event Date Event Price
Jan 6, 2022 Sold
Premium
Sold
May 10, 2021 Listed by Four Seasons Sothebys International Realty $525,000
Listed by Four Seasons Sothebys International Realty
Oct 20, 2010 Sold
Premium
Sold

Property Highlights

Parking Available
Garage
Fireplace

Building Info

Overview

    General

  • Year Built: 1920
  • Effective Year Built: 1920
  • Total Rooms: 12
  • Bedroom Count: 5
  • Bathroom Count: 5
  • Full Bathrooms: 4
  • Partial Bathrooms: 5
  • Building Condition: 3
  • Building Quality: 4
  • Construction Type: 0
  • Building Style: 1
  • Exterior Walls Type: 17
  • Interior Walls Type: 0
  • Roof Shape Type: 0
  • Roof Cover Type: 0
  • Floor Count: 200
  • Floor Cover: 0
  • Basement Type: 6
  • Basement Area: 0
  • Garage Type: 4
  • Garage Square Area: 1,400
  • Parking Space Count: 5
  • Patio Type: 0
  • Porch Type: 6
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 54,886
  • Total Building Area: 3,676
  • Building Area: 3,676
  • Building Area Measurement: L

    Heating and Cooling

  • Fireplace Count: 1
  • Air Conditioning: 0
  • Heating: 4
  • Heated Square Feet: 3,676
  • Heating Fuel Type: 6

    Utilities

  • Sewer System: 4
  • Water Service: 5

Building

  • Building Type: 0
  • Property Class: R
  • Land Acres: 0000001260
  • Standard Land Use Code: 1001
  • County Land Use Code: 210
  • Legal Description 1: 985 0 0

Neighborhood

  • School District Name: Cherry Valley-Springfield Central School District
  • School Tax School District: CHERRY VALLEY-S
  • Census Tract: 590101

Geography

  • Account Number: 037750
  • District: 362489
  • Section: 58.00
  • Parcel: 362489 58.00-1-9.00
  • Block: 1
  • Lot: 9.000
  • Municipality: CHERRY VALLEY (TOV)
  • Latitude: 42.8064
  • Longitude: -74.754

    Address

  • Full Address: 242 Campbell Rd
  • Address - House Number: 242
  • Address - Street Name: Campbell
  • Address - Suffix Type: Rd
  • State: NY
  • City Name: Cherry Valley
  • Carrier Code: R001
  • 4-Digit Zip Code: 3502
  • Zip Code: 13320

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $0
  • Tax Rate Code Area: 362401

    Appraisal Valuation

  • Standard Deviation: 0.1263
  • Valuation Date: Mar 13, 2024
  • Confidence Score: 74
  • Final Value: 251,037
  • High Value: 282,761
  • Low Value: 219,312

    Market Valuation

  • Market Total Value: $386,287
  • Market Land Value: $29,575
  • Market Improvement Value: $356,712

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $320,000
  • Assessed Land Value: $24,500
  • Assessed Improvements Value: $295,500

    Sales

  • Current Sale Contract Date: Jan 04, 2022
  • Current Sale Recording Date: Jan 06, 2022
  • Current Sale Price:
    Premium
  • Current Sale Document Type: 27
  • Current Sale Input Document Number: 2022-160
  • Previous Sale Recording Date: Oct 20, 2010
  • Previous Sale Contract Date: Oct 19, 2010
  • Previous Sale Amount: $385,000
  • Previous Sale Document Type: 27
Data used for valuation calculations is provided by RealtyHop, and other third party sources
Request mortgage information redaction

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Otsego

Stats & Trends

Median Asking:

$250,000

Sale Price/ft²

$155

Below Asking

0.03%

Average Days on Market

94

Average Home Size

2359 ft²

Average Home Age

97.8 years

Currently For Sale

231 Listings
Based on RH Advisors, Inc. calculations of home data from MLS and/or public records.

Similar Homes for Sale

Currently no similar homes around

Nearby Rentals

Rentals Near You

Click here to view more rentals in the neighborhood.
Global MLS

Listed by: Mary Lourdes Pinckney
Four Seasons Sothebys International Realty
Last Updated: 2 days ago
Data Source: Global MLS , MLS# 202118027
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed.

Frequently Asked Questions

When was property at 242 Campbell Road built and last sold?
The property at 242 Campbell Road was built in 1920 and last sold on Jan 4, 2022 for $500,000.
How much is this home worth?
The estimated value of the home located at 242 Campbell Road is $530,250.
What are some comparable homes to 242 Campbell Road?
There are currently no comparable homes to 242 Campbell Road.
Recent Neighborhood News
Haunted NYC Real Estate: 6 Spooky Stories Behind the Addresses
Lake House Prices Near NYC in 2026: What Waterfront Actually Costs (Labor Day Buyer's Guide)
9 New York City Seafood and Raw Bars
Why Some NYC Tenement Apartments Had Bathtubs in the Kitchen
Popular Searches
Cherry Valley Homes for Sale
Cherry Valley Houses for Sale
Cherry Valley Multifamily for Sale
Cherry Valley Land for Sale
Cherry Valley Commercial for Sale
Cherry Valley Homes with Basements
Cherry Valley Homes with Pools
Cherry Valley Homes with Parking
Nearby Cities
Canajoharie Homes for Sale
Fort Plain Homes for Sale
Cooperstown Homes for Sale
Sharon Springs Homes for Sale
Palatine Bridge Homes for Sale
Nelliston Homes for Sale
Ames Homes for Sale
Nearby Property Records
Schoharie County, NY Property Records
Montgomery County, NY Property Records
Otsego County, NY Property Records
Fulton County, NY Property Records
Herkimer County, NY Property Records
Schenectady County, NY Property Records
Delaware County, NY Property Records
Saratoga County, NY Property Records
Nearby Counties
Canajoharie Homes for Sale
Minden Homes for Sale
Sharon Homes for Sale
Seward Homes for Sale
Palatine Homes for Sale
Middlefield Homes for Sale
Springfield Homes for Sale
Roseboom Homes for Sale
Top Real Estate Agents
Top Agents in Cherry Valley
Top Agents in 12043
Top Agents in 13326
Top Agents in 13339
Top Agents in 13317
Top Agents in Canajoharie
Top Agents in Minden
Top Agents in 13459