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

1810 Via Latina Drive
Camarillo, CA 93012

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,798,000
Beds: 4
Baths: 3
Status: Pending
SqFt: 2627
Agency: Keller WIlliams Westlake Village

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 34,218 sqft
Property Type: Residential
Year Built: 1987
Notes: Completely reimagined single story home with unobstructed views of the surrounding hills & orchards! Ideally set on a private, 3/4 acre of newly landscaped grounds. The open floor plan, accentuated by new dual-glaze, energy-efficient windows and elegant French doors ensures a flood of natural light, creating an ambiance of warmth and welcome. Spacious formal living room complete with fireplace with white brick surround and French doors leading to an outdoor patio. The dining area boasts an upgraded light fixture with dimmer switch, setting the perfect mood for every meal. The heart of this home lies in the kitchen, featuring a custom-built center island, pristine quartz countertops with subway tile backsplash, and stainless appliances, this kitchen is designed to inspire your inner chef. Comfort meets luxury in the expansive family room featuring a cozy fireplace and a brand new picture window, ideal frame to the stunning backyard. All three family room windows come equipped with remote-controlled blinds, ensuring privacy and light control at the touch of a button. The dining area boasts an upgraded light fixture complete with a dimmer switch, setting the perfect mood for every meal. Retreat to the serene primary suite featuring vaulted ceiling with recessed lights, ceiling fan & brand new French doors leading to the backyard. The gorgeously remodeled primary bathroom exudes a spa-like ambience with new mirrors, custom vanity, a spacious walk-in shower with subway tiles, and a stand-alone tub, for ultimate relaxation. Three spacious, secondary bedrooms, one of which is being used as a craft room and has no closet. Fully remodeled guest bathroom, featuring custom vanities, upgraded mirrors, tub & flooring. Some of the many upgrades include: one of a kind laundry room with custom built-ins, fresh paint inside & out, upgraded baseboards, doors, trim & much more! Step outside to the ultimate backyard designed for entertainment and relaxation. Newly built pool complete with raised spa & waterfall feature, custom seat wall and fire pit. The outdoor kitchen area offers a new pizza oven, BBQ, and refrigerator. The home's exterior boasts a myriad of upgrades: new reinforced block wall & driveway for RV access & parking, custom gates, fresh stucco & paint, all new lighting and wrought iron fencing, complete with snake fencing. New rain gutters, pavers, and professionally landscaped grounds with new valves & sprinkler system ensure a pristine outdoor experience.
MlsNumber: SR24026651


Listing Provided By: Keller WIlliams Westlake Village, original listing
Name: Keller WIlliams Westlake Village
Phone: (805) 777-7777
Office Name: Keller Williams Realty World Class
Office Phone: (805) 777-7777
Agent Name: Lorenza Rinaldini
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.


Local Real Estate Expert

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 = 243 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;
Real Estate Expert Photo for Kelly Bond Ostrander
Kelly Bond Ostrander
ASCIIKeller Williams Westlake Village
Call Today!: (805) 795-3386

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App