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

3450 River Rhone Lane
Columbus, OH 43221
Cece Miller with NextHome Experience, original listing - (614) 396-6900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,075,000
Beds: 4
Baths: Full: 5
Status: Active
SqFt: 5927 Square Feet
Agency: NextHome Experience
Agency Phone: (614) 396-6900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Sited in an incomparable setting in a gated community along the Scioto River, this 4 level residence comprises 4BR,4.5BA and extends over 7000sq.ft.of living space.Upon entry, the features are revealed to be a Magnificent dramatically designed main floor offering a Spectacular Great room w/ Custom Fireplace surround and walls of windows that frame the views and a sitting area that could also be used as a formal dining room. Beautifully finished Hardwood flooring and intricate custom woodwork throughout. Generously scaled living areas flow seamlessly adorned with fine architectural details,soaring ceilings and an ample amount of natural light. The exquisitely updated interior features a stunning brand new Gourmet Chef's kitchen fully equipped with high end Subzero and Wolf appliances, Intricate custom cabinetry, Stone backsplash, large Island for seating, prep station, brilliant counters and masterful finishes. This Kitchen is Ideal for culinary artistry and gracious entertaining.The spacious walk-in pantry is situated conveniently near the elevator-which is wonderful when hosting guests. Off of the kitchen, there is a patio with a built-in Viking stove and the Mudroom is perfectly situated. Primary suite is truly an Extraordinary private retreat complete with a fireplace, walk-in closets, Built-ins, and a tranquil sitting area. Grand spa inspired luxurious all marble bath with double sinks, walk-in shower and tub. Upstairs, you will find 2 expansive Bedrooms en suite and a den/office area. The lower level is absolutely perfect for entertaining including a kitchen/bar, dining/living spaces with french doors out to the covered balcony. Off of the balcony is a screened in Porch.The walk out level offers a Great room,exercise area,secluded patio with a hot tub.Unparalleled comfort landscaped grounds completes the peaceful setting and combines to make this one of the most compelling offerings. This Pristine home embodies the Essence of class, character and elegance!
MlsNumber: --
ListingId: 225016396


Listing Provided By: NextHome Experience, original listing
Phone: (614) 989-0417
Office Phone: (614) 396-6900
Agent Name: Cece Miller
Disclaimer: Copyright © 2025 NextHome, Inc. 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] => franklin-northwest [3] => OH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: franklin-northwest State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: franklin-northwest 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 = 2062 AND i.igate IN ('ohhud','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 = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Amy Conley
Amy Conley
ASCIICutler Real Estate
Call Today!: (614) 595-4344

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App