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

298879 E County Road 1730
Velma, OK 73491
Cynthia Silvas with G3 Land & Home, LLC., original listing - (580) 721-9355

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: 4
Baths: Full: 3, ½: 2
Status: Active
SqFt: 5900 Square Feet
Agency: G3 Land & Home, LLC.
Agency Phone: (580) 721-9355

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 75 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Welcome to your dream rural retreat, a luxurious estate offering the perfect blend of remote living with modern off-the grid capabilities nestled on 75 rolling acres. This stunning property offers the perfect blend of elegance and functionality. The gated, private drive greets you landscaped features, a stocked trophy pond & Priefert fencing. The home boasts a covered circle drive & four-car garage. Inside, the home is a masterpiece of craftsmanship & comfort. The double insulated home features vaulted ceilings accentuated by hand-scraped cedar solid beams, two staircases with removable gates. The gourmet kitchen is equipped with all JennAir appliances, an induction stove, ice maker, built-in JennAir refrigerator, & copper sink. The kitchen's unique features include 1940 railway car flooring countertops, antique refurbished butcher block countertops, & large butcherblock for prepping. An oversized pantry with wine storage and oversized laundry room. 4 bedrooms, 3 full baths all with walk-in shower and Jetta tub, and 2 half baths. The master suite has a luxurious Jetta tub, walk-in his & hers closets with built-ins, granite countertops, sitting area inside one of the pine finished turrets, rock fireplace & back patio doors. There's an office, secret playroom & a bonus room with barn doors. Step outside to enjoy the outdoor swim spa, outdoor kitchen with Bull brand grill, griddle and fish fry. Propane firepit is perfect for those chilly nights and retractable automatic screens. 4 HVAC units, 1000-gallon buried propane tank, a 100-gallon per minute water well (functioning, but not being used), two Big Ass Fans, and sprinklers are inside the fenced yard. A 6 person flat safe in-ground storm shelter, a play set, trampoline, and tether ball are provided. He will love the 40 by 60 shop with electrical, a 6x12 bathroom, a 10x12 office, a 15x40 heat and cooled batting cage with turf, 16-foot walls, five 14-foot overhead doors, metal finishes, and a hot water heater.
MlsNumber: --
ListingId: 2440354


Listing Provided By: G3 Land & Home, LLC., original listing
Phone: (580) 721-9355
Office Phone: (580) 721-9355
Agent Name: Cynthia Silvas
Disclaimer: Copyright © 2024 MLS Technology, Inc. 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 = 2194 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;
Real Estate Expert Photo for Elizabeth A. Cartmill
Elizabeth A. Cartmill
ASCIIRE/MAX Professionals
Main: (580) 704-4224

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App