Title Page Background
DEBUG FN args: Array ( [0] => 312 [1] => [2] => [3] => agent ) BEFORE: Site: 312 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 312 Igate: njhud LocID: 312 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND e.expertIdNum = 1846500 AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 312 [1] => [2] => [3] => lender ) BEFORE: Site: 312 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 312 Igate: njhud LocID: 312 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND e.expertIdNum = -1 AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 312 [1] => [2] => [3] => other ) BEFORE: Site: 312 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 312 Igate: njhud LocID: 312 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND e.expertIdNum = -1 AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

220 Middlesex Tpke
Old Saybrook, CT 06475
Justin Manning with JJManning Auctioneers, original listing - (800) 521-0111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,950,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: JJManning Auctioneers
Agency Phone: (800) 521-0111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 124 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Property is being offered via Real Estate Auction in cooperation w/ Michael Hvizdo of Coldwell Banker on Wed., June 4 at 12pm on-site. The price noted above is the last list price, as the actual selling price will be determined by the bidders on auction day. Pre-auction offers must be presented on the auction P&S and are subject to seller confirmation. 10% Buyer's Premium applies. Auction Location: Clark Memorial Field - 210 Elm St, Old Saybrook, CT. Potential Development Opportunity - 124+/- Acres of Residential Land with Victorian Farmhouse & Obed Heights Reservoir. Site Preview: Wednesday, May 28 (11am-1pm). Old Saybrook is a desirable coastal community. Convenient to Routes 1 & 9, less than a 1/2 mile to I-95 & the Amtrak train station. Originally known as Fairview Farm, the property features picturesque Obed Heights Reservoir as well as elevated views of the Connecticut River & Long Island Sound. Stately farmhouse exteriors were featured in a 1970's cult classic film. This rare large acreage parcel offers many opportunities per zoning by right or special permit. Prospective buyers to conduct their own due diligence in regard to desired development or use. SITE AREA: 124+/- acres per Assessor, 110+/- acres per 2023 contour survey. FRONTAGE: 270+/- ft on Rt 154, additional roadways including I-95 abut property. ZONING: Majority is AA-1 with B-4 along Rt 154. EXISTING STRUCTURES INCLUDE: 7,088+/- sf GBA / 3,770+/- sf GLA 2.75-story Victorian farmhouse with tower, built c. 1875. 2,080+/- sf GBA / 1,248+/- GLA guesthouse with basement. 624+/- sf GBA detached garage. OBED HEIGHTS RESERVOIR: Originally created in 1880 by Dam (CT 00414) stoppage of Ragged Rock Creek, virtually all of this private reservoir lies within the property with limited access by others including the Obed Heights Association Beach. SEE PROPERTY INFO PACKAGE: Utilities, site map, dam info. PARCEL ID: 053/002
MlsNumber: --
ListingId: 11470702


Listing Provided By: JJManning Auctioneers, original listing
Phone: (800) 521-0111
Office Phone: (800) 521-0111
Agent Name: Justin Manning
Disclaimer: Copyright © 2025 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => middlesex [3] => CT [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: middlesex State: CT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: middlesex State: CT Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND e.expertIdNum = 1846500 AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Heather Harvey
Heather Harvey
ASCIICountry Living Realty
Call Today!: (423) 273-7842

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App