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

423 N St Marys St
Caldwell, KS 67022
VICKIE VARGAS-JACOBS with Coldwell Banker Plaza Real Estate, original listing - (316) 722-0030

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $142,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2227 Square Feet
Agency: Coldwell Banker Plaza Real Estate
Agency Phone: (316) 722-0030

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Manufactured Home
Year Built: 1974
Notes: This home is in good condition. Large home on just over 1/2 acre. The kitchen and main bath were remodeled within the last 5 years. Beautiful kitchen with all appliances and JennAir stove and oven which vents outside, quartz counter tops and sink, counter seating, enough room for a table plus dining area will accommodate a large table or would make a good family room. The living room is good size. The master bedroom has a master bath with sink and separate make up vanity and shower. The main floor also has another bedroom and office. The main floor bath was remodeled by Bath Fitters. The upstairs has 3 bedrooms, 2nd furnace and large bath with double sinks. The owners are leaving the cooling systems for each upstairs bedroom. The oversized attached 2 car garage 24x27 has 2 openers and keypad and offers good storage. The detached 1 car garage measures 24x26 has opener and key pad with access from the alley. The yard has an irrigation well and the owners loved their producing cherry tree. Front of home faces east, attached 2 car garage faces the north. ~~~ AGENTS READ THE PRIVATE REMARKS ~~~ BUYERS and AGENTS ALL INFORMATION DEEMED ACCURATE. PLEASE VERIFY INFORMATION TO SATISFY YOURSELF AS A BUYER AND/OR TRANSACTION BROKER OR A BUYER'S AGENT. Information such as room sizes, square feet, schools, lot lines etc. therefore if it is important to you, then investigate and inspect to satisfy yourself. **** The Sumner County casino offers to all Sumner County students who attend a Sumner Co. school at the start of the school year enrollment in grades K-12 a $100 educational reward card AND $1000 scholarship to all High School Graduates to be used towards their post-secondary education AND most teachers in Sumner County receive a $500 allowance to help defray the cost of classroom supplies, visit their website to learn more.****
MlsNumber: --
ListingId: 645426


Listing Provided By: Coldwell Banker Plaza Real Estate, original listing
Phone: (316) 393-4445
Office Phone: (316) 722-0030
Agent Name: VICKIE VARGAS-JACOBS
Disclaimer: Copyright © 2024 South Central 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 = 988 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