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 = 3320 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 3320 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 3320 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

5345 Brighton Court
San Bernardino, CA 92407

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $674,900
Beds: 4
Baths: 3
Status: Pending
SqFt: 2485
Agency: Keller Williams Realty Laguna Niguel-Laguna Beach

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12,629 sqft
Property Type: Residential
Year Built: 2009
Notes: Welcome to this beautiful home with a European Cottage Exterior in San Bernadino with mountain views, no HOA, and across the street from Cal State. This home is situated on a small cul-de-sac on an oversized lot with a 3-car tandem garage and features 4 bedrooms, a loft, 3 full baths, 2,485 sq ft on a 12,629 sq ft lot, and with the highly desired first-floor bedroom and full bath. The family room features a fireplace, a large media niche, with a wall of windows to bring in the natural light, and is open to the dining area followed by the kitchen with an island, abundant Beechwood cabinets, a pantry, recessed and under counter lighting, new appliances, tile countertops, and backsplash. Rounding out the first floor is the Laundry room with cabinets and access to the 3-car tandem garage. The second floor has the Primary bedroom with an ensuite bath with dual sink vanities, a separate tub, a walk-in shower, and a walk-in closet. The loft sits between two additional bedrooms and shares a full bath with dual sinks and a tub/shower combo. Other features include matching tile and backsplash countertops in the kitchen and all baths, matching floor tile in first-floor hallways, kitchen, dining room, and laundry, and all 3 baths, and 3 bedrooms have mirrored wardrobes. The large wrap-around yard with cinder block walls has so much potential for a pool, spa, putting green, or playground. Updates include Brand New Carpeting, Brand New Stainless Steel Kitchen Appliances, Brand New Interior Paint, and Brand New Exterior Fascia and Shutters Paint. Across the street from Cal State San Bernardino, close to shopping, restaurants, and freeways.
MlsNumber: OC24025675


Listing Provided By: Keller Williams Realty Laguna Niguel-Laguna Beach, original listing
Name: Keller Williams Realty Laguna Niguel-Laguna Beach
Phone: (949) 482-3999
Office Name: Keller Williams Realty
Office Phone: (949) 482-3999
Agent Name: Brian Brassil
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App