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

42507 W 27th Street
Lancaster, CA 93536

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $914,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2810
Agency: Coldwell Banker A Hartwig Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1987
Notes: Subtstantial Price Improvement! Very special custom built home on 40,000+sq.ft with paved streets, sidewalks and street lights. Features dual zone heat and air plus 2 thermostact operated ducted evap coolers. Great room with Ember Glo gas fireplace and thermostat, all open to the kitchen. Amazing cook's kitchen with a huge built in center island, blt in hutch, copious countertop areas and French style dual fuel WOLF range with two ovens. Also included are a wet bar and floor to ceiling double door wine cellar. There are french doors leading out from the kitchen to the outside cooking area plus a custom 12 ft wood slider with divided light windows leading from dining area to an entertainers dream, an outside kitchen that features a full wood burning fireplace, wood burning bar-be-que and and cooking island with another gas bar-be-que and a built in spa.The main bedroom suite is separated from other beds and bath. Enjoy another wood burning fireplace, a spacious bedroom, two large walk in closets with built-in storage. Bath has a Kohler deep soaking tub, separate shower(two shower heads), double sinks and door to patio and spa. Each additional bedrooms has large closets (one is a walk-in) with built in storage and shelving. Very nice laundry room with lots of storage and a sink. Circular drive and a huge concrete area leada to 3000+- sf detached garage with 3/4 bath. Built to allow a 2nd story. Potential room for 10+ cars. Water and electricity to building, + RV dump. Several other RV dumps on the property. Inside and otside storage for RV parking with 2 16 ft automatic doors to the garage. Solar locking gates to the back yard. Motion lts and sec cameras used with the ADT system. Behind detached garage is still much more room for a garden, animals etc...Truly an amazing home. Seller licensed to sell Real Estate in the State of Californis
MlsNumber: 24002400


Listing Provided By: Coldwell Banker A Hartwig Company, original listing
Name: Coldwell Banker A Hartwig Company
Phone: (661) 206-6301
Office Name: Coldwell Banker-A Hartwig Co.
Office Phone: (661) 948-8424
Agent Name: Patricia Danielsen
Disclaimer: Copyright © 2024 Greater Antelope Valley Association of Realtors. 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 = 202 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;
Silvia Aguilar
ASCIISan Fernando Realty, Inc
Call Today!: (661) 209-2565

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App