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

1401 Green Cove Road
Winter Park, FL 32789
Terry Yonker with BUCKEYE REALTY LLC, original listing - (407) 476-7935

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 4
Baths: Full: 4, ½: 3
Status: Active
SqFt: 5416 Square Feet
Agency: BUCKEYE REALTY LLC
Agency Phone: (407) 476-7935

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: This award-winning Tuscan Mediterranean residence seamlessly blends timeless architecture with a light-filled, open interior, situated on a spacious corner lot just moments from Park Avenue. From the moment you step into the grand foyer—with its graceful circular staircase, custom tile work, and rich wood floors—it's clear that every detail of this home was crafted with care.<br /> <br /> The heart of the home is a stunning chef’s island kitchen featuring professional-grade Thermador appliances, custom cabinetry, and granite countertops, all flowing effortlessly into the expansive family room with tranquil views of the private backyard. The main level also boasts a formal dining room, a dedicated office/study, a spacious laundry room, and a serene master retreat offering both privacy and luxury.<br /> <br /> Upstairs, you’ll find two oversized bedroom suites and a versatile bonus room, perfect for a media space or playroom. A separate attached guest suite with private entrance offers ideal accommodations for visitors or multi-generational living.<br /> <br /> The fully finished lower level includes two large rooms suitable for a home gym, media theater, additional office space, or ample storage.<br /> <br /> Outdoor living is just as exquisite, with a covered porch and summer kitchen, a serene pool and spa, and beautifully arranged entertaining areas around a charming outdoor fireplace. Lush, manicured landscaping frames the home, while updated LED lighting, bespoke built-ins, and fine tile finishes enhance every space.<br /> <br /> Located in one of Central Florida’s most desirable neighborhoods, this home offers walkable access to the best of Winter Park and Maitland. Please reach out to schedule a tour to take a look for yourself!<br /> <br /> Please see Matterport link for layout of this Beautiful Home.
MlsNumber: --
ListingId: O6306675


Listing Provided By: BUCKEYE REALTY LLC, original listing
Phone: (407) 476-7935
Office Phone: (407) 476-7935
Agent Name: Terry Yonker
Disclaimer: Copyright © 2025 Stellar MLS. 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