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

1415 E Babbitt Ln
San Luis, AZ 85336
Erica Rivera with The Realty Agency - Foothills, original listing - (928) 259-7205

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2084 Square Feet
Agency: The Realty Agency - Foothills
Agency Phone: (928) 259-7205

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Take a look at this amazing opportunity at 1415 E Babbitt Lane in sunny San Luis, AZ! Priced at just $325,000, this property is perfect for anyone looking for a cozy home with great potential for earning some extra income. When you step inside, you’ll feel welcomed by bright, spacious living areas with vaulted ceilings and a charming double-sided fireplace, ideal for those family nights or hosting friends. The main house features three comfortable bedrooms and two well-equipped bathrooms, making it perfect for relaxation. Plus, there’s a delightful separate wet bar that could easily transform into a second kitchen, opening up endless possibilities! There’s more! This property includes a fully furnished attached studio with its own bathroom, perfect for guests or as a rental space to help with those bills. You’ll also appreciate the central air conditioning throughout, along with individual mini split units in each bedroom, ensuring everyone stays comfortable year-round. Set on a desirable corner lot right in the heart of San Luis, you’ll love having two living rooms and two dining areas, giving everyone plenty of space to unwind. And for your vehicles, there’s a two-car garage to keep everything secure, along with space for RVs thanks to a second double gate. Freshly painted and listed well below market value, this gem gives you a fantastic chance to start your journey in homeownership with zero down payment. Don’t let this opportunity slip away, schedule a showing today and picture your new life in this lovely San Luis retreat!
MlsNumber: --
ListingId: 20252268


Listing Provided By: The Realty Agency - Foothills, original listing
Phone: (928) 581-3681
Office Phone: (928) 259-7205
Agent Name: Erica Rivera
Disclaimer: Copyright © 2025 Yuma 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App