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

1288 Sydney Court
Altamonte Springs, FL 32714

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $929,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 4471 Square Feet
Agency: FANNIE HILLMAN & ASSOCIATES

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Range, Refrigerator, Garbage Disposer, Oven - Convection
Architectural Style: New Traditional
Construction Materials: Stucco, Frame, Block
Cooling: Zoned A/C
Flooring: Carpet, Tile, Wood, Tile - Ceramic
Heating: Central Furnace, Fireplace
Interior Features: High Ceilings, Window Treatments, Walk-in Closet(s), Eat-in Kitchen, Tray Ceiling(s), Crown Molding, Stone Counters, Split Bedroom, CEILING FANS(S), PRIMARY BEDROOM MAIN FLOOR, SOLID WOOD CABINETS, KITCHEN/FAMILY ROOM COMBO
Rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Dining Room, Kitchen, Laundry, Bonus Room, Family Room, Living Room, Game Room

Window Features

Exterior Features: Pool, Lighting, Irrigation System, Fencing, Rain Gutters, Outdoor Grill, Sliding Doors, Sprinkler Metered, Private Mailbox
Fencing: Fenced
Parking Features: Off Street, Garage, Driveway, Garage - Attached, Workshop
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Bear Lake Elementary
Middle/Junior High School/District: /Aldine ISD
High School/District: Lake Brantley High
Subvidision Name: EDEN PARK ESTATES

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Welcome to 1288 Sydney Court! Expect to be impressed with this custom built home featuring 5 Bedrooms/3 full baths/4471 square feet & amazing floor plan. Outstanding curb appeal with meticulous landscape invites you via double doors into a lovely foyer & living room with Brazilian Cherry floors & gas fireplace that leads to a spectacular screened salt water pool & hot tub, oversized brick paver patio, outdoor kitchen with built-in gas BBQ & refrigerator + lush, fenced backyard. The Chef's kitchen renovated in 2021 boasts new cabinets, countertops, appliances, a large breakfast bar, walk-in pantry & charming breakfast nook that flows into the spacious family room with gas fireplace. The 3 way bedroom split plan includes stunning first floor Primary Suite with fireplace & huge bathroom including dual vanities, his & her closets, jacuzzi tub with separate shower & water closet. Bedroom #2 is perfect for nursery, office or home gym. Private Bedroom #3 is on opposite side of first floor with full bath. UPSTAIRS offers a second family room/game room with balcony overlooking pool area, a bonus room, home office, 2 additional guest bedrooms & full bathroom. Extra include: High ceilings, crown molding, plantation shutters, remote blinds, surround sound, large laundry room, zoned AC, 2 gas water heaters, exterior paint 2022, new roof 2016, 3 car side entry garage with workshop & epoxy finished floor. Conveniently located near I-4 & thoroughfares. Zoned for Bear Lake Elementary, Lake Brantley High School & walking distance to Teague Middle School. Quaint gated neighborhood is the perfect place to call HOME!
MlsNumber: --


Listing Provided By: FANNIE HILLMAN & ASSOCIATES, original listing
Phone: (407) 252-3210
Office Phone: (407) 644-1234
Agent Name: Catherine D'Amico
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => seminole-south [3] => FL [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: seminole-south State: FL Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: seminole-south State: FL 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 = 3222 AND i.igate IN ('dehud','usahud','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 = 'dehud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Rick Brown
Rick Brown
ASCIIBrown Home Group at KELLER WILLIAMS REALTY
Call Today!: (407) 383-1866

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App