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` = 1712044 OR `props-main`.`id` = 1701553 OR `props-main`.`id` = 1713620 OR `props-main`.`id` = 1712711 OR `props-main`.`id` = 1712707 OR `props-main`.`id` = 1702884 OR `props-main`.`id` = 1707045 OR `props-main`.`id` = 1676376 OR `props-main`.`id` = 1711219 OR `props-main`.`id` = 1709418 OR `props-main`.`id` = 1694651 OR `props-main`.`id` = 1702807 OR `props-main`.`id` = 1703357 OR `props-main`.`id` = 1704578 OR `props-main`.`id` = 1689622 OR `props-main`.`id` = 1705345 OR `props-main`.`id` = 1713162 OR `props-main`.`id` = 1709443 OR `props-main`.`id` = 1713645 OR `props-main`.`id` = 1713232 OR `props-main`.`id` = 1702432 OR `props-main`.`id` = 1695775 OR `props-main`.`id` = 1713463 OR `props-main`.`id` = 1702971 OR `props-main`.`id` = 1697912 OR `props-main`.`id` = 1713190 OR `props-main`.`id` = 1713392 OR `props-main`.`id` = 1690717 OR `props-main`.`id` = 1712347 OR `props-main`.`id` = 1712302 OR `props-main`.`id` = 1711357 OR `props-main`.`id` = 1695600 OR `props-main`.`id` = 1712295 OR `props-main`.`id` = 1703119 OR `props-main`.`id` = 1712267 OR `props-main`.`id` = 1711764 OR `props-main`.`id` = 1713353 OR `props-main`.`id` = 1710175 OR `props-main`.`id` = 1713699 OR `props-main`.`id` = 1693981 OR `props-main`.`id` = 1713108 OR `props-main`.`id` = 1713434 OR `props-main`.`id` = 1702731 OR `props-main`.`id` = 1713189 OR `props-main`.`id` = 1701671 OR `props-main`.`id` = 1693498 OR `props-main`.`id` = 1710064 OR `props-main`.`id` = 1704964 OR `props-main`.`id` = 1710159 OR `props-main`.`id` = 1712732 OR `props-main`.`id` = 1646600 OR `props-main`.`id` = 1666517 OR `props-main`.`id` = 1694971 OR `props-main`.`id` = 1703391 OR `props-main`.`id` = 1709852 OR `props-main`.`id` = 1702834 OR `props-main`.`id` = 1711297 OR `props-main`.`id` = 1713355 OR `props-main`.`id` = 1711541 OR `props-main`.`id` = 1705003 OR `props-main`.`id` = 1705009 OR `props-main`.`id` = 1713483 OR `props-main`.`id` = 1702956 OR `props-main`.`id` = 1713621 OR `props-main`.`id` = 1713311 OR `props-main`.`id` = 1709776 OR `props-main`.`id` = 1684831 OR `props-main`.`id` = 1705257 OR `props-main`.`id` = 1712982 OR `props-main`.`id` = 1712650 OR `props-main`.`id` = 1712369 OR `props-main`.`id` = 1712411 OR `props-main`.`id` = 1713251 OR `props-main`.`id` = 1711379 OR `props-main`.`id` = 1694633 OR `props-main`.`id` = 1713442 OR `props-main`.`id` = 1713365 OR `props-main`.`id` = 1712485 OR `props-main`.`id` = 1699969 OR `props-main`.`id` = 1712742 OR `props-main`.`id` = 1698851 OR `props-main`.`id` = 1704624 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226023847' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-06' 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();
8
Similar Properties
$530,000
3
2
1,772
0.15
2005 Floral Ct
Modesto, CA 95356
$530,000
4
2
1,772
0.13
2012 Spring Ln
Modesto, CA 95356
$495,500
3
2
1,711
0.11
3668 Veneman Ave
Modesto, CA 95356
$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.
