This stunning 5-bedroom, 3-bathroom with one bedroom with full bath on the main floor, home offers the perfect blend of modern upgrades, comfort, and prime location. Sitting on almost quarter acre corner lot, recently updated with new granite countertops, fresh laminate and carpet, fresh interior & exterior paint. Step inside to discover soaring high ceilings that enhance the open and airy feel, while the laminate flooring adds warmth and style throughout the main living areas. The kitchen has been refreshed with granite countertops, new backsplash and stainless steel appliances, making it ideal for both everyday meals and entertaining guests. The spacious primary bedroom with sitting area with Extra large walk-in-closet and plenty of natural light. All bedrooms are large and two with walk-in-closets. Large Backyard with plenty of room for RV Access. Solar is on power purchase agreement. Home is located near Costco and a brand-new shopping center just five minutes away, plus quick two-minute freeway access for an easy Bay Area commute. With its stylish updates and unbeatable location, this home is a perfect choice for modern living. COME SEE!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
Fixer
Year Built
2003
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 0-5YR, Other-Rmks 0-5YR
Stories
2
Home Warranty
No
Directions to Property
From E Yosemite Ave to Vasconcellos Ave to Valenzuela Ct
Cross Street
Vasconcellos Ave
County
San Joaquin
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Full Bath(s), Garage, Kitchen
Construction Materials
Frame
Foundation
Slab
Roof
Tile
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Ground Floor, Inside Room
Full Bathrooms
3
Bath Features
Closet, Double Sinks, Tub w/Shower Over, Window
# of Fireplaces
2
Fireplace Features
Insert, Primary Bedroom, Family Room
Flooring
Carpet, Laminate, Tile
Appliances
Gas Cook Top, Gas Water Heater, Dishwasher, Microwave, Double Oven
Kitchen Features
Breakfast Area, Butlers Pantry, Granite Counter, Island w/Sink
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 693452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 766447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3055 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3555 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1675425 OR `props-main`.`id` = 1673773 OR `props-main`.`id` = 1682161 OR `props-main`.`id` = 1675423 OR `props-main`.`id` = 1675424 OR `props-main`.`id` = 1688058 OR `props-main`.`id` = 1694671 OR `props-main`.`id` = 1684674 OR `props-main`.`id` = 1668258 OR `props-main`.`id` = 1653098 OR `props-main`.`id` = 1697684 OR `props-main`.`id` = 1695258 OR `props-main`.`id` = 1692837 OR `props-main`.`id` = 1697589 OR `props-main`.`id` = 1679946 OR `props-main`.`id` = 1697532 OR `props-main`.`id` = 1694427 OR `props-main`.`id` = 1668592 OR `props-main`.`id` = 1693112 OR `props-main`.`id` = 1690542 OR `props-main`.`id` = 1691242 OR `props-main`.`id` = 1694439 OR `props-main`.`id` = 1691965 OR `props-main`.`id` = 1693087 OR `props-main`.`id` = 1694823 OR `props-main`.`id` = 1692496 OR `props-main`.`id` = 1684638 OR `props-main`.`id` = 1685463 OR `props-main`.`id` = 1690648 OR `props-main`.`id` = 1683947 OR `props-main`.`id` = 1697360 OR `props-main`.`id` = 1686639 OR `props-main`.`id` = 1696774 OR `props-main`.`id` = 1692926 OR `props-main`.`id` = 1668392 OR `props-main`.`id` = 1697607 OR `props-main`.`id` = 1642548 OR `props-main`.`id` = 1603454 OR `props-main`.`id` = 1687813 OR `props-main`.`id` = 1695237 OR `props-main`.`id` = 1622931 OR `props-main`.`id` = 1665617 OR `props-main`.`id` = 1688524 OR `props-main`.`id` = 1696720 OR `props-main`.`id` = 1696690 OR `props-main`.`id` = 1697201 OR `props-main`.`id` = 1693636 OR `props-main`.`id` = 1679551)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225092302' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Courtesy of Sukhwinder Deol, CV Realty IDX provided by Reliance Marketing
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
