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

3078 Ridgecrest Drive
Purcell, OK 73080
Cassidy Lorenzo with Chamberlain Realty LLC, original listing - (405) 300-0543

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $579,900
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3506 Square Feet
Agency: Chamberlain Realty LLC
Agency Phone: (405) 300-0543

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: This newly remodeled custom property in the gated Cliffs Addition offers 3,506 sq. ft. of living space on a 0.61-acre lot. It features 5 bedrooms, 3 full baths, a powder room, formal living and family rooms, a home theater, and a three-car garage. The fifth bedroom upstairs, currently a home office, could also serve as a game room. The downstairs master bedroom offers privacy and includes a concrete-lined safe room that doubles as a storm shelter and closet. Located on the north end of town, this home offers quick access to I-35 and is just 1.5 miles<br /> from Purcell Hospital. To the east, the property borders private land stretching nearly a mile to the Canadian River, providing peaceful forest views and daily wildlife sightings, including deer. The large lot also includes a circle driveway and ample parking space for family and guests. The entire home has been recently remodeled, with an 8 ft pivot iron door acting as the entryway’s statement piece. Throughout the home, you’ll find quartz and granite countertops, ¾-inch red oak hardwood flooring on the first floor, luxury tile in the entry and living areas, and white marble floors in the master suite. The master bathroom features a 5’x10’ walk-in shower with a freestanding tub, 18-inch waterfall showerhead, and wall jets. The second floor offers red oak hardwood in the hall and office, with carpet in the bedrooms and theater room.Major maintenance updates include a new 30-year roof (2022), new A/C units and furnaces (2022), new 80-gallon water heater (2023), and new carpeting (2021).<br /> The backyard features a fenced 20x44 ft saltwater pool, with recent upgrades to the chlorine generator, liner, and pool pump. Electrical connections are in place for a hot tub by the covered porch. An additional 0.65-acre lot to the south is available for purchase. If you’re looking for the perfect home for your family, look no further.
MlsNumber: --
ListingId: 1146788


Listing Provided By: Chamberlain Realty LLC, original listing
Phone: (405) 706-4087
Office Phone: (405) 300-0543
Agent Name: Cassidy Lorenzo
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