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

4275 N Rockwell Avenue
Crescent, OK 73028
Nick Jones with Chamberlain Realty LLC, original listing - (405) 300-0543

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $430,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2620 Square Feet
Agency: Chamberlain Realty LLC
Agency Phone: (405) 300-0543

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: What a gem! An absolute beauty of a house on three acres with its own guest cabin! This modern farmhouse has everything you need to feel completely at home. The open concept layout is perfect for gathering together with family or entertaining friends. The massive living area is bathed in natural light, making for a rejuvenating environment to relax and recharge. The kitchen is both inviting and functional, and the pantry provides ample storage for all of your dry goods and essentials.<br /> <br /> A true split floor plan makes the primary bedroom and en suite a relaxing retreat. All four spacious bedrooms have generously sized closets, and three full bathrooms means no having to wait your turn to get ready in the morning. <br /> To step out onto the oversized back patio is to be transported to a rural oasis—an escape from the frenzied pace of the working day. Take in the sunset as the dappled light dances through the trees, or gather with friends and family around your stone fire pit for s’mores and great conversations.<br /> <br /> In addition to the breathtaking main house, the property also boasts a newly built guest house! Perfect for visiting friends and relatives, or to generate some income as a rural getaway, this one-bedroom, one-and-a-half-bath cabin (with its own laundry hookups!) features vaulted ceilings in the living area, a beautiful and fully functional kitchen, and a private, enclosed deck in the back for guests to gaze out into nature as they vacation in the beautiful land that you get to call home.<br /> <br /> Additionally, this amazing property offers a 12x16 outbuilding, two chicken coops, and a covered chicken run, as well as peach, plum, and hardy pomegranate trees—and don’t forget the blackberries! The owners have lovingly maintained this land, and have cleared a sizable portion for maximum efficiency of space, while at the same time preserving enough trees to ensure privacy and peaceful enjoyment. Come experience the allure of this one-of-a-kind home today!
MlsNumber: --
ListingId: 1150945


Listing Provided By: Chamberlain Realty LLC, original listing
Phone: (405) 473-4700
Office Phone: (405) 300-0543
Agent Name: Nick Jones
Disclaimer: Copyright © 2025 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