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

7280 Brandon Court
Riverside, CA 92506

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,450,000
Beds: 4
Baths: 5
Status: Pending
SqFt: 5382
Agency: Murray Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 89,298 sqft
Property Type: Residential
Year Built: 2004
Notes: Presenting a custom-built, magnificent estate in the highly sought after Alessandro Heights. Private and tranquil, park-like setting as you enter in the gated entrance. This floor plan offers 5,382 sq. ft and 4 bedrooms, 3 full baths and 2 half bathrooms with Main bedroom on lower level. A forged iron front door leads into the inviting foyer with decorative columns with up to 20’ ceilings with Faux wooden beams, library with custom wooden shelving, crown molding and elegant tray ceilings, and a formal dining room with French architectural moldings and a crystal chandelier. The formal living room has an exquisite hand carved limestone fireplace mantel and generously sized windows designed to enhance the abundance of light and views. Gourmet kitchen with an open concept, granite counter tops, custom Alder wood cabinetry, Stainless steel appliances, 3 ovens, a walk-in pantry and a wet bar. Main suite has private balustrade porch, a carved marble fireplace and a sitting room. Adjacent to the main bedroom, is a large spa like bathroom and two spacious walk-in closets. A custom-built luxurious dressing room/closet has been customized with so many elegant details. Recessed lighting, a gorgeous chandelier, a fireplace, glass and white cabinetry, shelving, and vanity. This is your dream closet! The upper-level highlights 3 bedrooms. Two with a Jack and Jill set up, walk in closets with an added area 8x34 for extra storage. The third has a dedicated bathroom and walk in closet. Designed for entertaining in several locations in the home, walk down the hall to a kitchenette with an inviting outdoor lanai, that overlooks the scenic view of the valley and mountains. Gorgeous and serene back yard space with a saltwater pool and spa with water features, an outside pool bathroom, fruit trees, such as avocado, guava and citrus, mature landscaping. Other amenities include custom accented gutters, chimney caps and awnings, wrought iron privacy gate. A large lot at 2.05 acres, you can use your imagination and build an ADU, custom garage/ workshop or even a tennis court in several areas on the property. Trees are strategically placed for privacy. Four car garage and close to all amenities, shopping and easy freeway access. No HOA. This is a one-of-a-kind custom home; meticulously kept, that has exceptional character and beauty. Make arrangements for your showing.
MlsNumber: IV22258374


Listing Provided By: Murray Real Estate, original listing
Name: Murray Real Estate
Phone: (951) 212-4495
Office Name: Vista Sotheby's International Realty
Office Phone: (951) 684-1300
Agent Name: BRITTNEY JEANSON
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 = 3368 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 Heather Davison
Heather Davison
ASCIIeXp Realty LLC
Call Today!: (951) 751-7253

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App