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

62128 315th Street
Maxwell, IA 50161

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $575,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1473
Agency: Whitaker Marketing Group

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Location of Land: Located 8.9 miles South of Nevada, IA or 4 miles West of Maxwell, IA Directions to the farm: From Nevada, IA, head South on 6th St and continue South onto 620th Ave for 6.5 miles. Turn left (East) on 315th St. The property is on the right (North) side of the road. From Maxwell, IA, Take 640th Ave West for 2 miles. Then turn right (North) on 630th Ave for half of a mile. Turn left (West) onto 315th St, and the property will be on the left (South) side of the road. Legal Description: Sec 19-82N-22W. Parcel ID (15-19-300-125) Gross Acres: 3.58 Net Acres: 3.15 Taxes: $4,934 Estimated Zoning: A-1 Agricultural Taxing District: Indian Creek Twp School District: Collins-Maxwell Community School House Information Occupancy: Single-Family / Owner Occupied Style: Split Level Frame Year Built: 1976 Condition: Very Good Grade: 3 Roof: Asphalt / Hip Flooring: Carpet / Tile / Hardwood Foundation: Conc Block Exterior Material: Composite Interior Material: Drywall Brick or Stone Veneer: 1/2 Story Brick; 82 linear ft. Total Gross Living Area: 1,473 SF Number of Rooms: 5 above; 4 below Number of Bedrooms: 3 above; 0 below Basement Area Type: Full Total Basement Area: 1,188 Basement Finished Area: 506 - Living Qtrs. (Multi); 682 - Living Qtrs. (Multi) Plumbing: 2 Standard Bath - 3 Fixt; 1 Shower Stall Bath -3 Fixt; 1 Sink; Appliances: 1 Dishwasher Central Air: Yes Heat: FHA-Gas Fireplaces: 1 Prefab; Porches: Frame 3 Seasons (169 SF); 1S Frame Open (190SF)
MlsNumber: 6316254


Listing Provided By: Whitaker Marketing Group, original listing
Name: Whitaker Marketing Group
Phone: (515) 460-8585
Office Name: Whitaker Marketing Group
Office Phone: (515) 460-8585
Agent Name: David Whitaker
Disclaimer: Copyright © 2024 RLI Farm & Ranch 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 = 878 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;
Real Estate Expert Photo for Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App