Title Page Background
DEBUG FN args: Array ( [0] => 3182 [1] => [2] => [3] => agent ) BEFORE: Site: 3182 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3182 Igate: njhud LocID: 3182 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 = 3182 AND i.igate IN ('txhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3182 [1] => [2] => [3] => lender ) BEFORE: Site: 3182 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3182 Igate: njhud LocID: 3182 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 = 3182 AND i.igate IN ('txhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3182 [1] => [2] => [3] => other ) BEFORE: Site: 3182 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3182 Igate: njhud LocID: 3182 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 = 3182 AND i.igate IN ('txhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'txhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

2 Sacramento Court
Marlton, NJ 08053

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,900
Beds: 4
Baths:
Status: Active
SqFt: 2938 Square Feet
Agency: Century 21 Alliance-Moorestown

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: Embrace modern living in this fully updated 4 bedroom, 2 full bath and 2 half bath home located on a cul-de-sac in the very desirable Ridings of Mayfair, just a couple of miles from Demasi Elementary/Middle School. When you approach this home you will immediately see this one is special, starting with the installation of James Hardie Board and Batten exterior and addition of front porch awning, metal roof and cast iron front door with sidelights. A grand entrance awaits as you step into the two-story foyer adorned with contemporary chandelier, gleaming hardwood floors, hardwood staircase with landing to back staircase to Family area, and bright white millwork. Your eye is drawn to the living room bathed in sunlight featuring 9’ ceilings with recessed lighting. The oversized dining room is the ideal space for gatherings and special occasions. Walk thru to the renovated kitchen with quartz counter tops, subway tile backsplash, sink, faucet, undercabinet lighting, GE Café stainless steel appliances, new light fixtures and undercabinet wine refrigerator. Adding to your kitchen amenities is the addition of a new butler’s pantry/mud room used mainly as the coffee room with custom built in organization for kids backpacks. Adjacent to the kitchen is the Family Room with soaring ceiling, recessed lighting and gas fireplace. This homes living space is expanded with access the rear yard and the 18’ x 20’ back patio and awning with metal roof and EP Henry pavers along with 14’ year round Artesian Swim Spa with new rolling cover. Lots of space for family fun is this beautifully landscaped rear yard. The second floor primary bedroom with Cathedral ceiling opens to an renovated ensuite with walk in shower, free standing soaking tub and dual vanity sinks with quartz counter top. Two large closets with systems installed for your organizational needs. Three additional oversized bedrooms with ceiling fans, 2nd floor laundry and 2nd full bath, including new cabinets, quartz counter top, new tile and dual vanity complete the second floor. Finished basement with half bath, custom full bar with cabinets, sink, under cabinet refrigerator and under cabinet ice maker. In addition, this home has a newer roof, 18 new double hung windows with custom wood trim and solid wood shaker doors throughout. New high efficiency 110K BTU gas furnace, 5 ton/16SEER AC condensing unit, Humidifier and UV light air purifier. Rachio WIFI Smart Sprinkler System Controller, Two 1.25 HP Smart Belt Drive Garage Door Openers w/smart capability and camera. New Electric sump pump and water powered back up sump pump.(runs without power/electric). Lastly widening of driveway with EP Henry Cobblestone pavers and addition of concrete sidewalks to front door and back patio and pad for trash/recycling cans. Easy access to all major highways including NJ & PA turnpikes, I-295, RTE 73,70 & 38. Close to hospitals, universities and major shopping areas. 20 min to Philadelphia and 1 hour to NY make this location surperb.
MlsNumber: --


Listing Provided By: Century 21 Alliance-Moorestown, original listing
Phone: (856) 722-0880
Office Phone: (856) 235-4664
Agent Name: Diane Gervasi
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