Title Page Background
DEBUG FN args: Array ( [0] => 857 [1] => [2] => [3] => agent ) BEFORE: Site: 857 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 857 Igate: njhud LocID: 857 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 857 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 857 [1] => [2] => [3] => lender ) BEFORE: Site: 857 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 857 Igate: njhud LocID: 857 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 857 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 857 [1] => [2] => [3] => other ) BEFORE: Site: 857 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 857 Igate: njhud LocID: 857 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 857 AND i.igate IN ('ilhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ilhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

223 Carver Avenue
Rhodes, IA 50234

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $584,900
Beds: 5
Baths:
Status: Active
SqFt: 2671 Square Feet
Agency: RE/MAX Precision

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Dryer
Architectural Style: Other
Construction Materials: See Remarks, Stone
Flooring: Carpet, Wood, Hardwood
Heating: Forced Air, Fireplace
Interior Features: Central Vac, Smoke Detector, Drapes/Curtains, 1st Flr Laundry
Rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Exercise Room

Window Features

Exterior Features: Deck, Open Patio
Parking Features: Driveway
Patio and Porch Features: Patio, Deck
Roof: Shingle, Asphalt

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: Introducing this immaculate one-owner two-story home perfectly situated on the Harvester Golf Course, boasting a generous .84-acre lot. This stunning residence offers 5 bedrooms, 4 baths, and over 3700 sq ft of finished living space. Retreat to the luxurious first floor en suite featuring a jacuzzi tub for ultimate relaxation. Enjoy the convenience of a walkout basement and the ease of low-maintenance living with a new roof and newer Pella windows. Entertain in style on the spacious deck overlooking the picturesque golf course while observing the country wildlife, and basking in the breathtaking sunrise and sunset views each day. Other features include 3-car attached garage, a gas fired auto-controlled fireplace, New AC in 2021, New interior ceiling paint on main level in 2023, Painted garage interior walls, ceiling, and installed new shelving racks in 2023. The house even comes with a new Stair lift to basement and ample storage throughout. Don't miss the opportunity to make this exquisite property your own! All information obtained from Seller and public records.
MlsNumber: --


Listing Provided By: RE/MAX Precision, original listing
Phone: (515) 223-9492
Office Phone: (515) 223-9492
Agent Name: Dustin Kupka
Disclaimer: Copyright © 2024 Des Moines Area Association of REALTORS®, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App