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

6 Clover Hill Circle
Trenton, NJ 08638

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $449,900
Beds: 4
Baths: 3
Status: Pending
SqFt: 2280
Agency: RE/MAX InStyle Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1962
Notes: Welcome to this meticulously maintained home that offers both space and potential! Nestled in a tranquil neighborhood, this charming residence boasts four bedrooms, two and a half bathrooms, and a wealth of opportunities for customization.<br /> <br /> Inside, you'll find hardwood floors hiding underneath of the carpet throughout most of the main and upper levels, creating an inviting atmosphere. The main level living area, while it does not have hardwood floors, is perfect for entertaining guests or simply unwinding after a long day. The couch and TV with surround sound speakers can be included in the sale if you wish!<br /> <br /> The kitchen is in incredible shape and offers ample cabinetry and counter space, providing a delightful culinary experience. Adjacent to the kitchen, you'll find a generously sized dining area for all your family meals.<br /> <br /> Upstairs, you'll discover a serene master bedroom complete with an ensuite bathroom, along with three additional bedrooms and a half bathroom. This half bath includes rough plumbing for a shower insert, offering the convenience of potentially adding a third full bathroom.<br /> <br /> One of the highlights of this home is the large three-season sunroom, providing the perfect spot to relax and enjoy the outdoors from the comfort of your home. Outside, the wicker patio furniture is being offered with the sale, offering a delightful space to soak up the sun or host outdoor gatherings.<br /> <br /> Completing this home is a full basement and an attached garage, offering plenty of storage space and convenience.<br /> <br /> With its prime location, spacious layout, and endless possibilities for customization, this home presents a rare opportunity to create the perfect haven tailored to your lifestyle. Don't miss out on making this your dream home! BEST AND FINAL OFFERS DUE THURSDAY 4/18 AT 5PM!
MlsNumber: NJME2041704


Listing Provided By: RE/MAX InStyle Realty, original listing
Name: RE/MAX InStyle Realty
Phone: (609) 303-3456
Office Name: RE/MAX Instyle Realty Corp
Office Phone: (609) 303-3456
Agent Name: Joseph Valenti
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