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 = 447 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 447 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 447 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

36 Stargazer Trail Nw
Rome, GA 30165
Keith Beauchamp with Hardy Realty & Dev. Company, original listing - (706) 291-4321

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,690,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Hardy Realty & Dev. Company
Agency Phone: (706) 291-4321

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 27 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1974
Notes: **Exceptional Property with Endless Possibilities - 27 Acres of Prime Real Estate** Welcome to your own private paradise! This extraordinary property spans 27 acres and offers a unique blend of luxurious living and investment potential. **Main Residence:** The centerpiece is a beautifully maintained 2,400 sq. ft. split-level home featuring Hickory cabinets in the kitchen and 10 KW generator. This inviting home includes 4 bedrooms and 3 bathrooms, ensuring ample space for family and guests. The lower level is perfect for relaxation, boasting a cozy family room that opens directly onto the beautifully landscaped pool area. Step outside to enjoy the serene surroundings or take a refreshing dip in the sparkling in-ground pool, ideal for those warm summer days. **Investment Opportunity:** The property includes five well-established 2 BR 1 BA duplexes, providing a steady stream of rental income. Each duplex is thoughtfully designed with comfortable living spaces and modern amenities. Additionally, there is a charming 2 BR 1 BA rental house, perfect for generating extra income or accommodating extended family. **Barn and Outbuildings:** A sizable barn complements the property, offering ample space for storage or hobbies. Attached to the barn is a versatile one-room apartment, which can be used as a guest suite, office, or additional rental unit. **Land and Location:** With 27 acres of lush, sprawling land, this property offers endless possibilities. Whether you envision developing the land further, starting a small farm, or simply enjoying the expansive open space, the options are limitless. The tranquil setting ensures privacy while remaining conveniently accessible to local amenities. The 15+ acre parcel is covered in loblolly pines planted in 2016 and 400 long leaf pines planted in 2019. This parcel is in an easement with 5 years left. Both the 8+ acre and 15+ acre parcel are zoned D-R with the 3+ acre parcel zoned A-R Don't miss this rare opportunity to own a piece of paradise with exceptional potential. Schedule your private tour today and explore the endless possibilities this remarkable property has to offer!
MlsNumber: --
ListingId: 10352484


Listing Provided By: Hardy Realty & Dev. Company, original listing
Phone: (706) 291-4321
Office Phone: (706) 291-4321
Agent Name: Keith Beauchamp
Disclaimer: Copyright © 2024 Georgia Multiple Listing Service. 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 = 447 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 Carla Mahan
Carla Mahan
ASCIIMahan Properties brokered by Northwest Communities Real Estate Group
Call Today!: (678) 521-6108

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App