Under contract-accepting backup offers. Exceptional direct Gulf-front living in Redington Beach. Built in 2019, this impressive coastal residence offers 5,615 heated SF, 9,947 total SF, 70 feet of direct Gulf frontage, 5 bedrooms, 4.5 baths, 2 additional flex rooms and a rare 2,200 SF garage with parking for up to 6 vehicles. A large double-sided elevator serves all four floors.

The outdoor setting is designed for Florida living, with a recently expanded pool lanai offering generous covered entertaining space, a heated pool and a large premium artificial-turf lawn leading directly to the quiet sands of Redington Beach. Coconut palms and low-maintenance tropical landscaping create a relaxed coastal setting. Recent improvements include a new pool fence and custom metal perimeter fencing in 2026, a new 2-foot wall and seawall cap in 2025, and a whole-house gas generator installed in 2025.

Inside, a dramatic foyer with an approximately 36-foot ceiling and custom stainless-steel wave railing leads to the main living level, where 30 feet of sliding glass doors frame sweeping Gulf views. Eleven-foot ceilings continue throughout the home. The open kitchen features two-tone cabinetry, granite and quartz countertops, generous seating and stainless-steel Miele appliances, including a gas range and built-in coffee maker. The kitchen flows seamlessly into spacious dining and living areas and out to the first of three expansive covered balconies. More than 1,700 SF of balcony space provides exceptional outdoor living and entertaining, with surround sound throughout the home and balconies.

The Gulf-front primary suite occupies an entire side of the home and features a wall of approximately 10-foot sliders, an oversized naturally lit walk-in closet and a spacious bath with dual vanities, separate water closets, soaking tub and large walk-in shower.

The next level showcases one of the home's most remarkable features: THREE additional direct Gulf-front bedrooms, for a total of FOUR Gulf-front bedrooms—an extraordinary find along the Pinellas beaches. Two are ensuite with walk-in showers, while all three enjoy access to another large covered Gulf-front balcony. A fifth bedroom, currently used as an office, a large laundry room and a dedicated media room with a 120-inch screen, Sony projector and premium audio complete this level. The media room and main-level den provide two additional flex spaces for guests, offices or recreation.

The fourth floor offers another versatile bonus area ideal for a gym, game room, kids' retreat or bar and opens to a rooftop terrace with spectacular 360-degree views of the Gulf, Intracoastal and coastline stretching south toward Pass-a-Grille and the Don CeSar.

With 70 feet of Gulf frontage, four Gulf-front bedrooms, a 6-car garage, elevator, heated pool, more than 1,700 SF of covered balconies and panoramic rooftop views, this move-in-ready residence delivers a combination of scale, amenities and beachfront living rarely available in this area!

Set amid sweeping pastoral views, 200 Woodville Road is a distinguished residence of exceptional scale, artistry and enduring elegance. Meticulously crafted details define every space, beginning with a sculptural suspended stairway that creates an unforgettable first impression. Beyond it, a magnificent gathering room rises dramatically overhead, offering an extraordinary setting for elegant entertaining as the evening sky unfolds across the horizon. This home will exceed your expectations. The kitchen, dining, and family room wing features impressive chef-style updates and expertly designed and truly customized amenities as well as a walk in pantry room. The first floor Primary Suite feels like a sanctuary & with with direct access to the manicured grounds this is your private space to retreat. The Primary bathing area includes a massive dressing room created with luxury style customizations.
With six en-suite bedrooms, there is privacy and space for all! A billiards and game suite round out the second floor with impressive woodworking, view over the manicured grounds, a gas fireplace, a fully appointed kitchen and a full bathroom become the epic entertaining space like no other. The right wing of the home offers three en-suite bedrooms and a theater room. A fully equipped gym/exercise studio, and sauna are set just off the four car garage with direct access into the main house. As you walk the tastefully manicured grounds, you will be delighted by the extensive hardscaping, flawless pool, grand stone fireplace & chef-style outside kitchen. Enjoy your evening under overlooking the stars from the hot tub. Just beyond the heated driveway, a custom barn with two additional garage bays for your play cars as well a half-court basketball gym.
This extraordinary home is an absolute show stopper with exceptional privacy on one of Maine's most magnificent estates. It's rich history and style are a one-of-a-kind opportunity, just minutes to Portland International Airpo

A MAGNIFICENT LUXURY WATERFRONT ESTATE. Masterfully crafted by renowned luxury builder Alvarez Homes, this spectacular residence showcases architectural sophistication, timeless elegance, and the uncompromising craftsmanship you would expect from one of the finest homes built in Tampa Bay. Located on a wide double lot with approximately 146 feet of stunning intracoastal waterfrontage, this remarkable residence offers a rare combination of expansive waterfront living, exceptional privacy, and premier deep-water boating access. From its impressive architectural presence to its thoughtfully designed interiors, every element reflects an unwavering commitment to quality, refinement, and enduring beauty. Designed for both grand entertaining and practical everyday living, the home provides approximately 6,200 sqft of superb living space - with six bedrooms and six-and-a-half bathrooms. Generously proportioned living areas and beautifully appointed interiors create an atmosphere of understated sophistication, with expansive views that bring the beauty of the waterfront into everyday life. A brilliant gourmet kitchen boasts an impressive array of high-end features, appliances and finishes, complemented by a fabulous waterfront dining area. The owner’s suite, with private balcony, enjoys an exquisite and pampering luxury bath that delivers a dazzling spa-like experience. Step up to the observation deck and take-in sweeping, unforgettable panoramic views of the intracoastal waterway and the Gulf. Out back you’ll find an incredible waterfront oasis – with outstanding zero entry Pebbletec pool and spa, an uncommon custom playground area, high-capacity boat lift and dual jet ski lifts. Additional features of this estate include a private elevator, whole-home generator, durable metal roofing and large covered balconies. This is an outstanding luxury value in a superior waterfront location.

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.

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.

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.

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.

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.

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.

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:

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.

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!

Prime Commercial Investment Opportunity - 28,000+ Sq Ft Across 5 Buildings

Don't miss this rare opportunity to own a well-positioned office park offering over 28,000 square feet of versatile space spread across five buildings. Located just off Main Street, this property boasts high visibility and easy accessibility, making it ideal for a variety of business and professional uses.
Currently home to well-established businesses and office tenants, the site offers strong income potential. This property is perfectly suited for investors or owner-occupiers looking to expand in a thriving area. Whether you're expanding your portfolio or seeking a new headquarters, this is a must-see commercial offering with long-term value.

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 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.

With a staggering level of opulence and luxury - crafted to a degree rarely seen in Tampa Bay, this palatial 10,174 total sqft estate makes a statement like few others. From its Jerusalem Gold limestone floors and lavish mahogany woodworking, to its Venetian plaster walls and impeccable custom inlaid designer ceilings, everything about this masterpiece sets the standard for high-end elegance. Built by Windstar, one of the bay area’s premier luxury builders, the most discriminating buyer will recognize an astonishing level of quality and detail craftsmanship built into virtually every element of this home; more than $1M in sublime upgrades were made to this already brilliant residence. Distinguished cast stone exterior trimwork introduces a magnificent all cast stone entryway arch and arched copper double doors. Step inside to the majestic 29ft-high foyer with dazzling wrap around flying staircase, and take in endless extravagance and splendor. The stately sitting room, with towering cast stone gas fireplace, features soaring 24ft-high window views of the pool deck and Bayou Club Golf Course. The executive office, richly adorned in mahogany with numerous custom built-ins, is a CEO-caliber decision-making space. Plush formal dining is complemented by a sumptuous gourmet chef’s kitchen with extensive custom designer cabinetry, stone counters/backsplash areas, Subzero refrigeration, Wolf gas cooking, a huge island bar/serving center, pass through serving stations, warming draw and much more. The grand living room, a central gathering and living area, boasts pocketing sliding glass corner doors – creating the ultimate indoor-outdoor living experience. Step into the luxuriant full-size game room with adjacent theater room. Game room enjoys a resplendent drybar with full size Subzero beverage chiller and pocketing sliding glass doors that open to the pool deck and outdoor kitchen. Not to be outdone, the superb theater room seats 10 in ultra-rich comfort. Upstairs, discover an extraordinary owner’s suite with ornate hallway entry, impressive custom built-ins, morning bar, grand sitting area and a massive, private 42ft-wide 600sqft covered balcony with commanding panoramic views of the golf course. Separate his and her full luxury baths are spacious (each with large walk-in luxe closet systems), are masterfully-finished in marble/stonework, and are joined by a stunning all marble double-sided walk-in glass shower enclosure. All bedrooms are large and exceptional in their finishes, and all baths are graceful in their appointments. Step out back to the striking freeform, zero-entry Pebbletec pool/spa and posh pool deck. Splendid 950sqft covered outdoor entertainment deck, offering three distinct dining/seating/lounging areas, supports a fine built-in outdoor kitchen and gas cooking center. You’ll appreciate the dedicated pool bath, deluxe elevator, tankless hot water heating and long list of custom amenities. With eye-catching arched hallways, cast stone columns, spectacular window treatments, and artisan quality woodworking/built-ins – nothing is left to want in this peerless home. Impossible to duplicate anywhere near this price. An uncompromising, definitive luxury golf course estate!

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.

Welcome to 546 Saratoga St, a rare four-family in East Boston’s Orient Heights offering modern living, ideal for owner-occupants or investors. Each unit features 2 bedrooms and 2 full baths, with units 3 and 4 designed as bi-level homes with an added half bath and their own private roof deck with beautiful views. Features include central A/C, in-unit laundry, and modern kitchens with dishwasher, microwave, stove, and refrigerator. Live in one unit and let the others help pay your mortgage, or add an income-producing asset to your portfolio. Set on a quiet residential block near cafés, restaurants, and waterfront parks, just steps to the Orient Heights Blue Line with a direct ride downtown. Minutes to Logan Airport, Route 1A, and the North Shore. Four-families like this are hard to find! First showings at the open houses Saturday 10/24 and Sunday 10/25, 12:00-1:30 PM.

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*

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!

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.

SOARING HIGH ABOVE DOWNTOWN ST. PETERSBURG WITH REMARKABLE VIEWS OF TAMPA BAY AND THE DOWNTOWN AREA, THIS DAZZLING 12`TH FLOOR RESIDENCE DELIVERS AN INSPIRING COASTAL CONTEMPORARY APPEAL! Step inside and take in a sophisticated and uniquely cosmopolitan living experience with sublime finishes, and a striking cultured ambiance that confirms, “this is home.” Numerous updates and upgrades include luxury fixtures, rich offset lighting, specialty wall treatments, elegant flooring/tilework, and electronic window treatments. Your secured, semi-private elevator opens to a private foyer with generous closet storage. The impressive great room plan provides captivating views of downtown and the waterfront, while the primary living area transitions to a 300sqft+ covered luxury balcony with lovely views of the bay and dazzling, sweeping views of downtown St. Pete. An eye-catching chef’s kitchen boasts a graceful minimalistic cabinetry design, with exquisite quartz counters, a center island bar with waterfall quartz surfaces, and high-quality Thermador and Miele appliances. You’ll appreciate the matching morning bar area with Thermador microwave and high-end beverage chiller. The posh owner’s suite boasts stunning views of downtown, a beautiful closet system and private access to the covered balcony. Owner’s bath is a lavish, pampering euro-inspired experience with gorgeous contemporary vanities, superior fixtures, custom designer tilework, wide form-factor LED mirror, Toto electronic toilet system (present in all baths), a sumptuous soaking tub and a terrific walk-in glass rain shower enclosure, with body sprays and secondary body shower. The second bedroom suite is plush, with fine city views and an exceptional full bath with a richly-appointed walk-in glass shower enclosure. Third bedroom enjoys wonderful downtown views, an attractive closet system, and direct access to an elegant and sizable full bath. Full feature laundry room provides exceptional cabinetry, built-in sink and generous storage. The 4th floor of the Nolan includes an outstanding array of indoor and outdoor amenities including a luxurious social room with media center, full-service kitchen and bar, fitness center and massage room. Step out to a magnificent outdoor living and social scene, with superbly manicured spaces, covered dining, a built-in cooking/grilling center, firepit, numerous lounging cabanas, and a large swimming pool with adjoining spa/hot tub. Frequently recognized as the Gulf Coast’s most vibrant coastal downtown area, downtown St. Pete features outstanding dining, shopping and entertainment; a short walking distance to Straub Park, Sundial, Beach Drive, the Museum of Fine Art, and the waterfront. This is a terrific value in a premium downtown location.

Under contract-accepting backup offers. A BOATER’S PARADISE MEETS SUPERIOR, HIGH-QUALITY COASTAL CONSTRUCTION. Welcome to a “built-to-last” waterfront sanctuary! Elevated with all block construction and poured concrete floors, you’ll appreciate the peace of mind offered by this exceptional, easy living waterfront residence. A spacious brick paver driveway, generous 6-car garage parking, and two 10,000 lb boat lifts make this the perfect place for your vehicles and watercraft. Driftwood-style porcelain floors, lovely crown woodworking and tall 10ft-high ceilings introduce a wonderful open floorplan with beautiful views of the waterfront. Your spacious living room opens to an elegant 225sqft covered balcony with a built-in electronic sunshade. Fabulous chef’s kitchen boasts fine quartz counters/backsplash, rich coastal cabinetry, huge wrap-around multi-level breakfast bar, under and above cabinet lighting, and pantry closet. Double doors open to a fabulous waterfront owner’s suite that opens to the waterfront balcony and features two walk-in closets with built-in dressers. Owner’s bath provides dual quartz vanities and an exquisite designer walk-in shower with seating bench. Second bedroom is oversized and en suite, and has a graceful bath with jetted tub and shower. Third bedroom is spacious and has a walk-in closet with adjacent full guest bath. Your private backyard oasis awaits you! Discover a huge 470sqft covered deck that transitions to a large paver area with a gorgeous Pebbletech Pool/Spa. Deck offers lots of lounging space and covered outdoor dining. Updated seawall supports a composite dock with two boat lifts. Bahamian shutters on the outside, plantation shutters on the inside, large and well-finished laundry room with extensive cabinetry storage, lower-level multi-purpose area, large 8ft-high elevator, PVC privacy fencing, and so much more. Located within easy walking distance of the powder soft sands of Treasure Island beach, dining, shopping and entertainment. An outstanding value in an excellent waterfront boating community!

Virtually Staged. LUXURIOUS AND CONTEMPORARY, WITH THE PERFECT L.A. BLEND OF MINIMALISTIC ELEGANCE, SUPERIOR FORM AND ADVANCED FUNCTION, THIS VISUALLY-STUNNING WATERFRONT RESIDENCE WAS BUILT WITH REFINED IMAGINATION AND YEARS OF FORWARD-THINKING! Remarkable planning and extraordinary attention to the smallest of details have yielded a home that breathes a beautifully rare and clean simplicity. High ceilings, tall windows, elegant engineered hardwood flooring and finishes designed to “float” throughout the home, deliver a deeply-satisfying, Andy Worhol-like living experience. Modern concept kitchen features inconspicuous white cabinetry, high-quality stainless steel appliances, gas cooking, quartz counters, large island bar and a wonderful multi-function pantry hidden away from the home’s open areas. Superb built-ins offer a distinct art deco flare that complement posh, state-of-the-art lighting and generous use of skylights. The inspired living area, with its sleek fireplace illumination, transitions to a fabulous open dining space overlooking the waterfront. Through pocketing sliding glass, take in grand, sweeping and unobstructed water views made possible by exquisitely-engineered cantilevered construction. Bringing all of your waterfront into view, you’ll love the expansive, 50 ft-wide (approx.) covered balcony with pristine porcelain floors, exterior marble façade, bench, planter and built-in gas for outdoor cooking & firepit. The owner’s suite enjoys private balcony access, neo-contemporary built-ins and a richly detailed closet system. Owner’s bath is a lavish, pampering experience; with its own unique combination of materials, design and color, you’ll be enthralled by the purity of concept in the partially-open rainshower, sublime soaking tub and custom double vanity – merging vintage wood credenza and modern granite surfaces. Large 2nd bedroom complements owner’s suite in style & substance. You’ll be drawn to the delightfully-appealing guest bath and its amazing use of light, tilework and composition. Plush theater room functions as a 3rd bedroom. Lower-level entry foyer has a rich welcoming feel, and extensive multi-purpose/storage space. Out back, discover 2 sizable covered private waterfront decks overlooking a gorgeous Pebbletech pool. Updated seawall, composite dock, backup generator, and many extras. Brilliantly conceived, and exceptionally well-built.

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.

BETTER THAN NEW! This is the one!!! Gorgeous four year old, 5 bedroom, 5.5 bathroom home with first floor main level bedroom and full bathroom option! Enter into a custom built smart home and discover a spacious open concept living room featuring a cozy fireplace and glass doors leading to an expansive deck. The gourmet eat in kitchen boasts top of the line appliances, an oversized center island, reverse osmosis water filtration system, and generous pantry complimented by a private dining room. Well appointed mud room leads to three car garage. Upstairs you will find two oversized suites on the second floor as well as two additional bedrooms, a loft/home office space, laundry and full bathroom with a walk up third floor with loads of potential! The finished basement is waiting for all of your activities - wet bar, game space, walk out to the firepit... Central air, central vac, EV charger, the opportunities are endless! Fully owned solar panels reduce your electric bill to next to nothing! Contact me for a private showing today!

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.

Welcome to The Live Oak Haus, a remarkable Fredericksburg retreat just TWO BLOCKS from Main Street! Offered fully furnished and turnkey, this impressive 6-bedroom, 6-bath residence combines luxury, location, and resort-style amenities in one extraordinary property. Whether envisioned as a private getaway, corporate retreat, full-time residence, or income-producing investment, the possibilities are endless. Thoughtfully designed for both entertaining and privacy, the spacious layout features multiple bedroom suites, upscale finishes, and inviting gathering spaces throughout. Step outside to your own private oasis featuring a custom pool and spa, covered cantina with outdoor kitchen, screened porch, and impressive fire pit, creating the perfect setting for relaxation and entertaining. All just moments from Fredericksburg's renowned restaurants, boutique shopping, live music, and celebrated wineries along the 290 Wine Trail. A truly irreplaceable advantage is the property's grandfathered STR permit under 2018 ordinances, allowing occupancy of up to 19 guests, far beyond the city's current guest limit for new permits. This rare distinction offers a level of rental capacity that cannot be replicated under today's regulations. With an established hospitality reputation and an extensive history of outstanding guest reviews, The Live Oak Haus offers a compelling turnkey opportunity. Future bookings convey with the sale, providing the potential for immediate rental income for buyers wishing to continue operations. Experience the best of Fredericksburg living and investment potential in one remarkable property. (Professional photos have been virtually enhanced.)

** Seller Financing Options Now Available - Ask about Options** 20 ACRE LUXURY HOME AND EQUESTRIAN FACILITY - 30 STALLS TOTAL; INDOOR AND OUTDOOR ARENAS AS WELL AS PLENTY OF PASTURES. EVERYTHING IS MOVE-IN-READY! The MAIN BARN was built by Lester, is 3-years NEW and is a white pole building with a black roof and wainscoting. Fully Insulated Walls with radiant floor HEAT and supplemental forced air heat. It features 16 Stalls; all equipped with mattresses, drop down stall fronts and electrical outlets. (6 Stalls are 12x12 with 12x24 run-outs; 10 Stalls are 10x12). Additional amenities include Viewing Room, Tack Rooms (2), Office, Bathroom, Indoor Wash Rack and Blanket Rack. HEATED INDOOR ARENA is 80x135x20 and features fiber footing, angled kickboards, large built-in mounting block. The interior walls are insulated and finished. There are 4 sliding windows for cross ventilation and 6 rows of lights. LARGE OUTDOOR ARENA was built with landscape fabric, limestone base and sand footing. It's finished with beautiful 4-Board Fencing. The separate barn entrance is a circle drive for easy in and out with trucks and trailers. ORIGINAL BARN by the house has been completely renovated. It features 5 Stalls (European Bamboo); 10x12 with swing-out feeders, mattresses and Dutch doors that open to 12x20 runouts. 8 PORTABLE LEAN-TOS WITH 9 OUTDOOR STALLS and storage. PADDOCKS AND PASTURES are constructed with 4-Board Wood Fencing. This lovely 2-Story Farmhouse sits on top of a hill overlooking the rest of the farm. There is original stone fencing around the perimeter of the property. It features 4,000 Sq Ft of finished space with 5 BR & 4.5 BA and has been COMPLETELY RENOVATED. Sellers added a Mud Room, Laundry Room, 1/2 Bath as well as other upgrades that have been finished to the period of the house to be historically correct. Large Formal Foyer with hardwood floors leads you to multiple rooms in the house...Large Kitchen with Eat-At Island is open to the Dining Room. The Kitchen features NEW white cabinets with crown molding, Quartz counters, Stainless Steel Appliances and a farmhouse sink. 4-SEASON ROOM / FAMILY ROOM faces south and has windows on 3 sides which provides maximum sun exposure and a beautiful view overlooking the pastures. LIVING ROOM features a beautiful bay window and a double-sided original stone fireplace that also serves the 1st Floor Bedroom with Full Bath. The 2nd floor features 3 BR & 2 BA; one is a shared Jack & Jill Bath. The Roof-Top-Deck is perfect for relaxing...day or night! The finished living space above the garage has its own separate entrance and includes a Sitting Room, Bedroom & Full Bathroom. It's perfect for the farm employee, Guest Quarters, In-Law or Related-Living Suite. NORTHEAST and NORTHWEST OUTBUILDINGS are primarily used for storage. (These two buildings have not been renovated.) This is your chance to own a historical property from 1815 with modern amenities. GREAT LOCATION: 5 Min to Woodstock for shopping, restaurants and the Metra and 1 Hour or less to 4 different show facilities. Zoned A1; Agriculture. *PLEASE ASK TO SEE THE ADDITIONAL FEATURES SHEET FOR FULL DETAILS * A PROOF OF FUNDS OR PREAPPROVAL LETTER IS REQUIRED AND A 24 HR NOTICE IS NEEDED FOR SHOWINGS TO BE APPROVED.* This property is also for lease: $10,000 for all or $6,000 for the Barn and Pastures.

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!

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.

Discover an extraordinary opportunity to own a private island retreat on beautiful Lake Winnisquam. Offering exceptional waterfront, privacy, and an impressive collection of amenities, Mohawk Island is a truly distinctive property designed for unforgettable summers and generations of memories on the lake.
At the heart of the island is a beautifully updated single-family home featuring multiple bedrooms, tiled bathrooms, inviting living spaces, and expansive outdoor areas overlooking the water. Offered fully furnished and move-in ready, you can begin enjoying island life from the moment you arrive.
Step outside to a large sandy beach, multiple docks for boating and swimming, expansive decks, and charming lantern-lit paths. The property also features the iconic Mohawk Island Lighthouse, one of its most recognizable and memorable features.
Multiple additional structures provide incredible flexibility for family and guests, including a bunkhouse, full gym, and additional guest spaces. A hot tub and fire pits create perfect gathering places for cool evenings and year-round enjoyment.
Island living is exceptionally convenient here, the mainland is just a few seconds away by boat. Mainland access includes a PRIVATE BOATHOUSE AND GARAGE, providing dedicated space for your boat, vehicles, and lake necessities.
For those looking for even more space, #5 Mohawk Island is also currently available for sale, creating the rare opportunity to own two properties on this remarkable island.
A rare opportunity to own a substantial piece of Lake Winnisquam and experience true New England island living. Owner financing may be an option!

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.

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,600 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.

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.

Beautiful ranch property located just East of Seguin on Highway 90-A East!
This property has a two story home with whole house filtration system, R-O system, water well, two stock ponds, outbuildings and numerous massive Live Oak trees spread over the ranch. The property is currently used as a cattle and hunting ranch. The area holds Whitetail deer, wild turkey, native birds, wild hogs, ducks and other native wildlife. There is an additional 77.54+- acre property with Guadalupe River frontage that can be bought in addition to this ranch.

40 ACRES, COMMERCIAL GREENHOUSE, RESIDENCE & ADDITIONAL BUILDING ALLOCATION,AGRICULTURAL FACILITY WITH SUBDIVISION POTENTIAL ON NATURAL GAS * Formerly operated as Delaney's Greenhouse, this 40-acre agricultural and rural commercial property offers an established greenhouse and operational compound situated on a larger, dividable acreage with expansion and development flexibility. The operational core includes four greenhouses and pole building totaling over 16,000 square feet of covered production and utility space. * Two 42x96 production greenhouses featuring passive and mechanical ventilation, drip irrigation, and in-floor heat in propagation areas, supporting year-round commercial growing. * One 30x96 modern freestanding double-poly greenhouse with concrete floor, roof peak vent, roll-up sidewalls, and overhead drip irrigation. * One 30x70 single-poly greenhouse with gravel floor, offering additional seasonal growing or flexible storage capacity. * A 16x42 office / head-house connects the greenhouse complex directly to a 43x62 pole building, creating efficient workflow between production, administration, and storage. The pole building, freshly painted, features concrete and gravel flooring and supports equipment storage, fleet vehicles, fabrication, warehousing, or contractor operations. Additional improvements include a well-maintained dairy barn with hay loft and original milking room, adaptable for storage or reuse, and two functional grain bins equipped with dryers, stirators, and aeration floors. The updated farmhouse offers four bedrooms, 2.5 bathrooms, and a full unfinished basement, providing a comfortable on-site living option for an owner-operator or management staff. The country kitchen features new oak cabinetry with many cabinet upgrades, stainless steel appliances, and ample table space, while the oversized family room includes a stone accent wall with fireplace, creating a warm, functional gathering space. The primary bedroom and bath are located on the first floor, offering convenient main-level living. Recent improvements include a newer roof, kitchen updates, interior and exterior paint, carpet, and landscaping. The home is well-suited for owner occupancy, employee housing, or conversion to office headquarters. * Beyond the operational compound, the balance of the acreage provides subdivision and development optionality, allowing the property to be: * Retained as a single owner-operator agricultural facility * Divide it for resale * Expanded for additional greenhouses, ag-retail, or related commercial uses. A rare opportunity to acquire a 40-acre property anchored by a fully improved commercial greenhouse and agricultural facility, offering natural gas service, multiple reusable structures, and land division potential. Suitable for owner-operators, investors, or buyers seeking a flexible ag-commercial platform with long-term upside. 35 Tillable acres with Swygert soil and a PI of 120. If buyer purchases & closes on property before March, they will have the option of farm the ground themselves. Otherwise, the ground will be leased for the 2026 growing season. Seller has received offers for cash rent of up to $450 / Acre. Lines drawn on photos are approximate & do not replace a survey.

Experience the art of exceptional living at 30 Mill Street, where timeless elegance, modern sophistication, and thoughtful design come together in this stunning 2026 luxury Colonial. Beautifully situated on nearly an acre along the Holliston–Hopkinton line, this remarkable residence offers approximately 4,587 sq. ft. of refined living space. An exquisite chef’s kitchen with a dramatic quartz waterfall island flows effortlessly into elegant entertaining areas, complemented by rich hardwood floors, architectural detailing, and three fireplaces. Four beautifully appointed en-suite bedrooms include a magnificent primary sanctuary featuring a fireplace, spa-inspired bath, and spacious dressing room. A private library, inviting second-floor lounge, and expansive finished lower level provide exceptional flexibility. Outdoors, a spectacular stone patio with a built-in kitchen creates the perfect setting for unforgettable gatherings. Complete with a three-car garage and proximity to golf, this is luxury living at its finest.

NO SHOWINGS UNTIL THE FIRST OPEN HOUSE TENTATIVELY SCHEDULED FOR LATE OCT. & WILL BE ANNOUNCED ASAP. THIS MAGNIFICENT HOME SITS ON A 1/2 ACRE LOT. THE SPACIOUS ENTRY LEADS TO A FORMAL FIREPLACED LIVING ROOM ON THE RIGHT AND ON THE LEFT SIDE IS THE ENTRY TO THE DINING ROOM, KITCHEN AND HUGE FIREPLACED FAMILY ROOM W/CATHEDRAL CEILINGS, LAUNDRY AND 1/2 BATH ON MAIN LEVEL. THE 2ND LEVEL HAS 2 HUGE BR'S WITH THE MAIN BR OFFERING A LARGE EN SUITE AND WALK IN CLOSET. ALSO ON LEVEL 2 IS A STUDY/OFFICE AND A FULL GUEST BATH.

TURN-KEY EQUESTRIAN FACILITY * 54 ACRES * RANCH HOME * 13 STALL BARN * OUTDOOR SHEDS * INDOOR & OUTDOOR ARENAS * HAYFIELD * POND * ZONED AGRICULTURE * The 2,140-square-foot ranch home offers three bedrooms, 2.5 bathrooms, a full unfinished basement and a two-car garage. The kitchen features stainless steel appliances, granite countertops and a breakfast bar, with an open dining area connecting the kitchen and living room. Overlooking the pastures, the three-season sunroom offers a relaxing place to watch the horses graze or an inspiring setting for a home office. The MAIN HORSE BARN features a 60x120 indoor arena with sand footing and angled kickboards. There are 13 stalls (tongue & groove with 1/2 walls for ventilation and mats), a viewing room (in the works), tack room, feed room, medical room, wash racks and a large hayloft. Peaceful and scenic, the LAND offers a little bit of everything. The northwest corner features woods, trails and a pond. An outdoor arena enclosed with wood fencing provides additional riding space, while four all-weather turnouts accommodate daily turnout needs. Two run-in sheds are each divided into four interior spaces, giving horses their own areas for shelter. The adjoining dry lots connect to grass pastures, making it easy to rotate turnout simply by opening and closing gates. A 20-ACRE HAYFIELD makes this farm SELF-SUSTAINING. The gravel road along the east side provides easy access for equipment. The property extends well into the woods, offering space for hunting or expanding the trail system. The newer 30x60 POLE BUILDING features a concrete floor, electric, insulated walls and ceiling, a heater and four insulated overhead doors. Ideal for equipment and storage, it also includes pallet racks that stay with the property. The ORIGINAL OUTBUILDING is 30x35 and currently serves as hay storage. It features a concrete floor, electric, an overhead door and a service door. Located just three miles from Marengo and 10 miles from Woodstock, with multiple show facilities between 8 - 43 miles away, this farm brings everyday horse care, riding and country living together in one convenient location. See Additional Features / Improvement Sheet for more details. This is a private residence and facility. PLEASE DO NOT ENTER PROPERTY WITHOUT AN APPOINTMENT.

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.

Tucked away on a quiet cul-de-sac in desirable West Boxford, this 4 bed/5 bath farmhouse seamlessly blends modern luxury and New England charm. Guests will be greeted in a light splashed, 2 story foyer with newly finished hearty pine that spans the home's main level. A generous chef's kitchen features cathedral ceiling, large island, double wall oven, gas cooktop, breakfast nook and coffee station. Grand living room is complete with wood burning fp, soaring ceilings and french doors. Additionally, the main level offers 2 home offices with dual sided gas fireplace, a formal dining room, private laundry room and separate half bath. The second level features a generous primary suite, walk in closet and spa-like bathroom complete with teak vanity, soaking tub and enclosed shower plus 2 spacious bedrooms and additional full bath. The versatile layout offers the perfect au-paire/guest suite or possible ADU with an oversized bedroom/full bath separated from the main sleeping quarters. Basement is partially finished with large rec room, half bath and loads of storage. On 6+ acres, additional features include; gorgeous sunroom perfect for dining alfresco, 2 car garage plus carport, rear patio with massive gazebo, wood flooring throughout, hot tub, firepit, generator, new water filtration system, storage shed and sprinkler system. Set back from the street, this home is your own private oasis- tastefully decorated and impeccably maintained. Don't miss out on this one of a kind property.

Beautiful Guadalupe River ranch located just East of Seguin on East US Highway 90 Alternate, about an hour East of San Antonio and about an hour South of Austin! This property offers outdoor adventure, seclusion, fishing, hunting and kayaking on the Guadalupe River. The ranch has ample winding river frontage and a native Pecan bottom with huge Pecan trees. Wildlife in the area include white tail deer, wild turkey, native birds, wild hogs, ducks and other native wildlife for nature lovers. There is a camping area in the Pecan bottom where one can walk to a sand bar on the river. Discover your slice of Texas on this live water property!

Offered at $1,600,000, this established rental investment opportunity in Flovilla, Georgia, provides investors with the chance to acquire 29 rental units conveniently located together near Indian Springs State Park. The property includes a 6-unit apartment building, 6 duplexes, 1 triplex and 11 single-family homes, totaling 29 rental units. Several units have been recently updated, while others offer opportunities for renovations and improvements, creating additional value-add potential for the next owner. With an established rental history and consistently rented units, this property offers an excellent opportunity for investors looking to expand their rental portfolio or acquire multiple income-producing units in a single transaction. Rent roll information is available upon request. Whether you're a seasoned investor looking to expand your holdings or searching for an opportunity to enter the rental investment market on a larger scale, this property offers established rental income, renovation potential, and the convenience of multiple units in one location. Additional investment opportunity:Approximately 44 acres of vacant land adjoining the rental properties and bordering the lake at Indian Springs State Park are also available for purchase separately. This acreage is not included in the $1,600,000 asking price. Inquire with the listing agent for additional information about the available land. Don't miss this opportunity to invest in an established rental property with income potential and room for improvements. Contact the listing agent for more details, rent rolls, or to schedule a tour.

WALK INTO A STUNNING VIEW OF THE LUCKY 8TH HOLE of the Jack Nicholson designed golf course next to this magnificent two story colonial. Surrounded by water views & fairways, this custom home welcomes you with a magnificent two story marble foyer w a dramatic spiral wood staircase & luxe chandelier. The light filled home continues on to the two story family room with fireplace with the sweeping views of the course from its huge picture windows framing the back. Left and right of the front entrance is the formal living and dining rooms. The formal living area has a FP and vaulted ceilings, and the dining room is the perfect size for a large table. Back in the family room with sky high ceilings is another wood burning FP. The newer plank wood floors (2024) lead to the patio doors that open up to the outdoor refurbished balcony (2026) and covered round gazebo. The open kitchen (remodeled in 2018) has white cabinets, quartz countertops, new stove (2026) with hardwood flooring. The generous eating area will be a popular place for family gatherings, and the service area behind is good for caterers & delivery. The convenient laundry room is next to the 3 car garage and has its own service half bath. Between the kitchen & dining is a butler pantry area, perfect for parties. Across the hall from the kitchen is the FIRST FLOOR MASTER BEDROOM SUITE with a full luxury Master Bath and 2 walk in closets. There is adjacent office and den and both rooms have golf course views. There is a convenient first floor powder room for guests. Upstairs are the 2nd, 3rd, 4th & 5th large & spacious bedrooms. The 2 right wing BR have their own ensuite full baths & walk in closets. The left wing BR share an extra large full hall bath, and both have walk in closets. Downstairs is the amazing finished walk out basement with another FP, recently remodeled this year 2026 w new flooring, new ceiling lighting & brand new full bath for the additional 6th BR below. The view, again, is of the beautiful approach to the 8th hole green, and the cement patio outside the sliding doors is perfect for outdoor activities or sightseeing. There are two small storage rooms plus the utility section of the unfinished basement area houses two furnaces (2016 & 2026), two hot water heaters (2025 & 2016), 2 A/C (2015 & 2025) & the home has 2 separate temp zones. Roof was replaced in 2017. Other than that, home will STRICTLY BE SOLD AS IS, and is priced accordingly. The interior has been painted and professionally cleaned before being marketed. Come and show it today with confidence. (Exterior landscaping plan is awaiting approval.) Clubhouse, golf membership are all extra, not included in HOA.

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.

Looking for a terrific waterfront pool home on the prestigious Isle of Capri? This completely updated 3-bedroom, 2-bath residence 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 sail to John’s Pass and out to the Gulf. From there, the world awaits your arrival. This solidly constructed home was built by the legendary builder Jack Apple, who was fond of saying, “Be honest and never build something you wouldn’t live in yourself”. With over 2,800 conditioned sq ft and over 3,500 total sq ft, all rooms are very spacious and include amenities such as a walk-in closet in the primary bedroom, double closets in the guest bedroom, and a wood burning fireplace in the den. The view is incredible as you look straight up the canal, across Boca Ciega Bay and over to Jungle Prada in St. Petersburg. Plus, you have a small private beach for launching kayaks or lounging in your beach chair with your favorite beverage. The home includes many extras such as hurricane impact windows/doors, extended-life tile roof, large 2-car garage, newer seawall, HVAC replaced in 2025, in-door laundry room, pergola and much more. The Isle of Capri neighborhood is a short walk or bike ride to the beach. The community has a park, playground, pickleball courts, ball field, picnic pavilion and dog park. As you enjoy the award-winning Treasure Island Beach, along with a variety of restaurants and shops, you will feel like you’re on vacation year-round. Outstanding value for a waterfront home with so much to offer.

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!

New Price! OPEN HOUSE THIS SAT. 10/10/26 FROM 11:00AM TO 2:00PM. Have you been searching for a lake property that offers possibilities? A place with plenty of room for friends and family to gather, easy swimming and boating access, and ample parking for everyone — including all your toys and equipment? You may have just found your needle in the haystack! This spacious lot offers room for expansion, along with a sandy beach and crystal-clear waters on one of Maine's most desirable ponds, known for its abundance of prize-winning fish. Whether you're looking for summer fun on the water, year-round outdoor activities, peaceful evenings around the campfire, or simply a place to escape and relax, this property has so much to offer. Imagine starting your morning with a cup of coffee while taking in the breathtaking water views from your back porch. Spend the day swimming, boating, fishing, and enjoying time with your favorite people. Then gather around the campfire as the loons call across the water and the crickets provide the evening soundtrack. It has all the possibilities you've been looking for, while still preserving that charming Maine summer-camp feel. This is it. You've found it. Showings Begin at the Open House. OPEN HOUSE — Saturday, September 5th 10:00 AM - 1:00 PM Come see it for yourself! I hope to see you there. Stay Tuned for more Photos.

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.

VILLAGE LIVING AT ITS BEST.WELL MAINTAINED. WALKING DISTANCE TO THE CENTRAL BUSINESS DISTRICT AND ALL THE CONVENIENCES. ALL UNITS ARE 2 BDRM.,1 FULL BATH. GAS IS INCLUDED IN RENT. 2 PARKING SPOTS PER UNIT. BASEMENT STORAGE. NEWER ROOF. RENT ROLE AND I/E TO FOLLOW. POSSIBLY ROOM TO EXPAND IN REAR OF PROPERTY
*SELLER WILL REVIEW LETTERS OF INTENT (LOI) NOVEMBER 11, 2026. THE LOI SHOULD INCLUDED TERMS OF AN OFFER, ANY OTHER CONDITIONS, A PRE APPROVAL LETTER OR PROOF OF FUNDS. *

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.

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.

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.

Rare opportunity to acquire two adjoining parcels on close to an acre of land featuring a single-family residence and a two-family duplex, offering three residential units in total! Ideal for investors, developers, owner-occupants, or multigenerational living. Enjoy the benefits of owning the entire property, including enhanced privacy, land control, and multiple income-producing opportunities. Situated in an area with a mix of residential and commercial uses, this unique offering may also present future redevelopment potential, subject to municipal approvals, buyers due diligence and zoning requirements. Properties are also available individually. See MLS #73590358 and MLS #73590357.

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.

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.

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!

Welcome to this beautifully maintained and spacious single-family home in Revere, offering the perfect combination of comfort, space, and modern finishes. The bright and inviting interior features hardwood floors, generous living and dining areas, updated kitchen with granite countertops and stainless steel appliances, and beautifully finished bathrooms. The primary suite offers a private bath with double vanity and ample closet space. With multiple living areas, this home provides plenty of flexibility for today’s lifestyle. Enjoy in-unit laundry, garage and off-street parking, plus a large fenced backyard featuring a deck and patio—an amazing space for entertaining, relaxing, and enjoying the outdoors. Conveniently located near shopping, dining, public transportation, schools, and major routes.

Two distinct homes. One address full of possibilities. Built in 2016, this Revere two-family offers approximately 4,000 square feet of living space across a three-bedroom, two-bath residence and a two-bedroom, one-bath residence. Bright interiors, hardwood floors, generous living and dining areas, kitchens with granite countertops and stainless steel appliances, and in-unit laundry bring comfort to everyday life. The three-bedroom residence features a fireplace and a primary suite with a private bath and double vanity. Outdoors, the landscaped, fenced yard invites you to gather on the deck, relax on the patio, and enjoy room to spread out. A two-car garage and additional off-street parking add everyday ease. Live in one home and rent the other, make room for extended family, or invest in a versatile property near shopping, dining, public transportation, and major routes.

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.

Discover a rare, once-in-a-lifetime investment opportunity in the heart of Black Mountain, NC. This
historic 100-year-old inn blends authentic architectural charm with immense commercial potential.
Perfectly positioned in the Front Porch of Western North Carolina, this estate offers 11 spacious
bedrooms and 9 bathrooms, making it an ideal candidate for a premier boutique hotel, bed and
breakfast, or corporate retreat. The true value lies in the expansive 2-acre site, a rarity in this highly
sought-after market. With prime commercial zoning, the property is a blank canvas for development,
offering ample space for luxury glamping sites, private event facilities for weddings, or additional guest
structures to maximize your investment. Its location near downtown Black Mountain—known for its
artisanal shops and craft breweries—and proximity to vibrant Asheville ensures steady year-round
interest. This property offers the perfect balance of timeless character and scale, providing a unique
foundation for any visionary hospitality operator. Whether you aim to restore a historic landmark or
develop a multi-faceted retreat, this iconic estate stands as a legacy asset in one of the region’s most
desirable locations. NO HISTORICAL RESTRICTIONS!

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.

Introducing The Claremont House—a landmark Grand Victorian beside Clark University, offering historic character, established rental income, and a rare 29,000+ sq ft double corner lot. Recognized with a Silver Hammer Award for its restoration, this 11,000+ sq ft property makes an unforgettable first impression with ornate woodwork, fireplaces, stained-glass accents, and a dramatic two-story staircase anchored by an 8’ × 10’ stained-glass mural. Currently operating as a licensed lodging house, the property offers 18 bedrooms, two full kitchens, four baths, and an established rental history in the Clark University district. Its generous lot and unfinished basement offer possibilities for a buyer to explore, subject to due diligence and approvals. ~ Claremont Street is also within Clark University’s University Park Partnership Scholarship zone, where qualifying residents may receive four years of undergraduate tuition ~ With its commanding presence, income in place, and location beside Clark, The Claremont House is a rare opportunity to own a piece of Worcester history.

Introducing The Claremont House—a landmark Grand Victorian beside Clark University, offering historic character, established rental income, and a rare 29,000+ sq ft double corner lot. Recognized with a Silver Hammer Award for its restoration, this 11,000+ sq ft property makes an unforgettable first impression with ornate woodwork, fireplaces, stained-glass accents, and a dramatic two-story staircase anchored by an 8’ × 10’ stained-glass mural. Currently operating as a licensed lodging house, the property offers 18 bedrooms, two full kitchens, four baths, and an established rental history in the Clark University district. Its generous lot and unfinished basement offer possibilities for a buyer to explore, subject to due diligence and approvals. ~ Claremont Street is also within Clark University’s University Park Partnership Scholarship zone, where qualifying residents may receive four years of undergraduate tuition ~ With its commanding presence, income in place, and location beside Clark, The Claremont House is a rare opportunity to own a piece of Worcester history.

Under contract-accepting backup offers. 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.

Welcome to 245 Judge Road, where elegance meets comfort! Ideally located in a desirable neighborhood adjacent to Lynn Woods and Nells Pond, this exceptional home offers over 6,500 sq. ft. of living space, distinctive architectural details, and versatile living options. A magnificent oak staircase, bamboo hardwood floors, crown molding, catwalk, and interior balconies create an impressive first impression. The spacious kitchen features a WOLF gas cooktop with ventilation, double ovens, touchless faucet, abundant cabinetry and counter space, a breakfast bar, separate island with seating for up to 12, and a coffee/serving station. The formal dining room showcases a glass chandelier and coordinating sconces. The grand family room features a freshly painted 30-foot vaulted ceiling, mother-of-pearl chandelier, gas fireplace, skylights, and spiral staircase. A brand-new Andersen slider opens to a new 300 sq. ft. composite deck. The sunroom offers a wall of windows and sliders leading to two connected decks. A second living room, full bathroom, and first-floor office complete the main level. Upstairs, the spacious primary suite offers vaulted ceilings, skylights, generous closet space, and a private bath with Jacuzzi tub and separate shower. Two additional bedrooms each feature window seats, double closets, private full bathrooms, and abundant natural light. The lower level offers flexible space with potential for an in-law suite, au pair accommodations, or ADU, subject to applicable approvals. Features include an additional bedroom, bathroom with stand-up shower, kitchenette, and ample storage. A two-car garage adds convenience with additional storage area and seasonal comfort with a heat/cooling exchange.Recent updates include a new roof, additional insulation, new central A/C unit, updated appliances and bathrooms, a new composite deck, and multiple replacement windows and doors.Enjoy exceptional space, distinctive design, flexible living arrangements, and a sought-after location near Lynn Woods and Nells Pond at 245 Judge Road!

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.

Dream Property, Unbeatable New Price: Now $1,299,000. Don't miss this luxurious enclave with year-round views! If you’ve been waiting for the perfect moment to buy, this is it. Every single corner of this estate is designed to jaw-drop. Here’s a quick tour of what’s waiting for you: the heart of the Home, a gourmet kitchen outfitted with SubZero refrigerator, Wolf gas range and microwave, Bosch dishwasher, instant hot on kitchen faucet, and sleek quartz countertops, flowing into a massive great room featuring a stunning stone fireplace and soaring vaulted ceilings. The Ultimate Primary Suite: A dreamy ensuite bathroom complete with a classic clawfoot tub situated perfectly to take in the stunning mountain views. Space to Live & Work: An elegant dining room, a spacious second bedroom, a second full bath, and a dedicated home office. A main-level laundry room equipped with its own elevator access to make moving between floors a breeze. The Bonus Levels: The Garage: Calling this a garage is an understatement—it’s a luxurious, immaculate space for your vehicles and toys. Lower Level Walk-Out: A giant second primary bedroom, a massive double-sized recreation room, a separate entry, and its own private deck with views. Perfect for an in-law suite or the ultimate guest quarters! Outdoor Paradise: Two Covered Decks: Positioned perfectly to capture those breathtaking, year-round mountain views. The Grounds: Custom landscaping, a built-in fire pit for chilly evenings, and a cozy outdoor sofa setup ready for entertaining. This is entirely turnkey. Every piece of high-end furniture, every extra, and every premium detail is included. The sellers are ready to move, the price has never been sweeter, and a luxury estate like this will not last at this newly reduced price.

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.

Under contract-accepting backup offers. Welcome to beautifully renovated coastal living at Mansions by the Sea on Sunset Beach. This stunning 6th-floor, 2-bedroom, 2-bath residence has been fully renovated throughout, offering 1,510 square feet of bright, open living space surrounded by incredible water views. Floor-to-ceiling windows and sliders fill the home with natural light and showcase panoramic views of the Gulf of Mexico and Intracoastal Waterway from the expansive wraparound balcony.

The renovation carries throughout the entire residence, including the kitchen, bathrooms, bedrooms and main living areas, creating a cohesive, modern coastal feel from room to room. The redesigned kitchen opens seamlessly to the living and dining areas and features quartz countertops, generous island seating, abundant cabinetry and stainless-steel appliances—ideal for both everyday living and entertaining. Updated flooring, lighting, fixtures and finishes continue throughout the home, while both bathrooms feature beautifully refreshed, modern designs. The spacious primary suite offers direct balcony access, water views and a renovated en-suite bath.

Mansions by the Sea offers resort-style living with direct beach access, a heated pool, fitness center, tennis and pickleball courts, clubhouse, saunas and more. Located on sought-after Sunset Beach with convenient access to local restaurants, shopping and all that Treasure Island and St. Pete have to offer. Move-in ready, beautifully finished and designed for effortless coastal living.

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!

Beautifully maintained three-family home ideally situated next to scenic Ronan Park. This spacious multi-family property offers generous living areas, front porches, rear decks, and a sizable backyard—a rare combination in the Dorchester market. Enjoy beautiful views of the park and water from the rear decks, adding to the property's unique appeal.Currently rented and offering strong income potential, this property presents an excellent opportunity for both investors and owner-occupants. Conveniently located near public transportation, neighborhood amenities, shopping, dining, and major routes. Well maintained and move-in ready, 52 Percival St is a fantastic opportunity to own a versatile multi-family property in a desirable Dorchester location.

Discover a truly special retreat on beautiful Lake Winnisquam, where privacy, tranquility, and waterfront living come together. Completely renovated from top to bottom, this thoughtfully updated island home offers a fresh, refined interior designed for effortless lake living. The kitchen and baths have been beautifully redone, while inviting living spaces and picturesque views create a warm and relaxing atmosphere throughout. Multiple rooms provide flexible accommodations and plenty of space for overnight guests, making it easy to host family and friends. Step outside onto the deck and take in sweeping lake views surrounded by the peaceful beauty of island life. Best of all, the property is just seconds by boat from the mainland and includes deeded mainland parking, offering exceptional convenience while preserving the privacy of an island retreat. Offered fully furnished and move-in ready, this is a rare opportunity to simply arrive, unpack, and begin enjoying life on Lake Winnisquam.
Neighboring property #6 Mohawk is also for sale. Owner financing may be an option!

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.

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!

Investment and development opportunity located directly in the path of growth in Butts County. This 5-acre parcel features nearly 300 feet of high-visibility road frontage along Highway 16 West, strategically positioned immediately adjacent to the rapidly expanding Riverpark development at the Interstate 75 interchange, making it an ideal candidate for strategic rezoning, future commercial expansion, or a private holding with long-term appreciation potential. Currently used as a recreational retreat, the property is largely undeveloped and ripe for vision. On-site improvements include an existing rustic structure with a functional loft-style apartment and a freestanding lean-to, providing immediate utility for weekend getaways or rental flexibility while future development plans take shape. Call for more information or to make arrangements to see the property in person. Appointment required.

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.

SIGNIFICANT PRICE REDUCTION Priced to sell. 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.

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.

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.

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.

Set-up for HORSES and with the FARMER in mind this property features 4.34 ACRES WITH RENOVATED FARMHOUSE, 80x200 INDOOR ARENA, 10 STALLS AND MULTIPLE OUTBUILDINGS. The early-1900s farmhouse was gutted to the studs in 2013. Extensive updating included windows, roof, siding, soffit, fascia, gutters, plumbing, electrical, spray foam insulation, drywall and kitchen. The owners preserved much of the home's character, including original brick chimneys, knot-free Southern Yellow Pine floors, built-in cabinets and five-panel doors. They created an open concept on the first floor between the kitchen, dining and living area making it easy to heat the home with the wood-burning stove. The main level also offers laundry, half bath and an office that could serve as a 4th bedroom. Upstairs are an oversized primary suite with jetted tub and separate shower, two additional bedrooms, full hall bath and loft/family room that could also be converted to another bedroom, if needed. The unfinished basement offers multiple rooms, floor drains, second laundry hookup. The 80x200 indoor arena was built in 2023 and features 16' sidewalls, sand footing, three rows of LED lighting and two 16x20 overhead doors capable of accommodating modern agricultural equipment. The adjoining 35x80 stall area includes six 10x10 stalls, each opening to its own 40' all-weather pipe-fenced run. Automatic geothermal waterers serve the stalls and runs. Additional amenities include an indoor wash rack, concrete aisle, hay loft with staircase and hay drops, plus a heated, insulated tack/feed/office area with sink and hot water. Outbuildings include the original 30x40 horse barn with 4 additional 10x10 stalls plus room for tack and feed storage, a 30x40 pole barn serves as an oversized 2-car garage and the corn crib provides substantial hay and shavings storage. Outside, the property offers a large grass pasture in front and additional perimeter turnout areas and flexible fence panels that can be reconfigured. A gated lean-to can function as two outdoor stalls or be opened for use as a run-in shelter. Three RV hookups provide additional flexibility for guests, and the large open parking area accommodates trucks, trailers and equipment while offering potential space for additional pasture or an outdoor arena. Multiple security cameras provide property-wide surveillance. Ask about the potential to rent 2 adjacent pastures and for the Additional Features Sheet on this property. Quiet country location with an easy drive to Ottawa for restaurants, shopping and conveniences.

Perched on one of Comanche Trace's premier estate lots, this exceptional custom home captures one of the community's most impressive panoramic Hill Country views. Designed by acclaimed architect Gustavo Arredondo and built by White Construction, the home blends timeless architecture, privacy, and a floor plan made for entertaining. Soaring ceilings, expansive living spaces, a formal dining room, gourmet kitchen, and private office with custom built-ins create an elegant yet comfortable atmosphere. The main-level primary suite opens to the backyard and features a spa-like bath, dual vanities, and generous walk-in closet. Upstairs, two private en-suite guest bedrooms share a second living area with wet bar and a covered view porch. A beautifully landscaped setting, inviting porches, oversized four-car garage with extensive cabinetry and half bath, and exceptional storage complete the home. Enjoy Comanche Trace walking trails, private Guadalupe River park, lake, and optional club amenities just minutes from Kerrville.

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.

5 ACRES (more available), 4 GREENHOUSES, POLE BARN, DAIRY BARN and FARMHOUSE on NATURAL GAS! Previously operated as a Greenhouse, this property is well-suited for commercial greenhouse operations, agricultural use, horticulture, or a rural business allowing multiple income-producing structures. At the core of the operation are two modern gutter-connect greenhouses, each measuring 42x96, offering over 8,000 square feet of controlled growing space. These greenhouses feature heat, passive and mechanical ventilation, drip irrigation and in-floor radiant heat in propagation areas, allowing for year-round production. The layout supports commercial plant production, floriculture, specialty crops, hydroponics, propagation, retail or conversion to alternative covered uses such as an event venue or equipment storage. The third greenhouse is a modern, double poly freestanding greenhouse measuring approximately 30x96 with a concrete floor, roof peak vent and roll-up and overhead drip irrigation. A fourth greenhouse, measuring approximately 30x70, is a single poly structure with a gravel floor, offering additional flexibility for seasonal growing or storage needs. A 16x42 office / head-house connects the greenhouse complex directly to the pole building, creating an efficient workflow between production, administration and storage. The 43x62 pole building has been freshly painted and features a combination of concrete and gravel flooring. It is well-suited for machinery storage, fleet vehicles, contractor operations, warehousing, fabrication or general commercial use tied to an on-site business. The dairy barn has been freshly painted in classic red and white and has been exceptionally maintained, highlighted by a beautiful hay loft with full staircase access and the original milking room at the front of the building. Two grain bins on the property are equipped with dryers, stirators and aeration floors, making them functional for grain, seed, feed or bulk material storage. The updated farmhouse offers four bedrooms, two-and-a-half bathrooms and a full unfinished basement. The country kitchen includes oak cabinetry, stainless steel appliances and table space, while the oversized family room features a stone accent wall with a fireplace. The primary bedroom and bathroom are located on the first floor. Recent updates include a newer roof, kitchen improvements, carpet, interior paint, exterior paint and landscaping. The home can serve as an owner-occupied residence, employee housing or office headquarters. An additional 35 acres and an extra residential building permit are available for an additional cost, offering expansion potential for farming, business growth or future development. Ask your agent for details. The combination of expandable acreage, multiple outbuildings, greenhouse infrastructure and grain storage creates a flexible live-work environment that can continue in greenhouse production, support a new agricultural or rural commercial venture, or be repurposed into storage, workshop, processing, ag-retail or equipment-based operations as business needs evolve. Taxes are based on 40 acres. Desired acreage will be split from larger parcel and new PIN # created.