Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 209 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 209 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 209 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

5309 Allred Road
Mariposa, CA 95338

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $710,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1850
Agency: Realty executives

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 219,107 sqft
Property Type: Residential
Year Built: 1970
Notes: Come home to peace and tranquility and be welcomed by a cherry blossom-lined private road with a security gate as you enter this 5.3 acre gem. This beautiful country ranch house is perched up on a hillside that will give you breathtaking views for years to come. <br /> Upon entry, arched entryways will invite you into the common areas. The home flaunts 1,850 square feet covered with low maintenance/durable tile flooring throughout. The 3rd bedroom has been converted to a dual office, allowing for the most ideal work-from-home environment. One of the two full bathrooms has a large walk-in shower, and the master bath showcases a relaxing jacuzzi tub. <br /> Kick off your boots and enjoy the warmth of the black enamel wood burning stove while you delight in your favorite book, or watch TV from the built-in overhead cabinet. Adjacent to the living room, you’ll find a bonus den/library with full-wall wooden bookshelves. <br /> The gourmet kitchen is perfect for cooking and entertaining your guests with plenty of crema bordeaux granite counter space, a kitchen island, and a bar-type seating area. Enjoy the picturesque snow-capped Sierra Mountain range through your garden window above the 3-part stainless steel sink. This chef’s dream has it all with a built-in microwave, commercial-grade 6-burner gas cooktop stove, and baking and warming ovens. The refrigerator and dishwasher both have a custom wood face matching the kitchen cabinets providing an esthetically pleasing finish. <br /> The laundry/utility room flaunts granite counters and is equipped with the included washer, dryer, and mini refrigerator. There is also plenty of cabinet space and a janitor's sink with a Dutch door leading to the outside.<br /> The fully landscaped grounds provide drought resistant native plants with a fully automated irrigation system. Landscape features also include a concrete patio with a serene water fountain and a gazebo for relaxation or entertainment. <br /> Some additional exterior features include an attached 2-car garage, room for RV or boat, new Generac generator, new well pump with ultraviolet lights, woodshed, tool shed, owned propane tank and a 2,500 gallon water storage tank. <br /> This charmer is located just 10 minutes to the charming historic town of Mariposa, 45 minutes to Merced, 40 minutes to Oakhurst, 50 minutes to Bass Lake and 50 minutes to Yosemite National Park. Call your realtor today to schedule a showing before it’s gone!
MlsNumber: MC24055993


Listing Provided By: Realty executives, original listing
Name: Realty executives
Phone: (209) 205-1331
Office Name: Realty Executives Of Northern California
Office Phone: (209) 385-8500
Agent Name: Ezequiel Carlos
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App