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;

Foreclosure: 1202 Hawthorne Court
Sewell, NJ 08080

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $189,900
Beds: 2
Baths: 2
Status: Active
SqFt: 1110
Agency: REMAX Infinity Top Achievers

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1988
Notes: ** MULTIPLE OFFER NOTICE ** Please inform all we have multiple offers and the property is being sold strictly in as is condition. make a solid offer and submit highest and best by the cut off on 04/24/2024 11:59pm MST. resubmit offer even if its the same as their initial offer. If you haven't submitted an offer and plan to do so, ensure its at best & final - as you may not get a counter. If a buyer/agent existing offer does NOT respond to the H&B by the deadline, their offer could be filed as rejected by the buyer. Any offers received after this time may not be considered. Buyers Agent must ensure that buyers financing (if any) meets as-is sale terms. Price Adjustment!! Prior buyer did not move forward signing contract. Now is your time to make a move. Come see this Upper condo at the Meadows..enjoy the large living room with fireplace, dining area, kitchen has subway tiled backsplash and features gas range and dishwasher. both baths are in good shape. bedroom have hardwood type flooring, larger bedroom features 2 good sized closets. peace full location not overlooking parking lot, great water views from outside deck. selling as-is, have your agent read you the agent remarks for sale terms. “This property is subject to the Freddie Mac First Look Initiative. The Freddie Mac First Look Initiative limits offers from being entertained during the first 30 days of listing to owner occupant and non-profit buyers. Investor offers will be responded to after the first look period ends on 04/05/2024"
MlsNumber: NJGL2039894


Listing Provided By: REMAX Infinity Top Achievers, original listing
Name: REMAX Infinity Top Achievers
Phone: (856) 722-8090
Office Name: RE/MAX ONE Realty
Office Phone: (856) 722-8090
Agent Name: Mark Petracci
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