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

19 Sweet Briar Court
Mullica Hill, NJ 08062

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $724,900
Beds: 4
Baths: 3
Status: Active
SqFt: 4236
Agency: Family Five Homes

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1998
Notes: Stately Brick Front Colonial nestled on a sprawling 1.23 acre lot with picturesque landscaping. This exquisite home exudes quality of construction, and elegance of todays standards. Starting with the impressive two story cathedral entrance with an Aladdin Light Lift making cleaning your new modern light fixture a breeze, as well as a newly refinished staircase, and nine foot ceilings t/o. The first floor is adorned with gorgeous oak hardwood floors, new trim, all new electrical outlets, switches, and light fixtures (t/o), and fresh comfortable paint colors. The powder room is completely remodeled with tile floor, shiplap, and all new fixtures. The Kitchen is a chef's delight with Cherry Cabinets, Granite Countertops, Tile Floor, Stainless Steel Appliances, and Recess Lighting. The Family Room Brick Fireplace with insert was whitewashed with a new added wood mantel, and ceiling fan. The Second Floor Bedrooms have all been renovated with new details such as shiplap, engineering hardwood floors, hardware, trim, ceiling fans, and some plantation shutters. The Master Bedroom and Bath (completely remodeled) are a homeowners dream! Lets not forget the freshly painted fully finished basement which adds an additional 1,224 sf to the already 3,012 sf totaling 4,236 sf. Other features include all new natural gas just completed with brand new hot water heater, new radon system, dual natural gas hvac, alarm, 12 zone sprinkler system, large covered deck, and a hot tub room. Come view this country feel beauty, you won't be disappointed!!!
MlsNumber: NJGL2040888


Listing Provided By: Family Five Homes, original listing
Name: Family Five Homes
Phone: (856) 655-8310
Office Name: Family Five Homes
Office Phone: (856) 939-0668
Agent Name: Theresa Vartebedian
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