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;

35277 Red Rover Mine Road
Acton, CA 93510
Teresa Thomas-Row with Front Row Realtors, Inc., original listing - (661) 714-8708

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,298,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 4388 Square Feet
Agency: Front Row Realtors, Inc.
Agency Phone: (661) 714-8708

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Experience the perfect blend of country and luxury This stunning 3 bedroom 3 bath with 4388 sq. ft offers a perfect blend of luxury and comfort, nestled in a serene setting. The expansive family room, bathed in natural light, serves as the heart of the home, providing ample space for gatherings and relaxation. From here, access the large loft via elegant spiral stairs. This versatile space is ideal for a game room or a kids' area, offering endless possibilities for fun and entertainment. The gourmet kitchen is a chef's delight, featuring granite countertops, and a spacious island perfect for meal prep and casual dining. Adjacent to the kitchen, the formal dining room is perfect for hosting dinner parties and special occasions. Retreat to the luxurious master suite, complete with a spa-like ensuite bathroom and a generous walk-in closet. Additional bedrooms are spacious and well-appointed, ensuring comfort for family and guests alike. Step outside to discover a sprawling backyard, perfect for outdoor activities and entertaining. Plenty of room for horses or toys, this property is a haven for those who love the outdoors. The expansive patio area is ideal for barbecues and alfresco dining, while the lush landscaping provides a tranquil backdrop. Also featuring like new swim spa for romantic evenings under the stars and keeping fit. This home also features a finished oversized 8 car garage area with 220V, work area and storage above. Something for everyone. Located close to schools, shopping, with easy freeway access, this property offers the perfect blend of convenience and tranquility. Don't miss the opportunity to make this exceptional property your own. Schedule a viewing today and experience the lifestyle you've always dreamed of!
MlsNumber: --
ListingId: 24004696


Listing Provided By: Front Row Realtors, Inc., original listing
Phone: (661) 714-8708
Office Phone: (661) 714-8708
Agent Name: Teresa Thomas-Row
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App