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

1920 Gingerfield Way
Sunbury, OH 43074
Lynette Cregge with Cutler Real Estate, original listing - (614) 339-4664

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4488 Square Feet
Agency: Cutler Real Estate
Agency Phone: (614) 339-4664

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2018
Notes: This meticulous 5 bed, 4.5 bath home is in the sought after Northstar community! Featured highlights: 2-story great room with floor-to-ceiling stone corner FP, wall of windows w/lots of natural light, double glass doors to one of the two flex rooms offers elegancy and privacy. Flex room can be used as a home office, den, formal living, media or other- you choose! Eat-in kitchen with island w/storage, pantry, double oven perfect for celebrations. Head upstairs -could have (2) owner suites since both have en-suites, 2 other bedrooms currently have king size beds in them for rm sizing. Another bed downstairs currently used as workout rm. 2nd fl laundry is convenient! Main Owner Suite boasts tray ceiling with chandelier, soaking tub with chandelier, walk-in shower, a double vanity and walk-in closet. Upgraded lighting throughout the home. Heading downstairs-the custom finished walkout basement is a must see ~complete with theater room, wet bar, could be bourbon sitting area now gaming area, workout as 5th bed, full bath and storage room. Use the walkout to go outside for more than just a patio.. this is a backyard oasis!! Picture yourself enjoying your peaceful backyard w/o neighbors behind you or entertaining in the pavilion cooking up food in the grill space. The pavilion has electrical w/lighting and a custom tv cabinet for watching sports/shows! Or gather around the built-in gas fire pit with sitting wall. Visualize yourself in the lounge area w/a book listening to the water fountain- so serene! Perfect for quiet time or entertaining! Lights illuminate the space at night automatically! The 3+ garage has a 10 foot enclosed bump out for possible golf cart, workshop, tools. storage, sports equipment and more -you choose! Versatile and flexible.This home is located in the Northstar community featuring amenities such as a walking path, Northstar Country Club- golf, dining, tennis/pickleball and pool.Welcome Home ! Owner agent.
MlsNumber: --
ListingId: 225012631


Listing Provided By: Cutler Real Estate, original listing
Phone: (614) 425-2731
Office Phone: (614) 339-4664
Agent Name: Lynette Cregge
Disclaimer: Copyright © 2025 Columbus and Central Ohio 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => delaware [3] => OH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: delaware State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: delaware State: OH 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 = 2058 AND i.igate IN ('cahud','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 = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for James Dull
James Dull
ASCIIRed 1 Realty
Call Today!: (740) 809-2908

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App