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 ('vahud','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 = 'vahud', 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 ('vahud','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 = 'vahud', 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 ('vahud','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 = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1044 Alcove Loop
The Villages, FL 32162
Kerry Hanson with LPT REALTY, original listing - (352) 460-4396

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,039,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2539 Square Feet
Agency: LPT REALTY
Agency Phone: (877) 366-2213

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: WHERE DO WE BEGIN...GOLF & WATER VIEW*POOL & HOT TUB*BRAND NEW ROOF*BOND PAID*REMODELED BRIDGEPORT Model 2539 sq ft in the VILLAGE OF HEMINGWAY 3 Bed | 2.5 Bath | This home is a true showstopper, perfectly positioned with breathtaking views of the 4th TEE BOX on the ROOSEVELT GOLF COURSE with a massive BIRDCAGE to enjoy watching the GOLFERS and the SERENE WATER VIEW. The BIRDCAGE was recently re-screened to include one side with UV PROTECTION and there is also a remote screen on the outside of the birdcage for added privacy. This home is an entertainer’s dream. From the moment you arrive, you'll be captivated by the stacked stone landscaping and a textured, CUSTOM-COORDINATED driveway that perfectly compliments the elegant front door. Adorned with 18-inch diagonal ceramic tile throughout, adding to the spacious and seamless feel. There is a foyer closet and a half bath with QUARTZ counters and a beautiful DESIGNER KOHLER DUTCHMASTER BLUSH FLORAL sink and KOHLER faucet. There is a striking QUARZITE feature wall in the living room. Relax in the 16x12 sunroom that overlooks the POOL & SPA, watch the golfers or lower the remote screens for extra privacy. The REMODELED kitchen shines with honed leather GRANITE countertops & BACKSPLASH (DOUBLE WATERFALL GRANITE on the RANGE wall), 2024 CAFE' Appliances, Carrera marble WATERFALL ISLAND, BAR area with a GRANITE wall, WINE FRIDGE plus teardrop light fixtures. Off the kitchen is a 12x15 dining room with LARGE SLIDERS leading to the birdcage. The laundry room is also off the kitchen leading to the garage for easy convenience. Featuring CAMBRIA QUARTZ countertop, DESIGNER SINK, matching CAFE' Microwave, SPEED QUEEN washer and LG dryer, CENTRAL VACUUM SYSTEM just outside the laundry room. The guest bedroom has been used as an office with built in cabinets and a desk. Both bedrooms have closets and they share a Jack & Jill bathroom with a shiplap wall, CARRERA MARBLE counter, DERRING CARILLON KOHLER SINK sink and faucet. The primary bedroom has 2 closets, GRANITE COUNTERTOPS, a linen closet and a ROMAN SHOWER. Let's talk about the garage...NEW EPOXY FLOOR, GOLF CART GARAGE, MITSUBISHI MINI SPLIT, work area in garage, Whole house NOVA water filtration system, ALUMINUM attic stairs with massive ATTIC storage area and MOISTURE BARRIER FOILED WRAPPING. Included in the sale is a 2017 4 seater PAR GOLF CART with 2 new batteries with acceptable offer.<br /> <br /> ADDITIONAL FEATURES: OVER $30K IN STONE UPGRADES, Custom Hunter Douglas Sliding Blinds, New 1HP MOEN Garbage Disposal with lights when cabinet door is opened, Plantation Shutters, 2021 Water Heater, 2019 Prime Carrier System, Ditek surge protection system, LIGHTENING ROD system on roof, Under cabinet and under granite lights on sink wall, Insulated garage door, plus a buried 250 Gallon Propane tank. Don't forget the BOND IS PAID IN FULL and that's over an $11,000 savings. Don't forget to watch the VIDEO and CALL NOW to see this amazing home!
MlsNumber: --
ListingId: G5092759


Listing Provided By: LPT REALTY, original listing
Phone: (352) 399-1412
Office Phone: (352) 460-4396
Agent Name: Kerry Hanson
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