Special offer

GORGEOUS NILES FOOTHILLS HOME AT 38624 PICKERING COURT, FREMONT, CA.

By
Real Estate Agent with The Medford Real Estate Team DRE#01223788

The Medford Team’s newest listing is a gorgeous Niles Foothills home at 38624 Pickering Court, Fremont, Ca.

Nestled in a quiet court, this five bedroom, three-and-one-half bath home includes an upscale gourmet kitchen with granite countertops, soaring ceilings, 2 wood-burning fireplaces, a three car garage and a lovely yard. Solar panels reduce electricity bills to almost nothing! The house includes new two-zone high-efficiency furnaces/AC units.

 Front of house

 Entry

Living Room

Kitchen

Master Bedroom

Master Bath

Yard

Yard

This home boasts a romantic setting; old world styling with a contemporary twist … and all the modern amenities today’s discerning executives demand. Factor in a secluded court location and views of the surrounding hills – it doesn’t get any better than this!

The home will be held open this Saturday and Sunday, July 21 & 22, from 1-4. The home is also available for viewing by appointment with the listing Realtor or with your Realtor.

Jeri & Henri Gutner
Realty One Group Legacy - Doylestown, PA
CRS,GRI

Nice looking home. Good luck with it. Hope you sell it soon.

Jul 20, 2012 01:31 AM
Michael Jacobs
Pasadena, CA
Pasadena And Southern California 818.516.4393

Hi John --- nice presentation of this new listing at 38624 Pickering Court in Fremont --- hope the open house event results in an accepted offer and a closed transaction.  Good luck!

Jul 21, 2012 01:46 AM
Pacita Dimacali
Alain Pinel - Oakland, CA
Alameda/Contra Costa Counties CA

John

Wow! That home is exceptionally sharp. Really looks great. And should sell quickly. Congrats on a wonderful listing.

Jul 24, 2012 03:08 PM
Hella Mitschke Rothwell
(831) 626-4000 - Honolulu, HI
Hawaii & California Real Estate Broker

John: Congratulations on this fabulous listing that shows so well. This won't be long on the market, I am sure.

Jul 26, 2012 04:52 PM
John Juarez
The Medford Real Estate Team - Fremont, CA
ePRO, SRES, GRI, PMN

Sold 10-12-12 for $975,000.                                                            .

Oct 13, 2012 01:06 AM