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

916 W 12th St
Larned, KS 67550
Lisa Schartz with Picket Fence Real Estate LLC, original listing - (620) 285-2951

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $389,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Picket Fence Real Estate LLC
Agency Phone: (620) 285-2951

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1975
Notes: 4 Bedrooms, 3 Bathrooms Stunning property featuring a pristine home and an impressive 24 x 30 shop This immaculate ranch-style home is situated in a well-established neighborhood, offering approximately 3,780 sq ft of living space. Upon arrival, you are greeted by a lush lawn, exquisite landscaping, and a beautiful front porch and entryway. Inside, the home welcomes you with a lovely living area that leads to a central hallway, providing access to a beautifully updated full bath, a bedroom\office, and a spacious primary suite with a ¾ bath and double closets. The updated chef’s kitchen boasts remarkable tile work, a center island, under-cabinet lighting, stainless-steel appliances, and stunning onyx countertops, along with a dining and coffee bar area. This kitchen seamlessly opens into a fantastic family room, which is awash with natural light from the east-facing bay window and sliding doors that lead to the west patio. The family room also features an electric fireplace and ample storage. Completing the main floor is an exceptional laundry\mudroom, equipped with beautiful cabinetry and a sink area. This space is conveniently located off the main hallway and connects to the backyard through sliding doors that open up to a fantastic deck, perfect for outdoor living!! The basement adds additional living space, featuring two non-conforming bedrooms, a ¾ bath, and a bonus room with a sink, providing endless possibilities for crafts, office work, or homeschooling. The basement also includes a mechanical room and an extra storage room. The outdoor living spaces are abundant, with a west patio area ideal for BBQs and a north deck nestled in a shaded, fenced backyard, complete with beautiful brick pathways. Additionally, the property features a remarkable 24x30 meticulously maintained workshop, equipped with a security system, heating and air conditioning, dedicated electrical, and an organizational setup that is a dream come true. The shop has ample space for two vehicles. Further amenities include an extensive home remodel, new flooring, new lighting, fresh interior paint, impact-resistant shingles, updated windows, updated kitchen, updated baths, central heating and air conditioning, an oversized double attached garage, a lawn sprinkler system, and a garden\mower shed. This turnkey home and pristine shop are truly magnificent and a rare find..
MlsNumber: --
ListingId: 203758


Listing Provided By: Picket Fence Real Estate LLC, original listing
Phone: (620) 285-5887
Office Phone: (620) 285-2951
Agent Name: Lisa Schartz
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 = 965 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App