Title Page Background
HFQUERY 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 s.locationid = 1777 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 s.locationid = 1777 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 s.locationid = 1777 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

275 Locktown Road
Flemington, NJ 08822
Mark Jacobson with Corcoran Sawyer Smith, original listing - (908) 782-0100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,500,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2400 Square Feet
Agency: Corcoran Sawyer Smith
Agency Phone: (908) 782-0100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 150 acre(s)
Property Type: Farm-Farm
Year Built: 1790
Notes: Welcome to Kleinhans Farm! This SPECTACULAR 150 ACRE COUNTRY ESTATE features a meticulously renovated Circa 1790 stone & clapboard colonial overlooking a scenic stream-fed pond. A stone fireplace, beamed ceilings, exposed stone walls & deep-set windows are among the authentic features retained in this thoughtfully updated 3 BR, 3 BA home. There's also a spacious 2 BR, 1.5 BA stone guest cottage, 2 story studio loft apartment, inground pool, multiple barns with a substantial number of horse stalls, extensive paddocks, expansive fenced pastures & magnificent hay fields! ALL DWELLINGS ARE SUBSTANTIALLY SET BACK FROM THE ROAD, OFFERING UNCOMPROMISED PRIVACY. An added bonus are the extensive solar panels, generating free electricity, that are owned by the seller and included in the sale. This working farm currently has 30 Belted Galaway cattle + sheep, lamb, chickens & retired race-horses. This exceptional homestead RETAINS FULL DEVELOPMENT RIGHTS (NOT farmland preserved), boasts extensive road frontage and adjoins an equally impressive 75 Acre country estate which is also available for purchase. Very rarely, perhaps once in a lifetime, is there an opportunity to acquire a property of this magnitude & splendor! Note- Total number of Rooms, BR's & BA's is a combination of the primary 7 RM, 3BR, 3 BA dwelling + 2BR, 1.5 BA cottage + studio/loft apartment. This 150 Acre Farm consist of the following Block & Lot #'s in Kingwood Twp: Block 21 Lot #'s 4, 6.01, 8, 10 & Delaware Twp Block 4, L 6.
MlsNumber: --
ListingId: NJHT2002986


Listing Provided By: Corcoran Sawyer Smith, original listing
Phone: (908) 782-0117
Office Phone: (908) 782-0100
Agent Name: Mark Jacobson
Disclaimer: Copyright © 2024 Bright 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

HFQUERY 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 s.locationid = 1777 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Rebecca Bitner
Rebecca Bitner
ASCIIWeichert Realtors
Call Today!: (610) 462-4869

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App