Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/225149215/429-Red-Lion-Way/Newman/https://www.londonproperties.com/images/props/metrolist/full/225149215.jpgLondon Properties Newman Real Estate | 429 Red Lion Way
This gorgeous 4 bed 2.5 bath home is located in a desirable area and comes with many features! Boasting 2,891 square ft this spacious home has a great layout downstairs for entertaining and a den which is currently being used as an office. The kitchen is a chef's dream with a nicely sized island that provides seating. Upstairs you will find all 4 bedrooms and the laundry room which is convenient and provides privacy away from the main floor. Be amazed as you walk in to the super neat low maintenance backyard that has a beautiful pool/spa and your own outdoor BBQ/Bar area. There are also two gates on each side of the home for easy access. The property comes with a fully PAID OFF SOLAR SYSTEM. The HVAC system has just been replaced 2 years ago, pool pump and pool heater were replaced 1 year ago, the 2nd story shared restroom was updated about 3 years ago, and the outdoor Kitchen/Bar was installed about 4 years ago. Come view all that this beautiful home has to offer!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2007
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Other-Rmks 0-5YR
Stories
2
Home Warranty
No
Directions to Property
Sherman Parkway to Southington, Right on Red Lion Way
Cross Street
Barrington Ave
County
Stanislaus
Special Listing Conditions
None
Main Level
Living Room, Dining Room, Family Room, Partial Bath(s), Garage, Kitchen
Construction Materials
Stucco, Frame
Foundation
Slab
Roof
Tile
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Area, Inside Room
Other Structures
Pergola
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Shower Stall(s), Double Sinks, Tub, Window
# of Fireplaces
1
Fireplace Features
Other
Flooring
Carpet, Tile
Kitchen Features
Breakfast Area, Island, Stone Counter, Tile Counter
Dining Room Features
Formal Area
Living Room Features
Other
Primary Bedroom Features
Walk-In Closet 2+
Upper Level
Bedroom(s), Primary Bedroom, Full Bath(s)
Exterior Features
Kitchen, Built-In Barbeque
Patio And Porch Features
Front Porch
Pool
Yes
Pool Features
Built-In, Pool/Spa Combo, Fenced, Gas Heat
Spa
Yes
Spa Features
Spa/Hot Tub Built-In, Spa/Hot Tub Personal
ADU/2nd Unit
No
Utilities
Public, Solar, Natural Gas Connected
Electric
220 Volts,220 Volts in Kitchen,220 Volts in Laundry
Irrigation
None
Water Source
Meter on Site, Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Auto Sprinkler F&R, Shape Regular, Street Lights, Low Maintenance
APN
049 055 059 000
Horse Property
No
Zoning Description
SFR
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Newman-Crows Landing
Middle or Junior School District
Newman-Crows Landing
Senior High School District
Newman-Crows Landing
Census Tract
35.01
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 536750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 593250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2641 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3141 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` = 1694190 OR `props-main`.`id` = 1697516 OR `props-main`.`id` = 1695443 OR `props-main`.`id` = 1685945 OR `props-main`.`id` = 1695960 OR `props-main`.`id` = 1693048 OR `props-main`.`id` = 1691915 OR `props-main`.`id` = 1692625 OR `props-main`.`id` = 1637376 OR `props-main`.`id` = 1692701 OR `props-main`.`id` = 1680870 OR `props-main`.`id` = 1676769 OR `props-main`.`id` = 1693310 OR `props-main`.`id` = 1678359 OR `props-main`.`id` = 1689819 OR `props-main`.`id` = 1697456 OR `props-main`.`id` = 1677324 OR `props-main`.`id` = 1677331 OR `props-main`.`id` = 1690708 OR `props-main`.`id` = 1697597 OR `props-main`.`id` = 1688939 OR `props-main`.`id` = 1673332 OR `props-main`.`id` = 1694772 OR `props-main`.`id` = 1695411 OR `props-main`.`id` = 1692795)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225149215' 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 Francisco Ruvalcaba, J.Peter Realtors 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.
