Frank Quismorio REALTOR®License #: CA DRE 02042675
Frank Quismorio REALTOR®License #: CA DRE 02042675
- Mobile:
- 510-945-9780
- Office:
- 510-226-2444 ext. 2445
- Email Me
Homes, Houses, Properties, | Page 1
Display only: Exclusive | Commercial | Residential
-
- 2,350,000.00
- City:
- Union City
- Zip Code:
- 94587
- Bedrooms:
- 5
- Bathrooms:
- 4
- Lot size:
- 0.12 Acres
A stunning luxury home located in the sought after Talavera community built by SummerHill Homes. The Wedgwood model boasts 5 bedrooms + loft (optional 6th bedroom) and 3,148 sq ft of living space. Conveniently offering one bedroom and bath on the lower level. Welcomed by a bright and open floor plan with rich hardwood floors, high soaring ceilings and living spaces immersed in natural light. The formal living and dining rooms flow into the back living areas.A gourmet kitchen with a large center island, granite counters and rich cabinetry. A cozy family room with fireplace and built-in shelving. A large master suite with his and hers vanities, a large soaking tub and walk-in closet. The upstairs loft provides additional living space and is perfect for a home office, play room or extra bedroom. A low-maintenance backyard retreat with a custom, covered patio and built-in BBQ - perfect for outdoor living. Walking distance to nearby Accinelli Park and Alameda Creek Trail which leads to Coyo
-
- 2,298,000.00
- City:
- Livermore
- Zip Code:
- 94550
- Bedrooms:
- 3
- Bathrooms:
- 2
- Lot size:
- 20 Acres
Welcome to the country! Two parcels approximately 20 acres located a short distance from the Livermore Valley, perched on a hill, with plenty of space and beautiful views. It is being offered for the first time in generations. Features include three-bedrooms, two-baths; the heart of this home is the kitchen with a breakfast bar and an adjoining family room and dining, making it ideal for gatherings. Indoor laundry room, new dishwasher, pellet stove fireplace, hay barn, detached garage, tack room, livestock corral, various outbuildings, and many acres to develop to your needs. 9153 Mines Road (APN: 099A-2435-004-02), approximately 19.12 acres, is included in the sale. This property enjoys easy access to Livermore's award-winning wineries and restaurants. Whether you dream of owning a ranch, a private sanctuary, or an investment property, this property offers endless possibilities for discerning buyers.
-
- 2,198,000.00
- City:
- Union City
- Zip Code:
- 94587
- Bedrooms:
- 4
- Bathrooms:
- 3
- Lot size:
- 0.17 Acres
Welcome to this stunning home located in the highly desirable Ponderosa Landing community. With a 3-car garage, the Chesapeake model boasts 4 beds, 3 baths and 2,551 sq ft of bright and open living space. Conveniently offering a full bed and bath on the lower level. A grand entry provides living and dining rooms with dramatic soaring ceilings and tall windows letting in an abundance of natural light. A newly remodeled kitchen offers a breakfast nook and large center island that flows into the cozy family room. The master bedroom includes a large, newly remodeled en-suite with his and hers closets, vanities and soaking tub. Located in a private court on a huge 7,169 sq ft lot which has been professionally landscaped with lush lawns, private patios and mature trees - perfect for outdoor living! A home that has been beautifully maintained and upgraded throughout with new LVP floors and baseboards, new interior paint, updated bathrooms, refinished cabinets, A/C and more! Served by #1 Delai
-
- 1,898,000.00
- City:
- Union City
- Zip Code:
- 94587
- Bedrooms:
- 4
- Bathrooms:
- 3
- Lot size:
- 0.14 Acres
A stunning contemporary home that has been tastefully remodeled with the finest, high-end finishes. This newly remodeled home offers a dream backyard retreat like no other and provides expansive outdoor living. Your very own park-like yard with private patios, custom built fire pit and redwood deck surrounded by gorgeous mature trees. Walk through a charming front yard entry into spacious formal living and dining rooms magnified by tall picturesque windows, high soaring ceilings all while being immersed in natural light. A brand new gourmet kitchen offers a large center island and a custom built breakfast nook. The family room offers even more living space and opens to the enchanting backyard patio - great for indoor and outdoor living. Spacious bedrooms and fully remodeled bathrooms exuding the utmost style and sophistication. Conveniently offering one bed and bath on the lower level. The custom master bath with barn door opening includes floor to ceiling porcelain tile and a large wa
-
- 1,785,000.00
- City:
- Fremont
- Zip Code:
- 94538
- Bedrooms:
- 3
- Bathrooms:
- 2
- Lot size:
- 0.14 Acres
Welcome to Maywood Street located in the highly sought Irvington District! This lovely home is situated in a family-friendly neighborhood within walking distance to three of Fremont's award winning schools (verify enrollment via FUSD). You can wake up each day to greet the sun as it rises from the east facing hills. Its 3bedroom/2 bath has many features including newly painted interior w/baseboards, oak engineered wood throughout, a gas insert fireplace for cold evenings in the winter, fully remodeled kitchen and dining combo w/refinished cabinetry & new hardware, new stone quartz counters, new vinyl flooring, new stove & above range microwave, new faucet, garbage disposal; dishwasher, new recessed LED lights throughout, new exterior door and vertical blinds. The exterior's front yard is newly landscaped with plush, fresh sod and sprinkler system with eco friendly smart plants. Also enjoy the spacious landscaped backyard with an ample storage shed, citrus fruit trees and take in the ev
-
- 1,698,500.00
- City:
- Livermore
- Zip Code:
- 94551
- Bedrooms:
- 4
- Bathrooms:
- 3
- Lot size:
- 0.26 Acres
This exquisite Livermore home has been beautifully upgraded, offering a perfect blend of elegance and modern amenities. Step inside to be greeted by vaulted ceilings and 20" tile flooring, complemented by solid fossilized bamboo floors. The dining room boasts a stunning chandelier, and real wood plantation shutters add a touch of sophistication throughout. The upgraded kitchen is a chef's dream, featuring granite slab countertops, stainless steel appliances, and double ovens, newer dishwasher. Conveniently, there is a full bedroom and bathroom on the main floor. The Primary Suite is a luxurious retreat with a cozy sitting area and dual walk-in closets. The backyard is an oasis of tranquility, featuring a spacious deck, majestic redwood and fruit trees, and a dog run complete with a custom doghouse. With ample space and privacy, it's perfect for entertaining or simply relaxing in your private sanctuary. Ideally located, this home offers easy access to commute routes, parks, shopping,
-
- 1,580,000.00
- City:
- Fremont
- Zip Code:
- 94536
- Bedrooms:
- 3
- Bathrooms:
- 2
- Lot size:
- 0.08 Acres
This Home is Attached SINGLE FAMILY HOME! Discover the home that truly has it all! Located in the prestigious Parkmont School District This is the right place for homebuyers seeking Comfort, Style, and Convenience. Close to School, Bart, CAL Train, Hospital, Restaurants!!! Inside, you’ll find an updated kitchen with modern finishes that blend style and functionality, making it a great space for both everyday cooking and entertaining. The master bedroom is a spacious sanctuary, complete with a private balcony where you can unwind and enjoy a morning tea and evening relaxation. The allure doesn’t stop inside. Step into your custom-designed backyard and find your own slice of paradise. This dreamy outdoor space features a soothing water feature, a cozy swing for lazy afternoons, and fruit trees. As night falls, the carefully placed nightlights create a magical ambiance, perfect for evening gatherings or quiet reflection. This home is waiting for you to start your next chapter in com
-
- 1,450,000.00
- City:
- Newark
- Zip Code:
- 94560
- Bedrooms:
- 3
- Bathrooms:
- 4
- Lot size:
- 0.14 Acres
Unique 3-bedroom, 4-bathroom home in Newark, featuring numerous updates and modern amenities. The home has a permitted upstairs primary bedroom with a private entrance via stairs to the side yard, an updated dual-zone heating and air system, and ensuite bathrooms for each bedroom. The spacious country kitchen includes a 6-burner gas stove, built-in oven and microwave, and a chilled Viking wine fridge. The refrigerator and all appliances are included as-is. Enjoy the newer fireplace, upgraded 225-amp electrical system, and 20 owned solar panels for energy efficiency. Recent improvements include updated dual-pane windows, a spacious redwood deck with a wheelchair ramp, and a storage shed. Ample parking is available with spacious side access for an RV or additional vehicles. The driveway and RV pad were redone 6 years ago, and the roof and gutters were replaced 4 years ago. Please note, car lifts are NOT included. Don’t miss the opportunity to own this unique home! Open House Sat & Sun
-
- 1,350,000.00
- City:
- Fremont
- Zip Code:
- 94555
- Bedrooms:
- 3
- Bathrooms:
- 2
- Lot size:
- 0.08 Acres
This beautiful home will be more beautiful if you remodel it with your own taste. Located near Hwy 880 in a quiet neighborhood, top rated schools and proximity to shops, and community pool. Your opportunity to make this house your dream home!
-
- 1,185,888.00
- City:
- Newark
- Zip Code:
- 94560
- Bedrooms:
- 3
- Bathrooms:
- 3
- Lot size:
- 0.03 Acres
Welcome to this stunning townhome, perfectly positioned at the end of a quiet cul-de-sac for added privacy. It is the only unit in the community featuring a gas fireplace, creating a cozy and inviting atmosphere. The ground floor offers a formal entry, a bedroom, and a private full bathroom. On the bright and open second floor, you’ll find a spacious living and dining area with high ceilings and large windows, ideal for entertaining. The well-appointed kitchen includes ample cabinetry, granite countertops, a large island with a breakfast bar, stainless steel appliances, a gas stove, and a pantry. This level also provides access to a large private balcony, perfect for outdoor relaxation. A convenient half bath and laundry closet are also located on this floor. The top floor boasts a luxurious primary suite, featuring a dual sink vanity, quartz countertops, tile flooring, a large step-in shower, and a walk-in closet. The third bedroom also has a walk-in closet and its own private bathr