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

415 Bridgeboro Road
Moorestown, NJ 08057
TINA GUERRIERI with RE/MAX 440, original listing - (609) 397-7111

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,400,000
Beds: 5
Baths: Full: 4, ½: 3
Status: Active
SqFt: --
Agency: RE/MAX 440
Agency Phone: (609) 397-7111

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Spectacular 5 bedroom, 7 bath estate home nestled on over 2 acres in prestigious Moorestown is conveniently located to Philadelphia & New York! This custom home is the epitome of luxury, with a majestic driveway, nearly 9000 sq feet on the first floor alone, radiant heated flooring throughout, a brand new roof, 7 air conditioners, 7000 sq ft partially finished basement, and a rare in-law/au pair suite. The grand marble foyer opens to the 2-story expansive great room, complete with vaulted ceilings, dramatic gas fireplace, plush carpeting, and elegant Roman columns. The awe-inspiring family room boasts coffered ceilings with dentil molding, gleaming hardwood flooring, stunning wall of windows, fabulous over-sized granite bar, movie theater with custom seating, and convenient powder room . The sundrenched gourmet kitchen features granite countertops & bar, granite island with additional storage, recessed lighting, Italian tile backsplash, ceramic tiled flooring, 2 sinks, modern pendant lighting, double oven, 5 burner gas range, and a breakfast room with exquisite chandelier. Don't forget the huge butler's pantry with full-size freezer , fridge, sink, and trash compactor. The elegant dining room is highlighted by handcrafted crystal chandelier, decadent Italian columns, gorgeous millwork, dentil molding inlay within the crown molding, tray ceiling with trim, chair rail with designer paint, bump out with 4 large windows! The cozy sitting room makes the perfect library or den, with fireplace and wall-to-wall carpeting. The first-floor office/study with built-ins can be used as a 6th bedroom. The extravagant primary suite boasts 2 massive walk-in closets, sitting room, plush carpeting, window seats with extra storage, a wall of windows overlooking the gardens, a powder room, and opulent full bathroom with water closet, Jacuzzi tub with sleek black tile surround, dual sinks, striking columns, and floor-to-ceiling tiled shower. The left wing of this grand estate has three bedrooms ( one is part of in-law suite) with huge walk-in closets, 2.5 bathrooms, full laundry room, several storage closets, and separate entrances from the back, side, and garage for your convenience. The massive basement has a bedroom with egress windows, gym with commercial grade water fountain, second office, a full bathroom, and additional nearly 6000 sq feet just waiting to be finished ! Don't miss out on your dream home!
MlsNumber: --
ListingId: 594012


Listing Provided By: RE/MAX 440, original listing
Phone: (267) 250-7649
Office Phone: (609) 397-7111
Agent Name: TINA GUERRIERI
Disclaimer: Copyright © 2025 South Jersey Shore Regional MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1770 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Real Estate Expert Photo for Sarah Johnson
Sarah Johnson
ASCIIBHHS Mount Laurel
Call Today!: (973) 757-9719

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App