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

502 N Broadway St
St. John, KS 67576
Rita Stimatze with Red Cedar Land Company, original listing - (620) 377-5022

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $350,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 2721 Square Feet
Agency: Red Cedar Land Company
Agency Phone: (620) 377-5022

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1925
Notes: This immaculate 4-bedroom, 4-bathroom home is ideally situated on a corner lot, just one block from downtown and directly across from the high school. Recently updated and move-in ready, this residence seamlessly combines modern amenities with charming details. As you approach the home, you are greeted by an inviting east-facing front porch and a stunning full glass front door that opens into a welcoming foyer with an open stairway and convenient half bathroom. Inside, the home boasts beautiful hardwood flooring, high ceilings, and large windows that flood the space with natural light. The main floor features a spacious living room and dining room, both showcasing exquisite woodwork and flooring. The updated kitchen is a chef's delight, equipped with sleek white cabinetry, quartz countertops, a stylish subway-tiled backsplash, an open pantry, and included stainless steel appliances. Adjacent to the kitchen, the cozy breakfast nook provides a lovely view and access to the backyard, perfect for morning coffee. As you ascend to the second story, you'll find two additional bedrooms and a full bath adorned with ceramic tile and a well-sized vanity. The expansive master bedroom also resides on this floor, featuring a luxurious walk-in onyx shower in the master bath. For added convenience, the utility room is located on the second floor, complete with a washer and dryer included. The finished basement adds even more living space, featuring a comfortable living room, and additional bedroom, and a bathroom, making it perfect for guests or as a private retreat. The mechanical room offers additional storage and utility space. Outside, the property boasts a detached garage, providing ample storage and parking options. The lush green yard is beautifully maintained and features an underground sprinkler system, ensuring your outdoor space stays vibrant and inviting throughout the seasons. This home offers a perfect blend of comfort, style, and functionality. Don't miss your chance to make this stunning property your own! (Man level: front entry with closet, half bath, sitting room, dining room with window seat, kitchen, open pantry, back entry. Second level: 2 bedrooms with closets, one full bath, master bedroom with three-quarter bath and closet, laundry. Basement: mechanical room with storage, living room with fireplace, sitting area, one three-quarter bath, one non-conforming bedroom with closet).
MlsNumber: --
ListingId: 11354494


Listing Provided By: Red Cedar Land Company, original listing
Phone: (620) 377-5022
Office Phone: (620) 377-5022
Agent Name: Rita Stimatze
Disclaimer: Copyright © 2024 My State 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 = 985 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