Title Page Background
DEBUG FN args: Array ( [0] => 3468 [1] => [2] => [3] => agent ) BEFORE: Site: 3468 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3468 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3468 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3468 [1] => [2] => [3] => lender ) BEFORE: Site: 3468 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3468 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3468 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3468 [1] => [2] => [3] => other ) BEFORE: Site: 3468 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 3468 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3468 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;

42 Exeter Rd
Millburn Twp., NJ 07078

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,195,000
Beds: 7
Baths: 6
Status: Active
SqFt: 6000
Agency: RE/MAX SELECT

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: Greeted by a bright and airy entrance foyer with soaring ceilings, welcome to 42 Exeter! This stunning new construction home in Short Hills checks all of the boxes! 10-year warranty! Featuring a grand open floor plan, the 1st floor is home to a living room, breathtaking powder room and EN-SUITE bedroom with the view of the picturesque landscaping. The Kitchen opens to the dining room and family room, serving as the heart of the house and showcases an expansive island, walk-in pantry, wine bar, Viking appliances, and elegant breakfast nook to fulfill all of your inner chef's desires. Exceptional sliding doors extend the living space to the deck, embracing all outdoor pleasure. The 2nd floor boasts 4 generous bedrooms, incl a bedroom suite with EN SUITE bath, 2 spacious bedrooms with a J&J bath, and a Remarkable PRIMARY BEDROOM SUITE with all the bells and whistles, enclosing a custom WIC, gorgeous primary bath, and an EN SUITE office, perfect for WFH or entertaining. A cheerful laundry room completes this level. The incomparable walk-out basement is mostly above the ground, incl an enormous recreation room, 2 spacious bedrooms with above-ground full-sized windows, a full bath, an expansive wine bar and tons of storage. The rear bedroom overlooks a stunning view outside, perfect for enjoying nature's beauty. Millburn's TOP Schools, Coveted Deerfield Elementary, Parks/Recreation, Thriving Downtown, Easy NYC Commute, Access to major highways, EWR Airport under 20 mins and MORE.
MlsNumber: 3896599


Listing Provided By: RE/MAX SELECT, original listing
Name: RE/MAX SELECT
Phone: (908) 233-9292
Office Name: RE/MAX SELECT
Office Phone: (908) 233-9292
Agent Name: HUI LU
Disclaimer: Copyright © 2024 Garden State MLS, LLC. 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