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

225 S Culp
Russell, KS 67665

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $650,000
Beds: 6
Baths: 2
Status: Active
SqFt: --
Agency: About You Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1951
Notes: Dream Home Alert!! Step into the epitome of comfort and space with our newest listing that has it all!! Presenting a sprawling 6~Bedroom, 2~Bathroom sanctuary that promises the perfect blend of functionality and luxury for your family. Spacious Living: Each bedroom is a canvas, ready for you to paint your personal haven. With ample space for king~sized beds, workstations, and seating areas, the only limit is your imagination. The two well~appointed bathrooms are oases of relaxation, featuring updated fixtures and finishes that cater to a busy household. Gourmet Kitchen and More: A culinary enthusiast`s dream, the kitchen offers generous counter space, space for state~of~the~art appliances, and storage solutions that make cooking and entertaining a breeze. The heart of the home location~ centrally designed to ensure you’re never too far from the action, whether you’re whipping up a feast or hosting a movie night in the massive living room. A Backyard Like No Other: Step outside to discover your private paradise; a massive backyard where endless possibilities await. Whether you’re envisioning a lush garden, a serene pool area, a playground for little ones, a space for your animals to roam, or just a peaceful space to drink your morning coffee, this space can accommodate it all and more. The Ultimate Workshop: Hobbyists and professionals alike will delight in the massive 40 x 60 shop. With enough room for all your projects, vehicles, toys, tools, and storage, this workshop is the dream of every outdoorsman and avid crafter. Game On!!: And just when you thought it couldn`t get any better, there’s a dedicated game house!! Transform it into the ultimate gaming den, a private cinema, or an exclusive clubhouse for weekend fun. It’s your exclusive retreat for leisure and lots of laughs. Your Forever Home Awaits: Nestled in a quiet neighborhood, this property balances tranquility and accessibility. You’ll be minutes away from local amenities while still enjoying the peace and privacy of your own personal haven. Don’t miss your chance to own this slice of paradise. Perfect for growing families, entrepreneurs, and everyone in between. Your forever home is waiting for you. Contact us today for a private viewing and take the first step towards living the dream in a home as expansive and inviting as your vision for the future. Call Traci Wieger to schedule your private tour of this property. Proof of funds are required prior to scheduling any viewings...
MlsNumber: 203226


Listing Provided By: About You Realty, original listing
Name: About You Realty
Phone: (785) 445-4146
Office Name: About You Realty
Office Phone: (785) 445-4146
Agent Name: Traci Wieger
Disclaimer: Copyright © 2024 Hays Multiple Listing Service. 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 = 976 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App