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

316 Hartman
Russell, KS 67665

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $388,000
Beds: 3
Baths: 3
Status: Active
SqFt: --
Agency: About You Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2011
Notes: Introducing 316 Hartman St., a stunning residence nestled in a tranquil and secluded neighborhood, offering the perfect blend of luxury and comfort. Built by Covenant Buildings in 2011, this exquisite home boasts a myriad of features that are sure to captivate any discerning buyer. As you approach the property, you are greeted by lush greenery and a meticulously maintained yard, three car garage, driveway, along with a circle driveway, enhancing the curb appeal of this beautiful home. The exterior is adorned with Malarkey 50~year shingles, adding durability and style to the roof. Step inside to discover a spacious interior with cathedral ceilings that create an airy and inviting atmosphere. The main level features a well~appointed kitchen with a pantry, perfect for culinary enthusiasts, while the downstairs kitchenette offers added convenience for entertaining guests. With five bedrooms and three bathrooms, including a luxurious master suite complete with a walk~in closet and a master bath featuring a new shower, bathtub, and tile, this home provides ample space for relaxation and privacy. The whirlpool tub adds a touch of indulgence to the master bath, creating a spa~like retreat within the comfort of your own home. The interior is equipped with modern amenities, such as central electric heating and cooling, a dishwasher, microwave, range\oven, and a gas fireplace with gas logs for cozy evenings. The full basement offers additional living space and storage options, making it a versatile area for various needs. Outside, the property features a covered deck, privacy fence, and a three~car garage, providing ample space for outdoor enjoyment and vehicle parking. City amenities such as water, sewer, electricity, and gas service add to the convenience of this exceptional property. Recent improvements include a radon remediation system, whole~house generator, concrete patio enhancements, new siding, and updated flooring throughout. Additionally, new carpeting, cabinet fronts, and a hot water heater have been installed, along with a new toilet downstairs for added comfort and functionality. For enhanced security and peace of mind, an alarm system by Nextech has been installed, ensuring the safety of your new home. Don`t miss the opportunity to own this remarkable property in Russell County. Contact us now to schedule a viewing and experience the epitome of luxurious living at 316 Hartman. Contact Kendra at About You Realty, 785.483.9347.
MlsNumber: 203202


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: Kendra Trueblood
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','nvhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'nvhud', 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