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 = 3183 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 = 3183 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 = 3183 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;

14 Simpkins Lane
Pemberton, NJ 08068
Mr. Carmen Santo with Keller Williams Cornerstone Realty, original listing - (908) 359-0893

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $500,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2353 Square Feet
Agency: Keller Williams Cornerstone Realty
Agency Phone: (908) 359-0893

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: Welcome to Your Dream Home in the Sought-After 55+ Community of<br /> Hearthstone at Woodfield!<br /> Discover the beautifully designed Madison Model, a semi-custom ranch home<br /> by KP Construction, perfectly situated on an oversized premium corner lot. This<br /> thoughtfully crafted home offers over 2,300 sq ft of open and elegant living<br /> space, ideal for entertaining and everyday comfort.<br /> Main Level Features:<br /> • 2 spacious bedrooms, including a luxurious bedroom suite with a walk-in<br /> closet and deluxe owner’s bath.<br /> • 2 full bathrooms designed with modern finishes.<br /> • A versatile den perfect for a home office or guest space.<br /> • A gourmet kitchen with 42-inch cabinetry, a double-size center island, granite<br /> countertops, and high-end finishes.<br /> • An inviting great room and formal dining room for memorable gatherings.<br /> • Engineered hardwood floors and decorator-selected neutral paint colors<br /> throughout, creating a warm, stylish atmosphere.<br /> Second Level Highlights:<br /> • A large loft area for added flexibility.<br /> • An additional bedroom and full bath, offering privacy for guests or extended<br /> family.<br /> Premium Features and Systems:<br /> • 30-year architectural roof shingles for durability.<br /> • Energy-efficient windows with low “E” glass and a programmable thermostat.<br /> • High-efficiency gas heating, central air, and an electric hot water heater.<br /> • Stainless steel appliances, including a gas range, dishwasher, microwave, and<br /> disposal.<br /> This home is move-in ready, with taxes estimated between $7,500 and $8,500<br /> per year. <br /> Don’t miss your chance to call this stunning property home! Schedule your<br /> private showing today and experience the comfort, convenience, and charm of<br /> this exceptional residence.<br /> Owner would like to stay in home as they look for another home approx. 3 months.<br /> Owner is willing to pay rent while still occupying home.
MlsNumber: --
ListingId: NJBL2079136


Listing Provided By: Keller Williams Cornerstone Realty, original listing
Phone: (908) 359-0893
Office Phone: (908) 359-0893
Agent Name: Mr. Carmen Santo
Disclaimer: Copyright © 2025 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