My Company's Active Listings

$4,500,000 (USD)
Active

Brewerton Area Land

Active

8780 Brewerton Road Cicero, NY 13029

Bed
0 Baths
sqft
MLS# S1679895
Virtual Tour
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.
Listing by: NYS ALLIANCE / Listed By: George Tucci Jr., Century 21 North East
$3,100,000 (USD)
Active

St Petersburg Area Single Family Home

Active

600 Alda Way NE St Petersburg, FL 33704

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

Bryan Area Single Family Home

Active

4207 Tuscany Court Bryan, TX 77802

4 Bed
6 Baths
4508 sqft
MLS# 26009620
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.
Listing Courtesy of BRYAN -COLLEGE STATION / Listed By: Jamie Prejean, Century 21 Integra