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

5910 W Saginaw Highway
Sunfield, MI 48890
Ruben Sauceda with Great America Brokers LLC, original listing - (517) 323-3200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $199,900
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1488 Square Feet
Agency: Great America Brokers LLC
Agency Phone: (517) 323-3200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1972
Notes: SEE ATTACHED 1ST LOOK & OFFER INSTRUCTIONS SEE MORE ON PUBLIC REMARKS Agent Remarks: Insert RES.NET offer submission instruction from the MLS Printout Request task. Financed offers must include: POF & Lender Pre-approval Letter. Cash offers must include POF. Corporate offers must include Corporate Resolution reflecting authorized signer. Buyer(s) to verify Sq Ft. of lot and structure. Property SOLD ''AS-IS''. Offers will be reviewed after 7 days on the market unless you receive other instruction from your REO Specialist. SEE ATTACHED OFFER INSTCTIONS AND Offers will be reviewed after 7 days on the market. This Property was previously financed by a mortgage loan that was insured by the U.S. Department of Housing and Urban Development ("HUD") and requires 30-day priority purchase period for Owner-Occupant buyers, Eligible Nonprofit Organizations, and governmental entities. Applicable buyers must submit the Notice of Interest document for offer review. (See Offer Instructions as attached). First Look Offerees will be granted a 10-business day due diligence (inspection) period from the date of notice. First Look Offerees have the right to waive this due diligence period or shorten it. Investor offers can be accepted after 31 days on market. All offers must be submitted by the Buyer's agent via the RES.NET Agent Portal. If your offer is accepted, you agree to be responsible for an offer submission technology fee of $150. The fee will be collected and disbursed by the settlement agent and disbursed at the closing and settlement of the transaction. To submit your buyer's offer, simply click the link (https://agent.res.net/Offers.aspx?-1802539). If you already have a RES.NET Agent account, you will be prompted to log in. If not, you will be prompted to create an account. Financed offers must include: POF & lender pre-approval letter. Cash offers must include POF. Corporate offers must include Corporate Resolution reflecting authorized signer. Buyer(s) to verify Sq. Ft. of lot and structure. Property SOLD "AS-IS".
MlsNumber: --
ListingId: 287358


Listing Provided By: Great America Brokers LLC, original listing
Phone: (517) 819-7123
Office Phone: (517) 323-3200
Agent Name: Ruben Sauceda
Disclaimer: Copyright © 2025 Greater Lansing Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1257 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Real Estate Expert Photo for BRIAN SUTTON
BRIAN SUTTON
ASCIIeXp Realty
Call Today!: (904) 476-6756

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App