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 = 1778 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1778 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 1778 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

4 William Boyer Drive
Titusville, NJ 08560
Neena Sampat with Keller Williams Cornerstone Realty, original listing - (908) 359-0893

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,750
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3100 Square Feet
Agency: Keller Williams Cornerstone Realty
Agency Phone: (908) 359-0893

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential Lease-Single Family Residence
Year Built: 2024
Notes: Recently constructed single family home in a highly rated school district, in Hopewell Parc, historic Hopewell's newest community. The home features 4 bedrooms, 3.5 baths, 2-car garage and a fully finished basement. As you enter this exquisite single-family home, you are greeted by an inviting foyer. The heart of the home features a gourmet kitchen equipped with top-of-the-line appliances, ample cabinetry, and a convenient center island. Adjacent to the kitchen, the sunlit sunroom provides a serene retreat with abundant natural light and a seamless connection to the outdoors. The home’s thoughtful design continues with a generously sized deck off the kitchen as well. Upstairs, you'll find a versatile loft area, perfect for a home office, playroom, or additional lounge space, 4 bedrooms and 2 full baths. The laundry room is conveniently located on this level. The fully finished basement extends the living space with endless possibilities. Whether used as a media room, game room, or additional guest quarters, it adds significant versatility to the home. Experience a recreation-rich lifestyle with access to a special event center, multiple sports courts, and a state-of-the-art clubhouse featuring an outdoor heated pool, fitness and aerobics center. Onsite are electric vehicle charging stations for residential use, bike racks for homeowner use, and multiple playgrounds. This community is served by the well-regarded Hopewell Valley Regional School District with local shops and restaurants right at your fingertips. Minutes away from access to I-295, I-95, Route 1 and NJ Transit for convenient commutes to the New York metropolitan area.
MlsNumber: --
ListingId: NJME2048794


Listing Provided By: Keller Williams Cornerstone Realty, original listing
Phone: (908) 359-0893
Office Phone: (908) 359-0893
Agent Name: Neena Sampat
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