Title Page Background
DEBUG FN args: Array ( [0] => 1314 [1] => [2] => [3] => agent ) BEFORE: Site: 1314 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1314 Igate: njhud LocID: 1314 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 = 1314 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1314 [1] => [2] => [3] => lender ) BEFORE: Site: 1314 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1314 Igate: njhud LocID: 1314 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 = 1314 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1314 [1] => [2] => [3] => other ) BEFORE: Site: 1314 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1314 Igate: njhud LocID: 1314 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 = 1314 AND i.igate IN ('mihud','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 = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

125 Elkenburg Street
South Haven, MI 49090

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $824,900
Beds: 3
Baths:
Status: Active
SqFt: 4031 Square Feet
Agency: Coldwell Banker Woodland Schmidt

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Condominium
Year Built: 1928
Notes: South Haven's Factory condo developer's unit with 4,000+ SF, 2 bedrooms plus a Murphy bed so sleeps like a 3 bedroom, 3.5 baths, 2 jet tubs, heated floors up & down & enclosed courtyard w/snowmelt. Open concept with very high-end finishes. Sleek gourmet chef's kitchen with stainless steel appliances & large butler's pantry. 3 ovens, 2 dishwashers, 2 laundries. Amazing atrium dining area with enclosed terrace with outdoor kitchen. Huge ensuite with great master bath & HUGE closet. Large fenced yard. Backs up to Van Buren & KalHaven bike trails and a block off Lake Michigan within a mile or less of South Beach & Kids Park. MUST SEE this one to appreciate. New geothermal Feb. 2024 and hot water heater ($20,000+/-). Built in speakers & fire suppression system. Seller is licensed realtor in the state of Michigan Amazing finishing touches including a $15,000 artichoke lamp featured in MOMA in the dining room. Much of the furniture is negotiable separately but not most of the art. Dining room fits 12 or more nicely. Sliders open to enclosed courtyard with grills, sink, and mini refrigerator. Seller is a licensed real estate agent in the state of Michigan<br /> <br /> There is storage galore both off garage (only unit that enters into their unit directly from garage) with loads of extra parking in the huge parking area. Dogs are allowed. Large fenced yard out back. Elevator can be used for moving furniture upstairs. <br /> <br /> Two laundries, 1 per floor. One in master closet. Two jet tubs. Two person shower in master. Maintained extremely well. Great light upstairs. Owner thought about adding rooftop deck and adding window in living area above the 3 gas fireplace burners where statue is hanging. Great place year round or as a second home. <br /> <br /> Super quiet area and condo within 1 mile walk or bike ride to beautiful downtown S Haven and the S Haven Yacht Club, beach and parks and bike trail out your back door. Pickleball, tennis courts, and other sports fields just a short distance at Elkenburg and LeGrange at the South Haven high school.<br /> <br /> Its believed the condo was totally rebuilt from studs in 2001 (only walls and maybe some roofing). Former factory.<br /> <br /> Basically the Board has to approve all Pets and only 2 are allowed. Each unit only gets 1 indoor parking space but they could barter with another owner who may be gone all winter or summer to use their indoor space. <br /> Below is the wording in the updated Bylaws.<br /> <br /> A. No more than two automobiles in total shall be kept on the condominium property by persons residing in a unit without written or e-mailed permission from the Board of Directors. Each owner shall be provided with 1 indoor parking space per unit identified when the unit is purchased. Subsequent changes in unit specific parking spaces can be agreed between Co-Owners with notification to the Board of Directors by all Co-Owners involved.<br /> B. Parking of any vehicle in a manner that obstructs driveway access is prohibited.<br /> <br /> A. Animals.<br /> 1. Renters and/or their guests will not be permitted pets.<br /> 2. No animals, livestock, or poultry of any kind shall be raised, bred, or kept as pets in any units except for dogs, cats and caged birds. No more than a total of two pets will be permitted and all pets must be approved by the Board of Directors.<br /> 3. All pet owners are responsible for cleaning up after their pets in their units and Common Areas.<br /> 4. All pets must be kept on a leash at all times when not inside a unit or fenced area, and must also be controlled when inside the units so they are not obnoxious because of noise, odor, or unsanitary conditions.<br /> 5. On demand by the Board of Directors, any pet owner shall be responsible for producing to the Board of Directors evidence of all pet vaccinations that have been administered to such owner's pet.<br /> 6. All animals must be attended to at all times when not inside a unit. "Attended to" means within the visual or audible control of the
MlsNumber: --


Listing Provided By: Coldwell Banker Woodland Schmidt, original listing
Phone: (616) 218-0267
Office Phone: (616) 396-5221
Agent Name: Andrea Crossman
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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