Outstanding Multi Use Property, Landmark Building Located on Broadway Chelsea . Completely Restored and Architecturally Designed From it's Original Use From Top to Bottom, 1st Floor and Basement house the Commercial Unit Approximately 3000 sq ft plus Full Basement Use with Elevator Access .Triple Net Lease Approx $20,000 Monthly. Sixteen 1 bd Apartments on 2nd and 3rd floors With Too Many Top of the Line Ammenities to List. Rents Generate $59,514 Monthly at Full Capacity.. (3 Apts Vacant On the Market Now). Parking in Rear for Business, Tenants Have Elevator Use to Laundry and Exit ...All Apartments Support Themselves, Mitsubishi Splits in Each For Heat ,Air and Electric, Video Monitoring Throughout Building . Short Walk to Transportation to Boston and Surrounding Towns . Property is A Money Maker !!!$$

Under contract-accepting backup offers. Discover the pinnacle of luxury, quality, and refinement in this brand-new custom California Coastal waterfront estate. Designed with exceptional craftsmanship and architectural sophistication, this residence embodies the highest standards of elevated coastal living. Soaring 25-foot ceilings create a striking sense of volume and light, while thoughtful conveniences include 42-foot-wide balconies, a commercial-grade elevator, dual laundry rooms, and an expansive 12-car garage. Constructed with uncompromising integrity, the home features full concrete construction, limestone cladding, deep-set pilings, and impact-rated casement and storefront windows. Inside, meticulously curated finishes showcase hand-selected natural stone, bespoke millwork, custom walnut cabinetry, and wide-plank European French oak flooring. The chef’s kitchen is appointed with Miele refrigeration, Wolf gas range, Wolf coffee system, Perlick wine column and Perlick clear ice maker, all complemented by honed Taj Mahal quartzite. A sleek linear gas fireplace and infinity glass railing add to the home’s refined aesthetic. Engineered for both luxury and longevity, the residence includes a protected deep-water dock, expanded seawall, and resort-style saltwater pool and spa—creating a private waterfront sanctuary. This newly built waterfront home—among the first offered to the public in over a decade in Belleair Beach—offers a rare opportunity along Florida’s Gulf Coast. The private residents-only beach lies just one block away, while world-class golf at Belleair Country Club and Pelican Golf Club is less than ten minutes from your door. Dimensions are estimates, buyer to verify.

MASTERFULLY REIMAGINED, THIS EXTRAORDINARY WATERFRONT ESTATE HAS NEVER FLOODED, HAS NEVER EXPERIENCED HURRICANE DAMAGE, AND SITS AT AN IMPRESSIVE ELEVATION OF 11.8 FEET. A rare combination of coveted western exposure and deep protected water makes this a boater’s dream, with spectacular sunsets year-round. The residence occupies a magnificent 1.1-acre lot overlooking the Intracoastal Waterway and the pristine shores of Caladesi Island. Originally built in 2002 and extensively upgraded in 2026, the home was constructed with enduring quality and resilience, featuring insulated concrete form (ICF) walls, rebar reinforced hurricane impact windows and doors, and a roof fortified by metal trusses, delivering exceptional structural integrity and peace of mind. Beyond the gated entrance, a sweeping shellstone driveway and curated landscaping introduce a home of elegance and distinction. Inspired by Coastal Tuscan architecture, stately pillars frame a grand foyer with soaring 24-foot ceilings. Exquisite porcelain flooring, artisan crafted millwork, graceful archways, fluted columns, designer lighting, and smooth Level 5 walls create a sophisticated and timeless aesthetic. The expansive waterfront living room flows seamlessly into a formal dining area, ideal for entertaining. At the heart of the home, the chef’s kitchen showcases dramatic double slab translucent quartzite countertops with ogee edge detailing, matching quartzite backsplash, custom raised panel cabinetry with under cabinet lighting, premium appliances, gas cooking, built in refrigeration, and dual islands with bar seating, all opening effortlessly to the pool deck and waterfront beyond. The spacious family room enjoys sweeping water views and features a custom multi level entertainment bar and serving center with Sub Zero refrigeration and a dedicated ice maker. The waterfront executive office is appointed with extensive custom built ins and offers generous space for workstations and conference style seating. The luxurious owner’s suite is a private waterfront sanctuary, featuring a spacious sitting area and two beautifully designed custom closet systems. The spa inspired owner’s bath is a showpiece of craftsmanship and luxury, finished in marble, quartzite, and translucent quartzite. Highlights include dual vanities, a dedicated cosmetics center, sauna, private rest room, freestanding microjet soaking tub, and a spectacular dual entry walk in rain shower with five additional body sprays. Each of the four guest suites offers exceptional scale and comfort, complete with walk in closet systems and beautifully appointed ensuite baths extensively finished in marble. Outdoors, the estate evokes the glamour and grandeur of a private waterfront resort. A dazzling 5,000 square foot elevated shellstone deck with elegant diamond pattern design surrounds the pool and spa and is enclosed by custom cast stone balustrades.

Pre-Construction. To be built. Pre-Construction. Coming in 2026. Brilliantly conceived and painstakingly-designed to precision extravagance and detail. Discover the pinnacle of luxury beachfront living through this astonishing 5 bedroom, 5 bath penthouse estate residence. Sumptuous coastal cosmopolitan themes blend seamlessly with the powder-soft white sands of Treasure Island and the azure blue waters of the Gulf of Mexico. Richly integrated materials, gorgeous contours with maximum complementary focus on the beach/Gulf, and stunning minimalist concepts deliver an unforgettable and uniquely beautiful waterfront living experience. Step inside to a spectacular great room plan with a dazzling 9ft full-height, 25ft-wide wall of glass that completely opens to a remarkable 64ft-wide (928sqft total) covered, oceanfront balcony. Balcony provides highly-flexible seating, dining and entertainment configurations while promising magnificent, unobstructed panoramic views of the Gulf, day and night. The posh gourmet kitchen, with a design and motif perfectly balanced for everyday living, feels like a contemporary work of art. Cove/Subzero/Wolf appliances, hidden butler’s pantry, waterfall counters and lavish cabinetry supply symmetry, form and function - to any chef’s great culinary delight. Not to be outdone, the elegant glass wine room enclosure is a place of pride and satisfaction, if not perhaps, just a little temptation. Opening to the balcony, the owner’s suite assures commanding views of the beach & Gulf. Awaken to an owner’s bath that is an indulging, pampering retreat with exquisite custom tilework, large dual vanities, frameless glass rain shower enclosure and rich soaking tub. All bedrooms are en suite with fine walk-in closets & lushly-appointed baths. You will appreciate the oversized laundry, tankless hot water heating, custom tray/designer wood ceilings, radiant lighting and full-height fold-away sliding glass doors and a penthouse that comprises the entire floor! Property features key fob elevator access, three deeded interior parking spaces, guest parking, dedicated dog run, outdoor heated pool & spa, and common patio fire pit space. There are beachfront condominiums and there are beachfront homes, but there is only one “Pearl.” A place where elegance is reimagined. The Pearl, the most iconic beachfront penthouse in all of Tampa Bay. Within short walking distance of dining/shopping/entertainment, and an easy drive to downtown St. Petersburg and Tampa International Airport.

A MAGNIFICENT LUXURY WATERFRONT ESTATE SUPPORTED BY AN IMPRESSIVE DEEP-WATER DOCK WITH MOORINGS FOR A 100FT YACHT! Located in renowned Pasadena Yacht and CC, south Pinellas County’s only gated golf and boating community, this remarkable Windstar Home rests on a wide, 1 ½ lot footprint, with beautiful open water view of Boca Ciega Bay. Step up to the elevated courtyard entry and take in rich cast stone and travertine exterior finishes. Soaring 25 feet high, the majestic rotunda foyer introduces exquisite cherrywood and marble floors, dazzling faux paintwork, elegant detailed woodwork, radiant lighting, brilliant custom ceilings and unforgettable waterviews. The superb CEO-quality executive office provides extensive sumptuous built-ins, wonderful matching coffered ceilings and a double-sided fireplace. Lovely casual waterfront dining is complemented by a gorgeous formal dining room with 12ft-high ceilings. The sublime chef’s kitchen is a deeply-satisfying culinary experience. Artisan quality raised-panel wood cabinetry and superb Ogee-edge granite surfaces support high-end Gaggenau steam, convection and gas cooking, Subzero refrigeration, built-in Miele coffee system, warming drawers, refrigeration drawers, large walk-in pantry, and a built-in workstation center. You’ll love the fabulous butler’s pantry, multi-level breakfast bar (with beverage chiller and ice maker), and dedicated wine closet that support this incredible kitchen. Relax in the resplendent waterfront living room with custom designer entertainment center, rich marble-encased fireplace, fine coffered ceilings, and terrific window treatments (all windows are elegantly encased in wood). Step out to the enticing 450sqft covered waterfront balcony with remote controlled sunshades. Balcony offers a built-in tumbled marble/granite gas cooking center, and spacious seating/dining areas. Huge guest bedroom suite has a lavish, adjacent luxury bath. Upstairs, you’ll discover a spectacular owner’s suite: a full-height cast stone double-sided gas fireplace separates the bedroom from the plush sitting area with Juliette balcony and magnificent built-in entertainment center. The grand walk-in closet system features numerous built-ins and a generous center island dresser. The owner’s bath is a posh, pampering retreat with commanding views of the water, exceptional marble/granite surfaces, built-in microjet spa tub, custom designer vanities, a dedicated sit-down cosmetics center, and a superb glass-enclosed marble rain shower/steam room. Bedrooms 3 & 4 are oversized and en suite, with beautiful, luxurious baths. Your massive lower level is ideal for fitness/gaming/storage. Lushly landscaped, out back you’ll find the perfect blend of luxury, entertainment and waterfront adventure. A 460sqft covered lounging/dining deck transitions to a stunning Pebbletec pool/elevated spa overlooking the water. An expansive composite dock supports a 16,000 lb boat lift with cat walk, shore power, water, lighting, shower and deep water mooring with tie poles for yacht with 22ft beam. This luxury estate is a true rarity and boasts countless amenities and highly-desirable extras. One of the finest waterfront homes in Tampa Bay! Pasadena Yacht & CC enjoys an extensive list of world-class amenities including golf, tennis, fitness center, marina, restaurant, community pool and clubhouse. A great location and an extraordinary community! Dimensions are estimates, buyer to verify.

TOES IN THE SAND IN JUST 10 SECONDS! BEACHFRONT LUXURY & VERSATILITY WITH SPECTACULAR VIEWS! Feel the sweet Gulf breezes, gentle rolling waves and sparkling azure waters of the Gulf! Built with concrete block construction, this 5 bedroom, 4 ½ bath home boasts lavishness and elegance throughout its 8,010 total sqft under roof. Privacy walls, cast stone exterior finishes and a fine paver entry introduce a 20ft-high foyer and a home with high ceilings, extensive custom millwork, lovely arches and columns, beautiful flooring and unforgettable views. Opening to the waterfront balcony, the expansive 11ft-high great room boasts attractive coffered ceilings, an exquisite custom designer granite/wood fireplace, beautiful crown woodwork and remote-controlled electronic window treatments. The fabulous chef’s kitchen features striking blue-flake granite surfaces, coastal white cabinetry, an excellent appliance package, custom-framed exhaust hood, wine/beverage chiller, and a huge island bar/prep center with seating for seven. Casual waterfront dining with buffet/credenza that matches the kitchen, is complemented by a resplendent formal dining area. Step outside to the impressive 34ft-wide covered beachfront balcony with electronic sunshades, built-in gas cooking center and sizable dining/seating overlooking the Gulf. 1st living level also offers a lovely guest bath, fabulous media center/den/office, and a wonderful guest bedroom suite with superbly-finished guest bath. Upper level provides exceptional cherrywood flooring and a magnificent owner’s suite with 12-ft high vaulted ceilings, fireplace and media center, wonderful morning bar with wine/beverage center, and a huge covered balcony with commanding views of the beach/Gulf. The owner’s bath is a serene and gratifying experience – with plush dual vanities, a soothing built-in jetted spa tub, a terrific walk-in closet system, sitting area, rest room, and a concealed dual entry walk-in double shower finished in marble. A second upper-level bedroom suite overlooks the beach/Gulf, has an outstanding full bath (with built-in jetted spa tub and glass shower enclosure), and opens to its own seating area on the upper-level balcony. All bedrooms are sizable and graceful, and all baths are rich and opulently-appointed. The splendid lower-level landing, finished in posh travertine, transitions to an inviting covered deck with unique covered swimming pool and hot tub. The covered deck enjoys generous pool side seating and dining areas, with private gated access to the beach. In addition to its 4-car garage parking, you’ll appreciate the large multi-purpose storage, gaming and fitness area. Take in three miles of continuous powdersoft white sand beach – one of the most beautiful extended beach areas in the world. Grocery and pharmacy are located on the island, with dining and entertainment a short walking distance away. A smart, well-priced luxury beachfront investment.

One or more photo(s) has been virtually staged. Pre-Construction. To be built. Pre-Construction. Coming in 2026. Brilliantly conceived and painstakingly-designed to precision extravagance and detail. Discover the pinnacle of luxury beachfront living through this astonishing 5 bedroom, 5 bath penthouse estate residence. Sumptuous coastal cosmopolitan themes blend seamlessly with the powder-soft white sands of Treasure Island and the azure blue waters of the Gulf of Mexico. Richly integrated materials, gorgeous contours with maximum complementary focus on the beach/Gulf, and stunning minimalist concepts deliver an unforgettable and uniquely beautiful waterfront living experience. Step inside to a spectacular great room plan with a dazzling 9ft full-height, 25ft-wide wall of glass that completely opens to a remarkable 64ft-wide (928sqft total) covered, oceanfront balcony. Balcony provides highly-flexible seating, dining and entertainment configurations while promising magnificent, unobstructed panoramic views of the Gulf, day and night. The posh gourmet kitchen, with a design and motif perfectly balanced for everyday living, feels like a contemporary work of art. Cove/Subzero/Wolf appliances, hidden butler’s pantry, waterfall counters and lavish cabinetry supply symmetry, form and function - to any chef’s great culinary delight. Not to be outdone, the elegant glass wine room enclosure is a place of pride and satisfaction, if not perhaps, just a little temptation. Opening to the balcony, the owner’s suite assures commanding views of the beach & Gulf. Awaken to an owner’s bath that is an indulging, pampering retreat with exquisite custom tilework, large dual vanities, frameless glass rain shower enclosure and rich soaking tub. All bedrooms are en suite with fine walk-in closets & lushly-appointed baths. You will appreciate the oversized laundry, tankless hot water heating, custom tray/designer wood ceilings, radiant lighting and full-height fold-away sliding glass doors and a penthouse that comprises the entire floor! Property features key fob elevator access, three deeded interior parking spaces, guest parking, dedicated dog run, outdoor heated pool & spa, and common patio fire pit space. There are beachfront condominiums and there are beachfront homes, but there is only one “Pearl.” A place where elegance is reimagined. The Pearl, the most iconic beachfront penthouse in all of Tampa Bay. Within short walking distance of dining/shopping/entertainment, and an easy drive to downtown St. Petersburg and Tampa International Airport.

One or more photo(s) has been virtually staged. Pre-Construction. To be built. Pre-Construction. Coming in 2025. Brilliantly conceived and painstakingly-designed to precision extravagance and detail. Discover the pinnacle of luxury beachfront living through this astonishing 4 bedroom, 4 ½ bath penthouse estate residence. Sumptuous coastal cosmopolitan themes blend seamlessly with the powder-soft white sands of Treasure Island and the azure blue waters of the Gulf of Mexico. Richly integrated materials, gorgeous contours with maximum complementary focus on the beach/Gulf, and stunning minimalist concepts deliver an unforgettable and uniquely beautiful waterfront living experience. Step inside to a spectacular great room plan with a dazzling 25ft-wide wall of glass that completely opens to a remarkable 64ft-wide (928sqft total) covered, oceanfront balcony. Balcony provides highly-flexible seating, dining and entertainment configurations while promising magnificent, unobstructed panoramic views of the Gulf, day and night. The posh gourmet kitchen, with a design and motif perfectly balanced for everyday living, feels like a contemporary work of art. Cove/Subzero/Wolf appliances, hidden butler’s pantry, waterfall counters and lavish cabinetry supply symmetry, form and function - to any chef’s great culinary delight. Not to be outdone, the elegant glass wine room enclosure is a place of pride and satisfaction, if not perhaps, just a little temptation. Opening to the balcony, the owner’s suite assures commanding views of the beach & Gulf. Awaken to an owner’s bath that is an indulging, pampering retreat with exquisite custom tilework, large dual vanities, frameless glass rain shower enclosure and rich soaking tub. All bedrooms are en suite with fine walk-in closets & lushly-appointed baths. You will appreciate the oversized laundry, tankless hot water heating, custom tray/designer wood ceilings, radiant lighting and full-height fold-away sliding glass doors and a penthouse that comprises the entire floor! Property features key fob elevator access, three deeded interior parking spaces, guest parking, dedicated dog run, outdoor heated pool & spa, and common patio fire pit space. There are beachfront condominiums and there are beachfront homes, but there is only one “Pearl.” A place where elegance is reimagined. The Pearl, the most iconic beachfront penthouse in all of Tampa Bay. Within short walking distance of dining/shopping/entertainment, and an easy drive to downtown St. Petersburg and Tampa International Airport.

CONFIRMED POTENTIAL FOR TWO BUILDABLE WATERFRONT LOTS creates one of the most compelling redevelopment opportunities on Anna Maria Island with nearly 100 feet of direct Sarasota Bay frontage.

Privately owned by the same family for decades, this exceptional bayfront property offers expansive open-water views, a coveted location in the heart of Bradenton Beach, and the opportunity to create two luxury waterfront residences or an extraordinary private estate. The City of Bradenton Beach has confirmed the property's potential for two buildable waterfront lots, presenting a rare opportunity for builders, developers, investors, or those seeking to create a legacy property.

The existing property features a 75-foot composite dock and 4,500-pound boat lift, providing immediate boating access to Sarasota Bay and beyond while future plans take shape.

Waterfront parcels of this size, width, and potential are becoming increasingly scarce on Anna Maria Island. Whether your vision is two exceptional custom homes, a multi-generational family retreat, or a landmark bayfront estate, this is an opportunity to secure one of the island's most remarkable waterfront offerings.

An exceptional Sarasota Bay waterfront opportunity offering nearly 100 feet of direct bay frontage in the heart of Bradenton Beach. The existing residence is habitable and may be enjoyed as-is, while also presenting outstanding long-term redevelopment potential. The Seller has obtained City confirmation regarding the potential for two waterfront homesites following removal of the existing residence (buyer to verify all zoning, permitting, subdivision, and development requirements). The property features a 75-foot composite dock with a 4,500-pound boat lift, breathtaking open-water views, and immediate boating access. Whether enjoyed today or reimagined for the future, this is a rare opportunity to create an extraordinary waterfront legacy on Anna Maria Island.

One or more photo(s) has been virtually staged. Pre-Construction. To be built. Pre-Construction. Coming in 2025. Brilliantly conceived and painstakingly-designed to precision extravagance and detail. Discover the pinnacle of luxury beachfront living through this astonishing 4 bedroom, 4 ½ bath penthouse estate residence. Sumptuous coastal cosmopolitan themes blend seamlessly with the powder-soft white sands of Treasure Island and the azure blue waters of the Gulf of Mexico. Richly integrated materials, gorgeous contours with maximum complementary focus on the beach/Gulf, and stunning minimalist concepts deliver an unforgettable and uniquely beautiful waterfront living experience. Step inside to a spectacular great room plan with a dazzling 25ft-wide wall of glass that completely opens to a remarkable 64ft-wide (928sqft total) covered, oceanfront balcony. Balcony provides highly-flexible seating, dining and entertainment configurations while promising magnificent, unobstructed panoramic views of the Gulf, day and night. The posh gourmet kitchen, with a design and motif perfectly balanced for everyday living, feels like a contemporary work of art. Cove/Subzero/Wolf appliances, hidden butler’s pantry, waterfall counters and lavish cabinetry supply symmetry, form and function - to any chef’s great culinary delight. Not to be outdone, the elegant glass wine room enclosure is a place of pride and satisfaction, if not perhaps, just a little temptation. Opening to the balcony, the owner’s suite assures commanding views of the beach & Gulf. Awaken to an owner’s bath that is an indulging, pampering retreat with exquisite custom tilework, large dual vanities, frameless glass rain shower enclosure and rich soaking tub. All bedrooms are en suite with fine walk-in closets & lushly-appointed baths. You will appreciate the oversized laundry, tankless hot water heating, custom tray/designer wood ceilings, radiant lighting and full-height fold-away sliding glass doors and a penthouse that comprises the entire floor! Property features key fob elevator access, three deeded interior parking spaces, guest parking, dedicated dog run, outdoor heated pool & spa, and common patio fire pit space. There are beachfront condominiums and there are beachfront homes, but there is only one “Pearl.” A place where elegance is reimagined. The Pearl, the most iconic beachfront penthouse in all of Tampa Bay. Within short walking distance of dining/shopping/entertainment, and an easy drive to downtown St. Petersburg and Tampa International Airport.

Under contract-accepting backup offers. THE ESSENCE OF COASTAL ELEGANCE, REIMAGINED! Located across from the beach in the only gated boating and tennis community on the barrier islands of Tampa Bay, this gorgeous 5 bedroom, 5 ½ bath estate residence offers an impressive 9291 total sqft under roof. Built in 2023 with all block construction and richly-distinctive exterior appointments, you’ll love its clean contemporary lines and luxurious feel. A grand circular paver driveway and fine covered entry welcome you to a soaring 20ft-high foyer and an inspiring living space. Large-format porcelain floors, dazzling designer lighting, and expansive window views galore deliver a light, open and engaging appeal. This remarkable smart home boasts whole house automation of lighting, window treatments, climate control, audio and more. A brilliant great room plan features a custom gas fireplace and media wall, with superb beamed ceiling accents. The open-concept designer chef’s kitchen is beautiful in its appearance and a culinary delight in its use – with coastal white shaker-style cabinetry, thick quartz counters, Subzero/Wolf appliances, gas cooking, sizable walk-in pantry, huge island bar and serving center, and full-height Subzero wine chiller. The open/airy dining area overlooks the waterfront and transitions to a fabulous 41ft-wide 535sqft luxury balcony with built-in gas cooking center/kitchen. Balcony provides multiple seating areas and wonderful views of the pool deck/waterfront. The 1st level guest bedroom suite contains a sumptuous full bath and provides access to the balcony. You’ll appreciate the dedicated office with generous closet storage. Upstairs you’ll discover exquisite wood floors, three plush bedroom suites and a spacious family/media room with rich custom wetbar and access to the upper-level balcony. The owner’s suite is truly a joy with its posh morning bar/beverage center, two walk-in closet systems, recessed ceilings, and private access to the covered 410sqft upper-level luxury balcony – the perfect place to start and end your day. The owner’s bath is a lavish, pampering retreat - with custom his/her vanities, radiant quartz surfaces, dedicated sit-down cosmetics center, free-standing soaking tub, and a strikingly-attractive walk-in glass rainshower enclosure. All bedrooms are oversized and all baths are elegantly-finished. A custom built-in “mud room” leads to the massive garage area and the lower-level 520sqft covered deck overlooking the pool and waterfront. Stunning Pebbletec pool/spa (heated and with salt chlorination system) is encased in a splendid shellstone paver deck, ideal for lounging and entertaining. Adjacent to the waterfront, a lushly-landscaped synthetic grass seating area surrounds a modern gas firepit. This astonishing home includes a dual jet ski with rapid access to open water, a 3-stop luxe elevator, tankless hot water heating, backup power gas generator and so much more. A fantastic home in a outstanding private location just a short walk to the beach. Don’t miss this rare opportunity, homes located directly on boating water seldomly become available in the Redington Shores Yacht & Tennis Club. Measurements are estimates, buyer to verify.

This remarkable property located in the Village of Lewiston and minutes to Canada presents a rare opportunity to acquire a 14,581± SF waterfront property situated on 2.65 acres directly along the Niagara River, featuring an impressive 267 feet of water frontage. Delivered fully vacant, the property offers immediate upside through lease-up, repositioning, or redevelopment in one of Western New York’s most desirable and supply-constrained submarkets. The property features a well-maintained commercial building offering a unique blend of executive office space, residential-style layouts, and flexible commercial functionality. The layout includes multiple conference rooms, private executive offices, a full kitchen, seven restrooms, four fireplaces, and a six-bedroom configuration—creating strong potential for corporate, hospitality, wellness, residential, or mixed-use applications. This offering presents a highly flexible, blank-slate opportunity with multiple paths to value creation: • Office / Professional Conversion: Reposition as executive office, medical, or multi-tenant professional space with strong long-term upside • Hospitality / Retreat Concept: Waterfront setting and unique layout create an ideal opportunity for boutique lodging, event space, or corporate retreat use • Residential Redevelopment: Expansive footprint and riverfront location support luxury residential or adaptive reuse concepts • Wellness / Lifestyle Use: Existing layout lends itself well to wellness, fitness, medical, or campus-style operations With the property delivered vacant, investors and owner-users gain full control to execute their vision without existing tenancy constraints. Large-scale waterfront commercial opportunities of this caliber are extremely limited in Lewiston, making this a rare chance to acquire scale, flexibility, and long-term upside in a highly desirable location. This is a unique offering that is difficult to replicate and well-positioned for a wide range of future uses.

Positioned within the emerging Rte 11 Commercial Corridor in the Clay/Cicero market of Central New York, 8780-8786 Brewerton Road (Rte 11) represents a rare opportunity to acquire commercially viable frontage directly adjacent to one of the largest semiconductor developments in United States history. The approximately 6.19-acre site features roughly 300 feet of frontage along Route 11 and is located approximately 1,166 feet from the planned full-access I-81 interchange at Sneller Road, creating a unique combination of interstate accessibility and direct proximity to the Micron semiconductor campus. The property sits along the operational edge of Micron’s planned 1,400+ acre campus and is positioned to benefit from the long-term supplier, contractor, logistics, and workforce demand expected to accompany the region’s expanding semiconductor ecosystem. Growing regional, national, and international investment interest tied to Micron continues to reinforce the strategic importance of commercially viable sites throughout the corridor. Unlike many surrounding properties, the site benefits from limited competing commercial frontage due to nearby OCIDA-controlled land constraints, utility infrastructure, and restricted development areas along portions of the opposite Route 11 frontage. In contrast, the subject property benefits from a unique positioning between Route 11 and Interstate 81, with frontage along Rte 11 and direct visibility from I-81, enhancing long-term commercial visibility and development potential. Potential uses include extended-stay hospitality, contractor and workforce support services, equipment rental and fleet operations, flex industrial development, logistics support, and service-commercial uses requiring visibility and efficient regional access. As development activity expands outward from the Micron campus and Rte 31 corridor, the Rte 11 corridor is expected to evolve into a critical support and access corridor serving both construction-phase and long-term operational activity. The property is being marketed for its strategic land value and redevelopment potential. Existing improvements are considered secondary to the site’s long-term value.

Prime location with ample road frontage! Located in the heart of McQueeney, TX and conveniently located near New Braunfels, IH 10, and IH 35. Endless development opportunities. Property is currently being used for farming crops.
Agent Only Remarks:

Beautiful Guadalupe River ranch located just East of Seguin on East US Highway 90 Alternate, about an hour East of San Antonio and an hour South of Austin! This property offers outdoor adventure, seclusion, fishing, hunting and kayaking. The ranch has ample winding river frontage, two stock ponds, numerous huge Live Oak trees, Post Oak trees and native Pecan bottom along the river. Those towering Pecan trees create a tranquil, park-like setting along the bank of the Guadalupe river. The property has a water well, equipment shed, a three bedroom, two and a half bath brick home with a whole house filtration system as well as an R-O system for drinking water and ice maker. There is a great camping area in the pecan bottom where one can walk to a small sandy beach on the water. The property is currently used as a cattle, recreation and hunting ranch. The area holds Whitetail deer, wild turkey, native birds, wild hogs, ducks and other native wildlife. Discover your own slice of Texas on this live water ranch!

Beautiful Guadalupe River ranch located just East of Seguin on East US Highway 90 Alternate, about an hour East of San Antonio and an hour South of Austin! This property offers outdoor adventure, seclusion, fishing, hunting and kayaking. The ranch has ample winding river frontage, two stock ponds, numerous huge Live Oak trees, Post Oak trees and native Pecan bottom along the river. Those towering Pecan trees create a tranquil, park-like setting along the bank of the Guadalupe river. The property has a water well, equipment shed, a three bedroom, two and a half bath brick home with a whole house filtration system as well as an R-O system for drinking water and ice maker. There is a great camping area in the pecan bottom where one can walk to a small sandy beach on the water. The property is currently used as a cattle, recreation and hunting ranch. The area holds Whitetail deer, wild turkey, native birds, wild hogs, ducks and other native wildlife. Discover your own slice of Texas on this live water ranch!

Under contract-accepting backup offers. Beautifully landscaped with an enticing curbside allure, this 5 bedroom, 4 ½ bath, 6021 total sqft contemporary southern-design residence is luxurious throughout. A lovely wrap-around covered porch opens to a towering 21ft-high entry foyer. Richly-detailed wall finishes, remarkable custom woodworking, tall 10 1/2ft-high ceilings with striking custom details, dazzling light fixtures, and brilliant “wire-brushed” wide-plant oak wood floors deliver a lavish “Restoration Hardware”-like appeal. The magnificent living room boasts intricate coffered ceilings, a terrific custom-designed entertainment wall with gas fireplace and built-in media center, and splendid window treatments. Rediscover the joy of cooking with a gourmet kitchen that is a functioning work of art; elegant quartz surfaces, coastal white shaker-style cabinetry, Wolf and Subzero appliances, gas cooking, a grand island bar with matching white farmhouse sink, and a wonderful walk-in pantry with organizers provide all you’ll need to make your cooking a true pleasure. The fine casual dining area is complemented by a tasteful, well-dressed formal dining room that is supported by an exquisite butler’s pantry. The first level guest bedroom suite is spacious, features a pleasing luxury bath, and opens to the rear entertainment deck. Office/den/5th bedroom is oversized and includes a primary closet and large secondary storage closet. Upstairs rests the sumptuous owner’s suite with large bedroom and substantial walk-in closet system. Treat yourself to the pampering experience offered by an owner’s bath with stunning marble tilework, superb quartz surfaces, impressive designer cabinetry, stand-alone soaking tub, Toto Neorest automated system, and inspiring all-marble walk-in glass rainshower enclosure. 2nd and 3rd upper-level bedroom suites are generously-appointed with excellent closet systems and graceful full baths. The wonderful 450sqft bonus family room, ideal as a multi-purpose game room or theater, contains tremendous auxiliary storage space. Step out back to the 650sqft covered travertine deck with 13ft-high wood ceilings, gas firepit, and outdoor gas cooking center. Stunning in-ground pool, with hot tub and in-pool lounging deck, is surrounded by artificial grass and enclosed within PVC privacy fencing. Oversized garage, exceptional window treatments, “mud room” with matching custom designer cabinetry, gas water heating and so much more. Inside and out, this 2018-built home breathes elegance, sophistication and refinement. Dimensions are approximate, buyer to verify.

Elegantly positioned in Arlington's desirable Morningside neighborhood, this custom build luxury colonial offers over 5600 sf of refined living space on a beautifully landscaped lot. This recently built home features 5 bedrooms,5 full and 1 half bath. A grand two-story living room filled with natural light creates a dramatic centerpiece, while the chef's kitchen is equipped with premium Thermador appliances, an oversized island, coffee bar, walk in pantry and wine storage. High end finishes, custom millwork, designer lighting are showcased throughout the home. The primary suite and additional ensuite bedrooms offer marble-appointed bathrooms and generous custom closets. A finished walk-out lower level already plumbed for a future bar, provides flexible space for entertainment, recreation, guest accommodations or multigenerational living. Additional highlights include 4 car garage, patio and deck areas and abundant storage. A rare combination of luxury, privacy and accessibility.

This exceptional ±66-acre tract offers a rare combination of location, access, and future development potential in the highly sought-after Navarro ISD. Currently under agricultural production (corn), the land is open, level, and highly usable — ideal for a wide range of development concepts.
The property features two separate access points, one on Timmermann Road and another on Willmann Road, providing excellent ingress/egress options for subdivision planning, traffic flow, or phased development. Its strategic location is a major highlight: the new Navarro High School sits directly across SH-123 at the Timmermann Road light, placing this tract in the path of rapid growth and making it a prime candidate for residential or mixed-use development.
With strong surrounding growth, dual road access, and proximity to major infrastructure and schools, this property represents a standout opportunity for developers, investors, or long-term landholders looking to position themselves in the Navarro market.

This exceptional 66-acre tract offers a rare combination of location, access, and future development potential in the highly sought-after Navarro ISD. Currently under agricultural production (corn), the land is open, level, and highly usable - ideal for a wide range of development concepts. The property features two separate access points, one on Timmermann Road and another on Willmann Road, providing excellent ingress/egress options for subdivision planning, traffic flow, or phased development. Its strategic location is a major highlight: the new Navarro High School sits directly across SH-123 at the Timmermann Road light, placing this tract in the path of rapid growth and making it a prime candidate for residential or mixed-use development. With strong surrounding growth, dual road access, and proximity to major infrastructure and schools, this property represents a standout opportunity for developers, investors, or long-term landholders looking to position themselves in the Navarro market.

Endless Development Opportunities! This 100-acre tract of land provides the perfect canvas for a wide range of development projects with its over 300 sq feet of road frontage, open terrain, and prime location. This property is ag exempt, low fenced with cross fencing and features a large barn, stock tank, water well, and electric. Schedule a showing today!

This private Miramont estate offers a rare blend of prestige, privacy, and resort-style living—just moments from the golf course and clubhouse. Spanning 4,508 square feet, this Mediterranean-inspired home is designed for those who value both presence and experience. From arrival, terra-cotta rooflines, hand-laid stonework, and grand wood doors create a timeless first impression. Inside, rich wood floors, curated stone & tile finishes, and exceptional craftsmanship unfold beneath soaring beamed ceilings. The main living areas are open yet inviting—anchored by a dramatic floor-to-ceiling rock and brick fireplace—ideal for both entertaining & everyday living. At the heart of the home, the chef’s kitchen features dual oversized islands, granite surfaces & a professional suite of Wolf appliances, Sub-Zero refrigeration, and a built-in wine cooler—perfect for hosting or quiet evenings in. The primary suite offers a serene retreat with a spa-inspired bath, dual vanities, an oversized walk-in shower with custom controls & a generous walk-in closet. Additional features include a dedicated office, game room, exercise room, and private wine cellar—spaces designed for both productivity and enjoyment. Outdoors, a covered patio becomes your personal retreat with a fully equipped kitchen—perfect for entertaining or relaxing after a day on the course. More than a home, it’s a lifestyle for the buyer who value privacy, comfort, and meaningful moments within the Miramont community.

RARE opportunity to own this attractive parcel on the corner of Summer and Hancock Street, comprised of a THREE FAMILY HOME & A SINGLE FAMILY HOME WITH 2 CAR GARAGE! This beauty has been family owned for many years. The adorable single family sits on the corner of the lot and consists of a living room, eat-in kitchen, 2 bedrooms & a full bath on the 1st floor, 2 bedrooms & 1/2 bath on second floor, & a finished basement with 2 bonus rooms & laundry area. The 3 family has beautiful high ceilings, spacious rooms & period details. Units 1 & 2 have 5 rooms with 2 beds & a bath - & unit 3 has 4 rooms with 2 beds & a bath. Fenced in yard, separate utilities, gas heating, coin-op laundry, & storage areas for each unit. Exterior freshly painted in 2025! New furnaces for 2nd & 3rd floor in 2024! This property will be delivered vacant. Close to Davis Square, Porter Square, the Red Line, Bike Path, bus line, Harvard & Tufts University, schools & Boston! THIS AN INCREDIBLE OPPORTUNITY FOR A POTENTIAL CONDO CONVERSION, INVESTMENT, OR FOR AN OWNER OCCUPANT TO BE THE NEW STEWARD OF THIS LOVELY SLICE OF SOMERVILLE! THE PROPERTY WILL BE DELIVERED VACANT & IS A BLANK CANVAS FOR YOUR IDEAS!

Urban accessibility and suburban living come together in this grand home, set in a highly sought after community. A columned portico opens to the grand foyer with high ceilings and a rainfall chandelier. The expansive living room with a gas fireplace and indirect light crown molding flows into a formal dining room. To the right of the foyer is an office/sitting room, full bath, and access to a two-car garage. The open concept kitchen features an imposing island, shaker style cabinetry, quartz counters, stainless appliances, and leads to the dining area with yard access. Hardwood floors, abundant windows, and detailed millwork enrich the first floor. Upstairs are four spacious bedrooms with ensuite baths, including a primary suite with two walk-in closets and a spa-like bathroom with soaking tub, shower, and double vanity. A second-floor laundry adds convenience. The finished lower level offers flexible space for a gym/den/playroom. A must-see home that blends elegance and function!

EXCEPTIONAL, UPSCALE 15-ACRE EQUESTRIAN FACILITY; 39 STALLS, INDOOR AND OUTDOOR ARENAS with LOCATION north of the CITY. Just 5 minutes from Highway to Horses...and the grounds are a showplace creating an inviting and peaceful atmosphere. As you drive in, you'll notice the picturesque 3-BOARD WOOD FENCING enclosing a total of 8 turnouts, which including 2 grassy pastures and 6 all-weather paddocks. The heart of the property is the impressive MAIN BARN featuring 28 spacious 10x12 stalls, all constructed with tongue-and-groove wood with a rich dark stain finish. Each stall is outfitted with individual electrical outlets and blanket bars, while exterior stalls boast louvered windows with bars for added ventilation and safety. The barn's asphalt aisle is fully rubber matted wall-to-wall, creating a safe, durable workspace. Amenities include a dedicated tack room, two grooming stalls, a wash rack, full bath room, laundry room, and a kitchenette. Upstairs, you'll find a finished loft with office space, a viewing room with built-in cabinetry, additional tack storage. Perfect for clinics, lessons, or administrative use. The east end offers 2 additional rooms; allowing you to expand the property's potential. The INDOOR ARENA is 70x164 and is ideal for year-round training, with leveled sand footing, beautifully stained 4-foot kickboards & tall white walls. Insulated & heated via two forced-air heaters and rows of fans. Sliding doors on either end provide ventilation and accessibility. The ORIGINAL BARN adds 11 more stalls (10x10), freshly painted in neutral gray and white tones. This cinderblock structure includes a wide concrete aisle, feed room and large hayloft. The OUTDOOR ARENA was expanded in 2015 to 110 x 230 with modern sand and fiber footing as well as a large decorative screened-in gazebo (12x24) with No Maintenance decking - adding both beauty and practicality. A nice option for warming-up or cooling down your horse is the former training race track around the large pond. It's shaded by large mature trees and fully fenced. This property is nestled in the desirable Equestrian Oaks subdivision. There is no residence currently on-site, but the flexibility is yours-build your dream home or purchase in the surrounding established subdivision. This property is well suited to any discipline. Conveniently located within close proximity to I-94. This is truly a rare opportunity to own a turnkey training or boarding facility in a high-demand location. UPSCALE AND PRICED TO SELL. *SHOWINGS BY APPOINTMENT ONLY*

This extraordinary custom estate is nestled within one of the most prestigious luxury communities, and offers over 9,000 square feet of impeccably designed living space on a spectacular 1.78-acre homesite. Blending timeless architecture and exceptional craftsmanship, this remarkable property offers an unparalleled setting for everyday living and grand-scale entertaining. A circular driveway welcomes you to the impressive two-story foyer, which opens to the formal dining room featuring hardwood flooring, a floor-to-ceiling window and lighted crown molding. The two-story living room showcases hardwood floors, a coffered ceiling and gas fireplace. Rich architectural details, soaring ceilings, expansive windows, and refined finishes continue throughout the home. The gourmet kitchen features granite countertops, travertine backsplash, built-in Viking double ovens and Viking refrigerator/freezer combination, walk-in pantry and breakfast bar. Just off the kitchen, the family room features a volume ceiling, gas fireplace and opens to the patio o/looking the lush grounds. The impressive first-floor primary suite offers a private retreat with generous proportions and luxurious accommodations. The bedroom features a wall of windows, a marble-surround gas fireplace, two walk-in closets, and French door leading to the patio. The spa-like primary bath includes a whirlpool tub, tiled shower and two separate vanities with granite countertops. A private office with hardwood flooring and custom built-in cabinetry provides an elegant workspace. Upstairs, additional bedrooms offer privacy for family and guests with en-suite baths and walk-in closets. A loft and bonus room or 5th bedroom, provides additional living space, while second-floor balconies o/look the living areas below. The finished walk-out lower level provides substantial additional living space ready to be customized to suit your needs. Outside, beautifully landscaped grounds create a serene, park-like setting with exceptional privacy. Geothermal HVAC system. Williamsville School District. This distinguished residence represents a rare opportunity to own this magnificent home. Sq footage adjusted per floor plans.

Welcome to 5284 Route 31, a rare and highly strategic investment property positioned directly across from the future Micron project site—one of the largest semiconductor developments in the United States. This high-visibility location offers exceptional anticipated economic growth, job creation, and increased housing and commercial demand in the immediate area.

Situated on a well-traveled corridor, this property benefits from strong frontage and easy accessibility, making it ideal for a variety of investment strategies. Whether you’re looking to hold for appreciation, develop, or reposition for commercial or mixed-use purposes, the possibilities here are substantial.

The surrounding area is poised for transformation as the Micron project continues to take shape, bringing thousands of jobs and catalyzing infrastructure improvements and supporting businesses. Properties in this direct proximity are expected to become increasingly scarce and valuable.

Key Highlights:

-Directly across from Micron development site
-High-traffic Route 31 exposure
-Strong potential for appreciation and redevelopment
-Ideal for investors, developers, or commercial users
-Positioned in a rapidly growing economic corridor

Don’t miss the chance to secure a foothold in one of Central New York’s most dynamic growth zones. Opportunities like this are limited—invest now and capitalize on the region’s future expansion.

Welcome to 5284 Route 31, a rare and highly strategic investment property positioned directly across from the future Micron project site and approximately 1400 feet from the White Pine Science and Technology Park—one of the largest semiconductor developments in the United States. This high visibility location offers exceptional anticipated economic growth, job creation, and increased housing and commercial demand in the immediate area. Situated on a well-traveled corridor, this property benefits from strong frontage and easy accessibility, making it ideal for a variety of investment strategies. Whether you’re looking to hold for appreciation, develop, or reposition for commercial or mixed-use purposes, the possibilities here are substantial. The surrounding area is poised for transformation as the Micron project continues to take shape, bringing thousands of jobs and catalyzing infrastructure improvements and supporting businesses. Properties in this direct proximity are expected to become increasingly scarce and valuable. Key Highlights: Directly across from Micron development site -High-traffic Route 31 exposure -Strong potential for appreciation and redevelopment -Ideal for investors, developers, or commercial users -Positioned in a rapidly growing economic corridor. Don’t miss the chance to secure a foothold in one of Central New York’s most dynamic growth zones. Opportunities like this are limited—invest now and capitalize on the region’s future expansion.

Welcome to The Live Oak Haus a rare Fredericksburg retreat just TWO BLOCKS from Main Street. Offered fully furnished and turnkey, this exceptional residence blends luxury, comfort, and entertainment in one of the Hill Country's most desirable locations. Whether envisioned as a private getaway, corporate retreat, full-time residence, or income-producing investment, the possibilities are truly unmatched. Thoughtfully designed for both connection and privacy, the spacious layout features multiple bedroom suites, upscale finishes, and inviting indoor and outdoor gathering areas ideal for entertaining or simply enjoying the Fredericksburg lifestyle. From peaceful mornings on the screened porch to evenings gathered around the impressive fire pit, every detail was curated to make daily living feel like a private resort. The outdoor setting is a true showpiece, complete with a custom pool and spa, covered cantina with outdoor kitchen, and beautifully designed entertaining areas that blend indoor comfort with outdoor living. Just moments away, enjoy the charm of Fredericksburg with its renowned restaurants, boutique shopping, live music, and the celebrated wineries and tasting rooms along the famed 290 Wine Trail. Current STR permit allows occupancy of 19 under grandfathered 2018 ordinances an increasingly rare advantage in Fredericksburg. The Live Oak Haus has earned a strong reputation for hospitality and a long list of stellar reviews. Future bookings convey with the sale, offering immediate income potential for buyers interested in continuing rental operations. (Professional photos have been virtually enhanced).

Enchanting and elegant, this Mariott home in Miramont will delight you. Built with expert craftsmanship and luxurious materials throughout, this custom 6 bedroom, 5.5 baths features space for all of your needs. The home has just been completely remodeled with every high end imaginable.
On the ground floor, the owners just built a brand new approximate 400 sqft enclosed glass sunroom with new AC installed. The sunroom is an entertainer's dream with floor to ceiling windows that bring in the gorgeous manicured backyard and huge built in brand new swimming pool with automatic cover.
A brand new roof is approximately 3 years old. 2 instant on demand gas water heaters, brand new Seer 18 ac unit, plumbed gas fire pit outside. 9x7 annex off the garage, new french doors to LR and DR and french doors to outside.
Replaced all carpet with new hardwood floors, replaced all ceiling fans, painted inside 3 years ago, added glass doors, bookshelf, installed new built in in DR, added full bathroom, all new appliances, kitchen aid top of the line.. warmer drawer, ice maker, gas range, 2 ovens, 5 burners, dishwasher, new stainless steel double refrigerator, commercial quad sink, instant h2o Krauz pot filler, professionally built in new cabinets throughout, quartz countertop. Everything in this home has been remodeled and is absolutely amazing. Ideal for a football home or a very large family.
This home is priced to sell, priced per sq ft in the Miramont neighborhood.

Welcome to 4 Shipley Court, where nearly 5,000 sq ft of living space is paired with a backyard built for entertaining. The centerpiece of the property is a resort-like outdoor retreat featuring a Heated Saltwater Pool with custom water features, Jacuzzi, Outdoor Bar, Built-In Stone Fireplace, expansive stone patios, Bose Speaker System, and mature landscaping that creates exceptional privacy. Inside, the home offers 4 bedrooms, 5 bathrooms, a dramatic two-story family room with a floor-to-ceiling stone fireplace, hardwood flooring, and a custom kitchen featuring Russo cabinetry, granite countertops, pot filler, Viking range, and Thermador double wall ovens. The spacious primary suite includes a custom walk-in closet and oversized bath. A stone front exterior, 3-car garage, and thoughtfully designed spaces throughout make this a home equally suited for everyday living and unforgettable gatherings.

Beautiful 58+- acre property on the Guadalupe River located just South of Seguin!  A gorgeous custom built home sits high on a hill overlooking the river and Pecan bottom.  Numerous recreational opportunities exist for hunting, fishing, boating and kayaking on this one of a kind water front retreat.  The home has a large back porch and an added patio with a great  water view for social gatherings.  The interior of the home features granite counter tops, built ins, masonry wood burning fireplace, walk-in pantry, RO water filter system, walk in closets, coffered dining room ceiling, tray ceiling in the main bedroom and a nice view of the river from the living room, kitchen and main bedroom.  Wildlife seen on the property include White Tail deer, wild turkey and other native species.  All of this is located a short distance from HEB, hospital, shopping and restaurants in Seguin.

Positioned within the emerging Route 11 Commercial Corridor in the Clay/Cicero market of Central New York, 8766 Brewerton Road (Route 11) represents a rare opportunity to acquire commercially viable frontage directly adjacent to one of the largest semiconductor developments in United States history. The 2-acre site features roughly 280 feet of frontage along Route 11 and is located 1,466 feet from the planned full-access I-81 interchange at Sneller Road, creating a unique combination of interstate accessibility and direct proximity to the Micron semiconductor campus. The property sits along the operational edge of Micron’s planned 1,400+ acre campus and is positioned to benefit from the long-term supplier, contractor, logistics, and workforce demand expected to accompany the region’s expanding semiconductor ecosystem. Growing regional, national, and international investment interest tied to Micron continues to reinforce the strategic importance of commercially viable sites throughout the corridor. Unlike many surrounding properties, the site benefits from limited competing commercial frontage due to nearby OCIDA-controlled land constraints, utility infrastructure, and restricted development areas along portions of the opposite Route 11 frontage. In contrast, the subject property benefits from a unique positioning between Route 11 and Interstate 81, with frontage along Rte 11 and direct visibility from I-81, enhancing long-term commercial visibility and development potential. Potential uses include extended-stay hospitality, contractor and workforce support services, equipment rental and fleet operations, flex industrial development, logistics support, and service-commercial uses requiring visibility and efficient regional access. As development activity expands outward from the Micron campus and Rte 31 corridor, the Rte 11 corridor is expected to evolve into a critical support and access corridor serving both construction-phase and long-term operational activity. The property is being marketed for its strategic land value and redevelopment potential. Existing improvements are considered secondary to the site’s long-term value.

Beautiful 58+- acre property on the Guadalupe River located just South of Seguin! A gorgeous custom built home sits high on a hill overlooking the river and Pecan bottom. Numerous recreational opportunities exist for hunting, fishing, boating and kayaking on this one of a kind water front retreat. The home has a large back porch and an added patio with a great water view for social gatherings. The interior of the home features granite counter tops, built ins, masonry wood burning fireplace, walk-in pantry, RO water filter system, walk in closets, coffered dining room ceiling, tray ceiling in the main bedroom and a nice view of the river from the living room, kitchen and main bedroom. Wildlife seen on the property include White Tail deer, wild turkey and other native species. All of this is located a short distance from HEB, hospital, shopping and restaurants in Seguin.

A RARE NORTH READING ESTATE — NOW OFFERED UNDER $2M. Privately set on 5.25 acres at the end of a desirable cul-de-sac, this turnkey property offers a combination of scale, privacy & versatility rarely available in North Reading. With over 8,100 SF of living space, extensive updates & Title V passed, it's ready to enjoy now while still offering the opportunity to personalize or elevate over time.The expansive main residence features 4 bedrooms, 3.5 baths, multiple living & entertaining spaces, fireplaces, full bar, updated kitchen with granite, fresh paint, deck, fenced patio & 3-car garage. The finished walkout level adds flexible living, office & recreation space with separate entrances.A detached carriage house further sets this property apart, offering hardwood floors, granite kitchen with upgraded appliances, 1.5 baths, additional finished space & its own garages. Throughout the property, numerous flexible-use rooms provide options for additional sleeping areas, guest accommodations, home offices, recreation, extended family or other lifestyle needs.With 5+ private acres, extensive garage & parking capacity, irrigation and remarkable flexibility, 31 Cedar presents a rare opportunity to own a property of this caliber and scale in North Reading. Move right in, make it your own & enjoy an estate that would be difficult to replicate today—all convenient to Boston, major routes & area amenities. Buyer/agent to perform due diligence regarding accessory spaces & permitted uses. Seller reserves the right to accept an offer at any time. Agent related to Seller *Some photos virtually staged using AI.*

A rare opportunity to own 118.25 acres in the historic Apolonia community just outside Anderson. Covered in mature trees and benefiting from a Timber Use exemption, this remarkable property offers privacy, natural beauty, and exceptional potential for recreation, investment, or building your dream country retreat. Enjoy the peace and quiet of rural Grimes County while remaining conveniently located near Anderson, Bryan-College Station, and within an easy drive of Houston. Large acreage tracts in this desirable area are becoming increasingly difficult to find, making this an outstanding opportunity to own a piece of Texas land with so much potential!

Welcome to your dream lakefront retreat on a deeded lot in the highly sought-after Tussahaw area of Jackson Lake. This stunning two-story, four-sided brick property combines timeless craftsmanship with modern luxury, offering a rare opportunity to enjoy sprawling big water views from nearly every corner of the home. Whether you are hosting in the open-concept kitchen or relaxing in the dining room, family room, or primary suite, the shimmering lake serves as your constant, picturesque backdrop. The heart of the home is a chef's kitchen designed for those who love to entertain, featuring custom cabinetry with pullout drawers, granite sinks with dual incinerators, and a dual convection oven. High-end touches like a pot filler and a commercial ducted vent over the cooktop make meal preparation a breeze, while a brand-new French door refrigerator and a dedicated stand-alone icemaker ensure you are always ready for guests. Just steps away, the primary suite offers a true sanctuary, complete with tray ceilings featuring elegant rope lighting and a private wet bar and refrigerator for ultimate convenience. The spa-like master bath invites you to unwind in a freestanding ceramic oval tub or the spacious walk-in shower with dual heads. Beyond the interior's 10-foot ceilings and hand-scraped engineered wood floors, the home is designed for maximum comfort and efficiency. Built with 2x6 framework and a 24-inch footer round the perimeter, the residence features triple-pane high-energy-efficient windows, two new HVAC systems with extended warranties, and comprehensive insulation from corner to corner. Outdoor living is equally impressive, centered around a screened-in fiberglass saltwater pool with an energy-efficient dual pump system. For the boating enthusiast, the property includes a new double-wide boat dock equipped with lift, a refrigerator, and storage, all protected by a durable Versalok retaining wall and sea wall. This is more than a home; it is a meticulously maintained lakeside lifestyle where every detail has been considered. Designed with the versatility to be either a prestigious full-time residence or a high-end vacation retreat, this home adapts perfectly to your lifestyle. Experience the best of Jackson Lake living, whether you stay for a weekend or a lifetime.

Why settle for shared walls when you could have a home of your own? Completely reimagined and gut-renovated, this exceptional West Newton residence offers approximately 2,850 square feet of beautifully finished living space across three levels. Thoughtfully redesigned and expanded, the home seamlessly blends the character of an established Newton neighborhood with the comfort, efficiency, and sophisticated finishes of new construction.The extensive renovation includes an expanded second level featuring a stunning primary suite with a private bath, a brand-new kitchen, beautifully appointed bathrooms, new flooring, new windows, a new roof, HardiePlank siding, and all-new systems throughout. The fully finished lower level provides valuable additional living space, ideal for a family room, home office, gym, or media room.The transformation continues outdoors with a newly paved driveway, professional landscaping complete with an irrigation system, handsome stonework enhancing the front exterior, and a new patio and deck directly off the kitchen, creating a wonderful setting for indoor-outdoor entertaining and everyday enjoyment. Bright, beautifully finished, and thoughtfully designed from top to bottom, this truly turnkey home is ideally situated in sought-after West Newton, near Wellington Park, with its fenced playground and space for dogs to fetch balls. Convenient to West Newton Square, restaurants, shopping, parks, schools, public transportation, the commuter rail, and major commuting routes. Everything has been done, simply move in and enjoy. Some photos virtually staged.

Discover luxury riverside living in this beautifully renovated 4-bedroom, 2.5-bath home on the St. Johns River in desirable Fleming Island. Spanning approximately 3,478 square feet, this residence offers an open, airy floor plan bathed in natural light, with breathtaking river views framed by a large steel-reinforced window in the living room.
Boating enthusiasts will love the expansive 600-foot dock providing direct river access for effortless days on the water. Car collectors and hobbyists will appreciate the massive 5-car garage, which includes an air-conditioned section prepped for easy conversion into an in-law suite, workshop, or additional living space.
The chef-inspired kitchen features modern finishes, generous counter space, and an ideal layout for entertaining family and friends. A practical, large mudroom handles everyday needs. The primary suite is a true retreat, complete with a spa-like ensuite bathroom.
The lift in the garage does not convey.

Under contract-accepting backup offers. Welcome to this one-of-a-kind custom-built modern farmhouse offering luxury, sustainability, and privacy on 1.08 beautifully landscaped acres with no HOA or CDD. This 4,561 sq. ft. estate is zoned for A-rated Schwarzkopf Elementary, Martinez Middle, and Steinbrenner High School and was built for durability with all-block construction, spray foam insulation, a metal roof, hurricane impact-rated windows, and high-and-dry elevation that remained unaffected during previous storms. The main home features 3 spacious bedrooms, 2.5 baths, a versatile flex room, a stunning Great Room with vaulted walnut ceilings, tongue-and-groove wood accents, polished concrete floors, and a chef's kitchen complete with premium Miele appliances, Italian wood cabinetry, a coffee bar, and a hidden Butler's Kitchen with a second full set of nearly brand-new appliances. The private primary suite includes an office nook, oversized custom walk-in closet with center island, and a spa-inspired bath. Additional features include a large laundry room, mud room with built-ins, skylights, and wiring for a Synergy smart home system. Outside, enjoy expansive covered patios, a resort-style pool (2025 pool heater), and a detached one-bedroom, one-bath guest house with its own spacious great room, perfect for guests or multigenerational living. The fully fenced property also offers electric and manual gated entry, a circular driveway, attached two-car garage with custom cabinetry, detached one-car garage, a covered breezeway equipped with a tv mount perfect for relaxing, mature fruit trees, newly built chicken coop, a Florida-friendly garden, and private well and septic, creating a truly exceptional modern farmhouse retreat that seamlessly blends luxury, resilience, and sustainable Florida living.

Lakefront living awaits at 42 Rocky Point Road in Milton, NH. This spacious 4,716 SF waterfront home offers 110 feet of frontage on a sandy beach, a private dock, and stunning views, creating the perfect year-round retreat, vacation home, or investment property. Featuring 3 bedrooms plus bonus rooms, the flexible floor plan provides plenty of space for family and guests. Expansive living areas and large decks make it easy to entertain or simply relax and enjoy the lake.

Recent improvements include a new 75-gallon water heater, whole-house water filtration system, upgraded HVAC plumbing with 1-inch piping, three mini-split systems, upgraded heating equipment with Google Nest thermostats, and a Moen smart emergency water shutoff system with leak sensors—ideal for seasonal homeowners. The home has also been refreshed with painted interiors, repaired wood floors, and updated furnishings throughout.

Outdoor enhancements include a brand-new hot tub with patio, new grill, updated patio furniture, repairs to the beachside tiki bar, and a repaired dock. Kayaks are included, making it easy to enjoy everything the lake has to offer.

The property can be sold fully furnished, providing a true turnkey opportunity. Currently operating as a successful Airbnb rental, the home offers immediate income potential. Buyers may assume future bookings and rental income or request that reservations be canceled prior to closing. Showings are subject to rental availability.

Rarely does a property combine this much living space, private waterfront, sandy beach frontage, extensive updates, and rental potential.

This modern farmhouse situated on a 20-acre Ag-Exempt property with a separate guest house is a must see! Located near I-45 and Highway 21/190 with access to Bryan/College Station, Austin, Houston, and Dallas.

The primary residence includes approximately 3,770 sq. ft. with 4 bedrooms, 3 full baths, and 2 half baths, plus an office. Interior features include an open living and dining area and a kitchen equipped with Z-Line stainless steel appliances. The second floor offers two flex spaces and a half bath. Additional features include an oversized 4-car garage and a covered back patio with a full outdoor kitchen, leading to a beach-entry pool and rear pasture. Property includes a mosquito misting system.

The guest home includes approximately 1,690 sq. ft. with 2 bedrooms, 1 bath, living area, and full kitchen with breakfast bar. Additional features include a game/theater area, temperature-controlled 2-car garage, workshop space, and covered patio.

LOCATION-LOCATION-LOCATION Experience the pinnacle of upscale waterfront living in this exquisitely remodeled pool home, perched on deep sailboat water with a sweeping canal panorama that unfolds beyond, instantly elevating every moment you spend here. Every detail has been meticulously refreshed to blend contemporary luxury with coastal elegance, delivering a turnkey sanctuary ready for its new owner from the moment you step inside. The open, sun-filled interiors showcase expansive water views from multiple rooms, with an elegant flow that invites effortless entertaining and everyday living. The chef’s kitchen gleams with high-end appliances, granite countertops, custom cabinetry, and a generous island that mirrors the sophistication of the home, while the living and dining areas open gracefully to capture the canal backdrop. This residence offers three tranquil bedrooms and two spa-inspired baths, including a tranquil primary suite with lush closet space and a luxe ensuite, all thoughtfully arranged to maximize water views and privacy. A dedicated two-car garage complements the layout, while a resort-style pool area and al fresco entertaining spaces provide a refined outdoor oasis perfect for sun-soaked days and sunset soirees. Direct canal access supports boating, kayaking, or paddle boarding just steps from your door. This home stands out not only for its unobstructed canal outlook and pool-side luxury but also for its immediate move-in readiness—no projects left to tackle and no compromises on quality or style. If you’ve been dreaming of a premier waterfront lifestyle that combines depth of water, expansive vistas, a pristine saltwater pool, and a fully remodeled, turn-key interior, this is the opportunity you’ve been waiting for. Roof 2024, remodel 2025. Easy stroll across Gulf Blvd to the pristine sugary white sands of Redington Beach. Numerous restaurants and shopping close by. Schedule a private tour and experience the depth of the water, the breadth of the views, and the glow of a meticulously renovated masterpiece.

Deeded Waterfront Living on Jackson Lake - A True Masterpiece Experience lakefront living at its finest in this stunning luxury home nestled on the shores of Jackson Lake. Boasting 5 spacious bedrooms and high-end finishes throughout, this exceptional property is designed for comfort, style, and effortless entertaining. Step into the bright and airy living room, where natural light pours in through expansive windows framing breathtaking big water views. The heart of the home is the chef's gourmet kitchen, featuring sleek quartz and granite countertops, custom cabinetry, and top-of-the-line appliances-perfect for hosting or crafting gourmet meals. The main-level master suite offers a peaceful retreat with lake views, a spa-inspired bathroom, and an oversized walk-in closet. Downstairs, the fully finished basement is an entertainer's dream-complete with a theater room, a huge wet bar with a full-size refrigerator, and multiple areas for gathering and relaxing. Enjoy lake life year-round with your covered two slip Trex dock with two lifts, ideal for boating, fishing, or simply soaking in the serene surroundings. Additional highlights include: * Lavish master bath with separate jacuzzi style tub, his and her and double vanities * Elegant high ceilings and premium finishes throughout * Ample storage and thoughtful layout for full-time living or vacation getaways * deep water for swimming at the dock. * inground sprinkler system Whether you're entertaining a crowd or enjoying quiet lakefront sunsets, this one-of-a-kind Jackson Lake estate offers luxury, comfort, and unforgettable views.

Endless opportunity awaits on this 173.62-acre agricultural tract just outside of Mumford—only 30 minutes from College Station. This well-kept property has been carefully managed and is ready for its next chapter, whether you’re looking to expand your farming operation or invest in productive land. The acreage features fertile clay loam soil, suitable for a variety of crops such as wheat, corn, cotton, or milo. Two working irrigation wells with motors, diesel tanks, and underground piping on the north side convey with the sale. The property is fenced on the east and west sides, with additional fencing along most of the north boundary. Utilities nearby: Entergy electric service and Wellborn water connections from FM 50-will need to add a private well. Easy access from FM 50 makes this a smart choice for farmers or investors alike.

Custom-built waterfront home on Cobbetts Pond with 50 feet of private frontage, private dock, sandy-bottom shoreline, and excellent swimming. Built in 2016, this exceptional property combines classic New England lake-house charm with modern amenities, efficiency, and convenience. Thoughtfully designed and expertly crafted, the home features extensive custom woodwork, wood ceilings, shiplap detailing, rich walnut finishes, and exceptional craftsmanship throughout. The open-concept floor plan offers bright, coastal-inspired living spaces with abundant natural light and beautiful water views. A stunning stone fireplace anchors the main living area, while a walk-in pantry, custom walnut island, and breakfast nook create a warm, inviting atmosphere. Designed for both everyday living and entertaining, the home includes a designated office area, guest bedroom, nursery, second-floor laundry, and a spacious upper-level hallway lined with custom built-in bookshelves. The primary suite serves as a private retreat with a waterfront deck, walk-in closet, and spa-inspired bath. The screened porch and adjoining deck provide the perfect setting for relaxing or entertaining, while the level backyard offers easy access to the shoreline, private dock, and sandy swimming area. The walk-out lower level offers a unique lodge-inspired retreat with custom log-style walls and ceilings, plus a full kitchen and 3/4 bath, ideal for guests, recreation, extended family, or potential in-law accommodations. A detached heated garage provides storage for vehicles, watercraft, or lake gear, while the unfinished attic above offers additional storage space. Walkout to patio area. Additional storage under the porch. Enjoy boating, fishing, kayaking, paddleboarding, swimming, and year-round waterfront living from this exceptional Cobbetts Pond property. Rarely available, this newer custom-built home offers the perfect blend of lake-house character, luxury, craftsmanship, and modern comfort.

Virtually Staged. SPACIOUS, BRAND NEW LUXURY WATERFRONT TOWNHOME FEATURES AN ELEGANT KEY WEST APPEAL, A PRIVATE SWIMMING POOL (RARELY FOUND IN TOWNHOMES/CONDOMINIUMS) AND A PRIVATE DEEP-WATER BOAT SLIP! EXPECTED COMPLETION BY END OF APRIL 2024, WITH ADDITIONAL PICTURES TO BE POSTED BY MID-APRIL. Beautifully finished with superb, high-quality materials and exceptional craftsmanship, this expansive 4 bedroom, 3 bath, 3 car garage residence provides three separate balconies, generous storage and wonderful views. First living level boasts a sumptuous coastal contemporary kitchen with exquisite quartz surfaces, graceful tile backsplash, rich white cabinetry, a terrific SS appliance package and a lovely island bar with matching quartz waterfall. Appealing and convenient, the 1st living level guest bedroom is supported by a splendid full guest bath. You’ll love the views from your huge great room and its grand covered balcony overlooking the waterfront. Upper-level offers three bedrooms, including the impressive owner’s suite with oversized walk-in closet, multi-level ceiling, private covered balcony overlooking the waterway, and a plush owner’s bath with dazzling tilework, and large, luxurious walk-in glass shower enclosure. Bedroom 3 is substantially large with a dedicated sitting area. From your massive lower-level garage and storage area, step out to your private 325sqft covered and pavered deck - perfect for evening entertainment. Updated seawall supports a new composite deep-water dock. From here to the Gulf is a short five-minute boat ride. Fine 3-stop elevator, gorgeous designer fans and many value-added extras/amenities. A great location, within easy walking distance of the Capri Community Park, excellent dining and entertainment, and the world class powdersoft sands of Treasure Island beach. AN OUTSTANDING NEW CONSTRUCTION WATERFRONT VALUE! Buyer to verify all dimensions.

Situated directly adjacent to the highly trafficked Walmart Supercenter corridor in rapidly growing Johnsburg, this exceptional commercial offering features two parcels totaling just over 21 acres with developmental potential. Running Brook Farm Blvd extends directly north of Walmart and leads to the property, creating a premier opportunity for retail, office, medical, dental, research & development, institutional, or mixed-use projects. Zoned SD - Special Development District, the property allows for a wide range of permitted commercial uses, offering flexibility for developers, investors, and end users seeking a strategic location in one of McHenry County's expanding commercial corridors. The site is surrounded by established national retailers and expanding residential growth. Nearby shopping and commercial anchors include Walmart Supercenter along with major regional retailers such as Meijer, Aldi, Dick's Sporting Goods, Home Depot, PetSmart, and DSW located throughout the surrounding retail corridor along Route 31. Adding to the long-term growth potential, new residential development continues immediately north of the property, including expanding neighborhoods at Running Brook Farm and additional home construction by builders including Lennar. The area continues to attract new residents seeking suburban living with convenient access to shopping, dining, healthcare, and commuter routes. With strong traffic counts near Richmond Road/Route 31, established neighboring retailers, expanding rooftops, and flexible zoning, this is a rare large-scale commercial land opportunity positioned for future growth and development in Johnsburg.

Discover the potential of this 155.31-acre farm property located just minutes from Mumford and a short 30-minute drive to College Station. Carefully cared for over the years, this tract is primed for agricultural use or as a long-term land investment. The soil here is a productive clay loam, well-suited for cultivating cotton, corn, wheat, milo, and other row crops. With convenient access off FM 50, this acreage offers irrigation wells, versatility, productivity, and room to grow—ideal for expanding your agricultural footprint or adding farmland to your portfolio.

Don’t miss this rare opportunity to acquire a turnkey, income-producing asset in the heart of Wakefield—combining established tenancy, commercial flexibility, recent renovations and an exceptional walkable location. This business-zoned, mixed-use property offers four 1-bedroom apartments plus first-floor commercial space, currently operating as a beauty salon, creating a compelling combination of residential and commercial income potential. All four apartments are leased providing established occupancy and income. Recent renovations include the commercial space and Unit 4 in 2025 and Units 2 and 3 in 2024. This property also offers off-street parking and the convenience of individual utilities. Ideally positioned directly across from the iconic Rockery and Wakefield Common, with downtown shopping, restaurants, cafés and public transportation just steps away. Lake Quannapowitt is also a short stroll away!

Experience luxury city living in the comfort of a beautifully renovated two-bedroom, two-bath loft condo featuring deeded garage parking. The exposed brick, timber beams and oversized windows are juxtaposed against modern finishes to create a visually striking environment. The spacious living area opens to a stylish kitchen featuring quartz countertops, an expansive 9-foot quartz island, updated cabinetry, tile backsplash, stainless steel appliances, a beverage refrigerator and microwave drawer. The primary suite offers dramatic, oversized barn doors, a generous closet and a newly added 2026 ensuite bathroom with tile flooring and a glass-enclosed walk-in shower. A second interior bedroom with a glass feature wall allows for an abundance of natural light, while the electric privacy shade and large closet offer flexibility to use this space as a bedroom or home office. A refreshed second full bath, refinished floors, updated lighting, in-unit laundry and central air complete the home.The unit is set within a professionally managed, six-story elevator building, with ample resident street parking nearby. Enjoy the city’s best restaurants, cafes and galleries, waterfront strolls along the Harborwalk, and the premier shopping and dining of the Seaport District. A short walk to South Station provides access to the Red and Silver Lines, commuter rail and Amtrak.The home is just minutes to Logan Airport and offers immediate access to I-90 and I-93. Nearby, plans for new development will include new public green space, retail, waterfront dining and Harborwalk improvements, further adding to this evolving waterfront neighborhood. A one-of-a-kind city residence that blends historic architecture and modern luxury in an exceptionally well-connected location.

Incredible Investment Opportunity: Historic Uptown 3-Unit Income Property in St. Petersburg....
Discover a rare, well-maintained vintage gem in the historic Uptown neighborhood along magnificent tree-lined streets. This triad opportunity blends classic charm with modern livability, featuring a spacious main residence plus two income-producing units—each with long-term tenants in place. The main house offers about 2,400 sq ft of living space, with four bedrooms and 2.5 baths, preserved original tile floors greeting you at the entry, tall ceilings, and generously proportioned rooms that radiate old-world charm. A magnificent fireplace anchors the living area, making it ideal for gatherings, while the layout flows gracefully into dining and living spaces filled with natural light. The property sits on a huge lot that showcases a large inground pool. The two back units also provide steady income: upstairs is a one-bedroom, one-bath unit and downstairs is another studio unit, all currently leased to long-term tenants, offering immediate cash flow. This is a true vintage home that has been meticulously cared for, merging original character with modern livability in a location that combines historic appeal with everyday convenience. If you’re seeking a remarkable Uptown find with genuine old-world charm, solid rental income, and a backdrop of tree-lined streets, this property is a must-see. Close to downtown St Petersburg and a short drive to the world renowned Pinellas county Beaches. Reach out today to schedule a tour and explore financing options that maximize this incredible opportunity.

Incredible Investment Opportunity: Historic Uptown 3-Unit Income Property in St. Petersburg


Discover a rare, well-maintained vintage gem in the historic Uptown neighborhood along magnificent tree-lined streets. This triad opportunity blends classic charm with modern livability, featuring a spacious main residence plus two income-producing units—each with long-term tenants in place. The main house offers about 2,400 sq ft of living space, with four bedrooms and 2.5 baths, preserved original tile floors greeting you at the entry, tall ceilings, and generously proportioned rooms that radiate old-world charm. A magnificent fireplace anchors the living area, making it ideal for gatherings, while the layout flows gracefully into dining and living spaces filled with natural light. The property sits on a huge lot that showcases a large inground pool. The two back units also provide steady income: upstairs is a one-bedroom, one-bath unit and downstairs is another studio unit, all currently leased to long-term tenants, offering immediate cash flow. This is a true vintage home that has been meticulously cared for, merging original character with modern livability in a location that combines historic appeal with everyday convenience. If you’re seeking a remarkable Uptown find with genuine old-world charm, solid rental income, and a backdrop of tree-lined streets, this property is a must-see. Close to downtown St Petersburg and a short drive to the world renowned Pinellas county Beaches. Reach out today to schedule a tour and explore financing options that maximize this incredible opportunity.

Attention Investors! EXTREMELY Rare Andover opportunity featuring TWO two-family properties with a total of four townhouse-style units. Acquire four income-producing units in one transaction with strong rental and value-add potential. Ideal for buy-and-hold investors, portfolio expansion, renovations, or potential future condo conversion, subject to buyer due diligence and required approvals. Properties are being sold together. Don’t miss this unique multi-unit investment opportunity in Andover.

Set on approximately 11.4 acres with views of Tussahaw Reservoir, this custom Locust Grove estate offers nearly 5,000 square feet of finished living space, an additional 3,165-square-foot unfinished daylight basement, six bedrooms, six-and-a-half baths, three separate parcels, and no HOA. The craftsmanship throughout the home immediately sets it apart, with cedar shake details, extensive stonework, custom beams and millwork, antique-inspired hardware, soaring ceilings, and three fireplaces. Generous living and entertaining spaces include a main-level primary suite, while each additional bedroom features its own private bath, offering plenty of flexibility for guests, home offices, or additional living space. The kitchen and gathering areas feature custom cabinetry, beautiful finishes, and another fireplace that adds to the character of the home. The unfinished daylight basement provides approximately 3,165 additional square feet with endless possibilities for future use, including additional entertaining space, a theater, home gym, game room, workshop, or storage. Outside, the 11.4-acre setting provides space, privacy, and views of Tussahaw Reservoir. The property consists of three separate parcels, with Georgia Power-owned land located along the reservoir shoreline. There is no private shoreline or direct reservoir access from the property; however, a public boat ramp is located just a few miles away for reservoir access. Despite the private setting, the property offers easy access to Strong Rock Christian School, I-75, Highway 42, Highway 155, shopping, dining, and the continued growth and new development throughout Locust Grove and South Metro Atlanta. A unique opportunity to own substantial acreage, a custom-built home, reservoir views, and more than 3,000 square feet of additional unfinished space-all in a location that keeps everyday conveniences within easy reach.

Incredible Investment Opportunity: Historic Uptown 3-Unit Income Property in St. Petersburg Discover a rare, well-maintained vintage gem in the historic Uptown neighborhood along magnificent tree-lined streets. This triad opportunity blends classic charm with modern livability, featuring a spacious main residence plus two income-producing units—each with long-term tenants in place. The main house offers about 2,400 sq ft of living space, with four bedrooms and 2.5 baths, preserved original tile floors greeting you at the entry, tall ceilings, and generously proportioned rooms that radiate old-world charm. A magnificent fireplace anchors the living area, making it ideal for gatherings, while the layout flows gracefully into dining and living spaces filled with natural light. The property sits on a huge lot that showcases a large inground pool. The two back units also provide steady income: upstairs is a one-bedroom, one-bath unit and downstairs is another studio unit, all currently leased to long-term tenants, offering immediate cash flow. This is a true vintage home that has been meticulously cared for, merging original character with modern livability in a location that combines historic appeal with everyday convenience. If you’re seeking a remarkable Uptown find with genuine old-world charm, solid rental income, and a backdrop of tree-lined streets, this property is a must-see. Close to downtown St Petersburg and a short drive to the world renowned Pinellas county Beaches. Reach out today to schedule a tour and explore financing options that maximize this incredible opportunity.

Incredible Investment Opportunity: Historic Uptown 3-Unit Income Property in St. Petersburg Discover a rare, well-maintained vintage gem in the historic Uptown neighborhood along magnificent tree-lined streets. This triad opportunity blends classic charm with modern livability, featuring a spacious main residence plus two income-producing units—each with long-term tenants in place. The main house offers about 2,400 sq ft of living space, with four bedrooms and 2.5 baths, preserved original tile floors greeting you at the entry, tall ceilings, and generously proportioned rooms that radiate old-world charm. A magnificent fireplace anchors the living area, making it ideal for gatherings, while the layout flows gracefully into dining and living spaces filled with natural light. The property sits on a huge lot that showcases a large inground pool. The two back units also provide steady income: upstairs is a one-bedroom, one-bath unit and downstairs is another studio unit, all currently leased to long-term tenants, offering immediate cash flow. This is a true vintage home that has been meticulously cared for, merging original character with modern livability in a location that combines historic appeal with everyday convenience. If you’re seeking a remarkable Uptown find with genuine old-world charm, solid rental income, and a backdrop of tree-lined streets, this property is a must-see. Close to downtown St Petersburg and a short drive to the world renowned Pinellas county Beaches. Reach out today to schedule a tour and explore financing options that maximize this incredible opportunity.

Welcome to 27 Woodleigh Rd, a well-maintained two-family home offering approximately 2,416 sq. ft. of living space in a desirable Watertown location. The property features two spacious units with separate entrances. One unit offers 2 bedrooms and 1 full bathroom, while the second features 3 bedrooms and 1 full bathroom. Both units offer updated kitchens and bathrooms and comfortable, functional layouts.Recent improvements include a newer roof (2021), two newer composite decks, and two gas hot water tanks installed in 2025. The property also offers an impressive driveway with parking for up to 10 cars.Additional space in both the basement and attic provides exciting future possibilities. The property is equipped with three electrical panels, including an additional panel that may support future expansion. The basement offers potential for an ADU, while the attic also presents potential for additional use and has independent exterior access currently enclosed within one of the bedrooms. Any ADU, expansion, or future use is subject to buyer due diligence and all required permits and municipal approvals.Conveniently located near shops, restaurants, public transportation and major routes, this property offers an excellent opportunity for an owner-occupant, investor, or multi-generational living. Easy to show.

Set on more than four private acres in Stratham, New Hampshire, this approximately 6,300-square-foot estate offers a rare combination of space, privacy, and convenience. The home features four bedrooms, five bathrooms, with expansive living and entertaining areas filled with natural light. Four fireplaces anchor the living room, library, family room, and primary suite, creating comfortable gathering spaces throughout the home. Additional highlights include an indoor pool, a private in-law suite with its own en suite bath, a three-car garage, circular driveway, and thoughtfully landscaped grounds.

Conveniently located just 15 minutes from downtown Portsmouth, Rye and North Hampton beaches, and Pease International Airport, the property also provides easy access to downtown Exeter, several nearby golf courses, and everyday amenities including restaurants and grocery stores within five minutes. Manchester-Boston Regional Airport is approximately 36 minutes away, while Boston Logan International Airport can be reached in about an hour. Offering over four acres, 6,300 square feet of living space, four bedrooms, five-and-a-half baths, an indoor pool, and an in-law suite, this property combines a private setting with excellent access to the Seacoast region and major transportation hubs.

Tucked away at the end of a cul-de-sac in one of Middletons most desirable neighborhoods, and bordering over 750 acres of conservation land, this 4,139 sq. ft. home offers a rare combination of privacy, space, and neighborhood living. Featuring 4+ bedrooms and 3.5 baths, the home is designed for both everyday living and entertaining. The spacious kitchen with center island opens to a sun-filled dining area surrounded by windows overlooking the wooded setting. The primary suite includes a private bath and impressive walk-in closet with custom built-ins. Professionally landscaped grounds with a six-zone irrigation system enhance the home's curb appeal. Additional highlights include public water, natural gas heat, central air, a two-car garage, exterior painted in 2025, and a full walkout basement offering excellent storage and future expansion potential. A unique opportunity to own a well-maintained home that combines size, setting, and long-term value. Schedule a private showing today!

Discover an extraordinary opportunity to own 284.9 acres of Vermont countryside in the scenic town of Fairfield. This remarkable property offers a beautiful mix of open agricultural fields, mature woodland, and abundant wildlife, providing exceptional privacy and endless possibilities for recreation, farming, or a peaceful rural retreat.

At the center of the property sits a historic farmhouse built in 1800, offering approximately 1,984 square feet with 4 bedrooms and 1 bathroom. The home is rich with character and presents a wonderful opportunity to personalize a classic Vermont farmhouse while enjoying the surrounding landscape.

The expansive acreage provides excellent potential for agriculture, forestry, hunting, trail systems, and outdoor recreation. Protected through a Vermont Land Trust conservation easement, the land has been preserved to maintain its agricultural productivity, natural resources, and scenic beauty for generations while still allowing continued farming, forestry, recreation, and residential use in accordance with the easement.

Despite its peaceful rural setting, the property is within driving distance of Jay Peak Resort and Smugglers’ Notch, offering easy access to some of Vermont’s best skiing, hiking, and four-season outdoor recreation.

Large conserved tracts of land of this size are increasingly rare. Whether you're seeking a working agricultural property, recreational escape, or long-term land investment, this unique Fairfield property offers incredible potential and Vermont country charm.

PRIVATE HORSE PROPERTY OR BOUTIQUE BOARDING AND TRAINING BARN * 5.25 ACRES; RANCH HOME; 13 STALLS, INDOOR ARENA; ZONED R-1 * This is an exceptional equestrian property in highly desirable KANE COUNTY that was well designed and is horse-ready. It makes excellent use of space for your personal or business use. The impressive CLEARY POLE BARN is 60x200 overall. The front portion is 60x72 and features 13 tongue-and-groove wood stalls (12x10 or larger) with mats over gravel and ag-lime base, solid stall fronts and some have summer stall fronts - great for air flow. Additional amenities include a concrete aisle, hot and cold wash rack, tack room, insulated viewing room with bathroom and loft space over the center stalls. The INDOOR ARENA portion is a 60x128 with beach sand footing, angle kickboards, mirrors, and 3 sliding doors (one is remote operated)! The LAND features 3-board and 4-board wood fencing creating 6 grass pastures of a variety of sizes. The RANCH HOME offers almost 4,000 square feet of finished space featuring 3 bedrooms, 3.5 bathrooms and an attached 4-car garage (will fit a crew cab truck with long bed). A covered front porch overlooks the picturesque front yard and pond, creating a peaceful and beautiful setting to enjoy nature. The kitchen features marble countertops, black and stainless steel appliances, two ovens, and a deep pantry closet. The adjoining Great Room showcases vaulted ceilings, expansive windows with sweeping views of the barn and pastures, and a beautiful fireplace that creates a warm and inviting gathering space. The Primary Bedroom and Ensuite offers a Jacuzzi tub, separate shower, double vanity, bidet, heated flooring, and a spacious walk-in closet with double hanging racks. Exterior door leads to a small deck (perfect for a hot tub). The hall bath has been updated with an all marble shower and the back deck was replaced in 2024. Looking for an in-law, related living, guest accommodations or a private office suite? The south wing of the house features one bedroom, one bathroom, large living room and kitchenette with sink and refrigerator (currently used as a wet bar) as well as 3 closets. It was designed with disability access in mind with a separate entrance on the side, direct access to the garage and gentle stair transitions (room for a ramp, if needed). Additional features throughout the home include recessed lighting, six-panel doors, luxury vinyl plank flooring, crown molding, dual HVAC systems and first-floor laundry. The full unfinished basement was intentionally constructed for future expansion as it has 8 foot ceiling clearance, rough-in plumbing, a second laundry area and 200-amp electrical service. Mature trees, attractive landscaping, a double fenced backyard, separate dog run, blacktop driveway, and ample space for a future outdoor arena further enhance the property's functionality and appeal. Conveniently located just 10 minutes to grocery shopping, dining, commuter routes and Fox Valley Saddle Association, 30 minutes from Lamplight Equestrian Center, and 50 minutes to Ledges. Lines drawn on photos are estimates and do not replace a survey.

Completely updated 4 bedroom, 3 full-bath residence in the prestigious Isle of Capri. This home is a boater’s dream. Leave your deep-water dock and you are less than 5 minutes to the Intracoastal Waterway. Then, it’s a short trip to John’s Pass and the Gulf. The open floor plan in this spacious home features water views from almost every room. The high ceilings with 3 large sliding doors make this home ideal for indoor/outdoor entertaining. This home boasts 2 open living areas, one upstairs and one downstairs. Both overlook the water. Take your pick of a primary bedroom suite on each floor, with stunning water views from both suites. The first-floor suite leads out to the pool area and has plenty of closet space. The 2nd, 3rd and 4th bedrooms are located upstairs, and all are comfortably sized with plenty of closet space, including a large walk-in closet in the 2nd floor suite. The large open kitchen features all new appliances and a pass-through to the outdoor patio. This home includes many extras such as impact windows and sliding glass doors, laundry chute, large 2-car garage, and circular driveway. The Isle of Capri neighborhood has a park, playground, racquetball courts, ball field, and dog park. Enjoying the award-winning Treasure Island Beaches, great restaurants and shops make you feel like you’re on vacation year-round. Outstanding value for a waterfront home with so much to offer.

Country Living at Its Finest! Escape the hustle and bustle to this remarkable 48-acre property, where country living, modern comfort & outdoor adventure come together. Located just 35 minutes from Bryan/College Station, this 2024 built home is perfect for equestrians, hunters & anyone seeking a private rural lifestyle. The beautifully designed 2,260 sq ft home offers 3 spacious bedrooms, 2.5 bathrooms, and an upstairs bonus room. Inside, you’ll find wide plank luxury vinyl flooring, granite countertops, an oversized island & stainless steel appliances. The open-concept layout is cozy and efficient, blending rustic charm with modern design. The private primary suite features a large walk-in shower, a garden tub & separate vanities. Step outside to your own slice of paradise with a huge covered back porch overlooking the sparkling pool and spa which provides a place to relax enjoying the surrounding views. The 2,880 sqft metal shop offering 2,016 sqft enclosed and complete with a bathroom makes an excellent workshop, man cave, or equipment storage area — a versatile space with endless possibilities. This property is also a hunter’s dream. Abundant wildlife including trophy-sized white-tailed deer. With mature hardwoods and natural habitat throughout, it’s perfect for hunting, wildlife watching, or simply soaking in the natural beauty. Whether your dream is peaceful country living, agricultural use, or recreational freedom, this ranch offers an incredible opportunity.

Country Living at Its Finest! Escape the hustle and bustle to this remarkable 48-acre property, where country living, modern comfort & outdoor adventure come together. Located just 35 minutes from Bryan/College Station, this 2024 built home is perfect for equestrians, hunters & anyone seeking a private rural lifestyle. The beautifully designed 2,260 sq ft home offers 3 spacious bedrooms, 2.5 bathrooms, and an upstairs bonus room. Inside, you’ll find wide plank luxury vinyl flooring, granite countertops, an oversized island & stainless steel appliances. The open-concept layout is cozy and efficient, blending rustic charm with modern design. The private primary suite features a large walk-in shower, a garden tub & separate vanities. Step outside to your own slice of paradise with a huge covered back porch overlooking the sparkling pool and spa which provides a place to relax enjoying the surrounding views. The 2,880 sqft metal shop offering 2,016 sqft enclosed and complete with a bathroom makes an excellent workshop, man cave, or equipment storage area — a versatile space with endless possibilities. This property is also a hunter’s dream. Abundant wildlife including trophy-sized white-tailed deer. With mature hardwoods and natural habitat throughout, it’s perfect for hunting, wildlife watching, or simply soaking in the natural beauty. Whether your dream is peaceful country living, agricultural use, or recreational freedom, this ranch offers an incredible opportunity.

Discover a rare opportunity on 36 unrestricted acres with two expansive homes and breathtaking views. The main home offers 4 bedrooms, 3.5 baths, over 3,100 sq ft, and a 2-car attached garage. The second home features 2 bedrooms, 2 baths, vaulted ceilings, and also has a 2-car garage. Enjoy a versatile workshop/gym, a pool house with 1 bedroom and 1 bath, and a sparkling pool. Both homes also have an 18KW Generac Generators in case of a power outage. Live water with a creek adds to the natural charm. Located just 30 minutes from town, this property offers a perfect blend of privacy, luxury, and freedom. Don't miss this unique multi-home retreat!

The perfect location for future commercial or investment purposes within the highly sought after Geronimo area. This tract is across from the new Navarro High School and has access to traffic counts which will continually increase. The site has an estimated 400 ft. plus of SH 123 road frontage, to be surveyed. The CAD has the acreage at 6.01 acres, but also subject to a survey. A water line extends along SH 123 and a sewer line is across SH 123, but subject to access availability. The land is currently zoned agriculture-ranch with agriculture use taxes and is currently farmed. This site is prime to support future commercial or manufacturing development.

Welcome to this exceptional estate just 5 miles south of Kyle Field in one of College Station’s most desirable areas. Set on 1.9 unrestricted acres, this custom-designed home offers 5,066 sqft of living space with both residential & commercial potential. Conveniently located near Texas A&M University & Highway 6, the property combines prime accessibility with a private, secluded setting. Designed for flexibility & functionality, this unique property is ideal as a private residence, Airbnb, bed and breakfast, sorority or fraternity house, event retreat, or multi-generational living opportunity. With no restrictions, the possibilities are endless for both personal & business use. Inside, you’ll find 5 spacious bedrooms, 3.5 bathrooms, a dramatic two-story foyer, a gourmet chef’s kitchen & a sunroom filled with natural light. Additional standout features include a third-floor exercise room, a luxurious primary ensuite with a spa-inspired bath and double-sided fireplace, and a private study overlooking the grand entryway. Step outside to enjoy an entertainer’s dream featuring a fully equipped outdoor kitchen, fire pit, and playground area. The property also includes a three-car metal garage/workshop and a plumbed concrete pad ready for future expansion or additional structures. This rare offering blends elegance, versatility, and investment potential in one of the area’s most sought-after locations—perfect for a large family, income-producing venture, or commercial opportunity.

Boasting spectacular long-range, year-round mountain views from the dual covered decks, this Modern Mountain masterpiece offers the pinnacle of Blue Ridge living on 1.66 private acres. Sold fully furnished with high-end furniture, lighting, and artwork, this residence is a sophisticated, turn-key sanctuary—perfect as a primary residence, premium second home, or multigenerational living. The main level is defined by a breathtaking open-plan living room featuring soaring cathedral ceilings and a majestic floor-to-ceiling stone fireplace that serves as the home's primary focal point. For the culinary enthusiast, the gourmet kitchen boasts custom cabinetry and premium high-end appliances that flow seamlessly into the formal dining area. Uniquely designed for flexibility, the lower level features a separate entrance and second living quarters, including a massive recreation room and a second primary suite. The thoughtful layout also includes a dedicated home office, fully finished garage, and an elevator for effortless access across all levels. Outdoor living is equally impressive, as the expansive decks provide the perfect vantage point in any season. The professionally landscaped grounds further enhance the retreat feel with a custom stone sofa, a welcoming front porch, and a dedicated firepit area designed for crisp Carolina evenings. While providing a profound sense of seclusion, this home remains exceptionally convenient—located less than 20 minutes from the vibrant culture of Downtown Asheville and within 15 minutes of the premier shopping in South Asheville and the Asheville Regional Airport. Complete with a whole-house generator for uninterrupted peace of mind, this property represents a rare opportunity to own a fully realized luxury lifestyle in one of the region's most sought-after locations.

WATERFRONT LIVING AT ITS BEST. 82 ft of SAILBOAT WATER. CLOSE TO THE BEACH on a large corner lot on a quiet Cul-de Sac. Experience luxury living and stunning water views in this completely renovated 3 bedroom, 3 bathroom waterfront oasis. Every detail has been thoughtfully designed and upgraded from top to bottom, delivering a move-in ready home that blends modern elegance with effortless coastal charm From the moment you arrive, you’ll be drawn in by the pristine curb appeal. Step inside to an open-concept living area where sun-drenched interiors and clean lines set the tone. The living room centers around a panoramic sliding glass door wall that frames glistening water vistas.The adjacent dining space comfortably seats family and guests, with designer lighting and water-inspired accents that create a coastal-modern atmosphere.The chef’s kitchen is a masterpiece of form and function, featuring top-tier materials and stainless steel luxury appliances. Quartz countertops, a substantial 10 ft island, with seating and custom cabinetry provide ample storage and prep space. A sleek backsplash, premium faucet, and custom lighting elevate everyday cooking into an experience.Retreat to the primary suite, a serene sanctuary overlooking the water and glass sliding doors opening to the pavered deck. The spa-inspired ensuite is appointed with a glass enclosed shower, dual vanities with gorgeous lighting, and designer hardware. Two additional bedrooms each offer generous closets and easy access to full baths, one of which doubles as a stylish guest bath with premium finishes. Large walk-in closet. No detail has been overlooked in the renovation. The home features a tile roof, updated electrical and plumbing, New Hvac, New waterheater, Hurricane windows and doors, including sliding glass doors leading to the inviting pavered deck by the water.Luxury finishes include wide-plank LVP floors, LED recessed lighting.An entertainer’s dream, the backyard is a waterfront haven with direct access to the water, a stone-paved terrace, and a low-maintenance landscaped lawn. Composite dock invites boating, kayaking, paddleboarding, fishing etc, newer seawall provides peace of mind. Enjoy your morning coffee or evening cocktail watching the sun set over the Gulf. This tropical oasis enables seamless outdoor gatherings for Family and Friends. Additional features include a two-car garage and ample driveway parking. The property is ideally positioned to enjoy an easy stroll to the sugary white sands of St Pete Beach nearby dining, boutique shopping while offering quick access to major highways for an easy commutes. This completely renovated waterfront home embodies luxury, comfort, and the essence of waterfront living. It’s not just a home; it’s a lifestyle upgrade—ready for new owners to move in, unpack, and start living the dream. Schedule your private showing today to experience the refined craftsmanship and the spectacular water views that set this property apart.

WATERFRONT One-of-a kind, Mid-Century Modern Waterfront , Pool Home in Causeway Isle — Your Florida Dream Come True Nestled along a pristine waterfront with tropical landscaping in a coveted bayside enclave. This one-of-a-kind must-see Mid-Century Modern retreat blends architectural flair with coastal ease: Open floorplan with gleaming terrazzo floors and expansive windows frame the gorgeous water vistas. Chef-inspired kitchen with stainless steel appliances (remodeled 2025), gleaming counter tops and a Breakfast bar/island flows into a welcoming dining area with pool and water views. Large inviting family and an additional enclosed florida room with lots of room to entertain Family and Friends. Convenient laundry room and pool bath combined with access to the cozy outdoor covered patio is a perfect place for enjoying your morning java or evening cocktail. The primary suite offers a spa-inspired bath, a roomy closet. large second bedroom and 2nd Bath. Convenient 1car attached garage (2025 garage door) Outdoor living is an entertainer’s delight—with a resort-style pool, covered patio and a private dock with deep-water access for boating and water sports, all set within lush landscaping and welcoming evening lighting. Located on a residential peninsula with quick access to beaches, dining, boutique shopping, short drive to downtown St Petersburg and I275. This property offers strong waterfront appeal for full or part time living. See this waterfront retreat in person to appreciate the scale and ambiance; schedule your private tour today and begin living the Florida dream in Causeway Isle.

Simply Gorgeous! Exceptional brick and stone California-style ranch estate situated on over one acre of beautifully landscaped grounds in highly sought-after Medinah. Nestled directly across from the renowned Medinah Country Club and surrounded by mature trees and a tranquil forested walking path, this remarkable residence offers the perfect blend of luxury, privacy, and convenience. An impressive grand entrance driveway welcomes you to over 4,000 square feet of thoughtfully designed living space featuring 5 spacious bedrooms, 4.5 baths, and an open-concept floor plan ideal for both everyday living and entertaining. The elegant chef's kitchen is the heart of the home, showcasing granite countertops, stainless steel appliances, abundant cabinetry, a bright breakfast area, and a formal dining room perfect for hosting family and friends. Designed for leisure and recreation, this home features a large private gym/exercise room, a spectacular 600+ square foot movie theater, a relaxing sauna, and two beautiful fireplaces that create warmth and ambiance throughout the year. The finished walkout lower level offers incredible versatility with two additional bedrooms, a huge bathroom, fireplace, recreation room and playroom. Step outside to the expansive deck overlooking a private, park-like backyard surrounded by mature trees, creating a peaceful retreat with exceptional privacy. Whether hosting summer gatherings, enjoying your morning coffee, or unwinding at day's end, the outdoor living space is designed to impress. A dedicated fire pit area provides the perfect place to gather with family and friends for cozy evenings under the stars. Ideally located near Metra, major expressways, shopping, dining, and top amenities, this extraordinary property combines a prestigious location with exceptional value, including remarkably low property taxes. Built for luxurious entertaining, comfortable living, and creating lifelong memories, this is truly a one-of-a-kind Medinah estate.

Welcome to this GORGEOUS COLONIAL located in the highly desirable Holland Ridge community and the AWARD-WINNING COUNCIL ROCK SCHOOL DISTRICT! Beautifully situated on a PRIVATE 1.01-ACRE LOT WITH AN IN-GROUND POOL, this impressive home offers the perfect combination of space, comfort, and an exceptional setting.Step inside through the welcoming TWO-STORY FOYER, featuring a beautiful turned oak staircase, hardwood flooring, French doors, and elegant crown molding. The spacious main level offers a FORMAL DINING ROOM, a bright and dramatic TWO-STORY FAMILY ROOM filled with natural light, and a generously sized kitchen featuring a CENTER ISLAND, PLENTY OF CABINET AND COUNTER SPACE, AND A LARGE BREAKFAST AREA WITH ROOM FOR A TABLE. A convenient FIRST-FLOOR OFFICE provides the perfect space for working from home, studying, or creating a private home library. Upstairs, you will find FOUR SPACIOUS BEDROOMS with plenty of natural light and storage. With 3.5 BATHROOMS, this home provides plenty of space and convenience for both everyday living and entertaining. The FINISHED BASEMENT offers even more living space and endless possibilities for a recreation room, home theater, gym, playroom, or additional entertaining area. Step outside and discover your own private retreat. The EXPANSIVE BACKYARD offers plenty of room to relax, entertain, and enjoy the outdoors, while the IN-GROUND POOL makes this property perfect for summer gatherings and unforgettable weekends at home. With its BEAUTIFUL 1+ ACRE LOT, ABUNDANT NATURAL LIGHT, GENEROUS ROOM SIZES, FINISHED BASEMENT, IN-GROUND POOL, AND PRIME LOCATION IN COUNCIL ROCK SCHOOL DISTRICT, this Holland Ridge Colonial has so much to offer. SPACIOUS, BRIGHT, PRIVATE, AND PERFECT FOR ENTERTAINING — THIS IS A HOME YOU DON'T WANT TO MISS!

Welcome to 70 Oakdale Road, a classic Cape-style residence offering timeless character, generous living space, and exceptional potential. Beautifully situated on an 8,700+ square-foot lot in a desirable Newton Center neighborhood, the home features approximately 2,105 square feet of above-grade living area, plus an additional 1,262 square feet in the unfinished lower level, and a one-car garage, an outstanding opportunity to move in, personalize, and create the home you have envisioned. The main level offers generous living and dining spaces, hardwood flooring, and a flexible floor plan ideal for today's lifestyle. The home features four bedrooms, including a versatile main-level bedroom currently used as an office, along with two-and-a-half bathrooms. Two fireplaces bring warmth and character to the interiors, while the expansive lower level provides valuable additional space with abundant possibilities. Outside, the spacious yard offers a wonderful setting for gardening, recreation, and memorable outdoor gatherings. Ideally located near Newton Highlands Village shops, parks, Green Line T, Chestnut Hill shops and major commuter routes. A fantastic opportunity for buyers looking to add their own personal touches and create their next home in Newton. Some photos virtually staged

Welcome to country living at its finest! Situated on 12.72 gated acres, this exceptional 4-bed, 3-bath home offers comfortable living, outdoor amenities, and convenience! Inside, you’ll find two spacious living areas, a wood-burning fireplace, and two dining areas, providing plenty of room for entertaining and everyday living. The all-electric kitchen features a cooktop, built-in oven, eating bar, and spacious pantry, while wood and tile flooring throughout makes maintenance a breeze. Retreat to the impressive primary suite, complete with a double-sink vanity, garden tub, separate shower, walk-in closet, and direct outdoor access. Generous secondary bedrooms offer flexibility for family, guests, or a home office. Outdoor enthusiasts and equestrian lovers will appreciate the impressive amenities, including a 200’ x 300’ outdoor arena, pipe fencing, roping chutes, and a large barn with covered stalls and an enclosed riding area - perfect for year-round use or additional storage. When it’s time to unwind, enjoy the peaceful surroundings, beautiful Texas sunrises, and breathtaking sunsets. With privacy and space to roam, yet just minutes from shopping, dining, and the amenities of South College Station, this rare property offers a lifestyle that’s hard to find. Don’t miss your opportunity to make it yours - schedule your appointment TODAY!

Rare Lake Champlain Waterfront home with 6.55 acres. This private retreat offers 170 feet of direct Lake Champlain frontage and a lifestyle that’s nearly impossible to find. Originally purchased on 5 acres, the property now spans 6.55 acres with two additional lots purchased for unmatched privacy. A long driveway welcomes you past landscaped apple orchards and perennial gardens, setting the stage for a truly special home.
Inside, enjoy one-level living with hardwood floors throughout. Two bedrooms feature en-suite baths, while a third bedroom is designed with four custom built-in bunks, perfect for guests. A dry, full basement offers expansion potential, and the attached two-car garage keeps everything convenient. The Anderson windows and new roof will give you complete peace of mind. Step outside to soak up sunsets and panoramic water views from the deck or wander to your own gradual beach and private shoreline. A large shed with two boat lifts, doc and extra storage space makes it easy to enjoy boating, fishing, and swimming right from your backyard.
This property blends seclusion with accessibility. Easy ride to Burlington, the airport, and the Canadian border. Explore Grand Isle’s state parks, hiking trails, farmers’ markets, historic landmarks, and vibrant local arts scene right nearby. Possible subdivision, minimum 1 acre lot. Don't miss your chance to own your own slice of heaven in Vermont!! OPEN HOUSE 9/13 10am-12pm.

Attention investors and savvy owner-occupants. This BRAND NEW 2-family property is a rare opportunity to build wealth while owning a beautifully crafted modern home. Whether you choose to live in one unit and offset your mortgage with rental income from the other, or maximize cash flow by leasing both units, this property offers flexibility, functionality, and long-term investment potential. Rent study completed.
Unlike typical cookie-cutter construction, this thoughtfully designed property showcases quality craftsmanship and modern finishes throughout. Each unit features 3 spacious bedrooms, 2.5 baths, and bright open-concept living spaces designed to attract today’s renters and buyers alike. The kitchens stand out with stylish light wood cabinetry, sleek white quartz countertops, and elegant soft brass hardware—creating a warm, upscale feel that sets this property apart in the rental market.
Additional features include 2-car garages, second-floor laundry, and full basements with potential to finish for even more value-add opportunities such as home offices, gyms, or additional living space. Perfect for multi-generational living, house hacking, or expanding your real estate portfolio.
Located in a commuter-friendly area with convenient access to parks, shopping, and major routes, this turnkey investment combines lifestyle appeal with strong income-producing potential. Plus, enjoy added confidence with a 1-year builder warranty included.
Opportunities like this are hard to find—modern new construction, income potential, and quality design all in one. Don’t miss your chance to secure a versatile investment built for today’s market and tomorrow’s growth. Cross Listed with One-side Available.

32.730 acres in sought-after Navarro ISD offering the perfect blend of country living, livestock facilities, and endless possibilities. This exceptional property features a spacious main home with 3 bedrooms, 2.5 baths, plus an office with a closet that could serve as a 4th bedroom. The open-concept design showcases a large living area with an abundance of windows, fireplace, built-ins, and beautiful views of the surrounding acreage.

The well-appointed kitchen is designed for both everyday living and entertaining, featuring Silestone countertops, custom cabinetry with lighting, a breakfast bar with pendant lighting, a 5-burner gas cooktop with double ovens, and a commercial double-door refrigerator/freezer. The oversized primary suite offers coffered ceilings and ample space for large furnishings.

A separate 3-bedroom, 2-bath manufactured home provides excellent flexibility for guests, extended family, or potential rental income.

Outdoor improvements include a 24' x 24' garage/workshop with a large kennel and an impressive 4,500-square-foot barn with stalls, ideal for livestock, equipment storage, horse enthusiasts, and FFA or 4-H projects.

Whether you're seeking a private country retreat, hobby farm, equestrian property, or versatile acreage with room to grow, this outstanding property delivers the space, functionality, and rural lifestyle you've been looking for.

Welcome to 25 Essex Street, a beautifully maintained 4-bedroom Colonial offering 3,388 square feet of thoughtfully designed living space in the Masconomet School District. Cared for by its original owners, this inviting home offers comfortable living spaces, quality features, and room to grow. The main level features an open-concept kitchen and living area with hardwood floors, recessed lighting, natural stone countertops, a peninsula with built-in desk space, and a cozy gas fireplace. A formal dining room provides plenty of space for entertaining. The spacious primary suite includes a walk-in closet and soaking tub. Fresh paint, new mirrors, and updated lighting in both bathrooms, along with a refreshed bedroom, add to the home's welcoming feel. The walk-out lower level offers exceptional flexibility and potential, with 9-foot ceilings, four full-size windows, and room to expand the finished space. Use it as a home gym, media room, playroom, office, or additional living area. Outside, enjoy a composite deck and direct backyard access to Middleton's Rail Trail. The trail provides a convenient route to Howe-Manning Elementary School, the adjacent park and baseball field, all less than a quarter-mile from home. The school bus also picks up directly at the driveway. With generous living space, flexible lower-level potential, and an exceptionally convenient location, 25 Essex Street offers a wonderful opportunity to make yourself at home in Middleton.

A rare opportunity in McQueeney, this charming 2-bedroom, 1-bath home sits on 23.54 fully fenced acres with beautiful mature trees and wide-open usable land. Located on a quiet dead-end street, the property offers privacy and a peaceful setting. Small working barns provide space for equipment, livestock, or hobby projects, while the carport and enclosed porch add everyday convenience and versatility. With its expansive acreage and flexible layout, this property offers endless possibilities, from private country living to future development or expansion.

Turnkey Investment! This massive, cash-flowing 3-family property is the ultimate addition to your portfolio or the perfect owner-occupant opportunity. Gut renovated to the studs in 2018, it delivers total peace of mind with all new electric, plumbing, heating, doors, and windows, plus a new rubber roof (2016). All 3 units are nearly identical, sprawling across 1,790 sq ft each. Enjoy flowing layouts: a Primary BR with a walk-in closet, 2 additional spacious BRs, 1.5 baths, and in-unit laundry. Designed for durability and style, the interiors feature gorgeous refinished original hardwoods, plush bedroom carpets, and quality vinyl. Each unit comes with a range, fridge, dishwasher, microwave, and HE washer/dryer. The exterior boasts a fantastic large deck for each unit and 9 dedicated parking spaces. Highly rentable location within walking distance to the MBTA Commuter Rail and a fantastic public park. Excellent rental history.

Exceptional investment opportunity in a prime Waterbury location along the highly traveled Waterbury-Stowe/Route 100 corridor. Offering approximately 5,214 finished square feet, this versatile property combines existing residential and income-producing spaces with exciting potential for future multifamily use.

The property currently includes spacious residential accommodations featuring three bedrooms with private en suite baths, a chef's kitchen and inviting living areas. An additional portion is currently utilized as a short-term rental, providing an established rental component. Existing retail/commercial space adds another layer of flexibility and may offer potential for conversion into additional residential units, subject to municipal and state approvals.

With its generous square footage and adaptable layout, investors may wish to explore opportunities to create additional apartments or further develop the property as a multifamily investment. More than 2,300 square feet of basement space provides substantial storage and utility space, while a two-car garage, ample on-site parking and an elevator/dumbwaiter system add functionality.

Location is a standout feature. Situated directly across from Cold Hollow Cider Mill on the Waterbury-Stowe Rd (rte 100) and minutes from Ben & Jerry's, Waterbury Reservoir, downtown Waterbury and Stowe, the property offers convenient access to skiing, hiking, mountain biking, restaurants, shopping and year-round recreation.

Whether continuing the property's current combination of uses or exploring additional residential possibilities, 14 Sunset Drive offers a rare combination of location, square footage, parking, flexibility and income potential in one of Central Vermont's most desirable destinations. Buyer to complete due diligence regarding permitted uses, unit count, zoning and conversion possibilities.

Exceptional two-family offering the perfect blend of modern updates, flexible living, and outstanding investment potential. This turnkey property features 2,274 sq. ft. of above-grade living space, plus a fully finished, permitted lower level of approximately 736 sf with its own heating zone, full bath, laundry, and additional living space, ideal for extended family, guests, or a home office. The property will be delivered fully vacant, making it perfect for owner-occupants or investors. The first-floor unit offers 2 bedrooms, a beautifully renovated bathroom, in-unit laundry, and a new kitchen featuring quartz countertops, all-new plumbing, a garbage disposal, dishwasher, and modern finishes.The spacious second and third-floor duplex lives like a single-family home with 4 bedrooms, a private office, a beautifully renovated bathroom, plus half bath on the third level, and a new kitchen complete with quartz countertops, all-new plumbing, and a garbage disposal. Access to both a front deck and private porch completes this exceptional owner's unit. Major improvements include updated electrical panels, newer heating systems, a newer roof, separate laundry for every living area, and extensive renovations throughout. Outside, enjoy a fenced-in yard perfect for entertaining, pets, or outdoor enjoyment, along with parking for up to 8 vehicles, a rare and highly desirable feature in Malden. Ideally located just minutes from Malden Center, the Orange Line MBTA, major bus routes, Route 1, parks, restaurants, shopping, and the Northern Strand Bike Trail, this home offers an exceptional combination of neighborhood charm and commuter convenience. Whether you're looking for a spacious owner-occupied property with excellent rental income, multigenerational living, or a turnkey investment, 404 Bryant Street offers exceptional versatility, quality, and value in one of Malden's most desirable and convenient locations. Some photographs have been professionally virtually staged to help illustrate the property's design potential. Furnishings, décor, artwork, and accessories shown are digitally rendered for illustrative purposes only.

Exceptional opportunity in the heart of Malden! This well-maintained three-family property offers a versatile unit mix with strong owner-occupant and rental appeal. The two first-floor units each feature comfortable 1-bedroom layouts. The second-floor unit at 205 Salem Street offers a spacious 3-4 bedroom configuration, while the second-floor unit at 203 Salem Street includes 1 bedroom plus a home office, with exciting potential to expand into a 4-bedroom plus office by updating the third floor making this a real value-add opportunity for the keen investor, family or owner occupant. Ideally situated just minutes from Malden Center with multiple bus routes, and major commuter highways, this property provides easy access to downtown Boston and the surrounding communities. Residents will appreciate the vibrant community atmosphere and convenience of nearby shopping, dining, parks, and everyday amenities. Whether you’re looking to start your real estate portfolio or add to it, this property is a smart buy for any investment minded individual, family or company.

Opportunity Awaits On This Private And Secluded 9.89-Acre Wooded Parcel Bordering The Forest Preserve. Zoned R-2 And Located Near Several Upscale Residential Subdivisions, The Property Offers Excellent Development Potential. The Existing Farmhouse And Outbuildings Are Being Sold As-Is. A Creative Buyer May Choose To Renovate The Farmhouse Or Use The Additional Space As A Studio Or Home Office. Please Bring A Flashlight If Touring The Farmhouse. Horses And Other Farm Animals Are Not Permitted Within The Village Of Frankfort.

One of Comanche Trace's premier estate properties, it offers a rare combination of elevated panoramic views, exceptional privacy, and an ideal floor plan for entertaining. Designed for both everyday living and entertaining, it features soaring ceilings, a formal dining room, gourmet kitchen, spacious living areas, and a private office with custom built-ins. The luxurious primary suite offers backyard access, dual vanities, a large walk-in closet, and a spa-like bath with a walk-in shower. Upstairs are two guest suites, each with a private bath, plus a second living area with a wet bar and covered porch showcasing spectacular views. Additional highlights include a large utility room and an oversized four-car garage with extensive cabinetry, and its own half bath. The beautiful landscaping with front and back porches adds to the lovely lifestyle lived on this special property. Located just minutes from Kerrville's shopping, dining, and premier medical facilities, Comanche Trace offers miles of walking trails, a catch-and-release lake, private Guadalupe River park, and optional golf, tennis, pickleball, fitness, and social memberships.

A Rare Opportunity To Own 9.89 Acres In A Desirable Frankfort Location, Surrounded By Upscale Residential Subdivisions. Zoned R-2, The Property Offers Excellent Development Potential. The Farmhouse Features 4 Bedrooms, 2 Full Bathrooms, And A Bonus Room That Could Serve As A Fifth Bedroom Or Home Office. Recent Updates Have Been Completed, And The Property Is Being Sold As-Is. Due To The Size Of The Property, Please Allow Sufficient Time When Scheduling A Tour. Please Note: Horses Are Not Permitted Within The Village Of Frankfort.

Welcome to unparalleled coastal luxury in this exceptional 4th-floor condo, nestled on the pristine shores of Sunset Beach in Treasure Island. This stunning residence offers unobstructed, breathtaking views of the sparkling Intercoastal waterways where every sunset paints the sky in vibrant hues, creating a masterpiece from the comfort of your own home. As you enter this exquisite unit, you are greeted by an expansive open floor plan that seamlessly blends elegant design with modern living. Floor-to-ceiling windows bathe the space in natural light and frame the panoramic vistas, enhancing the beauty of the coastal surroundings. Located on the south east corner of the Mansions the 90ft balcony wraps around the building and offers daily sunrise views and evening sunsets. The gourmet kitchen is a culinary enthusiast's dream, featuring top of the line appliances, including a wine fridge, custom cabinetry, and exquisite granite countertops, perfect for entertaining guests or enjoying casual meals. The luxurious master suite serves as your personal retreat (wheelchair accessible) complete with stunning water views, a private balcony for relaxation, and an opulent ensuite bathroom featuring an elegant shower enclosure.(wheelchair accessible) The Additional bedroom is designed as a private haven with generous closet space and beautifully appointed bathroom. Custom closets throughout. Step outside to your private balcony, where you can enjoy morning coffee or evening cocktails while soaking in the breathtaking sights and sounds of coastal living. The Coveted Mansions by the Sea offers an array of resort-style amenities, including a sparkling swimming pool, state-of-the-art fitness center, tennis courts, saunas, pickle-ball courts etc. and direct access to the powdery sands of Sunset Beach. Additional storage also included. Convenient assigned Parking space in garage. This remarkable condo is not just a home; it’s a lifestyle. With fine dining, boutique shopping, and vibrant nightlife just moments away, you’ll enjoy the perfect balance of tranquility and excitement in this idyllic coastal paradise. Experience the epitome of coastal luxury in this exceptional 4h-floor unit in the B Building. Schedule your private tour today and embrace the extraordinary lifestyle that awaits you! Call agent for more details and bring you pickiest Buyers. The Mansions do not disappoint.

Back on the market with recent painting completed, this distinctive circa-1770 Boxford antique offers a rare blend of history, character and meaningful updates. Set on more than 2 scenic acres, the home features original wide-plank floors, period woodwork, spacious rooms and notably higher ceilings than typically found in homes of this era. Three full baths, a walk-up attic and a two-story carriage house/garage provide exceptional flexibility for a studio, office, workshop or entertaining space. Major improvements include a new 5-bedroom septic system (2024), furnace, water heater, electrical upgrades, whole-house water treatment, well pump, propane tank, renovated full bath, laundry, appliances and basement improvements. Enjoy authentic New England charm with many costly infrastructure updates already addressed, all near Boxford schools, trails, parks and village amenities.

Interior photos were just added and photoshopped to show the vision. 100 FEET OF WATERFRONT • PANORAMIC VIEWS • SPECTACULAR SUNSET. Rare opportunity to own 100 feet of direct waterfront with coveted western and southwestern exposure, expansive water views, and breathtaking sunsets. This distinctive English Tudor offers 2,432+ square feet, hardwood floors, generous living areas, a walkout lower level, and a full second floor with plans for an additional bathroom. Ready for thoughtful updates and personalization, the home offers an opportunity to preserve its architectural character while creating a one-of-a-kindwaterfront retreat. Enjoy boating, kayaking, fishing, or simply relaxing along the shore in this peaceful setting. With substantial frontage, desirable exposure, panoramic vistas, and exceptional potential, this is a truly special waterfront property. Bring your vision; the home is being sold as-is

Experience the perfect blend of space, privacy & resort-style living with this impressive property situated on a private 1.35-acre rural lot just minutes from Texas A&M University. Offering exceptional flexibility and room to spread out, the main residence features 4 oversized bedrooms, 2 full bathrooms & 2 half bathrooms, along with two spacious living areas & two dining areas. The bedrooms are truly remarkable in size compared to traditional homes—while the main living area features an attractive wet bar, perfect for entertaining. Thoughtfully updated throughout, the home showcases a beautifully refreshed kitchen & bathrooms, updated finishes & all-new windows. Three new HVAC units provide added comfort & efficiency. An attached private apartment adds tremendous versatility, complete with its own full kitchen, 1.5 bathrooms & an expansive upstairs bedroom—ideal for extended family, a private home office or multigenerational living. The outdoor spaces transform this property into a private retreat. Enjoy the in-ground swimming pool, relax in the hot tub, gather around the firepit or entertain beneath the gazebo& multiple covered outdoor living areas. The property also includes an impressive 30' x 50' workshop, providing abundant room for vehicles, equipment, hobbies or projects. Located within highly regarded College Station ISD, this unique property delivers the acreage, oversized living spaces, workshop, pool & convenient location that are increasingly difficult to find.

Private 5-Acre Estate Just Minutes from I-90 * Imagine a property where complete privacy, exceptional functionality and everyday convenience come together on 5 beautiful acres just minutes from conveniences. Hidden among mature trees and set well back from the road, this extraordinary estate offers a level of seclusion rarely found so close to town. Located approximately one mile from the I-90 interchange, you're only minutes from shopping, restaurants, healthcare, schools, and Rock Cut State Park, while remaining just an hour from both Chicago O'Hare International Airport and Madison. Peaceful country living & modern accessibility exist in perfect balance. Purposefully designed as a private family estate, this property offers exceptional flexibility for today's lifestyle. Whether your vision includes a multi-generational home, executive live-work estate, contractor headquarters, collector's retreat, hobby farm or simply a private sanctuary, the possibilities are as expansive as the property itself. The custom ranch residence offers more than 4,620 sq ft of finished space thoughtfully designed for both comfort and versatility. Four bedrooms, four-and-a-half baths, an attached four-car garage and a partially finished walkout lower level, the home easily accommodates extended family, guests, or independent living arrangements. The open living, dining and kitchen areas flow seamlessly together before opening onto an expansive deck overlooking the beautifully landscaped grounds. A dramatic secondary gathering space features soaring wood-beamed ceilings, a floor-to-ceiling stone fireplace, Mexican tile flooring, and a fully equipped second kitchen with access to a second deck-creating an exceptional setting for entertaining and holiday gatherings. The main-level primary suite serves as a peaceful retreat with dual bathrooms, a walk-in closet and tranquil views across the property. Upstairs, a private loft suite offers another spacious bedroom, full bath, and an oversized walk-in closet or flexible bonus room. The walkout lower level adds a large family room, bedroom with full bath suite and covered patio, making the home exceptionally well suited for multi-generational living. This estate features a remarkable collection of outbuildings which provide more than 12,000 square feet of well-built enclosed space featuring concrete floors, overhead doors, electric service, natural gas heat, high-speed internet and security systems. Versatility to support a growing business, protect a prized vehicle collection, store recreational equipment or provide workshop and warehouse space. Originally developed to support a first-class private equestrian operation, the buildings can be adapted to meet a wide variety of residential, business, recreational, or hobby uses. Few properties offer this combination of infrastructure, privacy, and flexibility in such a convenient location. For equestrian enthusiasts, the estate remains equipped with a seven-stall barn, a 60' 135' indoor riding arena with sand footing and 16-foot sidewalls, a climate-controlled tack room, offices, half bath, wash rack, multiple fenced paddocks, and picturesque pastures framed by mature trees and classic dark wood fencing. The equestrian improvements are outstanding while remaining adaptable to future needs. Properties offering this unique combination of privacy, substantial improvements, business flexibility and interstate access seldom become available-and are becoming increasingly difficult to recreate due to today's zoning restrictions, escalating construction costs and land development regulations. Thoughtfully planned, carefully constructed and meticulously maintained, this estate represents far more than an exceptional home. It offers the freedom to live, work, create, entertain, and build lasting memories in one extraordinary setting. This is one of those rare places-designed with purpose, maintained with pride, and ready for the next family to make it their own.

GORGEOUS CONTEMPORARY COSMOPOLITAN CHIC IN AN EXCEPTIONAL SNELL ISLE LOCATION. A distinguished brick paver driveway introduces a uniquely-beautiful faux wood porcelain and tumbled marble exterior façade. The welcoming covered double door entry opens to a dazzling great room plan with views of the rear courtyard and swimming pool. Great room delivers a suave, sophisticated appeal with fine wide-plank oak wood flooring and a distinctive custom beamed ceiling. The resplendent kitchen is a flawless example of art following form and function: elegant quartz surfaces with quartz backsplash complement modern cabinetry and high-quality stainless-steel appliances including a superb Forno Paola range with Wolf range hood, and large built-in refrigeration. A luxury island bar/serving center with waterfall counters provides seating for four. You’ll love the matching butler’s pantry with its dedicated coffee station featuring a fantastic De'Longhi Magnifica espresso machine, seating area, generous storage and beverage chiller - a great place to start your day. For those who enjoy the finer vintages, you’ll be delighted with the impressive 8 x 8 custom-built walk-in wine cellar with commercial-grade cooling and dehumidification. The posh owner’s suite opens to the private pool deck and boasts a huge walk-in closet area with built-in island dresser. The owner’s bath offers two lavish quartz vanities, and an amazing and beautifully-tiled walk-in double rain-shower with dual body wands. The second bedroom is oversized and is supported by an exquisitely-appointed adjacent bath that doubles as the pool bath. The sizable third bedroom sits across from a lovely full guest bath with minimalistic quartz vanity and rich tilework. Step out back to the private garden and swimming pool sanctuary and feel life’s stresses just melt away. A white shellstone paver deck encases a stunning Pebbletec saltwater pool and oversized spa. Behind the pool rests a tumble marble half wall securing an attractive layered landscape. The entire back yard is encapsulated within tall concrete walls offset by landscaping that delivers a private, oasis-like feel. Fully operational solar panels assure this home has very low electric energy costs. In addition to the oversized 2-car garage, you’ll appreciate the large dedicated storage area ideal for a golf cart and bicycles, or even a fitness area. Ideally located close to highly rated schools, just a few blocks from the Vinoy Golf and Country Club, and a short distance to downtown St. Petersburg. A terrific luxury value in a great location! Measurements are estimates, buyer to verify.

PRIVACY, SPACE & EXCEPTIONAL LIVING ON 2.57 ACRES IN WINDHAM. Set on beautifully landscaped grounds, this impressive residence offers a rare combination of substantial living space, and incredible versatility in one of Windham’s most desirable communities. Offering 4 Levels of living space, 11 rooms, 4 bedrooms, 2½ baths, and an oversized two-car garage. Designed for today’s lifestyle, the main level features an open, inviting floor plan with a spacious kitchen at the heart of the home and generous fireplace living and family rooms that flow beautifully for everyday living and entertaining, including a sunroom that leads to an oversized deck. Upstairs, the spacious primary suite offers two closets and a private en-suite bath complete with a jetted tub and walk-in shower. An expansive open bonus area creates unexpected additional living space and can easily accommodate a home office, fitness area, music or study space, or a comfortable second-floor retreat plus 2 more bedrooms & bath. The walk-up third floor offers yet another space currently used as an oversized bedroom and lounge/pool table area. The oversized finished basement, with heat and A/C in separate zones, provides even more flexibility for recreation, media, home offices, or additional living space, plus a separate laundry area and abundant storage. Extensive improvements include PEX plumbing for hot and cold water, updated electrical wiring, replacement windows, recessed lighting, zoned heating and central air conditioning, along with energy-efficiency upgrades. Relax in the outdoor sun-dance hot tub, enjoy the peaceful surroundings, and experience a property that feels like a private retreat with an oversized deck, fire pit area, large shed, and beautiful yard. Windham schools; close to Tuscan Village, a Windham community that loves involvement if you want. Minutes to shopping and highways.

Experience refined waterfront living in this exceptional custom-built five-bedroom, 2.5-bath residence offering panoramic views and direct access to the East Niagara River. Set on over half an acre with beautifully landscaped grounds, this mostly brick home combines timeless elegance, superior craftsmanship, and remarkable pride of ownership throughout. A covered front patio welcomes you into a spacious foyer where stunning water views immediately capture attention. The dramatic two-story living room showcases floor-to-ceiling windows and a striking three-sided fireplace, creating an impressive yet inviting gathering space. Hardwood flooring, crown molding, and abundant natural light enhance the elegant formal dining room, which seamlessly opens to the solarium. Designed for both comfort and entertaining, the family room features a beamed ceiling, custom built-in cabinetry and shelving, and direct access to the year-round sunroom. The eat-in kitchen is beautifully appointed with granite countertops, a breakfast bar, recessed lighting, built-in refrigerator and microwave, convection oven range, ceramic tile flooring, and custom cabinetry with crown molding. A private office and convenient half bath complete the main level. Upstairs, the spacious primary suite offers breathtaking river views, dual closets including a walk-in, and a luxurious ensuite bath featuring ceramic tile flooring, dual granite vanity, and oversized tiled shower. Four additional bedrooms and a second-floor laundry room with included washer and dryer provide convenience. The finished basement rec room with wet bar adds additional living and entertaining space, while thoughtful amenities such as six-panel wood doors, central vacuum, two furnaces, two central air units installed 2026, and a secondary basement egress enhance everyday living. With river views from nearly every room, this extraordinary waterfront property offers a rare opportunity to enjoy luxury, comfort, and spectacular natural beauty in one remarkable home.

**TURNKEY, FULLY FURNISHED CABIN WITH PRIVATE ELLIJAY RIVER ACCESS!** Welcome to Harry's Hideaway, a true log cabin tucked inside the gated Goose Island community in Cherry Log, perfectly located between downtown Ellijay and Blue Ridge. Spend your mornings drinking coffee on the wraparound porch, afternoons exploring nearby apple orchards, wineries, hiking trails, shops, and restaurants, and evenings gathered around the firepit or relaxing in the hot tub. Completely renovated approximately three years ago, this spacious three-level cabin offers plenty of room for family, friends, and guests. The open main level features a soaring great room, dining area, updated kitchen with island, walk-in pantry and laundry room, and a private primary suite. Upstairs includes two guest bedrooms, and a shared full bath, while the basement level offers a game and media room, second private suite, plenty of storage, and an oversized garage. Approximately 1,300 square feet of outdoor living space includes a wraparound porch, screened porch, basement-level patio, multiple seating areas, grilling space, and a level firepit area. Stairs lead directly from the property to private access along the Ellijay River. The large paved driveway provides ample parking and easy access without the need for four-wheel drive. Currently operating as an established short-term rental, the cabin has maintained high occupancy, earned more than 50 five-star reviews, and received over 2.3 million views through a social media influencer's video. It is being sold fully furnished, with future bookings and additional rental marketing assets included, subject to transfer requirements. Whether you are looking for a proven investment, a peaceful mountain getaway, or a full-time home surrounded by everything North Georgia has to offer, Harry's Hideaway is ready to enjoy from day one.

**TURNKEY, FULLY FURNISHED CABIN WITH PRIVATE ELLIJAY RIVER ACCESS!** Welcome to Harry's Hideaway, a true log cabin tucked inside the gated Goose Island community in Cherry Log, perfectly located between downtown Ellijay and Blue Ridge. Spend your mornings drinking coffee on the wraparound porch, afternoons exploring nearby apple orchards, wineries, hiking trails, shops, and restaurants, and evenings gathered around the firepit or relaxing in the hot tub. Completely renovated approximately three years ago, this spacious three-level cabin offers plenty of room for family, friends, and guests. The open main level features a soaring great room, dining area, updated kitchen with island, walk-in pantry and laundry room, and a private primary suite. Upstairs includes two guest bedrooms, and a shared full bath, while the basement level offers a game and media room, second private suite, plenty of storage, and an oversized garage. Approximately 1,300 square feet of outdoor living space includes a wraparound porch, screened porch, basement-level patio, multiple seating areas, grilling space, and a level firepit area. Stairs lead directly from the property to private access along the Ellijay River. The large paved driveway provides ample parking and easy access without the need for four-wheel drive. Currently operating as an established short-term rental, the cabin has maintained high occupancy, earned more than 50 five-star reviews, and received over 2.3 million views through a social media influencer's video. It is being sold fully furnished, with future bookings and additional rental marketing assets included, subject to transfer requirements. Whether you are looking for a proven investment, a peaceful mountain getaway, or a full-time home surrounded by everything North Georgia has to offer, Harry's Hideaway is ready to enjoy from day one.

10 ACRE EQUESTRIAN ESTATE - CUSTOM ALL BRICK RANCH, IN-GROUND POOL, HORSE BARN, INDOOR ARENA AND MACHINE SHOP, ZONED A-1 * This property is well suited for horse owners, contractors, farmers, or small business owners. Built in 2001 with 2x6 construction by the original owner, the property includes a 2,450 square foot ranch home, horse barn, 60x80 indoor arena, 40x60 insulated shop, heated in-ground pool, fenced pastures, and approximately five acres currently in hay production. The home features 3 bedrooms and 3 full baths, including a spacious first floor primary suite with views of the horse pasture. Originally designed as a four-bedroom home, the two additional bedrooms are generously sized and each includes a walk-in closet and ceiling fan. The vaulted great room offers soaring windows and a brick fireplace, while the open kitchen features maple cabinetry, an island cooktop, KitchenAid stainless steel appliances, Italian porcelain tile flooring, reverse osmosis faucet, and an adjoining breakfast area with access to the maintenance-free deck and pool. The first floor laundry and mudroom includes oak cabinetry, utility sink, washer and dryer, and provides convenient access to the house, attached garage, and basement. The full basement offers 9-foot ceilings, plumbing for a future bathroom, a storm room beneath the stairs, central vacuum, battery backup sump pump, and automatic standby generator. It provides an excellent opportunity to create additional living space or related living. Recent improvements in 2026 include a new roof, multiple window replacements and repairs, and a new humidifier. The attached three-car garage is wired for heat, features two 8-foot overhead doors, and includes a 30-amp RV hookup. Outdoor amenities include a heated 21x36 in-ground pool with slide and surrounding fence, along with a maintenance-free deck that wraps around the side of the home and was replaced approximately three years ago. The equestrian improvements include a four-stall horse barn with 10x12 matted stalls, tack area, and ground-level hay storage. The attached 60x80 indoor arena provides year-round riding space and offers the flexibility for future expansion as your operation grows. The land includes two fenced pastures measuring approximately 100x200 each, expansive front and rear yards, and approximately five acres currently producing hay. The layout provides room for additional pasture development, outdoor riding facilities, or other agricultural uses. The 40x60 insulated and heated machine shop, built in 2007, is designed for serious work. Features include 220-volt three-phase electric service, an 8-inch concrete floor, corn-burning furnace, separate electric meter, overhead door, two service doors, and a second electrical pole serving the building. Whether you need space for equipment, farming operations, a commercial workshop, or a growing business, this building is ready to accommodate a variety of uses. Located in unincorporated Will County within the Peotone School District, the property offers convenient access to major highways, shopping, and commuter routes while maintaining the privacy and flexibility of rural living. Lines drawn on photos are estimated and do not replace a survey.