Christyherndon.com Search Results

$2,288,888

Large 19,516 lot size SB 9 possibilities (check with city of Fremont)Build 2 additional ADU’s plus another home in the historic area of Niles. This exquisitely rebuilt custom home (10 years ago) designed by a local architect sits on a flat 19516 sqft lot (rare to find in Fremont) and blends refined craftsmanship with modern innovation to create a truly elevated living experience, including all-new copper plumbing, complete electrical upgrades, and earthquake retrofitting per code—the home delivers the peace of mind, modern build with the elegance of curated luxury finishes. New exterior and interior paint, rich Cali Bamboo wood flooring, Brazilian Taj Mahal countertops, and Level 5 interior wall finishes set a tone of luxury. The chef’s kitchen is a masterpiece, featuring a professional Thermador gas cooktop, Wi-Fi–enabled Thermador Sapphire dishwasher, under-cabinet remote-controlled LED lighting, and a premium Samsung 34.3 cu. ft. refrigerator. Every detail has been considered, from upgraded outlets capable of powering multiple appliances to two 240-volt outlets, including EV charging readiness. The home’s advanced systems elevate everyday living: CAT6 networking, a Dolby Atmos 9.1 fiber-to-HDMI audio system, Puronics whole-house and under-sink filtration, filtered tankless hot/cold water access, and premium bidets with heated seats, heated water, filtration, and air-drying. A HeavyLux frameless shower enclosure adds spa-level luxury. Climate comfort is ensured with a Lennox Elite two-stage furnace, Lennox PureAir purification system with UV and MERV-16 filtration, Lennox Elite AC, and a padded attic for effortless filter access. Energy efficiency is exceptional, powered by 27 solar panels generating 11.06 kWh, a 26 kWh solar battery system, and a dedicated solar control panel. Natural light pours through four Velux skylights, each equipped with solar panels and remote/app-controlled shades. Outdoor spaces impress with extensive Basalite pavers, an outdoor office building/gym to an oversized 2 car garage - paved circular driveway, 2 storage sheds, veg garden, 2 patios for entertainment, a beautiful four seasons sunroom designed by California sunrooms, living sq feet includes sunroom (all done with permits), outdoor office building/gym, possibilities are endless. Open House Aug 29 -30, 1 - 4 pm

4 Beds ⋅ 2 Baths ⋅ 41146178 MLS

35596 Linda Dr, Fremont

$899,000

Move-in-ready home filled with thoughtful updates inside and out. Recent improvements include refreshed paint, updated lighting, new electrical outlets throughout, an updated HVAC system, new water heater, new sewer line, and updated bathrooms. The kitchen is a standout, featuring stone countertops, a bright skylight, generous cabinet storage, and convenient pull-out drawers. It flows seamlessly into the dining area and bonus room, creating an inviting layout for everyday living and entertaining. The front living room offers a cozy wood-burning fireplace with a mantle and screen, a perfect spot to unwind or gather with friends and family. This home features 3 bedrooms and 2 full bathrooms that have been tastefully updated. The versatile bonus room is ideal as a TV room, game room, home office, or additional living space. French doors open directly to the backyard, while tile flooring, two closets, and a dedicated wall A/C unit add comfort and functionality. The outdoor spaces received a complete refresh in 2025, with both the front and back yards revamped to create welcoming, low-maintenance spaces to enjoy. The backyard features a raised deck, covered patio, perfect for outdoor dining, entertaining, or simply relaxing. With major improvements already completed: including the HVAC system, water heater, sewer line, bathrooms, landscaping, paint, lighting, and more, this truly turn-key home is ready for its next chapter. Don’t miss it!

3 Beds ⋅ 2 Baths ⋅ 41145612 MLS

982 Ventura Ave, Livermore