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 = 3219 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 = 3219 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 = 3219 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;

15416 Nw 45th Place
Newberry, FL 32669
Betsy Pepine with PEPINE REALTY, original listing - (352) 226-8474

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,150,000
Beds: 6
Baths: Full: 7
Status: Active
SqFt: 7062 Square Feet
Agency: PEPINE REALTY
Agency Phone: (352) 226-8474

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Welcome HOME to PERFECTION!<br /> This magnificent 6 bedroom, 2 office, 7 bathroom custom-built by Mark Warring on a park-like estate is set on 5 pristine acres in the exclusive gated community of The Grove. With only 24 homesites, this elite neighborhood provides an unparalleled standard of luxury living, just minutes from Gainesville.<br /> <br /> Walk up the brick paver entry to a meticulously designed estate for both grand entertaining and comfortable family living. This expansive manor exudes excellence at every turn. The main house has 5 spacious bedrooms, formal living and dining rooms, chef's kitchen, 2 home offices, game room, theatre & a huge upstairs 2nd game room/playroom. Beautiful arched windows abound. The home also includes an attached main level apartment w/1 bedroom, 1 bathroom, kitchen, great room, laundry, its own dedicated garage, and private entrance, accessed through the pool area. The main-level primary suite is flooded with natural light and features elegant crown molding, intricate ceiling details, a cozy gas fireplace, and a custom-designed his and her walk-in closet. The spa-inspired bathroom is complete with split vanities, a luxurious soaking tub, & private shower. A second spacious bedroom is also on the main level.<br /> <br /> The 2nd floor offers 3 en-suite bedrooms, including one with a private balcony overlooking the front of the home featuring a great view of a majestic Live Oak. Two other bedrooms have beautiful window seats with delightful views of the property. All 5 bedrooms in the main home come with a dedicated bathroom & walk-in closet! The upper level also includes a spacious game area loft, storage rooms & a serene balcony off the bonus room overlooking the pool area.<br /> <br /> At the heart of the home lies an oversized chef’s kitchen—a culinary masterpiece w/stunning granite countertops, custom cabinetry, high-end stainless-steel appliances, oversized island, 6 burner gas range, 2 ovens, 2 dishwashers, 2 sinks, a large walk-in pantry, an eat-in dining area, & a built-in desk workstation. This kitchen is designed for culinary excellence and opens to the spacious family room with a soaring ceiling.<br /> <br /> Additional luxury features include a private home office + another office not included in the bedroom count, a formal dining room, a dramatic foyer with soaring 20+ ft cathedral ceilings, a formal living room, and a two-story family room complete with entertaining bar & wine refrigerator, a fireplace & a cathedral ceiling that seamlessly connects to the lanai. Entertainment options abound, with a dedicated game room & a state-of-the-art media room equipped w/movie theater screen & A/V technology.<br /> <br /> Beautiful wood floors grace the main living areas, adding warmth & sophistication throughout. Home also features central vacuum, tankless water heaters, & a two-sided (see-through) fireplace in the game room/pool area! The exquisitely landscaped grounds are highlighted by majestic Live Oak & chestnut trees and enhanced by premium Entropics lighting. The resort-style heated pool and spa, complete with a summer kitchen, provide the perfect setting for outdoor entertaining. The estate also includes a 3-car garage, an additional 2-car garage, and a sprawling driveway ideal for activities such as pickleball, along with plenty of green space and a gas fire pit for outdoor enjoyment. Save money with CLAY ELECTRIC! Located just minutes from local area shopping, restaurants, hospitals, nature parks and trails. Welcome HOME to The Grove!
MlsNumber: --
ListingId: GC525713


Listing Provided By: PEPINE REALTY, original listing
Phone: (352) 226-8474
Office Phone: (352) 226-8474
Agent Name: Betsy Pepine
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 = 3219 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 Arthur "AK" Lovarco
Arthur "AK" Lovarco
ASCIIeXp Realty
Call Today!: (352) 445-4688

Local Mortgage Pro

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 = 3219 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;
Real Estate Expert Photo for Daniel E Giroux NMLS#26531
Daniel E Giroux NMLS#26531
ASCIISemper Home Loans, Inc
Call Today!: (401) 578-8929

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App