Listing Agent: Maricela Lua-Garcia, Huff Real Estate
Beautiful 3 bedroom 2 full bathroom home. Starting from the front home features gated beautiful entry way ready for your outdoor table and chairs. Beautiful kitchen, living room has fireplace ready for the winter. Laundry room is inside. Carpet in all rooms. Backyard is well manicured with back patio. You have a insulated shed for storage. Minutes from shopping centers, schools, banks, restaurants and freeway. Great established neighborhood. Community park right around the corner. Perfect location!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1978
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Front door
Price Per Square Foot
$324
Days On Market
27
Cumulative Days On Market
27
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
E Whitmore Ave turn left on Lunar Dr. left on Moonview Dr.
Room Type
Living Room
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Flooring
Carpet, Laminate
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
0-1 Unit/Acre
Lot Size Area
6825.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Common Interest
None
Parcel Number
069009040000
Additional Parcels Y/N
No
Community Features
Sidewalks
Senior Community Y/N
No
Association Y/N
No
High School District
Ceres Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
9
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 418000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 462000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1110 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1610 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` = 1692684 OR `props-main`.`id` = 1692685 OR `props-main`.`id` = 1692912 OR `props-main`.`id` = 1600757 OR `props-main`.`id` = 1688578 OR `props-main`.`id` = 1690280 OR `props-main`.`id` = 1693090 OR `props-main`.`id` = 1692667 OR `props-main`.`id` = 1684524 OR `props-main`.`id` = 1693213 OR `props-main`.`id` = 1662513 OR `props-main`.`id` = 1664458 OR `props-main`.`id` = 1622951 OR `props-main`.`id` = 1695410 OR `props-main`.`id` = 1674469 OR `props-main`.`id` = 1697354 OR `props-main`.`id` = 1698018 OR `props-main`.`id` = 1684877 OR `props-main`.`id` = 1695115 OR `props-main`.`id` = 1697803 OR `props-main`.`id` = 1693039 OR `props-main`.`id` = 1693040 OR `props-main`.`id` = 1693038 OR `props-main`.`id` = 1671906 OR `props-main`.`id` = 1698030 OR `props-main`.`id` = 1692784 OR `props-main`.`id` = 1692885 OR `props-main`.`id` = 1692883 OR `props-main`.`id` = 1692884 OR `props-main`.`id` = 1691126 OR `props-main`.`id` = 1646283 OR `props-main`.`id` = 1693548 OR `props-main`.`id` = 1692829 OR `props-main`.`id` = 1691502 OR `props-main`.`id` = 1694773)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25262955' 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();
1
Similar Properties
$419,000
3
2
1,296
0.14
1813 Poppy Ln
Ceres, CA 95307
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.
