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

2405 Hawthorne Ln
Hutchinson, KS 67502
PATSY LOVETT with J.P. WEIGAND & SONS, INC, original listing - (316) 284-1973

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 4
Baths: Full: 4, ½: 2
Status: Active
SqFt: 7339 Square Feet
Agency: J.P. WEIGAND & SONS, INC
Agency Phone: (316) 284-1973

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Welcome to this STUNNING NUNNS BUILT MASTERPIECE on 4.17 acres w/ FOUR bedrooms, FOUR FULL and 2 half baths. FULL BASEMENT w/ ROOM TO ADD MORE LIVING SPACE OR BEDROOMS. Gorgeous WOOD FLOORS and newly REMODELED KITCHEN (2019) with NEW QUARTZ COUNTERTOPS, BACKSPLASH. DRINK STATION/COFFEE BAR with BEVERAGE REFRIGERATOR & ICE MAKER. ) NEW WOLF APPLIANCES (gas cook top, sub zero refrigerator, double oven & warming drawer, Cove dishwasher.) WALK IN PANTRY w/ separate WOLF freezer. BUTLER'S PANTRY to DINING ROOM for easy entertaining. Back living area w/ built ins and wood burning fireplace. HUGE PRIMARY BEDROOM on main level with fabulous bathroom. Separate office with built ins. Screened in porch on both main & 2nd floor. UPSTAIRS HAS A LOFT AND THREE LARGE BEDROOMS WITH THEIR OWN BATHROOMS. PLUS A HUGE BONUS ROOM PERFECT FOR PLAYROOM OR MEDIA ROOM. BASEMENT is partially finished with LARGE living area and HUGE UNFINISHED SPACE. PLUMBED FOR 5TH bathroom. GORGEOUS 20 X 60 SALT WATER POOL (installed in 2022 by Ebeling Pools) FEATURING POOL HOUSE with covered patio, wood burning fireplace, half bath and outside shower. Great place to watch your favorite team! Pool can be heated or cooled! Don’t miss the fabulous GARDEN with fruit trees (apple, cherry, etc.), produce, wild flowers and herbs. Impact resistant roof 2019, new enlarged back patio and steps (2021), new fencing around pool (2022). Full underground sprinkling on 2 wells. A TRULY SENSATIONAL HOME!
MlsNumber: --
ListingId: 51326


Listing Provided By: J.P. WEIGAND & SONS, INC, original listing
Phone: (316) 284-1973
Office Phone: (316) 284-1973
Agent Name: PATSY LOVETT
Disclaimer: Copyright © 2024 Mid-Kansas MLS. 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 = 970 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 Tod Emerson
Tod Emerson
ASCIIHeritage 1st Realty
Call Today!: (620) 245-4237

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App