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

870392 Red Stone Circle
Chandler, OK 74834

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $337,500
Beds: 5
Baths: 3
Status: Pending
SqFt: --
Agency: 405 Home Store LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential
Year Built: 2023
Notes: BUILDER IS OFFERING $5000 INCENTIVE MONEY TO BE USED TOWARDS CLOSING COST, UPGRADES, OR TO BUY YOUR RATE DOWN!!! Are you ready to elevate your living experience? Look no further, because this stunning new home in the Round Rock Addition of Chandler is a masterpiece of modern living, offering all the space and convenience you desire. Nestled on approximately 2.6 acres of land (MOL), this property is your ticket to tranquil country living while keeping you just a stone's throw away from the conveniences of Chandler and easy access to the turnpike. With 5 spacious bedrooms and 3 well-appointed bathrooms, you'll have room to grow and host guests with ease. A 3-car attached garage provides ample space for your vehicles, storage, or even a hobby workshop. Need more ask about adding a 30x40 shop! The 1900 square feet of living space is thoughtfully designed to optimize comfort and functionality, ensuring every inch is utilized to its fullest potential. Your home is situated on approximately 2.6 acres, offering boundless opportunities for outdoor<br /> activities, gardening, and creating your own personal retreat. Location, Location, Location! Round Rock provides an ideal setting for commuters with easy access to the turnpike, making your daily travels a breeze. Whether you're an avid gardener, a car enthusiast, or simply someone who craves the serenity of wide-open spaces, this home is a perfect match for your lifestyle. The lot offers ample room for outdoor adventures or simply savoring the peaceful atmosphere. With stylish finishes, a functional layout, and a prime location, this home is the epitome of convenience and comfort. You won't want to miss the opportunity to make it yours. Don't let this chance to own your dream home in Chandler's Round Rock Addition pass you by. Call now to schedule a viewing and experience the tranquility and convenience of this remarkable property for yourself. Your ideal lifestyle awaits – seize the moment!
MlsNumber: 1112135


Listing Provided By: 405 Home Store LLC, original listing
Name: 405 Home Store LLC
Phone: (405) 627-5236
Office Name: 405 Home Store
Office Phone: (405) 627-5236
Agent Name: Kristie Wirth
Disclaimer: Copyright © 2024 MLSOK, 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