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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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 = 0 AND i.igate IN ('usahud','nyhud','ushud') ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nyhud', 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;

2738 Sheridan Road
Fullerton, CA 92833

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,150,000
Beds: 4
Baths: 2
Status: Pending
SqFt: 1598
Agency: Award, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5,050 sqft
Property Type: Residential
Year Built: 1976
Notes: A fantastic SINGLE STORY, nestled in the hills of Fullerton in a very nice development surrounded by lush mature trees and natural ambiance. William Lyon's home with a tremendous curb appeal in the exclusive Westbluff community. A pride of ownership from long term owners that have lovingly raised a family in this property. Current owner maintained property updated and in pristine condition! Premium and outstanding location; four bedrooms and 2 bathrooms: as you walk in, the fantastic open floor plan shows through with timeless elegance and you will find a perfect, easy flow. Double door entry; gracious living room with vaulted ceiling, cozy fireplace and beautiful bay windows overlooking peaceful front garden and lush trees on the street are the perfect spot for enjoying family and friends. Family kitchen with Formica countertops, trey ceilings, upgraded white color appliances and casual dining area. Comfortable family room with tasteful built-in cabinets. Private master bedroom overlooking large side yard with nice covered patio with ceiling fan. Quality, attractive, vinyl dual-pane windows and sliding doors. Scraped ceilings, mirrored closet doors, recessed lighting throughout. Both bathrooms have been totally, gorgeously upgraded/remodeled; one bathroom has a skylight. Upgraded furnace/central air conditioning and water heater. Beautiful grounds! Professionally landscaped; awesome and generous sized back yard and large side yard with stamped concrete slab for perfect outdoor entertaining. Direct access to the 2-car garage. Enjoy association pools/spas/tennis courts/playgrounds, greenbelts/walking path. Superb school district (Fern Drive Elem., Parks Jr. & Sunny Hills High). Near Los Coyotes Country Club golf course and the 105-acre Ralph Clark Regional park. Close to Amerige Heights Shopping Center, grocery markets, restaurants and golf courses.
MlsNumber: PW24049145


Listing Provided By: Award, Inc, original listing
Name: Award, Inc
Phone: (800) 293-1657
Office Name: Century 21 Affiliated
Office Phone: (714) 780-0500
Agent Name: Linda Suk
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