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

4524 Whittington Circle
The Villages, FL 32163

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2061 Square Feet
Agency: NextHome Sally Love Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2022
Notes: IMMACULATE EXTENDED 3/2 BEGONIA with GOLF CART garage on POOL READY LOT!, located near HOG EYE PRESERVE and EDNA'S ON THE GREEN, in the Village of DeLuna. Front door UPGRADED WITH WINDOW in addition to sidelight window and overhead entry window provide additional light to entry. OPEN KITCHEN FLOORPLAN with breakfast nook and front view window, upgraded cabinetry, GAS RANGE, GE appliances, Large basin sink with CUSTOM FAUCET with detachable spray head. Large dining area, CUSTOM WINDOW BLINDS throughout, Deluxe tile throughout open floor plan and into bedrooms and baths. Large Master bedroom with TRAY CEILING, Master closets are HIS/HERS opposing with wire closet organizers. The Master Bath features SEPARATE VANITIES, MEDICINE CABINET and LARGE ROMAN SHOWER. Bedroom number two sports a GRAND BAY WINDOW and TRAY CEILINGS. The second bath has LARGE UPGRADED TILE SHOWER with glass enclosure, a pocket door allows privacy separation from the living area. Large WALL MOUNTED TV's have been installed in each of the bedrooms (3), The EXPANDED LIVING ROOM has a LARGE WALL MOUNTED TV. PANORAMIC SLIDING DOORS lead to an EXPANDED EAST FACING SCREENED LANAI with views of the POOL READY BACKYARD. There is a large concrete patio just outside of lanai. NEW LANDSCAPE BED CURBING WITH ACCENT ROCK professionally installed January 2024. NOVA WHOLE HOME WATER FILTRATION SYSTEM, The garage doors are UPGRADED WITH TOP PANEL WINDOWS. This area of DeLuna is away from the Turnpike noise but accessible to many amenities, BROWNWOOD SQUARE, RICHMOND PITCH AND PUTT, EDNA'S ON THE GREEN with nearby MARSH VIEW PITCH AND PUTT are only minutes away by golf cart, 4 pools are close by, including Deluna, Waterlily, Cattail and EVERGLADE RECREATION and SOFTBALL CENTER. Miles of walking trails surround this area including HOG EYE PRESERVE. Lowlands, Loblolly, and Longleaf EXECUTIVE GOLF COURSES are nearby. EASY ACCESS to US 301 provides the fastest non-roundabout access to all areas of the Villages as well as CONVENIENT ACCESS to the Turnpike and Freeway 75. MAGNOLIA PLAZA Shopping Center is ACCESSIBLE BY GOLF CART and has a PUBLIX, McDonald's, PIZZA, BBQ, SHIP STORE, 7-ELEVEN with golf cart gas and more. Owner is open to Turnkey offer. MUST SEE!
MlsNumber: --


Listing Provided By: NextHome Sally Love Real Estate, original listing
Phone: (720) 518-1273
Office Phone: (352) 399-2010
Agent Name: Maria Martinez
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App