Rogerprasad.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

Listing courtesy of Janki Patel from Y Realty. 925-989-8998

$1,198,000

Welcome to this Northeast facing 3021 Gettysburg Common, in a brand new Lincoln townhome community located near the Fremont Irvington Five Corners, the commercial heart of the Irvington District. Fremont Central Park, Kaiser and Washington Hospital, Safeway, Apni Mandi, and the future Irvington BART station, are all nearby. It's the most convenient location you can find, and yet it's on a quiet street. Excellent Durham elementary. Pre-installed high voltage electric car charging outlet. The natural lighting of these East and Northeast facing townhomes is excellent. Each unit has a first level bedroom. Very spacious 2nd level great room boasts a large kitchen and a central island. 3 additional bedrooms overlook the community on the third level. Solar system is already pre-installed with an additional cost to purchase. High end finishes found only in model homes from other bigger builders: smooth wall finish, not orange peel, stairs with hard surface, not carpet, kitchen cabinets with hardwood, backsplash, shower wall slabs, and pavers in yard. The official address is 3721 Gettysburg Common, 94538, but this new address is not searchable on most maps, hence the use of 40857 Lincoln Ave. Pictures from 3701, same floor plan. Some rooms are of irregular shapes.

4 Beds ⋅ 4 Baths ⋅ 41142088 MLS

3721 Gettysburg Common, Fremont

Listing courtesy of Charles Liu from Compass. 510-938-6668