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/crmls/MC25189681/708-Vista-Del-Rey-Dr/Atwater/https://www.londonproperties.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
139
Cumulative Days On Market
139
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
71109
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` = 1700384 OR `props-main`.`id` = 236633 OR `props-main`.`id` = 1667973 OR `props-main`.`id` = 1687773 OR `props-main`.`id` = 1622799 OR `props-main`.`id` = 1687772 OR `props-main`.`id` = 1691770 OR `props-main`.`id` = 1078072 OR `props-main`.`id` = 1690931 OR `props-main`.`id` = 1113258 OR `props-main`.`id` = 1701745 OR `props-main`.`id` = 1701484 OR `props-main`.`id` = 588889 OR `props-main`.`id` = 159004 OR `props-main`.`id` = 72047 OR `props-main`.`id` = 1696012 OR `props-main`.`id` = 1699137 OR `props-main`.`id` = 1699134 OR `props-main`.`id` = 1692028 OR `props-main`.`id` = 1692023 OR `props-main`.`id` = 137531 OR `props-main`.`id` = 1696912 OR `props-main`.`id` = 1687154 OR `props-main`.`id` = 1681454 OR `props-main`.`id` = 1687777 OR `props-main`.`id` = 1622894 OR `props-main`.`id` = 1691764 OR `props-main`.`id` = 1678715 OR `props-main`.`id` = 1700943 OR `props-main`.`id` = 1701001 OR `props-main`.`id` = 993755 OR `props-main`.`id` = 1678728 OR `props-main`.`id` = 1622738 OR `props-main`.`id` = 1675208 OR `props-main`.`id` = 1694839 OR `props-main`.`id` = 162423 OR `props-main`.`id` = 1688631 OR `props-main`.`id` = 1701023 OR `props-main`.`id` = 912425 OR `props-main`.`id` = 1698472 OR `props-main`.`id` = 1680711 OR `props-main`.`id` = 758993 OR `props-main`.`id` = 1698016 OR `props-main`.`id` = 1691911 OR `props-main`.`id` = 1698461 OR `props-main`.`id` = 1684766 OR `props-main`.`id` = 1695235 OR `props-main`.`id` = 1701056 OR `props-main`.`id` = 1651865 OR `props-main`.`id` = 1688038 OR `props-main`.`id` = 206870 OR `props-main`.`id` = 206871 OR `props-main`.`id` = 1697663 OR `props-main`.`id` = 1686740 OR `props-main`.`id` = 1691488 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` = 1685842 OR `props-main`.`id` = 1694170 OR `props-main`.`id` = 1694079 OR `props-main`.`id` = 1697382 OR `props-main`.`id` = 1691960 OR `props-main`.`id` = 1691872 OR `props-main`.`id` = 1691969 OR `props-main`.`id` = 274899 OR `props-main`.`id` = 1695667 OR `props-main`.`id` = 1698907 OR `props-main`.`id` = 1698905 OR `props-main`.`id` = 1651866 OR `props-main`.`id` = 1651867 OR `props-main`.`id` = 301027 OR `props-main`.`id` = 1694068 OR `props-main`.`id` = 1701739 OR `props-main`.`id` = 1701720 OR `props-main`.`id` = 1701729 OR `props-main`.`id` = 1700648 OR `props-main`.`id` = 1698802 OR `props-main`.`id` = 1701673 OR `props-main`.`id` = 521102 OR `props-main`.`id` = 1690038 OR `props-main`.`id` = 1688816)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25189681' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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.
