Featured Homes
For more information on these featured homes, contact Sandi Ohms at 888-686-7467 or 510-793-1700. If you are happily working with a Realtor, give the MLS listing number to the agent and they can make an appointment to show the home.
Click here to view more featured homes for sale

![]()
38259 Parkmont Drive Fremont, CA $1595.00 per month
HOME FOR RENT. 2 bedroom 1 bath n in lovely Parkmont area of Fremont. Washer, Dryer and Refig included. New appliances, enclosed front patio and fireplace. Light and bright! Award winning schools
![]()
1426 Taughber Street
Milpitas, CA
click here for tour
4 bedroom home with in-law unit!
Unique spacious home located on huge private lot in desirable developement in Milpitas. Permited in-law unit with kichenette, private entrance and full bath. Large family room, formal dining, formal living room and parquet floors throughout. Huge lot with dual side access. $725,000
![]()
5131 Royal Palm Drive
. JUST LISTED!!!!!
Fremont, CA
This Home Is A show Stopper!
Upgraded and remodeled 4 bedroom 2/12 bath home located within walking distance to schools. Enjoy a spacious formal living room, separate formal dining area, family room with fireplace and an eat-in kitchen.
Modern neutral colors, custom drapes and cozy comfortable floor plan makes this home easy to make it your own.
Upgrades include a totally remodeled kitchen with solid surface counter tops, remodeled baths, new dual pane, new texture updated carpets and tile flooring and some raised panel doors. The Huge back yard has no rear neighbors, over sized deck and side access.
This home is not a short sale! $525,888. OPEN SATURDAY 5/8/09 1-4PM
![]()
938 Walnut Ave
Fremont, CA
TEMP OFF MARKET
Adorable newer condo with a large garage, beautiful grounds and 2 balconies. Kitchen has been completely remodeled. High end appliances, granite counter tops & cherry cabinets. Fresh paint , new carpet and bright light totally remolded bath. Unit features separate study/computer. Close to freeways shopping and bart. $329,950
![]()
2415 Constellation
Hayward, CA
SOLD
Like new! home has been refurbished thought including, marble entry, laminate floor, upgraded carpet all remodeled baths with imported tile, upgraded fixtures, fresh paint, new texture and dual pane window. Added huge master bedroom retreat with sitting area, walk-in closet and private bath. this home is truly a real find! $719,950