Easy-care living in North Modesto awaits with this updated Tudor-styled home. Features include an upgraded kitchen, newer flooring, a great room plus formal dining, 2 bedrooms, 2 full baths, spacious interior utility room plus a pool, spa and gazebo. A gated entry and low-maintenance landscaping add to the appeal. Two fireplaces, a wetbar, lots of built-ins, shutters and a garden window provide comfort and convenience. The garage is lined with cabinetry. Close to schools, shops, parks and transportation in the desired Bloomfield neighborhood, this gem could be the answer for you! Check it out soon!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Property Condition
Updated/Remodeled
Year Built
1978
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 6-10YR, Kitchen 6-10YR
Stories
1
Home Warranty
No
Directions to Property
Union west from McHenry to Marigold, then south to home or Standiford to Columbine, north to Grace and east to Marigold, then north to home
Cross Street
West Union
County
Stanislaus
Special Listing Conditions
Trust
Main Level
Bedroom(s), Living Room, Dining Room, Primary Bedroom, Full Bath(s), Garage, Kitchen, Street Entrance
Architectural Style
Contemporary, Tudor
Construction Materials
Brick Veneer, Stucco, Frame, Wood
Foundation
Raised
Roof
Composition
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Cabinets, Sink, Electric, Gas Hook-Up, Hookups Only, Inside Room
Window Features
Dual Pane Partial, Window Screens
Property Faces
East
Other Structures
Gazebo
Interior Features
Cathedral Ceiling, Storage Area(s), Formal Entry, Wet Bar
Full Bathrooms
2
Bath Features
Tile, Tub w/Shower Over, Window
# of Fireplaces
2
Fireplace Features
Living Room, Primary Bedroom, Raised Hearth, Gas Log
Flooring
Laminate, Tile
Appliances
Built-In Electric Oven, Gas Cook Top, Gas Water Heater, Dishwasher, Disposal, Double Oven
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 493050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 544950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1581 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2081 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` = 1714512 OR `props-main`.`id` = 1701553 OR `props-main`.`id` = 1712711 OR `props-main`.`id` = 1702884 OR `props-main`.`id` = 1707045 OR `props-main`.`id` = 1709418 OR `props-main`.`id` = 1718110 OR `props-main`.`id` = 1702807 OR `props-main`.`id` = 1703357 OR `props-main`.`id` = 1718355 OR `props-main`.`id` = 1716276 OR `props-main`.`id` = 1704578 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1705345 OR `props-main`.`id` = 1713162 OR `props-main`.`id` = 1717046 OR `props-main`.`id` = 1709443 OR `props-main`.`id` = 1713645 OR `props-main`.`id` = 1714803 OR `props-main`.`id` = 1718275 OR `props-main`.`id` = 1702971 OR `props-main`.`id` = 1715773 OR `props-main`.`id` = 1715774 OR `props-main`.`id` = 1714968 OR `props-main`.`id` = 1714779 OR `props-main`.`id` = 1695600 OR `props-main`.`id` = 1715603 OR `props-main`.`id` = 1714740 OR `props-main`.`id` = 1714244 OR `props-main`.`id` = 1716996 OR `props-main`.`id` = 1717161 OR `props-main`.`id` = 1693981 OR `props-main`.`id` = 1713108 OR `props-main`.`id` = 1716555 OR `props-main`.`id` = 1716998 OR `props-main`.`id` = 1715731 OR `props-main`.`id` = 1702731 OR `props-main`.`id` = 1713189 OR `props-main`.`id` = 1701671 OR `props-main`.`id` = 1713777 OR `props-main`.`id` = 1717568 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1712732 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1716594 OR `props-main`.`id` = 1714912 OR `props-main`.`id` = 1716436 OR `props-main`.`id` = 1694971 OR `props-main`.`id` = 1717181 OR `props-main`.`id` = 1703391 OR `props-main`.`id` = 1717240 OR `props-main`.`id` = 1702834 OR `props-main`.`id` = 1711297 OR `props-main`.`id` = 1713355 OR `props-main`.`id` = 1714453 OR `props-main`.`id` = 1705003 OR `props-main`.`id` = 1705009 OR `props-main`.`id` = 1717959 OR `props-main`.`id` = 1713621 OR `props-main`.`id` = 1717960 OR `props-main`.`id` = 1717558 OR `props-main`.`id` = 1709776 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1705257 OR `props-main`.`id` = 1715828 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1717149 OR `props-main`.`id` = 1713251 OR `props-main`.`id` = 1711379 OR `props-main`.`id` = 1694633 OR `props-main`.`id` = 1713442 OR `props-main`.`id` = 1714806 OR `props-main`.`id` = 1699969 OR `props-main`.`id` = 1718356 OR `props-main`.`id` = 1716808 OR `props-main`.`id` = 1716418 OR `props-main`.`id` = 1716203 OR `props-main`.`id` = 1712487 OR `props-main`.`id` = 1704269 OR `props-main`.`id` = 1711435 OR `props-main`.`id` = 1694579 OR `props-main`.`id` = 1694304 OR `props-main`.`id` = 1705005 OR `props-main`.`id` = 1713231 OR `props-main`.`id` = 1715564)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226023847' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-26' 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();
5
Similar Properties
$530,000
4
2
1,772
0.13
2012 Spring Ln
Modesto, CA 95356
$499,000
3
2
1,680
0.15
3417 John Lee Ln
Modesto, CA 95350
$499,000
3
2
1,684
0.17
1600 Fairington Ln
Modesto, CA 95355
$495,000
4
3
1,710
0.15
1534 Bay Meadows Dr
Modesto, CA 95350
Courtesy of Denise Royer, Berkshire Hathaway HomeServices-Drysdale Properties 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.
