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;

2 S Boyd 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: $153,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1944 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-Single Family Residence
Year Built: 1951
Notes: Almost an acre in the bustling town of Caldwell with the city park and pool just across the street to the west, it's like having your own pool but someone else maintains it! This home has a lot to offer -- large living and dining area, 3 bedrooms, 2 baths (the bath on the main floor is updated), the kitchen is updated. The basement has a family room with fireplace (never used) and a huge closet. The family room is currently being used as the master bedroom. The basement has a large laundry room with sink and the basement also offers a huge storage area. There is a detached garage/shop approximate measure is 38x43 with electricity. The large yard is partially fenced and has a hand pump well for your outside watering needs. This home is within walking distance to the schools and downtown and sports complex. Buyers if you have been thinking about moving to a small town, you need to check Caldwell, KS out, located on the KS/OK border, with a rich history and a truly busy downtown. ***This area qualifies for USDA -- zero down loan, based on total household income, credit score and debt to income.****DO NOT ATTACH a letter from the buyer when submitting an offer due to the risk of Fair Housing Violations. ****Buyers be pre-qualified or have proof of funds before viewing.***The Sumner County casino offers to all Sumner County students 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 and to determine if you qualify.**** 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., if it is important to you, then investigate and inspect to satisfy yourself. Room sizes are estimated*****
MlsNumber: --
ListingId: 647471


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