Please provide the following information and Tiffany Wilson will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.3brosmom-realestate.com/agent/16607/tiffany-wilson/property/link/crmls/MC25189681/708-Vista-Del-Rey-Dr/Atwater/https://www.3brosmom-realestate.com/images/props/crmls/full/MC25189681.jpgLondon Properties Atwater Real Estate | 708 Vista Del Rey Dr
Listing Agent: Jacob Jenkins, Real Brokerage Technologies, Inc.
This 3-bedroom, 2-bath home is a fantastic opportunity to build equity and add your personal touch. Located on a desirable corner lot in a beautiful gated community, this home offers a spacious open floor plan that's full of potential. Enjoy the bright and airy layout, ideal for everyday living and entertaining. The backyard features a great space for barbecues and outdoor gatherings-just waiting for your creative vision. Plus, with solar panels already installed, you'll enjoy energy savings from day one. While the home could use some updates, it's the perfect canvas for buyers looking to customize their space and make it truly their own. Whether you're handy or planning to take it one project at a time, this is a solid investment in a great location. Square footage figures are provided as a courtesy estimate only and were obtained from Tax Record Data. Buyer is advised to obtain an independent measurement.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2002
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
$236
Days On Market
33
Cumulative Days On Market
33
County Or Parish
Merced
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
left onto N Buhach Rd; Right onto Green Sands Ave; Left onto Vista del Rey Dr.
Disclosures
CC And R's, Homeowners Association
Architectural Style
Cottage
Room Type
Kitchen, Living Room, Main Floor Bedroom, Main Floor Primary Bedroom, Primary Bathroom, Primary Bedroom, Primary Suite, Walk-In Closet
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Dryer Included, Electric Dryer Hookup, Inside, Washer Hookup
Roof
Shingle
Security Features
Fire and Smoke Detection System, Gated Community, Wired for Alarm System
Foundation Details
Concrete Perimeter
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Room Kitchen Features
Kitchen Open to Family Room, Tile Counters
Eating Area
Area, Breakfast Counter / Bar
Appliances Y/N
Yes
Appliances
Dishwasher, Gas Oven, Gas Range, Microwave, Refrigerator
Room Bathroom Features
Bathtub, Shower in Tub, Exhaust fan(s), Main Floor Full Bath, Tile Counters
Interior Features
Cathedral Ceiling(s), Ceiling Fan(s), Open Floorplan, Tile Counters
Flooring
Carpet, Concrete, Vinyl
Common Walls
No Common Walls
Fireplace Y/N
No
Fireplace Features
None
Pool Features
None
Pool Private Y/N
No
Spa Y/N
No
Spa Features
None
Patio Y/N
Yes
Patio And Porch Features
Concrete, Patio Open, Front Porch
Utilities
Cable Connected, Electricity Connected, Natural Gas Connected, Phone Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Driveway, Garage
Attached Garage Y/N
No
Garage Spaces
2.00
Lot Features
Corner Lot, Lawn
Lot Size Area
4635.0000
Lot Size Units
Square Feet
Road Surface Type
Paved
View Y/N
No
View
None
Fencing
Wood
Common Interest
Condominium
Parcel Number
004360030000
Additional Parcels Y/N
No
Zoning
P-D 9
Community Features
Curbs, Street Lights
Association Amenities
Playground, Pets Permitted
Senior Community Y/N
No
Association Y/N
Yes
Association Name
The Cottages at Ventana Del Rey
Association Management Name
The Cooper Company
Association Fee
110.00
Association Fee Frequency
Monthly
High School District
Merced Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
19
Tax Census Tract
8.02
72871
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 313500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 346500 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) >= 1147 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1647 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` = 144493 OR `props-main`.`id` = 1664241 OR `props-main`.`id` = 1682548 OR `props-main`.`id` = 236633 OR `props-main`.`id` = 1671744 OR `props-main`.`id` = 1680424 OR `props-main`.`id` = 1664540 OR `props-main`.`id` = 1664535 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1650038 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1650037 OR `props-main`.`id` = 1682552 OR `props-main`.`id` = 1682554 OR `props-main`.`id` = 1683889 OR `props-main`.`id` = 1659503 OR `props-main`.`id` = 1659457 OR `props-main`.`id` = 1652906 OR `props-main`.`id` = 1674115 OR `props-main`.`id` = 1674068 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1685361 OR `props-main`.`id` = 1685383 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1682186 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 1682563 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 1650700 OR `props-main`.`id` = 1650686 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1677931 OR `props-main`.`id` = 1684475 OR `props-main`.`id` = 1663305 OR `props-main`.`id` = 1684473 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1676250 OR `props-main`.`id` = 1676266 OR `props-main`.`id` = 1684205 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1684209 OR `props-main`.`id` = 1680386 OR `props-main`.`id` = 1661950 OR `props-main`.`id` = 1662023 OR `props-main`.`id` = 1680392 OR `props-main`.`id` = 1622697 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1686457 OR `props-main`.`id` = 1686562 OR `props-main`.`id` = 1679715 OR `props-main`.`id` = 1679711 OR `props-main`.`id` = 1662381 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1674729 OR `props-main`.`id` = 1645771 OR `props-main`.`id` = 1645839 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 1682226 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1685510 OR `props-main`.`id` = 1684190 OR `props-main`.`id` = 1684681 OR `props-main`.`id` = 1685091 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1639779 OR `props-main`.`id` = 1675140 OR `props-main`.`id` = 1627752 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1679233 OR `props-main`.`id` = 1674298 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1676559 OR `props-main`.`id` = 1682532 OR `props-main`.`id` = 1684138 OR `props-main`.`id` = 1685928 OR `props-main`.`id` = 1673216 OR `props-main`.`id` = 1673221 OR `props-main`.`id` = 1615839 OR `props-main`.`id` = 1614225 OR `props-main`.`id` = 1683616 OR `props-main`.`id` = 1686268 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1680693 OR `props-main`.`id` = 1680717 OR `props-main`.`id` = 1680723 OR `props-main`.`id` = 101784 OR `props-main`.`id` = 911713 OR `props-main`.`id` = 1656416 OR `props-main`.`id` = 1656413 OR `props-main`.`id` = 1685842 OR `props-main`.`id` = 1644663 OR `props-main`.`id` = 1642699 OR `props-main`.`id` = 1663976 OR `props-main`.`id` = 1681567 OR `props-main`.`id` = 1684031 OR `props-main`.`id` = 1683840 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1683304 OR `props-main`.`id` = 1683412 OR `props-main`.`id` = 1675291 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1667834 OR `props-main`.`id` = 1677069)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25189681' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-23' 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
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.