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

3275 Haven Drive
Jenison, MI 49428

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $523,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2220 Square Feet
Agency: Eastbrook Homes Inc.
Agency Phone:

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: Pool
Property Condition: New Construction

Neighborhood/Schools

Elementary School/District: Georgetown Elementary School|El Puente Elementary School/Hudsonville PSD|Jenison PSD
Middle/Junior High School/District: /Hudsonville PSD|Jenison PSD
High School/District: Hudsonville High School|Jenison Senior High School/Hudsonville PSD|Jenison PSD
Subvidision Name: Lowing Woods

Description/Comments


Lot Size: 0 sqft
Property Type: Other-Other
Year Built: --
Notes: Buildable Home Plan - Photos are Representational The Fitzgerald home plan is an elegant, contemporary ranch style home with three bedrooms, two full baths, one half bathroom and 2220 finished square feet.. Walk into your new Fitzgerald home from the pillared front porch to the main entryway. The formal dining area is positioned just off the front hall and can be transformed into an office with stylish French doors, tray ceiling, and closet space to suit your needs. The dining room and entryway lead back into the spacious family room, which can be further enhanced with one of two cozy fireplace options. The open family room transitions smoothly into the kitchen and breakfast area. The breakfast area includes a sliding door to the back yard, and can be enlarged with a generous bumpout option. The kitchen includes a sizable walk-in pantry, an island with double sink, and offers multiple options to personalize the cabinets, counters, and appliances to create your own unique space. The kitchen leads back to the mudroom with optional lockers and drop zone, the main level laundry room with optional folding counter or cabinets, an optional half bath, and the substantial two or three car garage.The owner's suite is located off of the kitchen and incorporates a sunlit master bedroom, a private master bathroom, and a large walk-in closet. The master bedroom can be expanded for additional space and offers an optional tray ceiling. The master bathroom has the option to add a double sink, plus a tile shower or a soaking tub and step-in shower. Love this home? Please note that this is a ready-to-build home plan, which means that style, selections, and options are representational. Youll be able to personalize this home to your liking, and your final price will depend on what options you choose! Contact us for more information on ready-to-build home plans, included features, and pricing.
MlsNumber: --
ListingId: 1567398


Listing Provided By: Eastbrook Homes Inc., original listing
Phone: (616) 326-3254
Agent Name: Kurt Suidinski
Disclaimer: Copyright © 2024 DRB Group (BDX). 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