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

3051 Saint Albans Drive
Rossmoor, CA 90720

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,485,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 1618
Agency: JohnHart Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7,210 sqft
Property Type: Residential
Year Built: 1957
Notes: A + Street, Peaceful, Prime Center of Tract, Tree Lined Street in Rossmoor! A short distance to Rush Park. Home features a charming private front entry with Dual Pane Windows, tile roof, high ceilings, high-efficiency furnace & icy cool central air, gas fireplace, ceiling fans, sprinkler system & controls for front and backyard, RV Parking, private backyard with a covered patio, grass area for entertaining. Spacious galley Kitchen features tile countertops, electric stove top and oven, dual pane windows, sink, perfectly designed Kitchen w/many drawers & cabinets, appliances, dishwasher, Refrigerator, plus convenient side door access into the backyard. Journey to the entertainer's backyard that features a private seating patio area and nice grassy area for a play set, or for your family pet and great for family gatherings. Some of the many features include dual paned windows, 2 car garage with direct access into the home. This beautiful, one-of-a-kind, home is a dream of a property with so much potential or just perfect as is. Rossmoor is known for its highly rated Los Alamitos Unified School District, two large parks, lovely tree lined streets, bike friendly community, small village feel, library & transportation which makes Rossmoor a great place to live. The spacious back yard is perfect for relaxing on sunny afternoons + hosting barbecues, + lovely patio, & plenty of outdoor living space. Convenient Central Rossmoor location close to Rush Park, schools, parks, bike friendly neighborhood, restaurants, medical facilities, and Seal Beach. Don't wait. This home won't last long!
MlsNumber: PW24024387


Listing Provided By: JohnHart Real Estate, original listing
Name: JohnHart Real Estate
Phone: (818) 246-1099
Office Name: JohnHart Real Estate
Office Phone: (818) 246-1099
Agent Name: Janie Bruce
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