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 = 245 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 = 245 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 = 245 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;

Foreclosure: 1329 Ramirez Street
Marysville, CA 95901
Sergio Becerra Casillas with RE/MAX Gold Coast-Beach Marina Office, original listing - (805) 382-9441

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $309,900
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 849 Square Feet
Agency: RE/MAX Gold Coast-Beach Marina Office
Agency Phone: (805) 382-9441

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1941
Notes: Beautifully Renovated Home in the Heart of Marysville, CA! Welcome to this stunning, fully renovated home located in the charming and historic city of Marysville, California! This beautifully updated property offers modern comforts while retaining its original character, making it the perfect place for you to call home. This home has been meticulously renovated with attention to detail. Enjoy a brand-new kitchen with stylish cabinetry, quartz countertops, and stainless steel appliances. The bathrooms have been completely updated with modern fixtures and finishes, and the living areas feature fresh paint, new flooring, and upgraded lighting throughout. Living in Marysville offers a unique blend of small-town charm and access to a variety of community attractions: Historic Downtown: Just minutes away, explore the quaint and historic downtown Marysville, known for its unique shops, and local dining. Feather River Recreation Area: Outdoor enthusiasts will love being close to the Feather River, where you can enjoy fishing, kayaking, boating, and beautiful scenic trails. Ellis Lake: A local gem, this peaceful lake offers walking paths, picnic areas, and bird watching. Marysville Raceway: For a bit of excitement, the nearby Marysville Raceway is perfect for race fans and hosts regular events throughout the year. Located just a short drive from Yuba City and within commuting distance to Sacramento, Marysville offers the best of both worlds--small-town living with big-city conveniences. This beautifully renovated home in Marysville offers the perfect blend of modern living and proximity to the area's best attractions. Don't miss your chance to own this charming property! Additional pictures to be added by 9/24. some pictures are digitally enhanced.
MlsNumber: --
ListingId: V1-25880


Listing Provided By: RE/MAX Gold Coast-Beach Marina Office, original listing
Phone: (805) 253-2595
Office Phone: (805) 382-9441
Agent Name: Sergio Becerra Casillas
Disclaimer: Copyright © 2024 California Regional MLS - Pasadena-Foothills and Ventura County Coastal. 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