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

1582 State Highway 45
Grimes, CA 95950
Todd Renfrew with California Outdoor Properties, Inc - Vacaville, original listing - (707) 455-4444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 4628 Square Feet
Agency: California Outdoor Properties, Inc - Vacaville
Agency Phone: (707) 455-4444

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: A mere one-hour drive north of Sacramento, tucked away through a private walnut tree lined driveway, situated on 2.12 acres, you’ll arrive at Grand Island Ranch Estate in Colusa County.<br /> <br /> <br /> <br /> Nestled amongst a well-landscaped garden, trees, and paved plaza, the Spanish Colonial style home features 4,628 sq. ft. of living space, boasting six bedrooms and four bathrooms. All bedrooms are spacious and well-laid out. Natural light pours into the entirety of the home through oversized windows and skylights. The living room embodies a comfortable country ambiance with exposed wooden beams and a high ceiling. Off the living room through sliding glass doors is a brick laden patio with a large lawn. Nearby the kitchen, the dining room features a wood coffered ceiling with a terracotta tile floor, reflecting its Spanish Colonial style. The kitchen features a wooden butcher island block, stainless steel appliances, and windows overlooking the green garden.<br /> <br /> <br /> <br /> Just a stone’s throw away from the home is the pool with a spacious paved deck to relax and lounge. The pool house is an entertainer’s delight with a turquoise-colored kitchen, indoor BBQ, fireplace, bar, bedroom, and bathroom. In addition, there are two dressing rooms each with their own sink and shower. There is plenty of room for vehicles and recreational equipment at Grand Island Mansion with a detached three car garage, featuring a uniquely large walk-in freezer with double sink.<br /> <br /> <br /> <br /> Come discover why living is easy at Grand Island Ranch Estate!<br /> <br /> <br /> <br /> PROPERTY HIGHLIGHTS:<br /> One-hour north of Sacramento<br /> Brick column entrance with pineapple finials<br /> Improvements:<br /> 4,628 SF main home:<br /> Spanish-Colonial style home<br /> 6 bedrooms and 4 bathrooms<br /> Oversized windows and skylights<br /> Well-landscaped paved plaza<br /> Exposed wood beams & coffered wood ceiling<br /> Above the entrance, unique guest bedroom/office space with a separate entrance<br /> Detached three-car garage with walk-in freezer with a double sink<br /> Pool<br /> Pool House with one bedroom and bathroom<br /> Two dressing rooms each with their own sink & shower
MlsNumber: --
ListingId: 67834


Listing Provided By: California Outdoor Properties, Inc - Vacaville, original listing
Office Phone: (707) 455-4444
Agent Name: Todd Renfrew
Disclaimer: Copyright © 2024 LandLeader. 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