This expansive new construction single-story at Artisan at Griffin Park offers effortless luxury with an open-concept layout, 10' ceilings, and a designer kitchen featuring a waterfall quartz island, gas cooktop, and French Walnut cabinets. The Primary Suite is a peaceful retreat with a spa-style shower, dual sinks, and a walk-in closet connected to the laundry room. Enjoy a covered patio, EV outlet, low-maintenance yard, and corner homesite privacy. Best of all, ultra-low property taxes mean more buying power. Close proximity to Hwy 99, I-5, and the ACE Train streamline the Bay Area commute. Perfect for those ready to simplify life without compromising on style. Come see it in person this home truly stands out!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached, Tract
Property Condition
New Construction
Year Built Details
New
Year Built Source
Builder
Remodeled/Updated
No
Stories
1
Levels
One
Home Warranty
Yes
Directions to Property
Google maps location: https://maps.app.goo.gl/ec6x8GddSxFu2zd9A
Cross Street
Bharvani Avenue
County
San Joaquin
Special Listing Conditions
None
Builder Name
Raymus Homes
Builder Model
The Carpenter
Main Level
Bedroom(s), Living Room, Primary Bedroom, Full Bath(s), Partial Bath(s), Garage, Kitchen, Street Entrance
Architectural Style
Contemporary
Construction Materials
Stone, Stucco
Foundation
Concrete, Slab
Roof
Tile
Heating
Central, Natural Gas
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Electric, Hookups Only, Inside Room
Window Features
Dual Pane Full, Low E Glass Full
Property Faces
North
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Split Bath, Tile, Low-Flow Shower(s), Low-Flow Toilet(s), Tub w/Shower Over
Flooring
Carpet, Laminate, Tile
Appliances
Gas Cook Top, Gas Plumbed, Hood Over Range, Dishwasher, Disposal, Microwave, Plumbed For Ice Maker, Tankless Water Heater
Room Type
Primary Bathroom, Primary Bedroom, Great Room, Kitchen, Laundry
Kitchen Features
Pantry Closet, Quartz Counter, Slab Counter, Island, Island w/Sink
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 691590.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 764389.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2031 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2531 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` = 1697546 OR `props-main`.`id` = 1697547 OR `props-main`.`id` = 1697657 OR `props-main`.`id` = 1695917 OR `props-main`.`id` = 1697548 OR `props-main`.`id` = 1690179 OR `props-main`.`id` = 1697484 OR `props-main`.`id` = 1695310 OR `props-main`.`id` = 1695312 OR `props-main`.`id` = 1697900 OR `props-main`.`id` = 1694189 OR `props-main`.`id` = 1690716 OR `props-main`.`id` = 1695539 OR `props-main`.`id` = 1683143 OR `props-main`.`id` = 1695252 OR `props-main`.`id` = 1689813 OR `props-main`.`id` = 1697594 OR `props-main`.`id` = 1697614 OR `props-main`.`id` = 1689495 OR `props-main`.`id` = 1697655 OR `props-main`.`id` = 1685456 OR `props-main`.`id` = 1683164 OR `props-main`.`id` = 1693150 OR `props-main`.`id` = 1697486 OR `props-main`.`id` = 1684051 OR `props-main`.`id` = 1688276 OR `props-main`.`id` = 1689365 OR `props-main`.`id` = 1669591 OR `props-main`.`id` = 1675425 OR `props-main`.`id` = 1673773 OR `props-main`.`id` = 1682161 OR `props-main`.`id` = 1669590 OR `props-main`.`id` = 1669592 OR `props-main`.`id` = 1675423 OR `props-main`.`id` = 1697361 OR `props-main`.`id` = 1688218 OR `props-main`.`id` = 1675424 OR `props-main`.`id` = 1688058 OR `props-main`.`id` = 1691793 OR `props-main`.`id` = 1690211 OR `props-main`.`id` = 1684674 OR `props-main`.`id` = 1655083 OR `props-main`.`id` = 1692893 OR `props-main`.`id` = 1697356 OR `props-main`.`id` = 1668258 OR `props-main`.`id` = 1694066 OR `props-main`.`id` = 1691195 OR `props-main`.`id` = 1659677 OR `props-main`.`id` = 1653098 OR `props-main`.`id` = 1679371 OR `props-main`.`id` = 1693995 OR `props-main`.`id` = 1689349 OR `props-main`.`id` = 1697684 OR `props-main`.`id` = 1674365 OR `props-main`.`id` = 1695264 OR `props-main`.`id` = 1697649 OR `props-main`.`id` = 1685437 OR `props-main`.`id` = 1697632 OR `props-main`.`id` = 1684828 OR `props-main`.`id` = 1697466 OR `props-main`.`id` = 1697668)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225142572' 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 Marie Raymus, Raymus Realty Group 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.
