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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

207 E Orchard Street
Santa Maria, CA 93454

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $309,000
Beds: 2
Baths: 2
Status: Active
SqFt: 861
Agency: eXp Realty of California Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1962
Notes: Attention investors! Don't overlook this charming two-story condo nestled in the desirable Rancho Gardens community. Step into your own private sanctuary with a fenced patio, perfect for hosting delightful backyard barbecues. This cozy abode features 2 bedrooms, 1 and 1/2 baths, making it an ideal haven for first-time homebuyers or savvy investors looking to capitalize on its market-aligned rental potential.Investors, take note! This property presents a lucrative investment opportunity with long-term tenants already in place. Convenience meets comfort with onsite community laundry and a detached carport. Enjoy the perfect balance of affordability and allure, with nearby amenities including shopping, dining, and schools just a stone's throw away. Plus, with easy access to Highway 101, your investment portfolio is effortlessly streamlined.Embark on the exciting journey of property investment with this impeccable opportunity as your starting point. Seize the chance to make this place your own, where every corner is filled with possibility and charm. Your dream investment property awaits in Rancho Gardens--schedule your viewing today!Seller intends to perform an IRS Section 1031 tax-deferred exchange. Seller requests buyer's cooperation in such an exchange and agrees to hold buyer harmless from any and all claims, costs, liabilities, or delays in time resulting from such an exchange. All information is deemed reliable but not verified.
MlsNumber: 24000318


Listing Provided By: eXp Realty of California Inc., original listing
Name: eXp Realty of California Inc.
Phone: (888) 584-9427
Office Name: eXp Realty of California, Inc.
Office Phone: (925) 565-7065
Agent Name: Lisa Bognuda
Disclaimer: Copyright © 2024 North Santa Barbara County Regional 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