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

51 Brownstone Road
Hightstown, NJ 08520

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $659,900
Beds: 4
Baths: 3
Status: Pending
SqFt: 1984
Agency: Realty Mark

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1997
Notes: BEST & FINAL OFFER DEADLINE by noon on Monday, 4/8/2024.<br /> Move right into this gorgeous 4 Bed, 2 1/2 bath colonial Single-family home built by Toll Brothers in the<br /> desirable Stonegate community of East Windsor. This home is situated in one of the largest lot in the<br /> community and is an ideal space for a modern lifestyle. The lucky new owner will be benefited with a newly freshly painted home with a complete new hardwood flooring, new porcelain tiles in the kitchen, new entry foyer and powder room flooring with new vanity, new toilet and new lightings, newer roof, updated water heater & AC, blinds, premium granite countertops with double sink, stainless steel appliances, large washer and dryer, ceiling fans in all rooms, crown moldings and wainscoting, 42-inch cabinetry, breakfast nook, 9 feet ceilings and a family room with a gas fireplace. A bonus is a great view of the sunset from the master bedroom. Enjoy the quiet and peaceful private backyard with a large custom paver patio which is the perfect place to relish dining or simply relax in summer! The master suite is with a large two walk-in-closets and a master bathroom with double vanity, soaking tub and a walk-in shower. Three additional generous sized bedrooms and the hall bath along with pulldown stairs to attic and large linen closet in hallway completes the second floor. This development is one of the best locations in East Windsor which is conveniently located close to major shopping centers, restaurants, and movie theatres. School bus comes just across the street allowing easy drop off and pick up. Easy access to NY/ Philly bus routes, trains, NJ Turnpike, Routes 33 and 130. Less than an hour to NY, Philly & the Jersey Shore beaches.
MlsNumber: NJME2038512


Listing Provided By: Realty Mark, original listing
Name: Realty Mark
Phone: (215) 376-4444
Office Name: Realty Mark Central, LLC
Office Phone: (609) 716-8400
Agent Name: Geeta Manek
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App