Homes, Houses, Properties, Fremont | Page 1

Save Search
  • 2465 TECADO TER, 40873183, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    10,860,000.00
    City:
    FREMONT
    Bedrooms:
    6
    Bathrooms:
    7 + 2
    Lot size:
    20.68 Acres

    "Stunning" 360 degree panoramic gated view estate!INCREDIBLE L Separate indoor pool/spa house with kitchen, sitting areas, full bath, dressing room & laundry rm. Office, game rm, media rm, 3 kitchens, 3 laundry rms, all new SS appliances, newly staged with owned new furniture. Available to Buyer if desired! Just completed new additional deck and DOUBLE SS BBQ. 1600 rose trees, many fruit trees, incredible view of Bay & City lights, Silicon Valley, San Jose, & more. "PERFECT FOR PRIVATE ESTATE & OR A CORPORATE RETREAT!" Possible to build more STRUCTURES on the property. By appointment 48 hours notice. 3 gates lead to the estate! Privacy and Serenity! Obstacle course & archery range too. Best of the Best! Perfect for the Young or Young at heart. Master on main floor. Solar! Country feel yet City Close. PERFECT FOR PRIVATE ESTATE OR CORPORATE RETREAT!

  • 867 Boar Ter, 40883325, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    6,798,000.00
    City:
    FREMONT
    Bedrooms:
    5
    Bathrooms:
    5 + 1
    Lot size:
    2.93 Acres

    A gated entry opens to this opulent, approximately 3-acre estate with magnificent grounds and a contemporary custom home. Inside, enjoy a 30-foot foyer flooded in natural light, custom windows, Brazilian walnut hardwood floors, a gourmet kitchen and stainless-steel chef kitchen. A great room, master suite with bay views, a piano room, library, entertainment room and media room round out the interior. Outside is an outdoor kitchen, fruit trees, putting green, saltwater system infinity edge pool, tennis and basketball courts and green house. Details like built-in wine cooler and storage, 15 art niches, Lutron system, heated bathroom floors and multiple balconies make this Mission Hills area energy-efficient home unforgettable.

  • 43223 Calle Dolorosa, 40884135, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    4,698,000.00
    City:
    FREMONT
    Bedrooms:
    4
    Bathrooms:
    3 + 2
    Lot size:
    0.65 Acres

    Meticulously restored and completely renovated by Robson Homes, the Starr House is a one-of-a-kind home that offers the unique opportunity to own a pristine grand estate in a private park setting. Originally built in the 1920’s, this registered historic home is tucked away in the over 5.4 acre Gardens of Palmdale in Fremont’s prestigious Mission District. Radiating with historic character and refined luxury, the nearly 6,000 square foot estate opens to sprawling lawns and majestic trees in a setting that is quite simply breathtaking. The estate includes a 4 bedroom, 3 full + 2 half bath, 4,642 sf home plus a detached 2-car garage with a 2 bedroom, 1 bath, 1,311 square foot guest unit. The guest unit has a unique address, perfect for a rental. This home offers the very best in luxury homebuilding and design with the charm and character only found in historic homes. There are also significant property tax benefits associated with this historic home.

  • 45901 Hidden Valley Ter, 40885993, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    4,680,000.00
    City:
    FREMONT
    Bedrooms:
    4
    Bathrooms:
    5 + 1
    Lot size:
    0.81 Acres

    Secluded, private oasis on a 35,164 sq. ft. lot. Spanish-style custom home features approx. 5,000 sq. ft. of interior living space adorned with marble and maple wood floors, crown molding, fireplaces, high ceilings and plantation shutters. Flooded w/ natural light.Newly remodeled gourmet kitchen w/ island, custom Carrara marble, Sub-Zero and Thermador appliances , butler bar, and large walk-in pantry. Family room opens to resort-inspired backyard with large pool of Italian tile, fountain and cabana w/ kitchen, bath, fireplace, limestone flooring, fans. Luxury abounds on 2nd level – spacious master suite w/ retreat, double-faced fireplace and updated master bath; 3 additional suites and multiple balconies accented w/ wrought iron offering stunning bay and hill views; bonus room w/ wet bar and wine cooler. Enjoy a 4-car garage, fire, security systems, custom lighting, vacuum system, computerized utilities. The home’s nearby creek adds to its Feng Shui. Tranquility at its finest.

  • 3101 Driscoll Rd, 40884587, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    4,288,888.00
    City:
    FREMONT
    Bedrooms:
    9
    Bathrooms:
    5
    Lot size:
    0.64 Acres

    This is truly a unique house with a rich history and providence. Built in the early 1850s, this Greek Revival home is the HORNER HOUSE, one of the oldest homes on California’s Register and is pending on the National Register. The perfect blend of artistic craftsmanship and modern amenities. Meticulous restored, renovated and updated including electrical, plumbing, irrigation and insulation. Eligible for Mills Act, May be eligible reduced property tax. Totally modernized interior, chef style kitchen with custom cabinetry, stunning granite slabs, and updated bathrooms bring all of todays’ comforts and conveniences you can want. Private apartment over garage and separate duplex brings multiple options for investment or housing all with privacy. Located in Mission school boundaries on over 0.65 acres of secluded land creating the ideal environment for entertaining or enjoying the well-designed mature landscaping as your own personal retreat. Located near shopping, dining, and commuting.

  • 350 Mayhews Rd, 40875624, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    3,800,000.00
    City:
    FREMONT
    Bedrooms:
    3
    Bathrooms:
    2
    Lot size:
    221.495 Ac...221.495 Acres

    City ranch 221 acres of endless possibilities in the beautiful Niles Hills of Fremont with 180 ft fronting on Mission Blvd. One residential lot APN 507-95-6 has a 3 Bedroom, 2 Bath, 1,752 sq ft single family home on it. Vast trail system with landings along the private paved road and flat staging area approximately 4 ac located 1/4 mile above home. Trail thru open meadow, wooded trails. This listing is for APN numbers 507-0085-005, 507-0085-021, 507-0085-024, 507-0095-006, 507-0095-007, 507-0095-009. POSSIBLE OWNER FINANCING - DON'T MISS THE CHANCE!

  • 42300 Vargas Rd, 40860501, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    3,500,000.00
    City:
    FREMONT
    Bedrooms:
    7
    Bathrooms:
    3
    Lot size:
    3.58 Acres

    Fremont Hills - Approximately 105 acres +/- with two separate addresses: 42300 and 42290 Vargas Road. Owner occupied 5 bedroom 3 bath mobile home plus 3 bedroom 2 bath modular home (on foundation) included. City water, electric, gas, septic all on the property. Larger parcel is currently being rented for cattle grazing. Excellent access to I-680 North and South. Potential is endless – There are many custom built homes in the area and this could be a great estate property for the Silicon Valley executive or for a custom home builder. ***$3,500,000. PRICE INCLUDES: PARCEL #513-160-1-18 (100.61 ACRES) #513-160-1-8 (.69 ACRES), 513-160-1-14 (.14 ACRES), 513-160--1-17 (3.58 ACRES)***. Property is currently in the Williamson Act and subject to City of Fremont guidelines. Potential buyers should verify with the City and/or County for specifics.

  • 338 Harvard Common, 52204365, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    3,199,888.00
    City:
    FREMONT
    Bedrooms:
    5
    Bathrooms:
    4 + 1
    Lot size:
    0.2058 Acres

    Situated on a tree-lined cul-de-sac minutes from the city- A sprawling, two-story Mediterranean-style stunner boasts 5 bedrooms, 4.5 bathrooms & a 3 car garage with a detached second-floor in-law unit. Across the threshold, glossy hardwood floors set the stage for arched entryways & soaring ceilings. A formal living room continues to a study with custom built-ins, sleek kitchen appointed & quartz countertops, subway tile backsplash, & stainless-steel appliances. A sunny dining area, fireplace-clad family room, & guest bedroom with en-suite bath completes the first floor. The second-floor houses three additional bedrooms, a master suite with soaking tub, stall shower, & two walk-in closets. A detached in-law unit offers a full bath, bedroom, living/dining area, & kitchen. Set against Fremont's rolling hills, situated in a secluded pocket of homes for the ultimate privacy, & walking distance to Top Rated Schools. Total square footage includes detached in law unit of 750 ft +/-

  • 338 Harvard Cmn, 40877124, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    3,199,888.00
    City:
    FREMONT
    Bedrooms:
    5
    Bathrooms:
    4 + 1
    Lot size:
    0.21 Acres
  • 2528 Rutherford Ct, 40879865, FREMONT, Detached,  for sale, Alison Hull, REALTY EXPERTS®
    3,198,000.00
    City:
    FREMONT
    Bedrooms:
    5
    Bathrooms:
    4 + 2
    Lot size:
    0.5 Acres

    Wow! Custom Vineyard Heights home on a half-acre corner lot. Approx. 5,550 sq ft w/ 5 bedrooms (one w/ private entrance), 4 and 2 half baths, and a gourmet kitchen complete with Sub Zero refrigerator, stainless steel appliances, wine cooler, large pantry and a reverse osmosis system. Separate study/playroom, large family room, living and dining rooms, plus pool room w/ tournament pool table. Master suite: fireplace, deck w/ 20-ft swim spa, walk-in closet, dressing area, 2 ceiling fans, granite countertops, double sinks, radiant floor heating, heated shower floor and seat, radiant heat towel warmer and Jacuzzi tub. Three bedrooms open onto approx. 2,500 sq ft of Trex decking. Radiant floor heating, two 5-ton HVAC systems, custom brick BBQ, porte cochere, security system, fire sprinklers, two 2-car garages, RV garage, workshop (11 ft by 33 ft), side access for boat storage, and automatic lawn sprinkler and central vacuum systems. New carpets, shutters, hardwood floors, tile and paint.

Have Questions?

reCAPTCHA