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;

501 Broadway Avenue
Burdett, KS 67523
Lisa Schartz with Picket Fence Real Estate Llc, original listing - (620) 285-2951

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $178,500
Beds: 5
Baths: Full: 2, ¾: 1
Status: Active
SqFt: 2470 Square Feet
Agency: Picket Fence Real Estate Llc
Agency Phone: (620) 285-2951

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1928
Notes: This property blends modern updates w/the original charm of the home5-bedroom 3 bath, 1 story home with approx. 2,470 sq ft of living area Renovations include a beautiful new kitchen, updated baths, plus solid surface flooring, updated lighting & fresh paint.Approx. 1.31 acres on a large corner lot in the quaint community of Burdett, KS. The home invites you with south facing covered front porch fantastic for morning coffee or evening relaxing. The large living room boasts a stunning stone fireplace w/ a beautiful black mantel, new flooring, fresh paint, updated ceiling with recessed lighting. Open stairway & plentiful windows highlight the living area open to the dining space. The dining area connects to the updated kitchen with oak cabinetry and amazing countertops, farm sink and stainless appliances. Main floor features large updated bath w/ an abundance of cabinetry and vanity countertop, main floor bedroom with ample space.Upstairs includes two bedrooms w/ add'l living area, walk in closets and updated flooring and an updated full bath w/ large vanity/storage. Basement offers large primary bedroom w/ egress window & extremely spacious walk-in closet, bath, bonus room w/ egress window, great for a bedroom (non-conforming/no closet), playroom, office, workout room, or storage. The main floor laundry area/mudroom is conveniently located off the west door that leads from add'l mudroom area adjoining the oversized double attached garage w/ workshop space & double overhead door plus walk outdoor to fenced backyard. Conveniently access the fenced backyard from the home thru the east sliding door in the kitchen for fantastic outdoor living, w/ garden area, outside water hydrant, basketball court, & 15x12 storage shed. Added features include ch/ca, updated concrete, plumbing, garden sheds, metal siding & roof for low exterior maintenance. Exterior offers great space beyond fenced yard w/ garden shed (2022) and exterior room to grow
MlsNumber: --
ListingId: 85005


Listing Provided By: Picket Fence Real Estate Llc, original listing
Phone: (620) 285-2951
Office Phone: (620) 285-2951
Agent Name: Lisa Schartz
Disclaimer: Copyright © 2024 Kansas Property Ads. 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