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;

219 Rogers Avenue
Hightstown, NJ 08520

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $598,000
Beds: 4
Baths: 3
Status: Active
SqFt: 2231
Agency: Aughenbaugh Realty, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1860
Notes: NOTE: NO SHOWINGS MONDAY APRIL 22 to WEDNESDAY APRIL 24. <br /> <br /> This Hightstown beauty from 1860 has been updated and opened up for today's living. With newly installed Central Air, new vinyl siding and painted trim this house shines with pre-Civil War charm. The new main roof this house is graced by a look-out turret you can sit in and admire the 360 degree view of Hightstown. A wrap around porch with front and side doors adorned with stained glass completes the exterior of the house.<br /> <br /> A gracious entry hall with wood floors add character and grace to this well proportioned family home with 2.5 baths, 4 bedrooms, a full basement and well sized yard. Enjoy the spacious rooms and high ceilings of as one travels through the nine rooms of this beautiful home. In addition to a formal living and dining room, the open plan kitchen and family room provides a more relaxed open plan feel for everyday life. The kitchen is also accessible from the backyard via a mud room with a coat closet, laundry and powder room. Located off Stockton Street this home is a piece of history, overlooking the Civil War Memorial, erected in 1875. (Seventy-six historic resources are located within the Hightstown Historic District, which is listed on the National Register of Historic Places. The District’s buildings, which are predominately single-family homes, include examples of Federal, Victorian, and Eclectic architectural styles reflecting the town’s growth over time.)<br /> <br /> A short walk to both the downtown district with its shops and businesses as well as the two local primary schools, this home is ideally placed in the center of all Hightstown has to offer.<br /> <br /> With a dog in the house, advance notice is required for all viewings. No showings May 2-5 or May 7.
MlsNumber: NJME2042182


Listing Provided By: Aughenbaugh Realty, LLC, original listing
Name: Aughenbaugh Realty, LLC
Phone: (609) 448-8200
Office Name: Aughenbaugh Realty, LLC
Office Phone: (609) 448-8200
Agent Name: Chris Falco
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