Title Page Background
HFQUERY 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 ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','flhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','flhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

271 Oak Park Place
Casselberry, FL 32707

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $412,500
Beds: 3
Baths: 2
Status: Active
SqFt: 1646
Agency: Direct Sell Inc DBA Weichert Realtors Hallmark Pro

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1993
Notes: You are going to fall in love with this beautiful, premium corner lot home that has been pampered since 1993 by the original owners. The pride of ownership and meticulous upkeep of this home is astonishing. As you walk up, you'll see how well the yard is being taken care of. As you walk in the front, it immediately feels like home. You'll notice the beautiful wood floors throughout the home, except in the kitchen and wet areas. Large and multiple windows in the formal living room allow natural light to flow through and showcase the high ceilings and shelving/ledge capacity for additional decorating. The formal dining room is ahead on the left with high vaulted ceilings. The kitchen is spacious with the ability to have a small dinette area. Laundry closet is in the kitchen. Washer and Dryer convey. Dryer is gas. Cabinets are solid oak. No need to replace the beautiful wood, just have them repainted to your liking. New stainless-steel appliances, except dishwasher. Range is gas. The family room is spacious at 13' x 15' with french doors that lead to the enclosed screened patio. Split floor plan with two bedrooms on the left side of the home and the primary bedroom on the right side. The guest bathroom has new fixtures and a door that leads to the enclosed patio. The primary bedroom has plenty of room at 15' x 11'. There are french doors that lead to the enclosed patio. Large primary bathroom with dual vanity, new fixtures, soaking tub, separate shower, toilet room, and a walk-in closet. AC, Water Heater, Range, and Dryer are all-natural gas. Fenced in yard for your privacy. New AC 2018. New Water Heater 2023. New Roof 2023.Double paned windows. Home has been re-piped and electric has been updated. All of the expensive projects have already been completed for you. This home is everything! Sunset Oaks is a quite hidden gem in a fantastic location. Near Sunset Park and Concord Park where you can enjoy free monthly concerts and various city events. Secret Lake Park is close by if you would like to partake in basketball, tennis, or just hit the playground. There is also a senior center with public activities. There is something for everyone nearby. Property is under audio/visual surveillance.
MlsNumber: O6193278


Listing Provided By: Direct Sell Inc DBA Weichert Realtors Hallmark Pro, original listing
Name: Direct Sell Inc DBA Weichert Realtors Hallmark Pro
Phone: (407) 841-0888
Office Name: WEICHERT REALTORS HALLMARK PROPERTIES
Office Phone: (407) 644-5385
Agent Name: Jeff Stewart
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

HFQUERY 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 ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC 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