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

41910 Crazy Horse Canyon Road
Aguanga, CA 92536
Denice Hickethier with HomeQuest Advantage Properties, original listing - (951) 763-1000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $724,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3592 Square Feet
Agency: HomeQuest Advantage Properties
Agency Phone: (951) 763-1000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Beautiful, Bright, Spacious and Like New, Turnkey Lake Riverside Gorgeous 3492 sf 4 bedroom custom home on 2.57 Acres!!! (OWNER'S BEING RELOCATED DUE TO WORK) These larger homes don't come up too often in the country. The builder was known for quality homes throughout the community. Some of the details include a grand spacious floorplan with LOTS of windows and mountain views, entertainer's kitchen with hickory cabinetry, granite counters, oversized kitchen island, cooktop, double oven, spacious pantry and wood flooring. The open concept kitchen is adjacent to a huge family/bonus room with lots of windows, wood burning fireplace and tall ceilings. For those who love more formal living combined with the open concept great room, this home also offers a formal entry living/bonus room (perfect for a home office, gym, game room, kids, home school or??), as well as a formal large dining room with built in buffet. Downstairs bathroom, direct access to 3 car garage with finished surface flooring, rear patio with beautiful views. All bedrooms are upstairs along with the laundry; washer and dryer included. Spacious bedrooms with oversized primary, 2 full bathrooms, and views, views, views!!!! The primary bath offers a tiled soaking tub, walk in custom tiled shower, plus 2 walk in closets. HVAC system is zoned (upstairs and downstairs). Some additional features which exemplify the quality of the home include dovetail finish cabinetry, Pella dual pane windows with molding around each, pull through driveway, 576 SF garage, lots of land/room for improvements, and 2 water storage tanks. Located within the Lake Riverside community with miles of equestrian, hiking and biking trails. Roads are primarily dirt so you can ride your horse or bike as far as you'd like, and the roads are HOA maintained. The community offers a 3600" lighted airstrip, 500 +/- acre aesthetic lake for birdwatching, catch and release fishing, bbq's, picnics (etc), a tot lot, sports courts, equestrian arena and round pen, community pool and more. Cal Fire resides directly within the community, so fire/paramedic response time is fast. Leave the city stress down the hill and enjoy living a clean life where you can see the stars again! Gated community with roving security. Shown by appt.
MlsNumber: --
ListingId: SW25012271


Listing Provided By: HomeQuest Advantage Properties, original listing
Phone: (760) 445-0973
Office Phone: (951) 763-1000
Agent Name: Denice Hickethier
Disclaimer: Copyright © 2025 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 = 3332 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 Tamara Wentworth
Tamara Wentworth
ASCIIeXp Realty
Call Today!: (949) 292-9305

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App