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 = 3181 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 = 3181 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 = 3181 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;

807 Heritage Road
Sewell, NJ 08080

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $469,900
Beds: 3
Baths: 3
Status: Pending
SqFt: 1855
Agency: Berkshire Hathaway HomeServices Fox & Roach, Real

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Other
Year Built: 1997
Notes: We've received multiple offers, HIGHEST & BEST will be due Tues. 4/30 by 5pm Thank you!! Nestled in the picturesque landscape of East Greenwich, this stunning property boasts a sprawling 1-acre homesite, offering a tranquil retreat with breathtaking views of the surrounding farmland. Secluded yet conveniently located, this home provides easy access to shopping amenities, Routes 295, and the N.J. Turnpike, blending the best of country living with urban convenience.Step inside this captivating abode and be greeted by the grandeur of the vaulted great room, illuminated by natural light pouring in through its impressive circle-top window and two skylights. Brazilian hardwood flooring sets the stage for elegance, complemented by a cozy fireplace and a ceiling fan to enhance comfort. The spacious layout of the great room effortlessly flows into the heart of the home, creating an inviting space for both relaxation and entertainment.The focal point of the main level is the meticulously designed kitchen, adorned with brand new granite countertops and a stylish backsplash. Equipped with stainless steel appliances and ample cabinetry, this culinary haven features a breakfast bar and a sunlit breakfast nook, perfect for enjoying morning coffee. Adjacent to the kitchen, a versatile dining room, currently utilized as an office, offers flexibility to suit your lifestyle needs.Convenience meets luxury with a first-floor primary bedroom retreat, complete with a walk-in closet and a beautifully updated ensuite bath featuring separate vanities and a tiled stall shower. The laundry room, conveniently located on the main level, adds to the ease of daily living.Ascending to the second floor reveals two nice sized bedrooms and a fully updated hall bath, providing comfort and privacy for family and guests. Outside, the expansive backyard beckons with its serene ambiance and views of the adjacent farm. The backyard extends to the trees beyond the fence, showcasing an inviting inground pool and a patio'ideal for outdoor gatherings and leisurely afternoons in the sun.Completing this exceptional property is a two-car garage and a large unfinished basement, offering ample storage space and endless possibilities for customization.Experience easy living in this East Greenwich gem, where tranquility meets modern convenience in a picturesque setting . Don't miss the opportunity to make this your dream home! Schedule your showing today. ( Serviced by Kingsway Regional Schools)
MlsNumber: NJGL2041704


Listing Provided By: Berkshire Hathaway HomeServices Fox & Roach, Real, original listing
Name: Berkshire Hathaway HomeServices Fox & Roach, Real
Phone: (888) 669-3643
Office Name: BHHS Fox & Roach Mullica Hill
Office Phone: (856) 343-6000
Agent Name: Patricia Settar
Disclaimer: Copyright © 2024 Berkshire Hathaway HomeServices Fox & Roach, Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App