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

416 Buckhorn Dr
White Twp., NJ 07823

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $559,000
Beds: 4
Baths: 3
Status: Pending
SqFt: --
Agency: remax supreme

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1994
Notes: TURNKEY HOME WITH MANY UPGRADES. HOME OFFERS A 3 SEASON SUNROOM OFF THE BREAKFAST NOOK THAT OVERLOOKS THE SPACIOUS BACKYARD! PERFACT FOR RELAXING WITH YOUR CUP OF COFFEE OR GLASS OF WINE! UPDATED KITCHEN WITH PLENTY OF CABINET SPACE, DISHWASHER, ELECTRIC STOVE, MICROWAVE, GRANITE COUNTERTOPS. KITCHEN IS OPEN TO THE BREAKFAST NOOK THAT GIVES PLENTY OF SPACE FOR ENTERTAINING. LARGE FORMAL DINNING ROOM, FAMILY ROOM, LIVING ROOM WITH FIREPLACE, 1st FLOOR LAUNDRY AERA WITH ROOMY 1/2 BATH COMPLETES THE 1st FLOOR.YOU ENTER THE HOME FROM THE STAMPED SIDEWALK TO THE ROCKING CHAIR FRONT PORCH INTO THE FOYER. UPSTAIRS YOU FIND A LARGE MASTER BEDROOM WITH FULL BATH AND WALKIN CLOSET. THERE ARE 3 OTHER BEDROOMS AND A FULL BATH ON THE 2nd FLOOR. THE FULL FINISHED BASEMENT ADDS A LOT OF ROOM FOR ENTERAINING OR JUST RELAXING. BASEMENT HAS AN OFFICE ROOM, A LARGE WINDOW TO LET IN LIGHT AND A SLIDING DOOR THE GOES OUT TO A COVERED PATIO. OUTSIDE YOU FIND A 30X40 3 BAY POLL BARN, AND ABOVE GROUND FENCED IN POOL THIS IS A LOT OF HOUSE FOR THE MONEY!! WORTH TAKING A LOOK! HOME SHOWS PRIDE OF OWNERSHIP!!
MlsNumber: 3888541


Listing Provided By: remax supreme, original listing
Name: remax supreme
Phone: (908) 213-2828
Office Name: RE/MAX SUPREME
Office Phone: (908) 213-2828
Agent Name: ROSEMARIE ADICKES
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