My Company's Active Listings
$13,000,000 (USD)
Asylum Hill Area Multi-Family Home
Active
33-39 Sumner Street Hartford, CT 06105
10 Bed
5 Baths
33408 sqft
MLS# 24220542
OWN THE COLLECTION. UNLOCK THE POTENTIAL. An exceptional opportunity to establish a commanding multifamily footprint in Hartford's high-demand Asylum Hill rental market. Offered at $13M, The Asylum Hill Collection encompasses seven all-brick multifamily properties strategically concentrated along Sumner, Huntington, and Collins Streets. This distinctive 104-unit portfolio offers scale, architectural integrity, established income, and compelling long-term investment potential. The diverse residential mix includes 10 one-bedroom, 35 two-bedroom, 31 three-bedroom, 28 four-bedroom residences. Featuring condominium tax status, on-site parking, and spacious residential layouts, the collection presents opportunities for operational efficiencies, portfolio optimization, and future revenue growth. Ideally positioned near Aetna, The Hartford, Saint Francis Hospital, the Mark Twain House, Harriet Beecher Stowe Center, Bushnell Park, and Downtown Hartford. A rare opportunity for discerning investors seeking meaningful market presence, portfolio scale, and enduring wealth creation. Seven Buildings. Three Streets. One Extraordinary Investment Opportunity.
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$13,000,000 (USD)
New London Area Multi-Family Home
Active
35 Union Street New London, CT 06320
61 Bed
81 Baths
75075 sqft
MLS# 24184169
Rare opportunity to own The Crocker House, a landmark mixed-use investment property anchoring the corner of Union and State Streets in downtown New London. Originally constructed in 1872 as a five-story luxury hotel and thoughtfully maintained over the years, this iconic red-brick building offers three distinct income streams under one roof: 81 residential apartments (studios, one- and two-bedroom units), 7 ground-floor commercial spaces, and a beautifully restored Grand Ballroom. Recent improvements include updated kitchens, modern flooring, elevator service to all floors, and convenient on-site laundry facilities on every level. Select upper-floor apartments offer sweeping views of the Thames River and downtown harbor. Ideally situated just steps from Union Station (Amtrak and Shore Line East), the waterfront, and City Pier, the property is also minutes from General Dynamics Electric Boat, the U.S. Coast Guard Academy, Pfizer, and Connecticut College. Located within the historic downtown district of New London, The Crocker House represents a true trophy asset blending diversified income, long-term investment stability, and irreplaceable historic character in one of southeastern Connecticut's most recognizable buildings.
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$7,800,000 (USD)
Cape Coral Area Land
Active
1322 NE 12th Avenue Cape Coral, FL 33909
Bed
0 Baths
sqft
MLS# 2026015934
One of the last parcels in Cape Coral for a large development site that is left in Cape Coral. Over 24+/- acres off the main road nestled off Del Prado to the East and Diplomat Pkwy to the north in Northeast Cape Coral, distract allows up to 394 dwelling units, 16 dwelling per acre, connected to City Utilities!!!.*seller is offering ground lease as well.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Zak Yona, Century 21 Allpoints Realty
$5,555,000 (USD)
Hartford Area Commercial
Pending
32-48 Huntington Street Hartford, CT 06105
0 Bed
4 Baths
0 sqft
MLS# 24152316
VALUE-ADD OPPORTUNITY IN PRIME ASYLUM HILL LOCATION! Bring new life to these classic brick buildings-5 solid multifamily structures plus a vacant lot with gated, shared parking in the rear. Rarely does a portfolio of this scale and potential hit the market. Situated on a unified campus, this offering features a diverse unit mix ranging from studios to spacious 3-bedroom townhomes, many of which include 2 full bathrooms. Approximately 25-30 units have already been renovated with modern finishes, while the remaining units present significant upside for investors looking to add value. Additional highlights include laundry rooms in each building, an on-site office, updated electrical with subpanels in every unit, and numerous newer boilers and hot water heaters. Whether you're looking to reposition for long-term cash flow or a new value add project, this is a rare chance to acquire a substantial footprint in a rapidly developing urban market. Savvy investors-don't miss out!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$5,400,000 (USD)
Southington Area Land
Active
90 Welch Road Southington, CT 06489
Bed
0 Baths
0 sqft
MLS# 24176184
An exceptional opportunity for builders, developers, and investors to acquire approximately 23 acres in one of Southington's most rapidly growing locations. Situated within the R-40 residential zone, this expansive parcel offers outstanding potential of a luxury residential subdivision, custom home community, condominium project, or possible active adult 55+ development. The property features valuable road frontage on Welch Road with convenient access near West Pines Drive and Bagno Drive being surrounded by high-end established residential neighborhoods, creating an ideal setting for future development. The land offers a favorable topography with gentle elevation changes and strong accessibility for planning and infrastructure design. Existing ulitiies and nearby amenities further enhance the investment appeal of this rare offering. Conveniently located in sought after Southington near major highways, shopping dining, schools, and recreational amenities while still offering privacy and a picturesque natural setting. (This property is residential zoning but has been used as farmland and has large amounts of rich topsoil.)
Listing Courtesy of SMART MLS / Listed By: Paula Burton, Century 21 Allpoints Realty
$3,950,000 (USD)
Durham Area Farm
Active
148 &Amp 153 Wallingford Road Durham, CT 06422
Bed
0 Baths
0 sqft
MLS# 24015202
The Greenbacker Brookfield is one of the largest farms now on the Connecticut market with over 400 acres. It has been in operation for over 100 years and is ready now for a new multi-generation family to take the reins or for a progressive investor. There is ample accommodation with 7 houses that have 29 bedrooms for the family to share. (The average size farm in CT is approximately 80 acres). The current owners are using 4 houses and renting 3 other homes. The investor agriculture buyer may also generate rental income from the farm's other rental property; 1. a Two story 35x50 horse barn, 2.a 35x80 stable with 1.5 story horse stalls. 3 a. Barn with double row stalls and indoor riding arena, 4. a 4-bay garage, 5. Dairy barn, and Chicken coops, etc.. These items may also be considered depreciable property (see your tax advisor). Other sources of income from the farm would include renting land for; 1, growing crops (92 acres of cropland leased, currently), 2, Durham Fair parking. 3, pastureland (20 acres of pasture leased, currently), 4, hunt club (land leased currently), 5, equestrian rental (stable & indoor/outdoor riding, currently leased) and for dairy farming. Potential income may come from establishing a farm stand, growing grapes/ winery, Christmas tree sales, blue berries, and more. The State of Connecticut Conservation Restriction requires this property to be 'agriculture in nature' according to development rights the state acquired approximately 70 years ag
Listing Courtesy of SMART MLS / Listed By: Gary Dobratz, Century 21 Allpoints Realty
$3,495,000 (USD)
Miramar Beach Area Single Family Home
Active
28 Spyglass Drive Miramar Beach, FL 32550
6 Bed
5 Baths
4820 sqft
MLS# 1012238
COASTAL LUXURY BETWEEN DESTIN HARBOR & 30A, GULF VIEWS, NO HOA & NO FLOOD ZONE!
Experience the ultimate Emerald Coast lifestyle in this exceptional 4,820-SF remodeled beach estate, ideally positioned in a quiet neighborhood less than a quarter mile from the Gulf and perfectly situated between the vibrant energy of Destin Harbor and the iconic 30A corridor.
One of the property's most distinctive advantages is its elevation. Sitting at the highest elevation in the neighborhood and located in a NO FLOOD ZONE, this remarkable property offers added peace of mind rarely found this close to the Gulf with NO HOA, you have the freedom and flexibility to enjoy the property on your terms.
The three-story residence showcases impressive scale, sophistication, and relaxed coastal elegance, offering 6 bedrooms and 5 beautifully appointed bathrooms with generous living spaces and high-end finishes throughout.
On the third floor, the luxurious primary suite captures beautiful Gulf views, creating an exceptional private retreat where you can wake up to the shimmering waters of the Emerald Coast and unwind with breathtaking coastal vistas.
Outside, you're just minutes from the area's legendary sugar-white beaches and emerald-green waters. Spend your days enjoying the Gulf, boating and fishing from Destin Harbor, playing golf, exploring 30A, or taking advantage of the area's renowned dining, shopping, and entertainment. Rental PJ's up to $250K Whether you're seeking a luxury primary residence, second home, private beach retreat, or income-producing investment, this property offers an extraordinary combination of size, elevation, Gulf views, location, and flexibility.
High elevation. Gulf views. No flood zone. No HOA. Less than a quarter mile to the beach.
This is more than a coastal home--it's an exceptional Emerald Coast lifestyle and an investment in one of Florida's most coveted destinations.
Experience the ultimate Emerald Coast lifestyle in this exceptional 4,820-SF remodeled beach estate, ideally positioned in a quiet neighborhood less than a quarter mile from the Gulf and perfectly situated between the vibrant energy of Destin Harbor and the iconic 30A corridor.
One of the property's most distinctive advantages is its elevation. Sitting at the highest elevation in the neighborhood and located in a NO FLOOD ZONE, this remarkable property offers added peace of mind rarely found this close to the Gulf with NO HOA, you have the freedom and flexibility to enjoy the property on your terms.
The three-story residence showcases impressive scale, sophistication, and relaxed coastal elegance, offering 6 bedrooms and 5 beautifully appointed bathrooms with generous living spaces and high-end finishes throughout.
On the third floor, the luxurious primary suite captures beautiful Gulf views, creating an exceptional private retreat where you can wake up to the shimmering waters of the Emerald Coast and unwind with breathtaking coastal vistas.
Outside, you're just minutes from the area's legendary sugar-white beaches and emerald-green waters. Spend your days enjoying the Gulf, boating and fishing from Destin Harbor, playing golf, exploring 30A, or taking advantage of the area's renowned dining, shopping, and entertainment. Rental PJ's up to $250K Whether you're seeking a luxury primary residence, second home, private beach retreat, or income-producing investment, this property offers an extraordinary combination of size, elevation, Gulf views, location, and flexibility.
High elevation. Gulf views. No flood zone. No HOA. Less than a quarter mile to the beach.
This is more than a coastal home--it's an exceptional Emerald Coast lifestyle and an investment in one of Florida's most coveted destinations.
Listing Courtesy of EMERALD COAST / Listed By: Rhonda Johnson, Century 21 Allpoints Realty
$3,400,000 (USD)
Bloomfield Area Commercial
Active
51 Gabb Road Bloomfield, CT 06002
Bed
0 Baths
36099 sqft
MLS# 24209004
A truly one-of-a-kind opportunity in Bloomfield! Set at the end of a private drive on approximately 8.7 acres, 51 Gabb Road offers an extraordinary 36,100 SF institutional building plus a separate 2,286 SF single-family home. Formerly home to the Bess & Paul Sigel Hebrew Academy, this architecturally distinctive property is now vacant and ready for its next chapter. The expansive interior features flexible open floor plans, classrooms, offices, a full gymnasium, cafeteria and commercial kitchen, library, multiple restrooms, elevator access, and an unforgettable domed skylight/assembly space. Outside, enjoy a private, wooded setting with ample paved parking, open fields and room to envision something entirely new. Zoned R-20 and approved for institutional use, the property presents a range of possibilities-from continued educational, community, medical, recreational or faith-based use to adaptive reuse or potential residential redevelopment, subject to Town of Bloomfield approval. Ideally located just minutes from Bloomfield Avenue, adjacent to West Hartford and convenient to Hartford, I-84 and I-91. A property of this size, character, privacy and flexibility is rarely available in Central Connecticut-bring your vision!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$3,200,000 (USD)
Wethersfield Area Commercial
Active
30 Jordan Lane Wethersfield, CT 06109
Bed
0 Baths
31758 sqft
MLS# 24175635
Striking three-story brick office building set on a beautifully landscaped, established site in Wethersfield's professional corridor! Find presentable curb appeal with red brick, a dormered roofline, and mature plantings. Three floors served by elevator, with a sizable ~158-space parking lot. Substantially renovated and significantly upgraded, with over $1.1M of documented capital investment in building systems, common areas, a refreshed lobby, and a full medical-grade second-floor buildout. Two long-term tenants anchor the building today, a medical practice and a home-care services group, providing strong in-place income. Well-suited for an owner-user: a medical group, specialty practice, or professional firm can occupy anywhere from 5,000 to 18,000 SF while the in-place leases help carry the building. The available space is flexible, with a spacious first floor (~10,000 SF) subdivideable into multiple configurations, and a large, light-filled open-plan upper floor (~8,000 SF) that works as a single tenant's space or carved into smaller suites. The building is a natural fit for a range of medical specialties, as well as professional users. The established medical cluster a mile away on Silas Deane Highway reinforces the address for any healthcare user. Easy highway access is an advantage too, with I-91 less than a mile away and downtown Hartford a ten-minute drive. An excellent opportunity to own a substantially improved, income-producing professional address!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$3,000,000 (USD)
Hartford Area Commercial
Active
11 Charter Oak Place Hartford, CT 06106
0 Bed
0 Baths
0 sqft
MLS# 24219881
A 1.93-acre campus redevelopment opportunity in one of Hartford's most historic neighborhoods, just a short walk to downtown, major employers, and cultural attractions. The site includes the former St. Peter's School, the adjacent convent at 11 Charter Oak Place, and the church, with potential for 65 residential units across the two buildings. Built in 1913, the 56,296 SF brownstone school has received Hartford Historic Preservation Commission approval for adaptive reuse as residential. Architect's concept plans lay out 49 units: 38 studios, 4 one-bedrooms, 5 two-bedrooms, and 2 three-bedroom lofts, plus a laundry facility and unit storage. The former convent, in the Charter Oak Place Historic District, also has Historic Preservation Commission approval for residential conversion. City-reviewed plans show 16 units: seven studios (438 SF), eight one-bedrooms (582 SF), and one two-bedroom (860 SF). The church invites buyers to bring their creativity, with potential to become a community gathering place, event venue, or another use that complements the residential campus. The local rental market supports strong pricing. Nearby studios rent for $1,300 to $1,380, new one-bedrooms achieve $1,650, and two-bedrooms command about $1,800.. Zoned MX-2. Historic approvals, concept plans, and a planning status letter are available to qualified buyers. Can be purchased as a package at a discount with 20 Clifford St and 273 Asylum
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$2,995,000 (USD)
Aqua Area Condominium
Active
13675 Vanderbilt Drive 406 Naples, FL 34110
4 Bed
4 Baths
3590 sqft
MLS# 2026012623
Experience elevated coastal living at AQUA at Pelican Isle, one of North Naples’ most exclusive luxury waterfront towers. This spacious 3,590 sq. ft. residence offers a rare opportunity to own a beautifully designed, Gulf-facing condominium positioned to capture sweeping views of the marina, mangroves, and the Gulf beyond—without overlooking parking areas or close neighboring buildings.
Designed with a desirable front-to-back floor plan, the residence features two expansive balconies that invite seamless indoor-outdoor living. Start your mornings overlooking vibrant landscape over the newly manicured Kinsale Golf course and end each evening with spectacular Gulf sunsets and afterglows from your private balcony overlooking a peaceful yacht harbor. Dolphins, manatees, and passing boats create a constantly changing waterfront backdrop.
Originally built as a model residence by the renowned Antonacci Design Group, this home showcases refined contemporary coastal design with luxury finishes and architectural details throughout. The residence includes 4 bedrooms plus a den, 4 full bathrooms, and two secured garage parking spaces, and is offered furnished, making it ideal for a seasonal resident seeking a move-in-ready Naples retreat.
A private elevator vestibule entry welcomes you into a sophisticated interior highlighted by elegant wood flooring, custom Italian cabinetry, and thoughtfully curated design elements that blend comfort with luxury.
Residents of AQUA enjoy the privacy of a low-density luxury tower combined with an exceptional collection of resort-style amenities. The community features a private marina with boat slips, cabanas, and direct Gulf access, along with kayaks for exploring the surrounding waterways. Additional amenities include a concierge attended lobby with 24/7 security, fitness center with sauna and steam rooms, theater, billiards lounge with golf simulator and bar, two grand social rooms, and beautifully designed outdoor gathering spaces.
Outdoors, enjoy the resort-style pool and spa areas, grills stations, marina pavilion, fire pits, and a Sky Lounge—perfect for entertaining or simply relaxing while taking in the waterfront setting. AQUA is also pet-friendly with dedicated dog park areas.
For those seeking an elevated club lifestyle, optional memberships are available next door at Pelican Isle Yacht Club, offering waterfront dining, tennis, pickleball, instructed fitness, and a shuttle boat to the beach. Golf enthusiasts may also consider opportunities at the newly opened Kinsale Golf Club, an exclusive course for 250 members.
Combining expansive living space, breathtaking waterfront views, and one of Naples’ most refined amenity offerings, this residence delivers a truly exceptional luxury coastal lifestyle in North Naples. Virtual renderings are included with photos.
Designed with a desirable front-to-back floor plan, the residence features two expansive balconies that invite seamless indoor-outdoor living. Start your mornings overlooking vibrant landscape over the newly manicured Kinsale Golf course and end each evening with spectacular Gulf sunsets and afterglows from your private balcony overlooking a peaceful yacht harbor. Dolphins, manatees, and passing boats create a constantly changing waterfront backdrop.
Originally built as a model residence by the renowned Antonacci Design Group, this home showcases refined contemporary coastal design with luxury finishes and architectural details throughout. The residence includes 4 bedrooms plus a den, 4 full bathrooms, and two secured garage parking spaces, and is offered furnished, making it ideal for a seasonal resident seeking a move-in-ready Naples retreat.
A private elevator vestibule entry welcomes you into a sophisticated interior highlighted by elegant wood flooring, custom Italian cabinetry, and thoughtfully curated design elements that blend comfort with luxury.
Residents of AQUA enjoy the privacy of a low-density luxury tower combined with an exceptional collection of resort-style amenities. The community features a private marina with boat slips, cabanas, and direct Gulf access, along with kayaks for exploring the surrounding waterways. Additional amenities include a concierge attended lobby with 24/7 security, fitness center with sauna and steam rooms, theater, billiards lounge with golf simulator and bar, two grand social rooms, and beautifully designed outdoor gathering spaces.
Outdoors, enjoy the resort-style pool and spa areas, grills stations, marina pavilion, fire pits, and a Sky Lounge—perfect for entertaining or simply relaxing while taking in the waterfront setting. AQUA is also pet-friendly with dedicated dog park areas.
For those seeking an elevated club lifestyle, optional memberships are available next door at Pelican Isle Yacht Club, offering waterfront dining, tennis, pickleball, instructed fitness, and a shuttle boat to the beach. Golf enthusiasts may also consider opportunities at the newly opened Kinsale Golf Club, an exclusive course for 250 members.
Combining expansive living space, breathtaking waterfront views, and one of Naples’ most refined amenity offerings, this residence delivers a truly exceptional luxury coastal lifestyle in North Naples. Virtual renderings are included with photos.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Miranda Pitts, Century 21 Allpoints Realty
$2,950,000 (USD)
New Canaan Area Commercial
Active
93 Cherry Street G1, G2, H1 &Amp H2 New Canaan, CT 06840
0 Bed
1 Baths
3200 sqft
MLS# 24186112
Rare investment & owner-user opportunity on the market in the heart of downtown New Canaan. 93 Cherry St. is an approx. 3,200sqft commercial property strategically positioned in one of Fairfield County's most desirable & supply-constrained markets. Well-maintained asset brings immediate income, long-term flexibility & exceptional value for investors, professional users & developers seeking a premier downtown location. Property Highlights*Prime downtown New Canaan location w/exceptional walkability & visibility*Private 12-space paved off-street parking lot & w/non-metered on-street parking-a significant competitive advantage in the downtown core*Strong in-place leases providing immediate cash flow & investment stability*Flexible Business A (BUSA) zoning*Potential for expansion or adaptive reuse, subject to zoning approvals & investor research diligence*Well-maintained office space w/minimal anticipated near-term capital expenditures*Attractive opportunity for investors, medical users, professional office occupants & mixed-use developers*Recent commercial sales in the surrounding area continue to demonstrate strong demand for boutique assets in downtown New Canaan, particularly properties that combine private parking, stable tenancy & future redevelopment potential. Historically limited inventory & significant barriers to entry, 93 Cherry St presents a compelling opportunity to acquire a high-quality commercial asset in one of Connecticut's most sought-after downtown markets
Listing Courtesy of SMART MLS / Listed By: Bob Virgulak, Century 21 Allpoints Realty
$2,900,000 (USD)
Guilford Area Single Family Home
Active
57 Faulkner Drive Guilford, CT 06437
3 Bed
3 Baths
2891 sqft
MLS# 24071370
Custom built with exceptional craftsmanship and attention to detail, this stunning coastal-area estate sits on one of the largest properties in the neighborhood with water views from every room, three separate deeds totaling approximately two acres, including two separate waterfront lots, with one being the perfect site for your future docking needs. Designed for both luxury and comfort, the home features radiant heated floors on all three levels, 9-foot ceilings, extensive crown molding, custom transom windows, surround sound, intercom system, whole-house generator, and fully insulated walls throughout. The chef's kitchen is equipped with Uba Tuba granite, custom cabinetry, Viking 6-burner cooktop, full-size double Wolf ovens, dual dishwashers, and premium finishes throughout. The main-level primary suite offers tray ceilings, oversized accessible doorways, spa-like bath, walk-in closet, and private safes. Additional highlights include a heated 3-car garage, walk-out lower level with future finishing potential, multiple office/flex spaces, custom built-ins, outdoor rain shower and fire pit seating area. Enjoy nearby private beach association access at Tuttle's Beach, completing this rare luxury offering.
Listing Courtesy of SMART MLS / Listed By: Janet Colello, Century 21 Allpoints Realty
$2,800,000 (USD)
Durham Center Area Single Family Home
Active
153 Wallingford Road Durham, CT 06422
15 Bed
8 Baths
2741 sqft
MLS# 24045388
This unique farm complex is comprised of an equestrian area for 40 horses +, 5 residential houses and more. It has been in operation for over 100 years and is ready for new multi-generation owners to take the reins or for a progressive investor. There is nearly 280 acres of outstanding land, a pond, pastureland, rolling hills, stalls for 40+ horses and much more. There is, also, an outstanding mix of 5 houses that have 22 bedrooms for the families to share. The current owners are using 2 houses and renting 3 other homes. The investor may generate rental income from the farm's 5 residential homes and 1. a Two story 35x50 horse barn, 2.a 35x80 stable with 1.5 story horse stalls. 3 a Barn with double row stalls, 4. a 4-bay garage, etc.. These items may also be considered depreciable property (see your tax advisor). Other sources of income from the farm would include leases for pasture land and equestrian rental of the stable & indoor/outdoor riding, which is currently leased). Potential income may come from establishing a farm stand, growing grapes/ winery, Christmas tree sales, blue berries, and more The State of Connecticut Conservation Restriction requires this property to be 'agriculture in nature' according to development rights the state acquired approximately 70 years ago. both parcel MUST be sold together.
Listing Courtesy of SMART MLS / Listed By: Gary Dobratz, Century 21 Allpoints Realty
$2,800,000 (USD)
Barry Square Area Commercial
Active
20 Clifford Street Hartford, CT 06114
Bed
0 Baths
60786 sqft
MLS# 24220135
Approved plans are in hand to transform the former St. Augustine School into 65 residential units in Hartford's South End. The City of Hartford approved the site plan in December 2023, and the approval runs through December 2028. The plans call for 23 studios ($1,300), 37 one-bedrooms ($1,650), and 5 two-bedrooms ($1,800), made possible in part by a new third-floor addition above the former gym wing. Thoughtful amenities include a fitness center, bike storage, and in-unit washer/dryers shown throughout the plans, plus a new accessible entry ramp. The classic brick exterior is designed to be preserved and restored, with all-new windows that keep the building's historic character while adding modern efficiency. Zoned MX-2. Architectural plans by URFORM and a detailed renovation budget are available to qualified buyers. A rare chance to turn a neighborhood landmark into a substantial income-producing property.
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$2,700,000 (USD)
Hartford Area Commercial
Active
273 Asylum Street Hartford, CT 06103
Bed
0 Baths
35277 sqft
MLS# 24219840
Approvals are in place for this standout downtown Hartford redevelopment. The former high school site is set for 50 residential units, with 22 studios, 11 studio-plus layouts, and 17 one-bedrooms, a mix built for today's urban renter. Projected market rents of $1,400+ for studios and $1,700+ for one-bedrooms point to strong income potential. In addition to buildings designated parking, a nearby parking area may also be available, a valuable amenity for future residents. The walkability is hard to beat: steps to PeoplesBank Arena, two blocks to Bushnell Park and City Place, and an easy stroll to TheaterWorks, Black-Eyed Sally's, Agave, Max Downtown, and more of downtown's dining and entertainment. Quick access to I-91, I-84, and Route 2 keeps residents connected to the region. Bring your vision to one of Hartford's most compelling development opportunities. Can be purchased as a package at discounted price with 20 Clifford St & 11 Charter Oak Place
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$2,685,000 (USD)
Freeport Area Land
Active
830 Four Mile Road Freeport, FL 32439
Bed
0 Baths
sqft
MLS# 1004690
Exceptional residential development opportunity in the rapidly expanding Freeport market. This ±32.23-acre assemblage consists of six contiguous parcels strategically positioned just south of Highway 20 with access from Tucker Town Road and convenient connectivity to Highway 83A and the greater Walton County growth corridor.
The property offers significant potential for a townhome or build-to-rent residential community, with conceptual density projections supporting approximately 135 to 200+ units, subject to engineering, rezoning, and governmental approvals. The site's scale and configuration provide flexibility for clustered residential planning, internal road networks, stormwater design, preserved natural areas, and community amenities.
Freeport continues to experience strong residential growth driven by the expansion of South Walton and the Emerald Coast workforce housing market. Demand for attainable attached residential product remains high as buyers and renters seek convenient access to Santa Rosa Beach, Destin, and the Highway 98 corridor while benefiting from Freeport's continued infrastructure and commercial growth.
This offering presents a rare opportunity for developers, builders, and build-to-rent operators to secure a large-scale residential land position within one of Northwest Florida's fastest-growing submarkets. Buyer to verify all information, dimensions, density, utilities, and development feasibility. Buyer to verify data for its own use. All information is believed to be accurate but is not guaranteed. Prospective buyers are responsible for independently verifying all information and determining the property's suitability for their intended use. All final terms are subject to negotiation and shall be set forth in a fully executed sales agreement between the parties.
The property offers significant potential for a townhome or build-to-rent residential community, with conceptual density projections supporting approximately 135 to 200+ units, subject to engineering, rezoning, and governmental approvals. The site's scale and configuration provide flexibility for clustered residential planning, internal road networks, stormwater design, preserved natural areas, and community amenities.
Freeport continues to experience strong residential growth driven by the expansion of South Walton and the Emerald Coast workforce housing market. Demand for attainable attached residential product remains high as buyers and renters seek convenient access to Santa Rosa Beach, Destin, and the Highway 98 corridor while benefiting from Freeport's continued infrastructure and commercial growth.
This offering presents a rare opportunity for developers, builders, and build-to-rent operators to secure a large-scale residential land position within one of Northwest Florida's fastest-growing submarkets. Buyer to verify all information, dimensions, density, utilities, and development feasibility. Buyer to verify data for its own use. All information is believed to be accurate but is not guaranteed. Prospective buyers are responsible for independently verifying all information and determining the property's suitability for their intended use. All final terms are subject to negotiation and shall be set forth in a fully executed sales agreement between the parties.
Listing Courtesy of EMERALD COAST / Listed By: Jim Ball, Century 21 Allpoints Realty
$2,599,000 (USD)
Destin Area Single Family Home
Active
514 Vera Cruz Drive Destin, FL 32541
6 Bed
6 Baths
3750 sqft
MLS# 1010454
Experience the ultimate Destin lifestyle from this exceptional canal-front beach home in the highly desirable community of Holiday Isle. Spend your mornings enjoying Gulf views, or boating to Crab Island and your evenings relaxing after a day on the water. The property offers 90 ft of deep-water canal frontage and two covered boat slips with lifts, making it easy to enjoy everything Destin's boating lifestyle has to offer. Designed for effortless coastal living, the home features a fully covered and enclosed outdoor entertainment area ideal for gathering with family and friends and enjoying coastal breezes. The property includes two separate living spaces: the second-level main residence and a third-level lockout. Each has its own private entrance and can be enjoyed together or independently, offering flexibility for extended family, guests or vacation-rental opportunities. The main residence features four spacious bedrooms, four full bathrooms, an expansive living area, a gourmet kitchen with breakfast bar and a private office. The third-level lockout offers two additional bedrooms, two full bathrooms, a large living area and fully equipped kitchen with breakfast bar. The lower-level space offers room for storing beach gear, paddleboards, fishing gear and boating supplies, workshop. The private beach access is a very short walk away, while Crab Island and Gulf of Mexico are 15 minutes away by boat. This one-of-a-kind property captures the very best of the Destin lifestyle!
Listing Courtesy of EMERALD COAST / Listed By: Ken Koger, Century 21 Allpoints Realty
$2,595,000 (USD)
Esplanade By The Islands Area Single Family Home
Active
15388 Motta Way Naples, FL 34114
4 Bed
6 Baths
4825 sqft
MLS# 226029991
MOTIVATED SELLER!! You have been patiently waiting for this listing! This Beacon model comes with all the bells and whistles and is located within a few minutes’ walk to the Amenity Campus. Location is everything! Water view with privacy landscaping and an expansive outdoor covered screened lanai to include a custom outdoor kitchen, pool, hot-tub spa and custom gas fireplace. Amazing SW sun exposure all day long. This is an entertainer's dream home! The home is presented fully furnished with an over sized garage to include a car lift for your fourth car. No worries, a generator has been installed for peace of mind. From the minute you walk in the foyer the main living space shines bright with an expansive living area with a built-in fireplace and wall shelves. As you enjoy your favorite media while you prepare meals in your gourmet kitchen which includes high-end Monogram appliances, quartz counter tops, upgraded cabinetry, dining area and a walk-in pantry. Enjoy your formal dining room when entertaining. The study has French doors to provide privacy. The master suite offers pure privacy with a soaking bath, over sized walk-in shower and two walk-in closets. On the first floor there are two en-suite bedrooms, a powder room and a very generous sized laundry room. This home has one of the most sought-after upgrades in the Beacon Model-The Bonus Room adjacent to the lanai. Wait there is more! The expansive upstairs offers a spacious living area to include a separate bedroom with en-suite bath and an additional powder shower. The kitchen includes a microwave, fridge, sink and plenty of cabinets. Perfect for visiting family and friends. Or a live-in that provides privacy for all.
The community Esplanade by the Islands offers an Amenity Campus that mirrors a five-star resort to include a resort style zero-entry pool and hot-tub spa with complimentary towel service, five tennis courts, eight pickle ball courts, four bocce courts with endless opportunities to participate in classes, competitive play and social events. The Wellness Center includes a full-service spa and salon, wellness programs, State-of-the-Art 24-hour fitness center with movement studio and group fitness. After your workout, enjoy your favorite morning fix at the Toasted café. The Bahama Bar located next to the resort pool offers lunch, dinner and pool service while you lounge at the pool. The expansive bar provides TVs to gather with neighbors while you cheer on your favorite sports team! A covered outdoor lanai lounge area with a custom fire pit and TV. The Venue is the most recent addition which offers a pool table, ping pong table, outdoor lawn for corn hole and a full-service kitchen and bar area to include a multi-purpose room. The highly anticipated 15,000 square foot Culinary Center will be opening soon! Esplanade by the Islands is conveniently located just minutes from Marco Island and Naples Famous Fifth Avenue beaches, shopping, fine dining and so much more!!
The community Esplanade by the Islands offers an Amenity Campus that mirrors a five-star resort to include a resort style zero-entry pool and hot-tub spa with complimentary towel service, five tennis courts, eight pickle ball courts, four bocce courts with endless opportunities to participate in classes, competitive play and social events. The Wellness Center includes a full-service spa and salon, wellness programs, State-of-the-Art 24-hour fitness center with movement studio and group fitness. After your workout, enjoy your favorite morning fix at the Toasted café. The Bahama Bar located next to the resort pool offers lunch, dinner and pool service while you lounge at the pool. The expansive bar provides TVs to gather with neighbors while you cheer on your favorite sports team! A covered outdoor lanai lounge area with a custom fire pit and TV. The Venue is the most recent addition which offers a pool table, ping pong table, outdoor lawn for corn hole and a full-service kitchen and bar area to include a multi-purpose room. The highly anticipated 15,000 square foot Culinary Center will be opening soon! Esplanade by the Islands is conveniently located just minutes from Marco Island and Naples Famous Fifth Avenue beaches, shopping, fine dining and so much more!!
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Richard "Rich" Kasparian, Century 21 Allpoints Realty
$2,550,000 (USD)
Rocky Hill Area Commercial
Active
1930 Silas Deane Highway Rocky Hill, CT 06067
Bed
0 Baths
35705 sqft
MLS# 24158439
1930 Silas Deane Highway presents a rare opportunity to acquire a large-scale commercial property located along one of Central Connecticut's most active retail corridors. The property consists of a 35,705 square foot commercial building situated on approximately 1.40 acres with direct frontage on the highly traveled Silas Deane Highway in Rocky Hill, Connecticut. Originally constructed in 1965 with steel construction and masonry exterior, the building most recently operated as an American Freight retail and warehouse facility. The current layout provides a versatile mix of retail showroom, warehouse/distribution space, and second-floor office or showroom areas, making the property suitable for a variety of commercial, industrial, or redevelopment uses. The ground floor features approximately 16,000 square feet of retail/showroom space positioned along the front of the building with strong visibility and signage potential along Silas Deane Highway. The rear of the building contains approximately 12,000 square feet of warehouse and storage space with approximately 20-foot ceiling heights, ideal for distribution, storage, logistics, or light industrial use. A second-floor mezzanine level of approximately 7,000 square feet provides additional office, showroom, or storage capacity. The warehouse portion is serviced by a loading dock and three 10-foot overhead doors, allowing efficient truck access and operational flexibility. The site includes a large paved parking area.
Listing Courtesy of SMART MLS / Listed By: Tyler DeVecchis, Century 21 Allpoints Realty
$2,392,500 (USD)
Santa Rosa Beach Area Land
Active
Tract I Sandgrass Blvd Boulevard Santa Rosa Beach, FL 32459
Bed
0 Baths
sqft
MLS# 968983
Truly PRIVATE 30A ESTATE LOT or ...Once, in a lifetime DEVELOPMENT OPPORTUNITY in the pristinely beautiful NatureWalk Community Development District. LOCATED IN THE HEART OF SEAGROVE BEACH. This would also make an amazing PRIVATE ESTATE Parcel is NOT part of the HOA and are zoned mixed use/ multi family. Previous development order for townhomes was approved in Walton County, but will need renewing. Tract I is 2.63 acres Close to beach access at San Juan. https://www.flexmls.com/share/DX8G0/107-Mosaic-Oaks-Circle-Santa-Rosa-Beach-FL-32459 Properties would also make great Beach Estate Homesites. Sellers may consider separating out parcels. Price includes all CDD fees paid.
Listing Courtesy of EMERALD COAST / Listed By: Victoria Hughes, Century 21 Allpoints Realty
$2,375,000 (USD)
Hebron Area Commercial
Active
14-16 Main Street Hebron, CT 06248
Bed
0 Baths
5483 sqft
MLS# 24195914
THIS LISTING IS AN OFFERING OF THE REAL PROPERTY AND SITE IMPROVEMENTS KNOWN AS 14-16 Main Street, Hebron CT ONLY. NO PART OF THE FLOUR GIRL BAKERY, LLC, OPERATIONS BUSINESS, OR THEIR LEASHOLD FIXTURES IN MADE A PART OF THIS OFFERING. This is a mixed use commercial and residential use complex consisting of 3 Free Standing Buildings with 3 Commercially lease space occupied by of the Flour Girl Bakery, Floor Girl Restaurant, and an Event/Function Space. The balance of the leased spaces consists of 4 Residential Apartment 1 and 2 BR Units. This incredible complex situated in the Hebron Green District has become the heart of "Hebron Center"! The location in the heart of HG district with its "billboard" visibility and high traffic count has a constant vibrant flow of daily visitors to amazingly planned combination of restored antique and new build post and beam structures! Renovations and New Construction undertaken in the Period of 2021 to Late 2025 offers genuinely well planned modern space with newer mechanicals serviced by public water, public sewer, and natural gas! Great site access by pedestrians from a grid work of public sidewalks with plenty of parking from both on-site and shared proximal public parking areas.
Listing Courtesy of SMART MLS / Listed By: James "Jim" Celio, Century 21 Allpoints Realty
$2,295,000 (USD)
Stamford Area Commercial
Active
526 Newfield Avenue Stamford, CT 06905
0 Bed
1 Baths
5427 sqft
MLS# 24193395
Rare opportunity to acquire a fully leased, 5,427sqft income-producing medical office building situated in one of Stamford's most established commercial corridors. Held under continuous ownership since 1989, the property provides investors immediate cash flow, long-term lease stability, scheduled rental increases & minimal management responsibilities through its favorable lease structure. Prime location, strong tenant roster & well-maintained footprint, this property appeals equally to passive investors seeking reliable returns & medical owner-users looking for long-term value. Property & Investment Highlights | *Tenant Roster: Fully occupied by 3 established medical & professional service tenants: Optician (Vision Care), Dentist & Chiropractor. *Building Size & Layout: Approximately 4,950 sq. ft. of income-producing medical office space. Note: Building features slab/grade construction with no basement space. *Parking & Land: Includes 22 total parking spaces (21 main spaces, plus 1 additional space located on the 13'1" parcel along the north side of the building on Newfield Ave). *Walk-Up Attic Storage: Features a large walk-up attic w/center ceiling heights reaching 12 feet. It provides dedicated, designated storage areas for all 3 tenants: Dental & Chiropractic Storage: ~12' 15' per space. Vision Care Storage: Double-sized storage area (~24' 15'). *Financial Stability: Immediate cash flow generated by a resilient, medical-focused tenant mix w/structured rental increases
Listing Courtesy of SMART MLS / Listed By: Bob Virgulak, Century 21 Allpoints Realty
$2,245,000 (USD)
Golden Gate Estates Area Single Family Home
Active
840 Jung Boulevard W Naples, FL 34120
4 Bed
3 Baths
3017 sqft
MLS# 226035554
Rare 8+ Acre Estate | Not in a Flood Zone | Golden Gate Estates – Naples A truly unique opportunity to own over 8 acres in Naples with a fully improved private estate offering space, privacy, and exceptional functionality. Fully fenced and gated, the property features three separate access points, including entry from two different streets, allowing for flexible use, privacy, and efficient circulation—an uncommon and valuable feature in Golden Gate Estates. The main residence offers over 3,000 sq. ft. with 4 bedrooms plus a den and 3 full bathrooms, showcasing Jerusalem stone flooring, plantation shutters, solid wood interior doors, and a fully upgraded kitchen with gas appliances, electric oven, and steam oven. Multiple recent system upgrades provide comfort and peace of mind, including a fully updated electrical system, whole-home reverse osmosis water system, and emergency backup generator. Designed for durability and storm readiness, the home includes hurricane impact-rated doors and additional protection. Outdoor living is enhanced by a saltwater pool with gas heater, ideal for year-round enjoyment. Additional improvements include a detached air-conditioned gym garage, dedicated camper hookup, and a canal-fed irrigation system that keeps the grounds green year-round—ideal for gardening, a nursery, or maintaining open acreage. Not located in a flood zone and conveniently positioned just minutes from Immokalee Road and Vanderbilt Beach Road, this property offers the freedom of estate living with close proximity to shopping, dining, and everyday conveniences. Properties of this size, condition, and infrastructure in Naples are exceptionally rare. Schedule your private showing today.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Rolando Abin Sanabria, Century 21 Allpoints Realty
$2,190,000 (USD)
Madison Area Single Family Home
Active
15 Highland Terrace Madison, CT 06443
5 Bed
3 Baths
1614 sqft
MLS# 24191331
COME EXPERIENCE THIS ONE-OF-A-KIND, FULLY RENOVATED MADISON HOME ON A RARE DOUBLE LOT WITH PRIVATE BEACH RIGHTS! Just 300 feet from the sandy shoreline, this exceptional home has been completely reimagined from a traditional raised ranch into a stunning elevated ranch with a bright, open-concept floor plan designed for modern living and effortless entertaining. Every detail has been thoughtfully curated to blend contemporary elegance with coastal charm. The main level features a spectacular chef's kitchen anchored by a nearly 10-foot white quartz island, premium appliances, and exceptional finishes. Two driveways provide ample parking, while two sets of washers and dryers offer added convenience. Multiple living spaces are bathed in natural light, including a breathtaking sunroom with brand-new oversized Marvin picture windows framing serene views toward Long Island Sound. A spacious hallway leads to a beautifully renovated full bath, a conveniently located laundry area, and the luxurious primary suite. Originally two bedrooms, this private retreat now offers a remarkable 9' x 12' walk-in closet and a spa-inspired ensuite featuring a double vanity, dual rain showers, and built-in shower benches. The finished lower level includes three generously sized bedrooms, a beautifully renovated full bath with a double vanity, a second brand-new washer and dryer, and an expansive family room, providing flexible space for guests, recreation, or relaxing after a day at the beach!
Listing Courtesy of SMART MLS / Listed By: John Cronin, Century 21 Allpoints Realty
$2,179,900 (USD)
No Named Subdivision Area Multi-Family Home
Active
5237 Thomas Drive A & B Panama City, FL 32408
10 Bed
10 Baths
5156 sqft
MLS# 791806
This brand-new, purpose-built vacation rental duplex on Thomas Drive is a rare turnkey investment opportunity in one of Panama City Beach's most desirable corridors -- and it's priced below appraised value. Constructed to the highest standards and designed from the ground up to maximize rental income, this fully furnished and professionally decorated property is ready to perform from day one.
Each side of the duplex features 5 bedrooms, 4 full baths, and 1 half bath across three thoughtfully designed floors. The first floor welcomes guests with a stylish living area, a sleek modern kitchen, and a back porch patio opening to a meticulously paved private backyard. There, each unit has its own in-ground saltwater pool with a natural gas heater and remote control -- a premium amenity that drives top rental rates and keeps bookings strong throughout the season. The oversized lot is fully fenced, with a privacy divider between each side giving guests their own secluded retreat.
Head upstairs to find a large master suite with an immaculate en-suite bath, two additional guest bedrooms -- one featuring built-in bunk beds perfect for families -- plus a dedicated laundry room, ample storage, and luggage areas on every level. The third floor crowns the property with another spacious master bedroom and en-suite bath, plus an additional guest room. Step out onto the large balcony and take in panoramic Gulf views while grilling on the built-in natural gas grill -- the ultimate beach party space for guests who want to entertain in style.
The property is fully furnished and decorated by two leading designers, turnkey for short or long-term rental operations. A full fire suppression system reflects the level of quality and attention to detail that sets this build apart from anything else at this price point.
Situated just moments from pristine white sandy beaches, St. Andrews State Park, and a variety of renowned restaurants and shopping, this property delivers the location, amenities, and income potential that serious investors are looking for. The second you walk in this one, you can feel the quality of the build and the materials used, this property is truly a must see to appreciate!!!
Buyer to verify all square footage, zoning, and rental regulations. All information deemed reliable but not guaranteed.
Each side of the duplex features 5 bedrooms, 4 full baths, and 1 half bath across three thoughtfully designed floors. The first floor welcomes guests with a stylish living area, a sleek modern kitchen, and a back porch patio opening to a meticulously paved private backyard. There, each unit has its own in-ground saltwater pool with a natural gas heater and remote control -- a premium amenity that drives top rental rates and keeps bookings strong throughout the season. The oversized lot is fully fenced, with a privacy divider between each side giving guests their own secluded retreat.
Head upstairs to find a large master suite with an immaculate en-suite bath, two additional guest bedrooms -- one featuring built-in bunk beds perfect for families -- plus a dedicated laundry room, ample storage, and luggage areas on every level. The third floor crowns the property with another spacious master bedroom and en-suite bath, plus an additional guest room. Step out onto the large balcony and take in panoramic Gulf views while grilling on the built-in natural gas grill -- the ultimate beach party space for guests who want to entertain in style.
The property is fully furnished and decorated by two leading designers, turnkey for short or long-term rental operations. A full fire suppression system reflects the level of quality and attention to detail that sets this build apart from anything else at this price point.
Situated just moments from pristine white sandy beaches, St. Andrews State Park, and a variety of renowned restaurants and shopping, this property delivers the location, amenities, and income potential that serious investors are looking for. The second you walk in this one, you can feel the quality of the build and the materials used, this property is truly a must see to appreciate!!!
Buyer to verify all square footage, zoning, and rental regulations. All information deemed reliable but not guaranteed.
Listing Courtesy of CENTRAL PANHANDLE / Listed By: Chris Jennings, Century 21 Allpoints Realty
$2,100,000 (USD)
South Windsor Area Commercial
Active
1170 Ellington Road South Windsor, CT 06074
0 Bed
0 Baths
11692 sqft
MLS# 24177394
Welcome to 1170 Ellington Rd - this architecturally distinctive Gambrel-style office building sits on a beautifully landscaped site in an established South Windsor corridor! Red brick, white dormers, and a gabled front entry give the property great curb appeal. Two stories of well-maintained Class B office space sit behind a generous parking lot with frontage on Ellington Road, proximate to I-291, I-84, and Bradley International Airport. A portion of the building (~51%), well-suited for a variety of educational, social services, and professional uses, is in the process of being leased to the South Windsor Board of Education - a creditworthy municipal anchor. The remainder is remarkably configurable: open spans that can be carved into smaller professional suites or kept as larger spaces. That flexibility opens the door to an unusually wide range of uses - a private school, early-childhood center, or district administrative offices; a cluster of medical, therapy, or counseling practices; a fitness, dance, or yoga studio; a martial arts academy; a worship space; or a polished headquarters office for an operator working within the region's logistics corridor. South Windsor itself is among the most affluent and stable towns in the Hartford metro - strong schools, professional demographics, and consistent recognition as one of the region's best places to live. A rare opportunity to own a distinctive building with in-place income and plenty of options!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$2,000,000 (USD)
Georgetown Area Single Family Home
Active
80 Old Farm Road Weston, CT 06883
4 Bed
5 Baths
3604 sqft
MLS# 24217178
Set high above the road on 2 private acres, this brand-new 2026 colonial was built to capture the view. A long stone-walled drive climbs to the home, where every front-facing window looks out over sweeping lawn and treetops. The elevated setting brings in remarkable natural light along with true privacy and quiet. The listing photos were taken with the interior lights off... that brightness you see is all daylight! Inside, over 3,600 sqft of beautifully crafted living with hardwood floors throughout. The open kitchen and family room form the heart of the home: a large quartz island with seating for four, white shaker cabinetry, stainless appliances with a professional-style range, and a sunlit dining area with sliders to a bluestone patio. The family room is anchored by a coffered ceiling and a fireplace flanked by built-ins. A front living room, separate dining area, private office, two powder rooms, and a mudroom with custom cubbies complete the main level. Upstairs, the vaulted primary suite offers a sitting area, custom walk-in closets, and a spa bath with freestanding soaking tub, double vanity and oversized glass shower with bench. Three more bedrooms include one with its own en-suite bath, plus a hall bath with double vanity and a second-floor laundry room. An unfinished lower level adds room to grow. Elevated, private, and filled with light: This is Weston at its best.
Listing Courtesy of SMART MLS / Listed By: Alex Kniffin, Century 21 Allpoints Realty
$1,999,000 (USD)
Durham Center Area Single Family Home
Active
148 Wallingford Road Durham, CT 06422
7 Bed
3 Baths
1786 sqft
MLS# 24045370
The Greenbacker's Brookfield Farm located midway between Hartford and New Haven in Durham Connecticut has two houses, dairy barn and many other outbuildings. There is approximately 140 acres and approximately 100 acres are least to other farmers for growing crop, etc.. The investor may generate income from the farm's rentals 1. Dairy barn, 2, growing crops (92 acres of cropland leased, currently), 3, Durham Fair parking. 4, pastureland (20 acres of pasture leased, currently), 5, hunt club (land leased currently). Potential income may come from establishing a farm stand, growing grapes/ winery, Christmas tree sales, blue berries, and more. The State of Connecticut Conservation Restriction requires this property to be 'agriculture in nature' according to development rights the state acquired approximately 70 years ago. Both 148 and 153 Wallingford Road MUST be sold together.
Listing Courtesy of SMART MLS / Listed By: Gary Dobratz, Century 21 Allpoints Realty
$1,995,000 (USD)
Wild Heron Phase Vi Area Single Family Home
Active
1318 E Lakewalk Circle Panama City Beach, FL 32413
4 Bed
4 Baths
3132 sqft
MLS# 785124
Experience refined coastal luxury in Wild Heron with this exceptional new construction residence, thoughtfully designed with the highest level of craftsmanship and premium finishes throughout.
Construction has already begun with a completion date of Fall '26 on this 4-bedroom, 3.5-bath home and will offer approximately 3,132 square feet of beautifully curated living space, showcasing top-of-the-line materials, designer selections, and architectural details that elevate everyday living. The open-concept floor plan is ideal for both entertaining and relaxed coastal living, featuring a gourmet kitchen, spacious living and dining areas, and a private primary suite designed as a true retreat.
Every element of this home has been carefully selected to reflect modern elegance and timeless quality, with opportunities for buyers to secure today's pricing and take advantage of exclusive pre-construction incentives. Construction has already begun, allowing early purchasers the unique advantage of locking in value and participating in select design choices. (Terms and selection deadlines apply).
Located within the prestigious, gated community of Wild Heron, residents enjoy access to world-class amenities including a lakeside boathouse, fitness center, resort-style pool, walking trails, and the renowned Shark's Tooth Golf Club, all just minutes from the white-sand beaches of 30A and Panama City Beach.
Secure your place in one of the area's most sought-after communities and take advantage of this rare pre-construction opportunity before pricing increases. All pictures and video are renderings of what is to be built.
Construction has already begun with a completion date of Fall '26 on this 4-bedroom, 3.5-bath home and will offer approximately 3,132 square feet of beautifully curated living space, showcasing top-of-the-line materials, designer selections, and architectural details that elevate everyday living. The open-concept floor plan is ideal for both entertaining and relaxed coastal living, featuring a gourmet kitchen, spacious living and dining areas, and a private primary suite designed as a true retreat.
Every element of this home has been carefully selected to reflect modern elegance and timeless quality, with opportunities for buyers to secure today's pricing and take advantage of exclusive pre-construction incentives. Construction has already begun, allowing early purchasers the unique advantage of locking in value and participating in select design choices. (Terms and selection deadlines apply).
Located within the prestigious, gated community of Wild Heron, residents enjoy access to world-class amenities including a lakeside boathouse, fitness center, resort-style pool, walking trails, and the renowned Shark's Tooth Golf Club, all just minutes from the white-sand beaches of 30A and Panama City Beach.
Secure your place in one of the area's most sought-after communities and take advantage of this rare pre-construction opportunity before pricing increases. All pictures and video are renderings of what is to be built.
Listing Courtesy of CENTRAL PANHANDLE / Listed By: Chris Jennings, Century 21 Allpoints Realty
$1,895,000 (USD)
Wethersfield Area Commercial
Active
239 Silas Deane Highway Wethersfield, CT 06109
Bed
0 Baths
18622 sqft
MLS# 24199269
Rare opportunity to acquire a highly visible 18,622 SF mixed-use investment/owner-user property on the Silas Deane Hwy in Wethersfield. Offered at $1,895,000, this two-building property combines established retail and professional/medical office tenants with renovated vacant space available for an owner-user or additional rental income. Current tenant mix includes restaurant, retail/pawn and pediatric/medical office uses. Significant recent capital improvements include a NEW ELEVATOR, roof improvements/repairs, approximately $100,000 in newly installed HVAC systems and completely renovated vacant space. Approx. 4,470 SF retail and 7,742 SF office/professional space with subdividable options. Features include central air, natural gas heat, public water/sewer, paved parking, multiple entrances/exits and excellent Silas Deane Hwy visibility. Strong value-add opportunity to lease remaining vacancy and increase income, or occupy available space while benefiting from existing tenants. Ideal for investment, owner-user, retail, medical or professional office use.
Listing Courtesy of SMART MLS / Listed By: Tyler DeVecchis, Century 21 Allpoints Realty
$1,770,000 (USD)
Downtown Area Commercial
Active
19-29 Main Street Hartford, CT 06106
0 Bed
0 Baths
19500 sqft
MLS# 24175630
Welcome to 25 Main Street, a four-story masonry Class B professional office building in downtown Hartford, sitting directly adjacent to the Hartford Hospital campus and surrounded on three sides by Hartford Hospital-owned property! Capital improvements include replacement roof and windows, roof-mounted HVAC, back-up generator, and a four-stop hydraulic elevator. Four identical ~5,000 SF floor plates, currently 100% vacant and fully adaptable for an incoming owner. The standout feature is the substantial ~98-space gated parking lot - a rare amenity in Downtown Hartford. Ideally suited for hospital-adjacent users: physician groups affiliated with Hartford Hospital or Connecticut Children's, ambulatory care, dental, behavioral health, imaging, rehab, outpatient surgical, or DME providers, all of whom benefit from being right at the campus front door. Hartford Hospital recently announced a nearly $1 billion long-term campus transformation including a new 14-story patient tower, with Connecticut Children's Medical Center just steps away. Downtown Hartford is also in the middle of an active office-to-residential conversion wave, opening the door to exciting possibilities for affordable housing developers. Projects in this corridor have been supported by a variety of programs including CRDA, CHFA, and DOH financing, and federal & state HTC. This is a rare chance to acquire in the shadow of a billion-dollar hospital expansion - don't pass on this uniquely-poised opportunity!
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$1,700,000 (USD)
New London Area Multi-Family Home
Active
82 Maple Avenue New London, CT 06320
20 Bed
12 Baths
8732 sqft
MLS# 24198075
Excellent value-add opportunity at 80-82 Maple Avenue, New London. This 12-unit apartment building is already well into a substantial renovation program. Eight units are renovated and/or in good condition, one unit is currently being renovated, and three units are gutted or under construction, providing an investor with clear upside through completion of the remaining renovations and further stabilization of the property. Built in 1925, the property offers approximately 8,732 SF of building area / 10,555 SF gross area on approximately 0.34 acres (14,810 SF). Features include two stories, a 2,877 SF basement, gas-fired hot-water heat, asphalt-shingle mansard roof, shingle exterior and open porch. Public records identify the property as a 12-unit apartment building. Excellent New London location near the Thames River waterfront, downtown New London, Waterfront Park, Cross Sound Ferry and the city's intermodal transportation center, providing access to ferry, rail and bus transportation. New London's waterfront and downtown offer restaurants, entertainment, arts, recreation and waterfront activities, while nearby conveniences include Lawrence + Memorial Hospital, shopping, grocery stores and major roadways. The property also has a reported Walk Score of 92. Ideal for investors seeking a partially renovated multifamily asset with significant improvements already completed and additional value-add potential through completion of the remaining units. Property, unit conditi
Listing Courtesy of SMART MLS / Listed By: Tyler DeVecchis, Century 21 Allpoints Realty
$1,675,000 (USD)
North Guilford Area Single Family Home
Active
1 Hart Landing Guilford, CT 06437
5 Bed
4 Baths
6328 sqft
MLS# 24206997
Architecturally distinctive and beautifully sited on 2.11 private acres, this five-level contemporary offers more than 5,200 square feet of flexible living space plus a separate 862 square foot guest house. The main residence features five bedrooms, multiple gathering spaces and an abundance of natural light, with curved walls, expansive windows and wooded views adding character throughout. At the heart of the home is a spacious kitchen with extensive cabinetry, an oversized center island with seating and a sun-filled breakfast nook wrapped in windows. Additional highlights include a formal dining room, dramatic living room/family room, office and an expansive recreation level with a wet bar and direct access to the stone terrace. Two fireplaces, a jetted soaking tub, private balcony and extensive stonework enhance the home's distinctive appeal. The detached one-bedroom guest house provides comfortable, independent accommodations above its own two-car garage. A three-car garage at the main residence brings the total to five garage bays. Stone patios, retaining walls, mature woods and natural rock outcroppings complete this remarkable setting. Guilford offers the best of Connecticut shoreline living, with its historic Town Green, locally owned shops and restaurants, scenic coastline, beaches and abundant outdoor recreation-all within a convenient commute of Yale University, Yale New Haven Hospital and downtown New Haven.
Listing Courtesy of SMART MLS / Listed By: Mary Tirozzi, Century 21 Allpoints Realty
$1,599,000 (USD)
Avon Area Single Family Home
Pending
108 Westland Road Avon, CT 06001
5 Bed
7 Baths
6688 sqft
MLS# 24206485
Stunning custom Colonial tucked away on a picturesque cul-de-sac in the exclusive Northington neighborhood of Avon. Offering over 8,600 sq ft, this exceptional 5 bedroom home showcases refined craftsmanship throughout. The chef's kitchen is a showstopper, featuring a 2025 48" Sub-Zero, Wolf range, two dishwashers, Sub-zero wine refrigerator, massive central island and abundant custom cabinetry - perfect for both everyday living and hosting large gatherings - opens to an inviting family room which centers around a grand gas stone fireplace and flows seamlessly to a home office. Gorgeous hardwood floors throughout this home have been freshly refinished! Generously sized bedrooms include an expansive primary suite with a spa-like bathroom and double-sided gas fireplace. The 850 sq ft flex space at the top level with a full bath and walk-in closet provides endless possibilities. Walls of windows offer stunning views from multiple levels of this gorgeous home! The walk-out lower level boasts soaring ceilings and is designed for entertainment, offering a 12-seat private movie theater, workout room, living area with wet bar, and a multiuse space with full bath and walk-in closet that can easily serve as a bedroom to accommodate an au pair or multi-generational living. Outside, enjoy a gated backyard oasis with a large gunite Pebbletec heated pool, gas fire pit, custom stonework and exceptional privacy. The oversized three car garage features industrial-sized garage doors.
Listing Courtesy of SMART MLS / Listed By: Deb McCracken, Century 21 Allpoints Realty
$1,595,000 (USD)
Cape Coral Area Single Family Home
Active
2746 SW 37th Terrace Cape Coral, FL 33914
4 Bed
4 Baths
2733 sqft
MLS# 2026042171
Experience the best of the Florida waterfront lifestyle in this beautifully appointed 4-bedroom, 4-bath home with direct Gulf access and a private boat dock. Built with quality craftsmanship and high-end finishes, this newer residence offers a expansive and thoughtfully designed floor plan with exceptional indoor-outdoor living.
The large living room is filled with natural light and features sliding glass doors that open seamlessly onto the pool, creating a beautiful connection between the indoor and outdoor spaces.
The spacious master suite is a private retreat, featuring beautiful views overlooking the pool and the picturesque canal intersection. The roomy master bath is complemented by a generous walk-in closet with custom cabinetry, providing both style and functionality. Three additional oversized bedrooms offer plenty of privacy and comfort, each featuring its own private en-suite bathroom—perfect for family and guests. In addition, a separate private office provides a quiet and comfortable space for working from home.
The impressive outdoor living area is truly the heart of the home, featuring an oversized pool deck, sparkling pool, relaxing hot tub, and fully equipped outdoor kitchen. It is the perfect setting for entertaining, relaxing, and enjoying Florida's year-round sunshine.
The private waterfront dock offers more than just convenient Gulf access. A dedicated waterfront seating platform provides the perfect spot to relax by the water and enjoy beautiful Florida sunsets, while an additional elevated kayak platform makes it easy to launch and enjoy the waterways. From boating and kayaking to sunset gatherings by the water, this property is designed to make the most of its exceptional waterfront setting.
Offered fully furnished, this home is completely move-in ready and allows you to immediately enjoy everything the Florida lifestyle has to offer. A rare opportunity to own a newer, high-quality waterfront residence with Gulf access, private dock, resort-style outdoor living, and exceptional comfort throughout.
Located in a safe, quiet, and highly sought-after neighborhood, this home is close to top-rated schools, shopping, dining and golf courses. This property thrives in a high-performing rental program with year-round demand, generated an impressive income the last years.
The large living room is filled with natural light and features sliding glass doors that open seamlessly onto the pool, creating a beautiful connection between the indoor and outdoor spaces.
The spacious master suite is a private retreat, featuring beautiful views overlooking the pool and the picturesque canal intersection. The roomy master bath is complemented by a generous walk-in closet with custom cabinetry, providing both style and functionality. Three additional oversized bedrooms offer plenty of privacy and comfort, each featuring its own private en-suite bathroom—perfect for family and guests. In addition, a separate private office provides a quiet and comfortable space for working from home.
The impressive outdoor living area is truly the heart of the home, featuring an oversized pool deck, sparkling pool, relaxing hot tub, and fully equipped outdoor kitchen. It is the perfect setting for entertaining, relaxing, and enjoying Florida's year-round sunshine.
The private waterfront dock offers more than just convenient Gulf access. A dedicated waterfront seating platform provides the perfect spot to relax by the water and enjoy beautiful Florida sunsets, while an additional elevated kayak platform makes it easy to launch and enjoy the waterways. From boating and kayaking to sunset gatherings by the water, this property is designed to make the most of its exceptional waterfront setting.
Offered fully furnished, this home is completely move-in ready and allows you to immediately enjoy everything the Florida lifestyle has to offer. A rare opportunity to own a newer, high-quality waterfront residence with Gulf access, private dock, resort-style outdoor living, and exceptional comfort throughout.
Located in a safe, quiet, and highly sought-after neighborhood, this home is close to top-rated schools, shopping, dining and golf courses. This property thrives in a high-performing rental program with year-round demand, generated an impressive income the last years.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Heiko Strauss, Century 21 Allpoints Realty
$1,595,000 (USD)
Santa Rosa Beach Area Land
Active
20 Acres Nellie Drive Santa Rosa Beach, FL 32459
Bed
0 Baths
sqft
MLS# 1012855
Rare large-acreage development opportunity in the heart of Santa Rosa Beach. This approximately 19.5-acre parcel fronts Nellie Drive and offers a compelling combination of location, privacy and residential development potential in one of South Walton's most active growth corridors. With more than 9 acres of uplands, the property presents an excellent opportunity for a distinctive low-density residential community, estate-size homesites or a unique barndominium-style development with room for larger homes, workshops, boat/RV storage and outdoor living.
The property's location is becoming even more attractive with the Nellie Drive extension now under construction, creating a new direct connection south from Chat Holley Road to U.S. Highway 98 adjacent to Publix. This future connectivity should provide convenient access to shopping, restaurants, schools, employment centers and the beaches of South Walton while preserving the property's more spacious North Santa Rosa Beach setting. Potential rezoning opportunity could yield 30+ lots. All information is deemed reliable but buyer should perform its own due diligence for its own use.
The property's location is becoming even more attractive with the Nellie Drive extension now under construction, creating a new direct connection south from Chat Holley Road to U.S. Highway 98 adjacent to Publix. This future connectivity should provide convenient access to shopping, restaurants, schools, employment centers and the beaches of South Walton while preserving the property's more spacious North Santa Rosa Beach setting. Potential rezoning opportunity could yield 30+ lots. All information is deemed reliable but buyer should perform its own due diligence for its own use.
Listing Courtesy of EMERALD COAST / Listed By: Jim Ball, Century 21 Allpoints Realty
$1,575,000 (USD)
North Stamford Area Single Family Home
Active
501 Woodbine Road Stamford, CT 06903
4 Bed
5 Baths
5285 sqft
MLS# 24138517
BACK ON THE MARKET AFTER 11 MONTHS UNDER CONTRACT! 7,568 SQ. FT. | FULLY RENTED UNTIL DECEMBER 31, 2026 MANHATTAN PRICES? THINK AGAIN! STAMFORD OFFERS MORE SPACE, MORE LIFESTYLE & EXCEPTIONAL VALUE! Why pay Manhattan prices when you can own an extraordinary residence in Stamford, Connecticut, offering substantially more space, an outstanding location, and tremendous value-enhancement potential? A RARE SECOND OPPORTUNITY! Previously under contract for 11 months, this exceptional property is now returning to the market because the buyer's circumstances have changed! STAMFORD REAL ESTATE: VALUES CONTINUE TO RISE! According to Zillow's September 2026 housing data, Stamford's typical home values increased approximately 7.9% over the preceding year, essentially approaching 8% appreciation. It has been reported that approximately 5.93% annual growth in price per square foot through September 2026. Sources: Zillow Stamford Housing Market; Stamford Market Report.Stamford, Connecticut, exceptional value and investment opportunity. Back on the market after 11 months under contract. Asking price about half of the average price per square foot in Stamford. 7,568 square feet. Currently fully rented, to be delivered vacant as of December 31, 2026. Let the numbers speak for themselves. Buyers, ask your realtor to prepare a comparative market analysis of Stamford properties. Manhattan buyers, investors, and homeowners, take notice.
Listing Courtesy of SMART MLS / Listed By: Cosmo Iadanza, Century 21 Allpoints Realty
$1,550,000 (USD)
Tolland Area Land
Active
00 Tolland Stage Road Tolland, CT 06084
Bed
0 Baths
0 sqft
MLS# 24052420
Exceptional Opportunity!! Incredible potential to fully develop over 80 acres of raw land with easy access to interstate 84. Fantastic possibility awaits you on this large level lot zoned Residential Design District which encourages a flexible site design that covers many options from single family homes to village type cluster housing. Expand your options with special permit uses which include senior housing, assisted living facility, a private school, nonprofit club or take advantage of the natural landscape for a sporting club, campground or resort, just to name a few. (See Section 5.1 - 5.2 attached for more details) Use your imagination, so many options available for an investor or real estate developer. Ideally located with 1,200 feet of frontage on Tolland Stage Road/Route 74 and additional access on Buff Cap Road only minutes to local amenities and attractions, easy commute to Boston in under 90 minutes. Some wetlands which enhance the beauty of the property. This parcel of land is a true gem, visit today for more details and information.
Listing Courtesy of SMART MLS / Listed By: Elaine AbouAkar, Century 21 Allpoints Realty
$1,550,000 (USD)
Tolland Area Commercial Land
Active
Tolland Stage Road Tolland, CT 06084
Bed
0 Baths
0 sqft
MLS# 24101836
Exceptional Opportunity!! Incredible potential to fully develop over 80 acres of raw land with easy access to interstate 84. Fantastic possibility awaits you on this large level lot zoned Residential Design District which encourages a flexible site design that covers many options from single family homes to village type cluster housing. Expand your options with special permit uses which include senior housing, assisted living facility, a private school, nonprofit club or take advantage of the natural landscape for a sporting club, campground or resort, just to name a few. (See Section 5.1 - 5.2 attached for more details) Use your imagination, so many options available for an investor or real estate developer. Ideally located with 1,200 feet of frontage on Tolland Stage Road/Route 74 and additional access on Buff Cap Road only minutes to local amenities and attractions, easy commute to Boston in under 90 minutes. Some wetlands which enhance the beauty of the property. This parcel of land is a true gem, visit today for more details and information.
Listing Courtesy of SMART MLS / Listed By: Elaine AbouAkar, Century 21 Allpoints Realty
$1,500,000 (USD)
New Haven Area Commercial
Active
825 Grand Avenue New Haven, CT 06511
Bed
0 Baths
2800 sqft
MLS# 24185883
Tremendous opportunity to acquire a mixed-use property and bring your own vision to life in one of New Haven's most recognizable corridors. Whether used as a medical, dental, or professional office, a restaurant, residential apartments, or a creative mixed-use redevelopment, this property offers exceptional flexibility, significant value-add potential, original exposed brick & soaring ceiling on all levels. A standout feature of the offering is the adjacent private parking lot with over 22 dedicated spaces, a rare amenity in this market. The building contains approximately 7,200 square feet across four levels, including a finished lower level, providing ample space for an owner-user, investor, or developer to customize the property to their specific vision. Ideally located just 0.4 miles from the renowned Sally's Apizza, the property benefits from proximity to one of New Haven's most popular dining destinations and the continued growth of the surrounding neighborhood. Attached are the floor plans and a preliminary diligence check package for your clients' review. Prospective purchasers should conduct their own independent diligence check regarding zoning, permitted uses, and all other aspects of the property.
Listing Courtesy of SMART MLS / Listed By: Bob Virgulak, Century 21 Allpoints Realty
$1,495,000 (USD)
North Canton Area Single Family Home
Active
27 &Amp 35 Ridge Road Canton, CT 06019
5 Bed
4 Baths
5622 sqft
MLS# 24216048
47.74 private acres high above Ridge Road on your own hilltop setting, with sweeping views to the east and south and room to breathe in every direction. Rarely does this much land come with a home built to match it. Designed to work with its site, this one-of-a-kind steel-frame contemporary uses passive solar gain and geothermal heating and cooling for year-round comfort, and is EPA Energy Star certified and Built Green. Inside, a dramatic two-story atrium with skylights and an interior balcony draws natural light deep into over 5,600 square feet with 5 beds and 2.2 baths. A third-floor tower frames the long views, and three fireplaces warm the home in every season. The chef's eat-in kitchen offers granite counters and Sub-Zero appliances, surrounded by exceptional natural materials: cork and triple-laminate glass floors, maple doors and cabinetry, native cherry and purple heart trim, marble, German limestone, and Vermont and Brazilian slate, all under a zinc and tile roof. The primary suite features a raised sitting area with fireplace. A separate studio with its own entrance, breezeway, and bath makes an ideal private office or artist's retreat. Two separate two-car garages, plus a walk-out lower level plumbed for a second kitchen and full bath. Step outside to a sunny, level lawn and garden, then keep going. Over 47 acres of privacy, space, and possibility await.
Listing Courtesy of SMART MLS / Listed By: Robert Perriello, Century 21 Allpoints Realty
$1,425,000 (USD)
Riviera Beach Villas Area Single Family Home
Active
21504 Front Beach Road 6 Panama City Beach, FL 32413
5 Bed
5 Baths
2483 sqft
MLS# 794988
Welcome to Panama Jane's, your perfect beach getaway on the highly desirable West End of Panama City Beach! This spacious 5-bedroom, 5-bathroom vacation home offers plenty of room for large families, multiple families traveling together, or groups looking to enjoy everything the Florida Gulf Coast has to offer.
Best of all, Panama Jane's is located directly across the street from the beach, putting the sugar-white sand and emerald Gulf waters just steps away. Spend your mornings enjoying coffee by the coast, your afternoons soaking up the sun, and your evenings watching unforgettable Florida sunsets.
Inside, the home offers generous accommodations with five bedrooms and five bathrooms, providing comfort, convenience, and privacy for everyone in your group. Whether you're gathering together after a day at the beach or enjoying some quiet time of your own, Panama Jane's offers the space to make your vacation feel effortless.
Located on the quieter and highly sought-after West End, you'll enjoy the perfect balance of a relaxing beach atmosphere while remaining close to local restaurants, shopping, entertainment, and everything Panama City Beach has to offer.
Panama Jane's is more than just a place to stay--it's your home base for making unforgettable beach memories. Pack your flip-flops, grab your sunscreen, and come experience the Florida Coastal Lifestyle just steps from the Gulf!
Best of all, Panama Jane's is located directly across the street from the beach, putting the sugar-white sand and emerald Gulf waters just steps away. Spend your mornings enjoying coffee by the coast, your afternoons soaking up the sun, and your evenings watching unforgettable Florida sunsets.
Inside, the home offers generous accommodations with five bedrooms and five bathrooms, providing comfort, convenience, and privacy for everyone in your group. Whether you're gathering together after a day at the beach or enjoying some quiet time of your own, Panama Jane's offers the space to make your vacation feel effortless.
Located on the quieter and highly sought-after West End, you'll enjoy the perfect balance of a relaxing beach atmosphere while remaining close to local restaurants, shopping, entertainment, and everything Panama City Beach has to offer.
Panama Jane's is more than just a place to stay--it's your home base for making unforgettable beach memories. Pack your flip-flops, grab your sunscreen, and come experience the Florida Coastal Lifestyle just steps from the Gulf!
Listing Courtesy of CENTRAL PANHANDLE / Listed By: Chris Jennings, Century 21 Allpoints Realty
$1,399,999 (USD)
Glastonbury Area Multi-Family Home
Active
571 Woodland Street Glastonbury, CT 06073
5 Bed
4 Baths
3268 sqft
MLS# 24204242
Perched high above the South Glastonbury countryside, this extraordinary two-residence property offers a rare opportunity to combine luxury living with income potential. Sweeping orchard views, breathtaking sunsets and distant Hartford skyline views create an unforgettable setting with exceptional appeal for multigenerational living, luxury rentals or potential short-term rental use, subject to applicable approvals. Two parcels. Two residences. Multiple possibilities. The property includes 571 Woodland St, with the residences on approximately 1 acre, plus 541 Woodland St, an additional approximately 1-acre parcel. The main residence offers 4 bedrooms, 2 full baths, soaring ceilings, walls of glass, private balconies, sauna and attached 3-car garage. The private guest residence features 1 bedroom plus loft, 2 full baths, kitchen, living and dining areas, fireplace, laundry and private balcony. Ideal for an owner-occupant seeking supplemental income or an investor exploring luxury rental opportunities. A distinctive lifestyle property where privacy, flexibility and investment potential converge.
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$1,399,999 (USD)
Glastonbury Area Single Family Home
Active
571 Woodland Street Glastonbury, CT 06073
5 Bed
4 Baths
3268 sqft
MLS# 24184457
Perched high above the South Glastonbury countryside, this extraordinary retreat offers breathtaking sunsets, sweeping views across rolling orchards to the Hartford skyline, and a sense of peace that is truly unforgettable. Two parcels, two residences, one extraordinary lifestyle. This is a home that simply cannot be fully captured in words or photographs-it must be experienced in person. From the breathtaking views and unforgettable sunsets to the thoughtful spaces, unique amenities, and peaceful surroundings, every corner reveals something special. It's more than a home; it's a lifestyle waiting to be felt. Cherished by one family and offered for the very first time, the property includes 2 parcels: 571 Woodland St, featuring the residence on approximately 1 acre, and 541 Woodland St, an additional approximately 1-acre lot. Walls of glass, soaring ceilings & private balconies bring the spectacular setting indoors. The main residence offers 4 bedrooms, 2 full baths, an open floor plan, private sauna & attached 3-car garage. The attached guest residence has its own living area, kitchen, dining space, laundry, fireplace, loft, 1 bedroom, 2 full baths & private balcony-ideal for multigenerational living, guests or a private retreat, with potential for yearly or short-term rental income, subject to applicable approvals, to help offset homeownership expenses.
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$1,374,900 (USD)
Riviera Beach Villas Area Single Family Home
Active
21504 Front Beach Road 11 Panama City Beach, FL 32413
4 Bed
3 Baths
2111 sqft
MLS# 795020
Welcome to Panama Joe's--where the Florida Coastal Lifestyle meets exceptional vacation rental potential!
This 4-bedroom, 3-bathroom vacation rental home is ideally positioned on the highly desirable West End of Panama City Beach, directly across the street from the Gulf. With Gulf views, a coastal dune lake in the backyard, and a proven history as a high-performing vacation rental, Panama Joe's offers an exceptional combination of lifestyle and investment opportunity.
Just steps from the beach, guests can easily spend their days enjoying the sugar-white sand and emerald waters of the Gulf of Mexico, then return home to relax and take in the coastal surroundings. The Gulf views add an extra layer of appeal, while the coastal dune lake directly behind the property creates a truly unique backyard setting that is hard to replicate.
Inside, the spacious 4-bedroom, 3-bath layout provides comfortable accommodations for families and groups, making this an ideal vacation home for generating rental income while still offering a place for the owners to enjoy themselves.
The West End is known for its more relaxed coastal atmosphere while still putting you within easy reach of Panama City Beach's restaurants, entertainment, shopping, and attractions.
Panama Joe's isn't simply an investment property--it's an opportunity to own a piece of the Florida Coastal Lifestyle while benefiting from an established vacation rental business.
Gulf views in the front. A coastal dune lake in the backyard. The beach across the street. And income potential in between. That's Panama Joe's.
This 4-bedroom, 3-bathroom vacation rental home is ideally positioned on the highly desirable West End of Panama City Beach, directly across the street from the Gulf. With Gulf views, a coastal dune lake in the backyard, and a proven history as a high-performing vacation rental, Panama Joe's offers an exceptional combination of lifestyle and investment opportunity.
Just steps from the beach, guests can easily spend their days enjoying the sugar-white sand and emerald waters of the Gulf of Mexico, then return home to relax and take in the coastal surroundings. The Gulf views add an extra layer of appeal, while the coastal dune lake directly behind the property creates a truly unique backyard setting that is hard to replicate.
Inside, the spacious 4-bedroom, 3-bath layout provides comfortable accommodations for families and groups, making this an ideal vacation home for generating rental income while still offering a place for the owners to enjoy themselves.
The West End is known for its more relaxed coastal atmosphere while still putting you within easy reach of Panama City Beach's restaurants, entertainment, shopping, and attractions.
Panama Joe's isn't simply an investment property--it's an opportunity to own a piece of the Florida Coastal Lifestyle while benefiting from an established vacation rental business.
Gulf views in the front. A coastal dune lake in the backyard. The beach across the street. And income potential in between. That's Panama Joe's.
Listing Courtesy of CENTRAL PANHANDLE / Listed By: Chris Jennings, Century 21 Allpoints Realty
$1,350,000 (USD)
Miramar Beach Area Condominium
Active
56 N The Grove Drive 321 Miramar Beach, FL 32550
4 Bed
5 Baths
2394 sqft
MLS# 1002118
Experience elevated coastal living in this brand-new 2025 construction at The Grove at Seascape--Unit 321. This expansive 4-bedroom, 4.5-bath residence offers 2,394 square feet of thoughtfully designed living space, blending modern luxury with the relaxed charm of the Emerald Coast.
Step inside to discover an open-concept floor plan filled with natural light, high ceilings, and upscale finishes throughout. The spacious living and dining areas flow seamlessly into a beautifully appointed kitchen featuring premium cabinetry, solid surface countertops, and high-end appliances--perfect for entertaining or enjoying quiet evenings at home. Each of the four bedrooms is generously sized with its own en-suite bath, providing comfort and privacy for owners and guests alike. The additional half bath adds convenience for entertaining.
Built with today's buyer in mind, this residence offers contemporary design, energy efficiency, and low-maintenance living, making it ideal as a primary residence, second home, or investment property.
The Grove at Seascape is part of the highly sought-after Seascape Resort, where owners and guests enjoy access to an array of resort-style amenities. Spend your days relaxing at multiple pools, including a resort-style pool deck, or take advantage of the private beach access just a short distance away. Golf enthusiasts will appreciate the on-site championship golf course, while tennis and pickleball courts provide additional recreational options. The resort also features dining, walking and biking paths, and 24-hour security, creating a true coastal lifestyle experience.
Located in the heart of Miramar Beach, you're just minutes from shopping, dining, and entertainment, while still enjoying a peaceful resort setting.
Unit 321 at The Grove at Seascape delivers the perfect combination of luxury, location, and lifestyle--an exceptional opportunity along the Emerald Coast.
Step inside to discover an open-concept floor plan filled with natural light, high ceilings, and upscale finishes throughout. The spacious living and dining areas flow seamlessly into a beautifully appointed kitchen featuring premium cabinetry, solid surface countertops, and high-end appliances--perfect for entertaining or enjoying quiet evenings at home. Each of the four bedrooms is generously sized with its own en-suite bath, providing comfort and privacy for owners and guests alike. The additional half bath adds convenience for entertaining.
Built with today's buyer in mind, this residence offers contemporary design, energy efficiency, and low-maintenance living, making it ideal as a primary residence, second home, or investment property.
The Grove at Seascape is part of the highly sought-after Seascape Resort, where owners and guests enjoy access to an array of resort-style amenities. Spend your days relaxing at multiple pools, including a resort-style pool deck, or take advantage of the private beach access just a short distance away. Golf enthusiasts will appreciate the on-site championship golf course, while tennis and pickleball courts provide additional recreational options. The resort also features dining, walking and biking paths, and 24-hour security, creating a true coastal lifestyle experience.
Located in the heart of Miramar Beach, you're just minutes from shopping, dining, and entertainment, while still enjoying a peaceful resort setting.
Unit 321 at The Grove at Seascape delivers the perfect combination of luxury, location, and lifestyle--an exceptional opportunity along the Emerald Coast.
Listing Courtesy of EMERALD COAST / Listed By: Keith Bailey, Century 21 Allpoints Realty
$1,330,000 (USD)
Santa Rosa Beach Area Land
Active
398 Flatwoods Forest Loop Santa Rosa Beach, FL 32459
Bed
0 Baths
sqft
MLS# 998155
Unique acreage (1.84) located in Nature Walk at Seagrove in the 308 corridor. Zoned multifamily mixed use can fit multiple homes on the property or keep as a family estate 1.84 acres. This property butts up To the point Washington State Forest. Very private in great location, central to shopping, beaches, restaurants with hiking and biking trails.HOA includes A zero entry style pool, heated lap pool, hot tub and a kids splash pool, exercise trails, gas grills, fire pit, kitchenette, shower, and restroom area by pools two Pickleball courts, to half court basketball courts a tot spot playground, access to point Washington State Forest, fitness stations throughout the community and so much more. All CDD fees paid up-to-date
Listing Courtesy of EMERALD COAST / Listed By: Victoria Hughes, Century 21 Allpoints Realty
$1,300,000 (USD)
Middletown Area Commercial
Active
480 Main Street Middletown, CT 06457
0 Bed
10 Baths
13837 sqft
MLS# 24184246
Welcome to 480 Main Street, Middletown - a rare investment opportunity in the heart of Downtown Middletown! This stunning brick mixed-use building blends timeless character with strong income-producing potential. Featuring 8 spacious residential units, each offering 900+ square feet, soaring ceilings, beautiful hardwood flooring, functional built-ins, and oversized layouts that tenants love. Seven of the Eight residential units have been updated, and many feature newer hot water heaters, helping minimize future capital expenses. The property is anchored by two commercial storefronts, including a 3,100 SF space and a 1,100 SF (long-term tenant). Commercial tenants contribute approximately 40% of CAM expenses, creating additional value for ownership. Featuring classic brick construction, a well-maintained roof, and a prime downtown location, 480 Main Street offers a rare blend of character, stability, and investment potential. Located just steps from restaurants, shopping, and entertainment, this is an excellent opportunity to own a standout mixed-use asset in the heart of Middletown
Listing Courtesy of SMART MLS / Listed By: Lindy Hoyt, Century 21 Allpoints Realty
$1,300,000 (USD)
Destin Area Single Family Home
Active
3551 Scenic Hwy 98 20 Destin, FL 32541
4 Bed
4 Baths
1920 sqft
MLS# 1009715
Destiny Beach Villas rock!! Two fully furnished 2 bedroom/2 full bath rental units on Scenic Hwy 98 - just steps away from popular Crystal Beach. Each unit is fully furnished. Recent improvements include back deck furniture 2024, new king size mattresses 2024, new floors and kitchen cabinets in down unit 2024. Back yard is Four Prong Lake with lots of nature - fish, ducks and turtles. Extended paver deck on down unit for barbecue.
Everything is near by - shopping and recreation. Large community pool for owners and rental guests. A totally relaxing property on a lake. Walking access over and under Scenic Hwy 98 to Destin's white sand beaches!!! A top investment opportunity on the Emerald Coast.
Everything is near by - shopping and recreation. Large community pool for owners and rental guests. A totally relaxing property on a lake. Walking access over and under Scenic Hwy 98 to Destin's white sand beaches!!! A top investment opportunity on the Emerald Coast.
Listing Courtesy of EMERALD COAST / Listed By: Paul Maryeski, Century 21 Allpoints Realty
$1,300,000 (USD)
Middletown Area Multi-Family Home
Active
480 Main Street Middletown, CT 06457
8 Bed
10 Baths
13837 sqft
MLS# 24182655
Welcome to 480 Main Street, Middletown - a rare investment opportunity in the heart of Downtown Middletown! This stunning brick mixed-use building blends timeless character with strong income-producing potential. Featuring 8 spacious residential units, each offering 900+ square feet, soaring ceilings, beautiful hardwood flooring, functional built-ins, and oversized layouts that tenants love. Seven of the Eight residential units have been updated, and many feature newer hot water heaters, helping minimize future capital expenses. The property is anchored by two commercial storefronts, including a 3,100 SF space and a 1,100 SF (long-term tenant). Commercial tenants contribute approximately 40% of CAM expenses, creating additional value for ownership. Featuring classic brick construction, a well-maintained roof, and a prime downtown location, 480 Main Street offers a rare blend of character, stability, and investment potential. Located just steps from restaurants, shopping, and entertainment, this is an excellent opportunity to own a standout mixed-use asset in the heart of Middletown
Listing Courtesy of SMART MLS / Listed By: Lindy Hoyt, Century 21 Allpoints Realty
$1,275,000 (USD)
Miramar Beach Area Land
Active
Lot 13 Hollywood Street Miramar Beach, FL 32550
Bed
0 Baths
sqft
MLS# 993689
PRIME LOT in Frangista Beach. Build your dream home at the beach or if money making is your thing build that perfect rental home. Location is everything. And this lot has it. Located directly across the street from amazing white sand beach and emerald green waters. Close to restaurants, shopping and entertainment. Additional lot next-door available for purchase if you're looking for a larger property, you can put them together and enjoy your own estate.
Listing Courtesy of EMERALD COAST / Listed By: Victoria Hughes, Century 21 Allpoints Realty
$1,275,000 (USD)
Miramar Beach Area Land
Active
Lot 12 Hollywood Street Miramar Beach, FL 32550
Bed
0 Baths
sqft
MLS# 993688
PRIME BUILDING LOT in Frangista Beach. Build your dream home at the beach or if money making is your thing build that perfect rental home. Location is everything and this lot has it. Located directly across the street from amazing white sand beach and emerald green waters. Close to restaurants, shopping and entertainment. Additional lot next-door available for purchase if you're looking for a larger property, you can put them together and enjoy your own estate.
Listing Courtesy of EMERALD COAST / Listed By: Victoria Hughes, Century 21 Allpoints Realty
$1,250,000 (USD)
Cape Coral Area Land
Active
1750 Sandy Circle Cape Coral, FL 33904
Bed
0 Baths
sqft
MLS# 2026037250
OUTSTANDING OVERSIZED RIVERFRONT LOT – A RARE OPPORTUNITY FOR BOATERS, INVESTORS & WATERFRONT LIVING! Exceptional riverfront property offering over 150 feet of frontage on the Caloosahatchee River/Intracoastal Waterway with expansive, million-dollar water views. Assessments Paid! A recently installed high-panel seawall with riprap provides enhanced shoreline protection and added peace of mind. Imagine building your dream waterfront estate and waking to spectacular sunrises, watching marine life from your backyard, and enjoying moonlit reflections across the river. This property also offers a front-row view of the annual Red, White & Boom fireworks celebration—an incredible setting for entertaining family and friends. For boating enthusiasts, the location is hard to beat. Boat directly from your backyard to waterfront restaurants, beaches, barrier islands, and the Gulf. Marinas and yacht clubs are nearby, along with convenient access to area beaches and airports. Enjoy the added benefit of being within walking distance of Cape Coral’s vibrant entertainment district, featuring restaurants, shopping, city-hosted events, and the new waterfront food truck park offering boat slips, fuel, a bar, entertainment, and a ship store. Whether you envision a spectacular private riverfront residence or are exploring the property’s investment and development potential, this oversized parcel offers exceptional possibilities. Located within the CRA District, which may provide additional development opportunities or incentives—buyers should verify available programs, zoning, and development options with the appropriate local authorities. Prime riverfront frontage, incredible boating access, spectacular views, and an exceptional location—the Southwest Florida waterfront lifestyle is calling. SW FL awaits you- what are you waiting for?
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Janet Eck, Century 21 Allpoints Realty
$1,175,000 (USD)
Wayland,East Side Area Multi-Family Home
Active Under Contract
130 Elmgrove Avenue Providence, RI 02906
8 Bed
4 Baths
5660 sqft
MLS# 1425522
Discover an exceptional opportunity to own a beautiful and spacious three-family residence in the heart of Providence’s highly desirable East Side! Situated along charming Elmgrove Avenue, this impressive property offers approximately 5,660 square feet of living space, generously sized units, and endless possibilities for comfortable living. Perfect for owner-occupants seeking the benefits of homeownership while enjoying additional rental income, this property combines the charm of East Side living with the flexibility of a multifamily home. Enjoy the convenience of being just moments from Blackstone Boulevard, Wayland Square, neighborhood cafés, restaurants, parks, shopping, and Brown University. Whether you're looking for a place to call home, room for extended family, or the opportunity to offset your mortgage with rental income, this property offers a unique lifestyle in one of Providence’s most desirable neighborhoods. Don't miss the opportunity to make this exceptional East Side property your own!
Listing Courtesy of RHODE ISLAND / Listed By: Adi Avraham, Century 21 Allpoints Realty
$1,150,000 (USD)
Hyde Park Area Land
Active
4341 Estero Boulevard Fort Myers Beach, FL 33931
Bed
0 Baths
sqft
MLS# 2025013959
Prime Investment Opportunity on Fort Myers Beach – Build Across from the White Sands!
Positioned directly across the street from the iconic wide, white sands of Fort Myers Beach, this vacant lot offers an unparalleled opportunity for investors and developers. With direct public beach access just steps away, this location is perfect for a luxury vacation rental, boutique hotel, or a dream beach home that capitalizes on both location and lifestyle.
Property Highlights:
Direct beach access across the street – no need to drive or search for parking
Zoned for development – ideal for residential or potential income-generating property
High visibility location with steady foot and vehicle traffic
Stunning Gulf views possible with elevated construction
Close to popular restaurants, shops, and the newly revitalized areas of Fort Myers Beach
Utilities available at the street
Fort Myers Beach continues to grow as a year-round destination for tourists and seasonal residents. Whether you're a builder, investor, or end-user, this is a rare chance to secure a slice of paradise in a high-demand coastal market.
Don’t miss your opportunity to develop in one of Southwest Florida’s most desirable beachside communities. Act now while this premium location is still available!
Positioned directly across the street from the iconic wide, white sands of Fort Myers Beach, this vacant lot offers an unparalleled opportunity for investors and developers. With direct public beach access just steps away, this location is perfect for a luxury vacation rental, boutique hotel, or a dream beach home that capitalizes on both location and lifestyle.
Property Highlights:
Direct beach access across the street – no need to drive or search for parking
Zoned for development – ideal for residential or potential income-generating property
High visibility location with steady foot and vehicle traffic
Stunning Gulf views possible with elevated construction
Close to popular restaurants, shops, and the newly revitalized areas of Fort Myers Beach
Utilities available at the street
Fort Myers Beach continues to grow as a year-round destination for tourists and seasonal residents. Whether you're a builder, investor, or end-user, this is a rare chance to secure a slice of paradise in a high-demand coastal market.
Don’t miss your opportunity to develop in one of Southwest Florida’s most desirable beachside communities. Act now while this premium location is still available!
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Michael Healy, Century 21 Allpoints Realty
$1,125,000 (USD)
West Side Area Commercial
Active
63 Selleck Street Stamford, CT 06902
0 Bed
4 Baths
1878 sqft
MLS# 24218484
Opportunity Knocks to Start Your Own Business, Previous Usage of Building was a Restaurant that Served the Community for Over Fifteen Years, Building Space can be Retrofitted for other Types of Business per Stamford Zoning Approval. High Traffic Area and Visibility. Easy Access to Highway & Transportation Modes, Plenty Off Street Parking Available in Adjacent Parking lot. Property Lot Size is Approximately 156 ft x 36 ft with 1,689 sf Retail Space, (2) Apartments on Second Level, Parking Area for 6-8 vehicles & 396 sf Storage Area.
Listing Courtesy of SMART MLS / Listed By: Arnold Knittel, Century 21 Allpoints Realty
$1,125,000 (USD)
West Hartford Area Multi-Family Home
Pending
202 Park Road West Hartford, CT 06119
4 Bed
4 Baths
4474 sqft
MLS# 24212001
A rare, turn-key investment opportunity available in the heart of West Hartford! This stunning mixed-use property was fully renovated in 2020 and offers the perfect blend of strong rental opportunity and an unbeatable location. The property features two beautiful commercial spaces fully leased through 2029/2030. Additionally, there are two spacious 2BR/1BA residential units with open floor plans, modern finishes, in-unit laundry and central AC. One residential unit is currently vacant and available for lease, offering immediate upside or owner occupant potential. Tenant-paid utilities, designated tenant parking and commercial tenants covering 50% of property taxes make this an amazing long-term investment in a desirable location.
Listing Courtesy of SMART MLS / Listed By: Maddy Ceruti, Century 21 Allpoints Realty
$1,125,000 (USD)
West Hartford Area Commercial
Pending
202 Park Road West Hartford, CT 06119
0 Bed
6 Baths
11614 sqft
MLS# 24212015
A rare, turn-key investment opportunity available in the heart of West Hartford! This stunning mixed-use property was fully renovated in 2020 and offers the perfect blend of strong rental opportunity and an unbeatable location. The property features two beautiful commercial spaces fully leased through 2029/2030. Additionally, there are two spacious 2BR/1BA residential units with open floor plans, modern finishes, in-unit laundry and central AC. One residential unit is currently vacant and available for lease, offering immediate upside or owner occupant potential. Tenant-paid utilities, designated tenant parking and commercial tenants covering 50% of property taxes make this an amazing long-term investment in a desirable location.
Listing Courtesy of SMART MLS / Listed By: Maddy Ceruti, Century 21 Allpoints Realty
$1,120,000 (USD)
Cape Coral Area Land
Active
3031 NW Juanita Place Cape Coral, FL 33993
Bed
0 Baths
sqft
MLS# 2026029946
BUILDERS AND INVESTORS TAKE NOTICE!! About 220,000+- sq feet of land zoned RML/ML With Option to 40,000+- sq feet (in green), total over 260,000 sqft. FOURTEEN + TWO LOTS, with a combination of double, triple and larger lots, to be sold together, for a huge parcel in the up and coming North Cape.
RML Zoning allows for up to 16 units per acre once city
utilities are installed. Check with the city about the great potential for this property.
Opportunity to own a big assemblage of lots and take advantage of the future growth in the Cape! Build a great Duplex now and another one once it is connected to utilities!!
*Seller financing may be available with 50% down-details available to qualifying Buyers.
RML Zoning allows for up to 16 units per acre once city
utilities are installed. Check with the city about the great potential for this property.
Opportunity to own a big assemblage of lots and take advantage of the future growth in the Cape! Build a great Duplex now and another one once it is connected to utilities!!
*Seller financing may be available with 50% down-details available to qualifying Buyers.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Zak Yona, Century 21 Allpoints Realty
$1,100,000 (USD)
East Side Area Multi-Family Home
Active
34-36 Park Street Bridgeport, CT 06608
18 Bed
7 Baths
5888 sqft
MLS# 24192406
Exceptional 7-Unit Investment Opportunity in Bridgeport's East Side! Welcome to 34-36 Park Street, a well-positioned multifamily property offering seven residential units just one block from Washington Park and minutes from downtown Bridgeport, public transportation, shopping, restaurants, and major highways. The property consists of (1) five-bedroom unit, (2) three-bedroom units, (3) two-bedroom units, and (1) one-bedroom unit, providing a desirable mix of apartment sizes to appeal to a broad tenant base. One unit is currently vacant, offering immediate leasing potential or flexibility for renovations and repositioning. Tenants are responsible for their own heat and electricity, helping to reduce owner operating expenses. The building features natural gas utilities, public water and sewer, off-street parking, a full basement, and a level lot. With approximately 5,888 square feet of living space, this income-producing asset presents an excellent opportunity for investors seeking to expand their portfolio or add value through rental optimization and property improvements. Conveniently located near Washington Park, Barnum Avenue, schools, shopping, Metro-North, and I-95, this property benefits from strong commuter access and consistent rental demand. Whether you're looking for stable cash flow, long-term appreciation, or a value-add investment, 34-36 Park Street offers exceptional potential in a prime Bridgeport location.
Listing Courtesy of SMART MLS / Listed By: Tyler DeVecchis, Century 21 Allpoints Realty
$1,098,888 (USD)
East Hartford Area Multi-Family Home
Active
645 Burnside Avenue East Hartford, CT 06108
10 Bed
9 Baths
5846 sqft
MLS# 24205669
9.4% ROI | 7.7% CAP RATE | 9-UNIT MIXED-USE INVESTMENT OPPORTUNITY! Positioned along East Hartford's active Burnside Avenue corridor, 654 Burnside Avenue offers investors a diversified income stream with one cafe plus eight residential units consisting of one 2-bedroom, three 1-bedroom apartments and four studios. The cafe pays its own gas and electric, helping reduce ownership expenses, while ample on-site parking adds convenience for both residential and commercial tenants. Recent property improvements include a new front porch, front entry doors, central boiler and hot water heater and select replacement windows. With a combination of commercial and residential income, strong visibility along Burnside Avenue, access to public transportation and proximity to neighborhood retail and services, this property presents an attractive opportunity to acquire a cash-flowing mixed-use asset. Multiple income streams. Ample parking. Strong returns. One investment.
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$1,075,000 (USD)
Shalimar Area Single Family Home
Active
5 Poquito Road Shalimar, FL 32579
5 Bed
3 Baths
3349 sqft
MLS# 1005606
Unlimited possibilities can make all your dreams come true on the Bayou at 5 Poquito.
Poquito Bayou, known for its unique homes, larger lots, no HOA, community boat ramp & playground, is conveniently located near Eglin AFB, schools, shopping, dining, parks & area beaches. This property offers modern updates & added flexibility in one of the most beautiful & established communities.
Spectacular sunrises & stunning sunsets are the perfect setting for life here. From the moment you arrive, you'll find something for everyone & every lifestyle. Extra living space can be found in the charming 2-bedroom, 1-bath guest cottage with small kitchen--perfect for guests, a mother-in-law suite or office. The cottage has easy access to the main house with 3 bedrooms & 2 baths.
The recently updated kitchen features an exceptional island seating up to 8. The open living area includes a cozy gas fireplace, pecky cypress accent wall & expansive floor-to-ceiling windows & glass door framing your first views of the Bayou below.
This home's design will not disappoint, with outdoor spaces on different levels--from the wooden deck to the stone patio & finally to the deep-water boat dock with ample decking for fishing, swimming or relaxing. Looking back up at the house showcases an elevation unequalled in most coastal homes. This property was made to be enjoyed & celebrated by you, your family & friends.
Updates: Kitchen/layout (2021/2022) | HVAC (2024) | Roof (2015) | Water heater (2015)
Poquito Bayou, known for its unique homes, larger lots, no HOA, community boat ramp & playground, is conveniently located near Eglin AFB, schools, shopping, dining, parks & area beaches. This property offers modern updates & added flexibility in one of the most beautiful & established communities.
Spectacular sunrises & stunning sunsets are the perfect setting for life here. From the moment you arrive, you'll find something for everyone & every lifestyle. Extra living space can be found in the charming 2-bedroom, 1-bath guest cottage with small kitchen--perfect for guests, a mother-in-law suite or office. The cottage has easy access to the main house with 3 bedrooms & 2 baths.
The recently updated kitchen features an exceptional island seating up to 8. The open living area includes a cozy gas fireplace, pecky cypress accent wall & expansive floor-to-ceiling windows & glass door framing your first views of the Bayou below.
This home's design will not disappoint, with outdoor spaces on different levels--from the wooden deck to the stone patio & finally to the deep-water boat dock with ample decking for fishing, swimming or relaxing. Looking back up at the house showcases an elevation unequalled in most coastal homes. This property was made to be enjoyed & celebrated by you, your family & friends.
Updates: Kitchen/layout (2021/2022) | HVAC (2024) | Roof (2015) | Water heater (2015)
Listing Courtesy of EMERALD COAST / Listed By: Whitney Cramer, Century 21 Allpoints Realty
$1,050,000 (USD)
North Stamford Area Single Family Home
Active
240 Fishing Trail Stamford, CT 06903
5 Bed
3 Baths
2463 sqft
MLS# 24183782
...Nestled on a private level acre in desirable North Stamford, located at the end of a cul-de-sac this beautifully updated five-bedroom executive colonial offers the perfect blend of timeless elegance and modern comfort. Thoughtfully renovated throughout, the home features spacious sun filled rooms, hardwood floors on the main level, and an ideal layout for both everyday living and entertaining. The heart of the home is the stunning updated kitchen with premium finishes, seamlessly flowing into inviting family and dining spaces. A generous primary suite provides a peaceful retreat, while four additional bedrooms offer flexibility for family, guests, or home office needs. Step outside onto a private deck to enjoy the expansive acre of professionally landscaped grounds, providing exceptional privacy and plenty of room for recreation and gardening. Located in one of Stamford's most sought-after neighborhoods, this move-in-ready home combines a tranquil setting with convenient access to downtown Stamford, parks, shopping, dining and commuting routes. Note: Dining room chandelier is excluded. Tax records show 4 bedrooms when there are actually 5. And for the NYC commuters, the Talmadge Hill train station is 10 minutes away.
Listing Courtesy of SMART MLS / Listed By: Nancy Hadden, Century 21 Allpoints Realty
$999,900 (USD)
Wolcott Area Commercial
Active
10 Wakelee Road Wolcott, CT 06716
Bed
0 Baths
0 sqft
MLS# 24156394
Exceptional opportunity to acquire a freestanding commercial building on Wakelee Road in Wolcott, Connecticut. Situated on 2.00 acres within an industrial zone, this versatile property offers strong visibility, substantial frontage, and expansive on-site parking with approximately 100+ uncovered spaces. The one-story building, originally constructed in 1969, features a distinctive greenhouse-style front facade that creates an inviting architectural presence. Inside, the layout includes a full-service bar, spacious main dining area, a private event room, and a side porch designed for outdoor seating. The facility includes a high-volume commercial kitchen capable of accommodating large-scale food service operations. A standout feature of the property is the approximately 3,000-square-foot outdoor pavilion, complete with a secondary kitchen setup, making it well-suited for weddings, live entertainment, seasonal dining, and large private gatherings. The 2-acre parcel allows flexibility for a range of commercial uses or potential redevelopment consistent with industrial zoning regulations. The building is serviced by public water, public sewer, natural gas with hot air heat, and central air conditioning. This offering presents strong potential for continued restaurant and banquet use, brewery or taproom concept, catering headquarters, or adaptive commercial redevelopment. Financials and additional operational details are available upon request and requires a NDA.
Listing Courtesy of SMART MLS / Listed By: Tyler DeVecchis, Century 21 Allpoints Realty
$997,900 (USD)
Tampa Area Single Family Home
Pending
14317 Avon Farms Drive Tampa, FL 33618
4 Bed
5 Baths
3581 sqft
MLS# 791881
'CURRENTLY UNDER CONTRACT, SELLER WILL CONSIDER BACKUP OFFERS' Welcome to 14317 Avon Farms Drive, a beautifully designed 4-bedroom, 5-bath home with a dedicated office, located in the exclusive gated community of Retreat at Carrollwood. Nestled in the highly desirable Lake Magdalene/Carrollwood area, this home offers the perfect blend of modern finishes, thoughtful design, and everyday functionality.
Step inside to discover hardwood flooring throughout the main living areas, a stylish designer wallpaper accent wall in the living room, and a formal dining space perfect for entertaining. Just off the entryway, a private office provides the ideal work-from-home setup, study space, or flex room to fit your lifestyle.
The first-floor primary suite is a true retreat, featuring a spacious bedroom and a private bathroom with dual vanities, a bathtub, and a separate walk-in shower with a ceiling-mounted rain shower.
The kitchen is the heart of the home, featuring a large center island, premium stainless steel appliances, a gas cooktop, and a generous walk-in pantry--perfect for everyday living and entertaining.
Upstairs, you'll find a spacious loft offering additional living space, along with three generously sized bedrooms, each featuring its own private bathroom for maximum comfort and privacy.
Step outside to the screened lanai and enjoy Florida living year-round. The space is enhanced by a decorative artificial greenery accent wall, creating a stylish backdrop for relaxing or entertaining. The backyard has been virtually staged to illustrate the potential for a future pool, helping buyers visualize how the space can be transformed into their own private outdoor retreat.
The home features both a two-car garage and a separate one-car garage, offering flexible space for parking, storage, or a workshop. Conveniently located just 5 minutes from I-275 and approximately 18 minutes from Downtown Tampa, Midtown Tampa, and Tampa International Airport, this home offers easy access to some of the area's best dining, shopping, entertainment, and business districts.
Freshly painted throughout and move-in ready, this exceptional home offers luxury, comfort, and an unbeatable location.
Schedule your private showing today and discover everything Retreat at Carrollwood has to offer.
Step inside to discover hardwood flooring throughout the main living areas, a stylish designer wallpaper accent wall in the living room, and a formal dining space perfect for entertaining. Just off the entryway, a private office provides the ideal work-from-home setup, study space, or flex room to fit your lifestyle.
The first-floor primary suite is a true retreat, featuring a spacious bedroom and a private bathroom with dual vanities, a bathtub, and a separate walk-in shower with a ceiling-mounted rain shower.
The kitchen is the heart of the home, featuring a large center island, premium stainless steel appliances, a gas cooktop, and a generous walk-in pantry--perfect for everyday living and entertaining.
Upstairs, you'll find a spacious loft offering additional living space, along with three generously sized bedrooms, each featuring its own private bathroom for maximum comfort and privacy.
Step outside to the screened lanai and enjoy Florida living year-round. The space is enhanced by a decorative artificial greenery accent wall, creating a stylish backdrop for relaxing or entertaining. The backyard has been virtually staged to illustrate the potential for a future pool, helping buyers visualize how the space can be transformed into their own private outdoor retreat.
The home features both a two-car garage and a separate one-car garage, offering flexible space for parking, storage, or a workshop. Conveniently located just 5 minutes from I-275 and approximately 18 minutes from Downtown Tampa, Midtown Tampa, and Tampa International Airport, this home offers easy access to some of the area's best dining, shopping, entertainment, and business districts.
Freshly painted throughout and move-in ready, this exceptional home offers luxury, comfort, and an unbeatable location.
Schedule your private showing today and discover everything Retreat at Carrollwood has to offer.
Listing Courtesy of CENTRAL PANHANDLE / Listed By: Anna Borodkin, Century 21 Allpoints Realty
$989,900 (USD)
Woodbridge Area Single Family Home
Pending
14 Tulip Tree Lane Woodbridge, CT 06525
5 Bed
6 Baths
4552 sqft
MLS# 24214337
A blend of classic English architecture & refined modern living, this Tudor offers beautifully appointed interiors, & a versatile floor plan designed for a variety of lifestyles. Its distinctive brick & stucco facade sets the stage for a home rich in character & thoughtful updates. The marble foyer leads to a stunning step-down L/R with hardwood floors, custom millwork, & expansive walls of windows that fill the space with natural light. The banquet-sized formal D/R impresses with H/W floors & opens to the inviting porch for a seamless connection between indoor & outdoor entertaining. At the heart of the home, the updated kitchen is both functional & inviting, showcasing cherry cabinets, granite counters, & premium appliances, The open eating area bridges the screened-in porch & the adjoining family room, a warm retreat with its stone fireplace & custom built-ins. You are sure to love the home's flexible floor plan, highlighted by a spacious 1st-floor primary suite that offers the luxury & convenience of single-level living without sacrificing the generous accommodations of a traditional 2-story. A richly paneled library with custom cherry built-ins makes a great home office, study, or quiet sanctuary, while the 1st-floor laundry room makes that chore a breeze! The 2nd floor offers 4 generously sized bedrooms, including two ensuite baths, and an additional full hall bath This configuration provides for everyone's needs.
Listing Courtesy of SMART MLS / Listed By: Stacy Pfannkuch, Century 21 Allpoints Realty
$949,900 (USD)
Canton Area Single Family Home
Pending
100 Robin Drive Canton, CT 06019
4 Bed
3 Baths
3772 sqft
MLS# 24205275
**Please watch Video!** A rare blend of sophistication, privacy, natural light, and breathtaking views-set beautifully in the hills of Canton. This truly exceptional contemporary Colonial offers a refined yet comfortable lifestyle, with a neutral, timeless interior, thoughtful updates, soaring ceilings, and a gracious open floor plan designed to showcase its spectacular setting. At the heart of the home is an updated chef's kitchen featuring a gas range, double ovens, granite countertops, classic shaker cabinetry, and stainless-steel appliances. The adjoining dining area is surrounded by walls of glass, creating the perfect spot to enjoy morning coffee while taking in the views or linger over dinner as the sun sets. Open to the kitchen, the inviting family room features elegant French doors, transom windows, and a dramatic floor-to-ceiling fieldstone gas fireplace by Mendota. Just beyond, an expansive rear deck spans the width of the home, offering an exceptional outdoor living space and maximizing the panoramic views. An electric radiant heater tucked into the soffit area allows you to enjoy this remarkable setting even on cooler evenings. The first level continues with a beautiful sunroom, sophisticated formal dining room, and a private office with fireplace and custom built-in bookcases, along with a second office-perfect for today's work-from-home lifestyle. Upstairs, all four bedrooms are thoughtfully located on the second level.The spacious primary.
Listing Courtesy of SMART MLS / Listed By: Tatyana Makarov, Century 21 Allpoints Realty
$925,000 (USD)
Shelton Area Commercial
Active
269 Coram Avenue Shelton, CT 06484
Bed
0 Baths
10300 sqft
MLS# 24216535
Welcome to 269 Coram Avenue! This well established Church is ready for its next owner! Located on a corner lot, this property offers not only an 8000+ square foot Church, it also convey with a large 2-family home. There is so much potential for this conveniently located property. The City of Shelton is motivated to work with new owners and developers to help facilitate growth in Shelton.
Listing Courtesy of SMART MLS / Listed By: Maureen McLarin, Century 21 Allpoints Realty
$925,000 (USD)
Shelton Area Multi-Family Home
Active
269 Coram Avenue Shelton, CT 06484
4 Bed
2 Baths
7810 sqft
MLS# 24209297
Welcome to 269 Coram Avenue! This is a one of a kind opportunity! This established property offers a Church and a 2-family home. This stately Church was built in 1894, and the building is just as solid a structure as it was back then. Featuring a newer roof, potential for a commercial kitchen with the addition of a new ansul system, and extensive options for growth, this is a very special building. It comes with a 2-family home that is conveniently located right next door. The Church and 2-family home also offer the potential to be developed. The City of Shelton is firmly committed to helping develop and increase traffic to downtown businesses.
Listing Courtesy of SMART MLS / Listed By: Maureen McLarin, Century 21 Allpoints Realty
$905,999 (USD)
Niceville Area Single Family Home
Active
4327 Sunset Beach Circle Niceville, FL 32578
5 Bed
3 Baths
3331 sqft
MLS# 1008057
Located in the highly desired and gated community of Sunset Beach in Bluewater Bay. This stunning custom-built and totally remodeled home offers 3,331 square feet of beautifully updated living space with 5 bedrooms and 3 full bathrooms. Quality craftsmanship throughout, this exceptional home features a new 50-year metal roof, fresh interior and exterior paint, new luxury vinyl plank and tile flooring throughout the main living areas, new carpet in the bedrooms, updated bathrooms, new light fixtures, gas fireplace, dual HVAC systems, central vacuum system, water filtration system, wet bar with wine cooler, 10-foot ceilings on the main level, 9-foot ceilings upstairs, extensive crown molding, and a spacious storage room over the garage. The chef style kitchen boasts new quartz countertops, stainless steel appliances, a breakfast bar, abundant cabinetry, perfect for entertaining or everyday living. The spacious first floor master suite is conveniently and features dual vanities, Jacuzzi tub, walk-in shower, and an oversized walk-in closet. A second bedroom and full bath are also located on the main level. Three additional bedrooms upstairs with ample closet space, one of which features French Doors with balcony overlooking the backyard. Residents of Sunset Beach enjoy a resort-style swimming pool, clubhouse, private beach and pier with access to the Bay. Seller owns a pool company and is willing to design and install a deeply discounted custom pool. Don't miss out!
Listing Courtesy of EMERALD COAST / Listed By: Ken Koger, Century 21 Allpoints Realty
$899,900 (USD)
Monroe Area Single Family Home
Active
133 Bug Hill Road Monroe, CT 06468
4 Bed
3 Baths
3194 sqft
MLS# 24196390
An elegant Monroe Colonial awaits gracefully blending classic architecture with thoughtful modern updates. This exceptional home offers more than 4000 square feet of beautifully appointed living space. Designed for both everyday comfort & effortless entertaining. The heart of the home is the updated kitchen, featuring newer quartzite countertops, stainless steel appliances, a center island, and bar area. The well-placed laundry room between kitchen & garage, creates an easy everyday drop zone. From the kitchen, the floor plan flows effortlessly into the formal dining room, private living room, sun-filled sunroom, & inviting family room, where the floor to ceiling fireplace creates a warm gathering space. A highly desirable 1st floor bedroom & full bath add exceptional flexibility for guests, multigenerational living, or private home office. Every space connects seamlessly, making the home as functional for daily living as it is for entertaining. Retreat upstairs to the expansive primary suite, a true private sanctuary, featuring a generously sized ensuite bath, walk-in closet & a walk-in attic offering storage today & potential for future expansion. Two additional nice sized bedrooms & hall bath complete the second level.The spectacular finished LL is a true extension of the home, featuring stylish luxury vinyl plank flooring and expansive, flexible living space. Create the ultimate recreation room, home fitness studio, or media lounge.
Listing Courtesy of SMART MLS / Listed By: Stacy Pfannkuch, Century 21 Allpoints Realty
$875,000 (USD)
Islands End Area Multi-Family Home
Active
21671 Indian Bayou Drive 673 Fort Myers Beach, FL 33931
4 Bed
2 Baths
2350 sqft
MLS# 2026026787
Drastic reduction don't miss out on this fantastic opportunity! Fort Myers beach Duplex on 3/4-acre lot, live on one side and rent the other side or rent both sides as an income property. This home is currently listed with a management company for Short- and long- term rentals. Home sits on pilings where the superior height offers lower flood insurance at only 1,000 a year. Home has never flooded or had any Hurricane damage. A-3 minuet walk to Sugar sand beaches that includes fishing, Dolphins hunting the Shoreline and long Sunset Strolls. The duplex is Turnkey with brand New Furniture, with beautiful Lake views, with large private balconies on each side, each unit has its own private laundry room. parking spots, along with individual carports for each unit. Both duplexes have been fully renovated with large format 2 FT X 4 FT Porcelain tile throughout the home and bathrooms. All modern bathrooms with new shower glass enclosures with all the modern touches. Brand new Kitchens with slow close draws and doors, new appliances, stylish backsplashes and new Quartz Counter tops. Home has a new metal roof 2023, new interior oil paint, new exterior paint, new decking, new water heaters, new washers, dryers, new plantation shutters, new smart TV's, brand new A/C's and new ceiling fans. Custom exterior Hardi Backer board exterior for maximum weather deterrent. New Landscaping, new exterior patio furniture with a propane fire pit and new landscaping rocks. Exterior lighting and string lighting creates a resort style setting. Very rare 100 FT X 100 FT of lake is also deeded to the property, so you could build a dock, sea wall, pier or additional lounging area. Very Large, enclosed storage room on the first floor approximately 500 square feet with a high ceiling. Additional 8X5 storage room for Beach gear. Minutes to Fort Myers Beach Town Shops, music, entertainment and restaurants. Begin your Florida lifestyle today.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Michael Hall, Century 21 Allpoints Realty
$874,900 (USD)
Pond Point Area Single Family Home
Active
63 Chester Street Milford, CT 06460
4 Bed
4 Baths
2949 sqft
MLS# 24206076
Truly exceptional coastal home designed for the discerning buyer seeking luxury, privacy and an energy-conscious lifestyle-surrounded by breathtaking, unobstructed panoramic views of Milford's protected tidal marshes. This architectural stunner is 6 years young & offers~3,000 sft of bright, open living space with 9' ceilings, oversized windows, transom glass and beautiful hickory floors. Exceptional craftsmanship boasts custom millwork, 8" crown molding, shiplap, wainscoting and two dramatic floor-to-ceiling fireplaces. The chef-inspired kitchen features soft-close Shaker cabinetry, granite countertops, multiple ovens and Bosch and Cosmo commercial-grade stainless steel appliances, flowing seamlessly into the open living and entertaining spaces. With 4 bedrooms and 3.5 baths, the flexible floor plan offers the possibility of three primary suites, complete with walk-in closets and custom closet systems. A walk-up third-floor suite with a full bath is a total flex space: guest retreat, family room or home office. Four expansive composite decks take advantage of the spectacular views. Thoughtfully built with energy efficiency in mind, features include spray-foam insulation, Low-E tilt-out windows, Energy Star appliances and lighting, WaterSense fixtures, a high-efficiency LP gas furnace, tankless on-demand hot water and energy-saving home automation forsecurity, thermostats, lighting and locks. Elevated to FEMA standards with no expense spared, the property also features
Listing Courtesy of SMART MLS / Listed By: Karin Stocknoff, Century 21 Allpoints Realty
$874,900 (USD)
Wolcott Area Single Family Home
Active
91 Idlewood Road Wolcott, CT 06716
4 Bed
3 Baths
4530 sqft
MLS# 24194808
Welcome to 91 Idlewood Road, where over 4,500 SF of above-grade living space offers up to 5 bedrooms and flexibility for every chapter of life. A grand two-story foyer welcomes you with hardwood floors, elegant crown molding, and beautifully appointed formal living and dining rooms. Just beyond, the gas-fireplaced family room opens to a private deck and flows seamlessly into the light-filled kitchen featuring a gas range, double wall ovens, center island, two pantry closets, and sunny dining area with new sliders. Nearby, the first-floor office can easily serve as a guest or in-law bedroom, with an adjacent powder room offering potential for future expansion to a full bath. Upstairs, the primary suite indulges with a dual-sink vanity, soaking tub, and expansive walk-in closet, joined by two additional bedrooms, versatile fourth room, full main bath, and an equipped laundry room. The showstopper? A vaulted bonus room with vintage 1950s-style diner bar, wet bar sink, and spacious lounge is perfect for entertaining, hobbies, or multi-generational living, with a private staircase to the mudroom providing garage and front walk access. An oversized, heated 3-car clear-span garage, ample basement space with heated workshop and wine storage room, gas piped grill, generator hookup, and updates including a 2025 roof and recent 2026 improvements to the well system (hydro-fracturing, new well tank, and a new well pump) complete the package.
Listing Courtesy of SMART MLS / Listed By: Renee Lovley, Century 21 Allpoints Realty
$849,999 (USD)
Navarre Area Single Family Home
Active
9202 E River Drive Navarre, FL 32566
4 Bed
3 Baths
4200 sqft
MLS# 1012155
An amazing purchase, fantastic place to live. This beautifully maintained 4-bedroom, 3-bathroom home offers 4,200+ SF of thoughtfully designed living space on 1.2 acres. Backed up to greenspace, the backyard offers exceptional privacy and room to relax/entertain. Home is entered through a screened covered porch. Open the door and you are greeted with a large living area with wood flooring. The family room is separated and also has wood flooring. The kitchen features stainless steel appliances with custom oak cabinets and island w/sink and granite countertops, breakfast nook and pantry. The Master Bedroom is huge, featuring 2 walk-in closets where one doubles as a Disaster Safe Room. The Master Bathroom has stained oak wood cabinets/granite counter tops his/her sinks on opposite walls, walk-in shower and a Senior Jetted Walk-in Tub. Each bathroom has stained oak wood cabinets w/granite tops and Delta Bathroom accessories and Jacuzzi jetted bathtubs. For your comfort, the home has two HVAC systems and two tankless water heaters. This property offers several other bonus options such as a screened back porch, oversized 2-car garage and 18'x16' Gazebo with wired light/fan and steel sink. Seller includes a 48'x30' Steel Barn with auto rollup door w/purchase (No electricity, conveys AS IS). This home benefits from no HOA, closeness to beach, restaurants, great schools, and abundance of the Emerald Coast water activities. The home is also handicap accessible.
Listing Courtesy of EMERALD COAST / Listed By: Arthur Blakely, Century 21 Allpoints Realty
$845,000 (USD)
Cape Coral Area Single Family Home
Active
2104 SW 28th Lane Cape Coral, FL 33914
4 Bed
3 Baths
2598 sqft
MLS# 2026028578
Experience true Florida living in this beautifully appointed home perfectly positioned right on the waterfront offered fully furnished and professionally decorated. Bright, airy, and designed for comfort, this residence features an open-concept layout with Sliding glass doors and windows that fill the home with natural light and provide gorgeous water views throughout.
Enjoy the comfort of two spacious and separate living areas, each offering stunning pool and water views.
The gourmet kitchen offers modern stainless steel appliances, custom cabinetry's, generous counter space, and a spacious island ideal for entertaining.
The spacious primary suite offers pool and water views, two walk-in closets, and an ensuite bathroom with dual vanities and a walk-in shower.
The three additional fully furnished bedrooms and a full bathroom are conveniently located on the opposite side, making it ideal for family, guests.
Step outside to your private tropical oasis, complete with a sparkling pool & spa, screened lanai, and ample patio space for sunbathing, outdoor dining, or evening relaxation by the water. With direct gulf water access this home blends indoor comfort with the best of outdoor Florida living. Located in a safe, quiet, and highly sought-after neighborhood, this home is close to top-rated schools, shopping, dining, golf courses and Sands Park. This property thrives in a high-performing rental program with year-round demand, generated an impressive income the last years and already has bookings secured through March 2027.
This home is truly turnkey—just bring your suitcase and start living the waterfront lifestyle.
Enjoy the comfort of two spacious and separate living areas, each offering stunning pool and water views.
The gourmet kitchen offers modern stainless steel appliances, custom cabinetry's, generous counter space, and a spacious island ideal for entertaining.
The spacious primary suite offers pool and water views, two walk-in closets, and an ensuite bathroom with dual vanities and a walk-in shower.
The three additional fully furnished bedrooms and a full bathroom are conveniently located on the opposite side, making it ideal for family, guests.
Step outside to your private tropical oasis, complete with a sparkling pool & spa, screened lanai, and ample patio space for sunbathing, outdoor dining, or evening relaxation by the water. With direct gulf water access this home blends indoor comfort with the best of outdoor Florida living. Located in a safe, quiet, and highly sought-after neighborhood, this home is close to top-rated schools, shopping, dining, golf courses and Sands Park. This property thrives in a high-performing rental program with year-round demand, generated an impressive income the last years and already has bookings secured through March 2027.
This home is truly turnkey—just bring your suitcase and start living the waterfront lifestyle.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Heiko Strauss, Century 21 Allpoints Realty
$834,900 (USD)
Moorgate Point Area Single Family Home
Active
7587 Moorgate Point Way Naples, FL 34113
3 Bed
2 Baths
2107 sqft
MLS# 226035416
Welcome to Moorgate Point where this inviting three-bedroom, two-bath attached villa
pairs effortless Florida living with exceptional lake and golf course views. The bright,
open floor plan features easy care tile and laminate flooring throughout, creating a
seamless flow for everyday living and entertaining. Step outside to your private outdoor
retreat, where a pool and spa are framed by a picture-window screen designed to
showcase wide, unobstructed views across the long lake to the manicured golf course
beyond. The spacious lanai is the perfect setting for quiet sunrise coffee, relaxed
afternoons poolside, or evening gatherings with friends. Inside, the thoughtfully
designed layout provides comfortable separation and privacy for both owners and
guests. Each bedroom is generously sized, while the primary suite offers a peaceful
escape with direct access to the scenic outdoor views. Residents enjoy access to the
renowned, eight-time Club of the Year Players Club & Spa, featuring the signature
waterfall pool, tiki hut, premier tennis and pickleball courts, gourmet dining, a state-of-
the-art fitness center, and full-service spa. Three championship golf courses complete
the exceptional lifestyle package. Enjoy the beauty, amenities, and easygoing luxury of
Southwest Florida from this well-positioned villa. This home is truly a sanctuary for
those who appreciate fine views and relaxed, refined living. Start living your best life
today. Live, Laugh, and Love the Lely Lifestyle!
pairs effortless Florida living with exceptional lake and golf course views. The bright,
open floor plan features easy care tile and laminate flooring throughout, creating a
seamless flow for everyday living and entertaining. Step outside to your private outdoor
retreat, where a pool and spa are framed by a picture-window screen designed to
showcase wide, unobstructed views across the long lake to the manicured golf course
beyond. The spacious lanai is the perfect setting for quiet sunrise coffee, relaxed
afternoons poolside, or evening gatherings with friends. Inside, the thoughtfully
designed layout provides comfortable separation and privacy for both owners and
guests. Each bedroom is generously sized, while the primary suite offers a peaceful
escape with direct access to the scenic outdoor views. Residents enjoy access to the
renowned, eight-time Club of the Year Players Club & Spa, featuring the signature
waterfall pool, tiki hut, premier tennis and pickleball courts, gourmet dining, a state-of-
the-art fitness center, and full-service spa. Three championship golf courses complete
the exceptional lifestyle package. Enjoy the beauty, amenities, and easygoing luxury of
Southwest Florida from this well-positioned villa. This home is truly a sanctuary for
those who appreciate fine views and relaxed, refined living. Start living your best life
today. Live, Laugh, and Love the Lely Lifestyle!
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Tony Cologero, Century 21 Allpoints Realty
$825,000 (USD)
Hartford Area Commercial
Active
530 Farmington Avenue Hartford, CT 06105
0 Bed
2 Baths
3072 sqft
MLS# 24202875
TRIPLE-NET SALE! Situated along the major Farmington Avenue corridor in the vibrant West End neighborhood of Hartford, you will find this great income-producing commercial building resting on a prominent corner lot, featuring two curb cuts, one from Kenyon Street and one from Farmington Avenue. The property offers a private parking lot, as well as on-street parking, allowing you to capitalize on both foot and motorized traffic. The close proximity to Asylum Hill and local educational facilities creates consistent, recurring traffic patterns that contribute to a strong and profitable environment for your venture. The land and building sit on 0.32 acres. A huge benefit to this triple-net sale is the long-standing and notable eatery occupying the property, which has been recognized as one of West Hartford's top-rated restaurants from 2021-2025. With its highly visible corner location, excellent accessibility, dedicated parking, established tenancy, and strong surrounding traffic, this property presents an excellent opportunity for an investor seeking an income-producing commercial asset.
Listing Courtesy of SMART MLS / Listed By: Bob Virgulak, Century 21 Allpoints Realty
$823,800 (USD)
Cape Coral Area Single Family Home
Active
2018 SW 30th Terrace Cape Coral, FL 33914
4 Bed
3 Baths
1983 sqft
MLS# 2026043880
Welcome to a beautifully designed, light-filled waterfront home where timeless finishes, quality construction & expansive outdoor living spaces come together. The Southern exposure & open concept offers a seamless flow for the indoor-outdoor Florida living. The kitchen features custom countertops, upgraded cabinetry, stainless-steel appliances and a generous island with seating—ideal for everyday living and entertaining.
Mature landscaping & outdoor lighting enhances the private outdoor oasis. Boating enthusiasts will appreciate the covered boat dock & lift that is boat ready. No waiting to start enjoying the waterfront lifestyle.
Built with ICF construction & impact windows and doors add both style and peace of mind including being generator ready. New Tile Roof and oversized bay window pool cage was replaced in 2023.
Freshly painted interior features elegant plantation shutters & crown moulding throughout, whole house water softener with under the sink RO. The 3 Bedrooms & 3 bathrooms plus a home office provides both comfort & functionality. The garage floor boasts new epoxy.
Step outside to a custom pool featuring a swim-up bar, bubblers on the sun shelf, water feature & outdoor shower all enclosed by an expansive bay-window screening for unobstructed views.
You will enjoy peaceful canal views, your boat in your backyard, resort style pool & lush tropical surroundings. Complete with a two-car garage and a desirable Southwest Cape Coral location, this home is ready to impress.
Mature landscaping & outdoor lighting enhances the private outdoor oasis. Boating enthusiasts will appreciate the covered boat dock & lift that is boat ready. No waiting to start enjoying the waterfront lifestyle.
Built with ICF construction & impact windows and doors add both style and peace of mind including being generator ready. New Tile Roof and oversized bay window pool cage was replaced in 2023.
Freshly painted interior features elegant plantation shutters & crown moulding throughout, whole house water softener with under the sink RO. The 3 Bedrooms & 3 bathrooms plus a home office provides both comfort & functionality. The garage floor boasts new epoxy.
Step outside to a custom pool featuring a swim-up bar, bubblers on the sun shelf, water feature & outdoor shower all enclosed by an expansive bay-window screening for unobstructed views.
You will enjoy peaceful canal views, your boat in your backyard, resort style pool & lush tropical surroundings. Complete with a two-car garage and a desirable Southwest Cape Coral location, this home is ready to impress.
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Carolyn Gardewine, Century 21 Allpoints Realty
$819,000 (USD)
Niceville Area Single Family Home
Active
4342 Sunset Beach Circle Niceville, FL 32578
4 Bed
5 Baths
2916 sqft
MLS# 1013655
Hebel Block Construction in a Resort style living in Bluewater Bay FL! Amazing clubhouse, pool, bay front access, security gate with a full time guard on duty. Spacious chef's kitchen featuring large center island, 5-Burner gas cooktop and double oven. Enter the front door and you will walk straight into a large entertaining room with 24 ft ceilings, stone fireplace, and built-in mini bar with wine refrigerator. Take in the gorgeous view of the lake and 6th tee box from your glass sunroom out back. Large custom sitting area in back of home with covered pergola and lush landscaping. All four bedrooms have their own private, full bath! One year old roof. Extensive upgrades in past 5 years such as, New paint inside and out, LVP flooring, renovated bathrooms and landscaping, 2 HVAC units. This is truly a LUXURY home in a premier location .Sunset beach HOA provides an amazing clubhouse and pool, bay front access for boating, kayaking, a sandy beach and chairs to watch sunsets, all lawn care and lawn watering, a security gate with a guard on duty.. It is a very active HOA with regular gatherings at the club house for Holidays, special events and so forth. The large resort pool overlooks the bay and pool seating is provided. Come and walk through this home and I think you will be glad you did. There has been so many expensive upgrades done in the past five years that make this home a ''Turn Key '' home and ready to enjoy with four master suites !
Listing Courtesy of EMERALD COAST / Listed By: Jerry "Jay" Boxberger, Century 21 Allpoints Realty
$800,000 (USD)
Sarasota Area Single Family Home
Active
434 S Shore Drive Sarasota, FL 34234
3 Bed
2 Baths
1912 sqft
MLS# A4710735
Mid-Century Modern Gem with Pool, Character & Endless Potential in Indian Beach Sapphire Shores.
Bring your vision and creativity to this mid-century modern home in the highly desirable Indian Beach Sapphire Shores subdivision! Offering 3 bedrooms, 2 bathrooms, and a desirable split-bedroom floor plan, this property is full of character and ready for someone with the imagination to restore it to its former glory.
Inside, you’ll find beautiful wood ceilings accented by exposed beams, adding warmth and architectural charm throughout the home. A wood-burning fireplace creates a welcoming focal point, while the in-ground swimming pool and expansive yard offer plenty of space for outdoor living, entertaining, and creating your own private retreat. Partial water views from the rear of the property add another special touch.
This property requires substantial repairs and is being offered cash only, as-is. It presents an opportunity for investors, renovators, or buyers looking for a project with distinctive architectural character, a generous lot, and a desirable location. Utilities have been turned off for some time. Buyer will need to complete inspections prior to making an offer.
With its mid-century modern appeal, spacious grounds, pool, and unique setting in Indian Beach Sapphire Shores, this property offers the opportunity to bring new life to a home with plenty of potential. Bring your contractor and your imagination and explore the possibilities!
Bring your vision and creativity to this mid-century modern home in the highly desirable Indian Beach Sapphire Shores subdivision! Offering 3 bedrooms, 2 bathrooms, and a desirable split-bedroom floor plan, this property is full of character and ready for someone with the imagination to restore it to its former glory.
Inside, you’ll find beautiful wood ceilings accented by exposed beams, adding warmth and architectural charm throughout the home. A wood-burning fireplace creates a welcoming focal point, while the in-ground swimming pool and expansive yard offer plenty of space for outdoor living, entertaining, and creating your own private retreat. Partial water views from the rear of the property add another special touch.
This property requires substantial repairs and is being offered cash only, as-is. It presents an opportunity for investors, renovators, or buyers looking for a project with distinctive architectural character, a generous lot, and a desirable location. Utilities have been turned off for some time. Buyer will need to complete inspections prior to making an offer.
With its mid-century modern appeal, spacious grounds, pool, and unique setting in Indian Beach Sapphire Shores, this property offers the opportunity to bring new life to a home with plenty of potential. Bring your contractor and your imagination and explore the possibilities!
Listing Courtesy of 
STELLAR as distributed by MLS GRID / Listed By: Alison Cochran, Century 21 Allpoints Realty
STELLAR as distributed by MLS GRID / Listed By: Alison Cochran, Century 21 Allpoints Realty
$800,000 (USD)
Marco Island Area Single Family Home
Active
340 Regatta Street Marco Island, FL 34145
3 Bed
2 Baths
1493 sqft
MLS# 226033135
Enjoy Island living in this spacious home. Large tile with a diagonal design in the main living area, and wood grain vinyl flooring in the master bedroom with a slider to the outside living area. The kitchen boasts a lighted tray ceiling with beautiful cabinetry, stainless steel appliances and a window and slider that brings the outdoors into the home, great for entertaining. Additional features include a large laundry room with a sink and plenty of shelving for storage. You will enjoy hours in your expansive covered lanai, relaxing in the pool and plenty of privacy in the fenced in the back yard. The home is located around the corner from Mackle Park, YMCA, LIBRARY, Tommie Barfield Charter School, and Marco Island restaurants and shops!!!
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Yoli Arias, Century 21 Allpoints Realty
$799,900 (USD)
Fairfield Area Single Family Home
Pending
1012 Reef Road Fairfield, CT 06824
2 Bed
1 Baths
1098 sqft
MLS# 24216112
Location, Location, Location! Enjoy the very best of Fairfield from this lovingly maintained 2-bedroom, 1.5-bath Ranch offering 1,098 square feet of comfortable living space and a detached 1-car garage, all just a short stroll to the beach. Ideally situated near the heart of Fairfield, this wonderful home offers the ultimate in convenience and coastal charm! Enjoy the fabulous restaurants and shops in downtown Fairfield, or hop on the train. Lovingly cared for over the years, the home was raised in 1986 and features natural gas heat and central air conditioning. Whether you're looking to downsize or expand this is a fantastic opportunity! Call the assessor for information on the prorated tax the new buyer will pay.
Listing Courtesy of SMART MLS / Listed By: Karin Stocknoff, Century 21 Allpoints Realty
$799,900 (USD)
Wolcott Area Single Family Home
Active
112 Idlewood Road Wolcott, CT 06716
4 Bed
4 Baths
4112 sqft
MLS# 24201653
Welcome to 112 Idlewood Rd in Wolcott CT offering a distinctive custom Victorian Colonial set on approx 3 private acres w over 4000 SF of living space and a picturesque private brook fed pond w fountain This impressive 4 BR 2 full BA 2 half BA home offers exceptional space character privacy and versatility A wide wraparound porch w gazebo overlooks the beautiful grounds and provides the perfect setting for relaxing and entertaining Inside find abundant natural light HW floors crown molding and generous living spaces Spacious EIK features granite counters breakfast bar newer SS appl and views of the backyard and pond Expansive family rm offers built ins and a wood stove Exceptional 1st fl primary suite features HW floors WIC private BA and oversized jetted indoor spa beneath a dramatic 2 story round tower ceiling plus slider to the backyard 1st fl laundry and office add convenience Upstairs offers 3 additional BRs plus 2nd kitchen providing excellent in law or guest potential Walk up attic and lower level rec space provide additional possibilities Oversized 4+ car garage fits up to 6 vehicles w workshop and storage Barn outbuilding w water and electric offers equestrian hobby or gathering potential Enjoy fishing for bass in summer and winter skating on the pond when conditions allow Andersen windows 2 AC units 2 zone heat dual access driveway newer exterior paint roof approx 12 yrs well pump and WH replaced 2022 A truly unique New England estate
Listing Courtesy of SMART MLS / Listed By: David Hughes, Century 21 Allpoints Realty
$799,900 (USD)
Manchester Area Commercial
Active
46 Apel Place Manchester, CT 06042
0 Bed
1 Baths
77569 sqft
MLS# 24200106
Whether you need space for production, storage or operations, this facility is designed to support your business success. Expansive multi-building warehouse/manufacturing complex on 6.8 acres. Offering a series of small, med. and large warehouses, an office building and an 11 bay service garage with warehouse space and additional office space. This property is ideal for light industrial and a variety of commercial/industrial operations. Multiple warehouse buildings are perfect for storage, manufacturing or distribution. Convenient on site office space to manage operations. High ceilings, large doors, loading docks and parking areas accommodate trucks, employees, trailers, machinery and equipment with ease. Service garage can be equipped for fleet servicing, storage or converted to complimentary usable space. Easy access to major highways, shipping routes and local business hubs. Ideal for logistics and distribution centers, light manufacturing, storage and warehousing, construction and trade businesses. Clean phase 1 and 2 study available.
Listing Courtesy of SMART MLS / Listed By: Denise Reale, Century 21 Allpoints Realty
$799,000 (USD)
Woodlawn Unit 2 Area Single Family Home
Active
405 Bay Shore Drive Panama City Beach, FL 32407
3 Bed
2 Baths
1968 sqft
MLS# 790982
191 FEET OF WATERFRONT • 0.55 ACRE • NO HOA • PRIVATE DOCK & BOAT LIFT • DIRECT BAY ACCESS
Opportunities like this are increasingly difficult to find in Panama City Beach. Situated on more than half an acre in the established Woodlawn community, this canal-front property offers approximately 191 feet of seawall frontage, a private dock, substantial boat and RV parking, and direct access to St. Andrews Bay and the Gulf of Mexico.
For boaters, this property is the main event. The wide canal measures approximately 80 feet across and averages 5-6 feet deep at center, providing excellent maneuverability and access for larger vessels. The private dock features an I-beam boat lift capable of accommodating a vessel up to approximately 30 feet, allowing you to keep your boat at home and be on St. Andrews Bay in minutes.
From your backyard, spend the morning fishing, cruise to Shell Island for the afternoon, visit one of the area's boat-accessible restaurants, or finish the day with a sunset ride across the bay. This is the kind of property where boating isn't something you plan around--it becomes part of everyday life.
The 0.55-acre lot and approximately 191 feet of waterfront provide a combination of space and shoreline that can be difficult to replicate. A wide electronic gate, extensive paver area, and dedicated space for a boat trailer or RV add even more flexibility--all with NO HOA.
Built in 1958, the 3-bedroom residence reflects the Old Florida character of Woodlawn, one of the area's earlier planned waterfront communities. Inside, you'll find 2 full bathrooms plus a convenient half bath near the garage, along with a Florida room that expands the living space and creates an easy transition between the home and waterfront.
Unique features give the property additional character, including a built-in mini bar, covered outdoor patio, and built-in BBQ grill with a functioning flue system--an ideal setup for entertaining after a day on the water.
And while the property feels tucked away from the busier tourist corridor, the location remains exceptionally convenient. Historic St. Andrews, Downtown Panama City, restaurants, shopping, and entertainment are just minutes away, while Panama City Beach and Pier Park are within an easy drive.
This isn't simply a home near the water--it's a waterfront property built around the boating lifestyle. With approximately 191 feet of seawall, more than half an acre, a private dock and boat lift, room for your boat or RV, direct access to St. Andrews Bay, and no HOA, 405 Bay Shore Drive offers a combination that's increasingly hard to find.
Bring your boat and come experience what waterfront living in Panama City Beach can look like.
Opportunities like this are increasingly difficult to find in Panama City Beach. Situated on more than half an acre in the established Woodlawn community, this canal-front property offers approximately 191 feet of seawall frontage, a private dock, substantial boat and RV parking, and direct access to St. Andrews Bay and the Gulf of Mexico.
For boaters, this property is the main event. The wide canal measures approximately 80 feet across and averages 5-6 feet deep at center, providing excellent maneuverability and access for larger vessels. The private dock features an I-beam boat lift capable of accommodating a vessel up to approximately 30 feet, allowing you to keep your boat at home and be on St. Andrews Bay in minutes.
From your backyard, spend the morning fishing, cruise to Shell Island for the afternoon, visit one of the area's boat-accessible restaurants, or finish the day with a sunset ride across the bay. This is the kind of property where boating isn't something you plan around--it becomes part of everyday life.
The 0.55-acre lot and approximately 191 feet of waterfront provide a combination of space and shoreline that can be difficult to replicate. A wide electronic gate, extensive paver area, and dedicated space for a boat trailer or RV add even more flexibility--all with NO HOA.
Built in 1958, the 3-bedroom residence reflects the Old Florida character of Woodlawn, one of the area's earlier planned waterfront communities. Inside, you'll find 2 full bathrooms plus a convenient half bath near the garage, along with a Florida room that expands the living space and creates an easy transition between the home and waterfront.
Unique features give the property additional character, including a built-in mini bar, covered outdoor patio, and built-in BBQ grill with a functioning flue system--an ideal setup for entertaining after a day on the water.
And while the property feels tucked away from the busier tourist corridor, the location remains exceptionally convenient. Historic St. Andrews, Downtown Panama City, restaurants, shopping, and entertainment are just minutes away, while Panama City Beach and Pier Park are within an easy drive.
This isn't simply a home near the water--it's a waterfront property built around the boating lifestyle. With approximately 191 feet of seawall, more than half an acre, a private dock and boat lift, room for your boat or RV, direct access to St. Andrews Bay, and no HOA, 405 Bay Shore Drive offers a combination that's increasingly hard to find.
Bring your boat and come experience what waterfront living in Panama City Beach can look like.
Listing Courtesy of CENTRAL PANHANDLE / Listed By: Jason Maddux, Century 21 Allpoints Realty
$799,000 (USD)
Brookside Area Single Family Home
Active
3 Topping Lane Norwalk, CT 06854
3 Bed
3 Baths
1342 sqft
MLS# 24213906
Back on the Market Newly Improved! Beautifully renovated and move-in ready, this home sits on a private 0.57-acre lot in Norwalk's desirable Brookside neighborhood. Features include soaring 16-foot ceilings, abundant natural light, wooded views, refinished hardwood floors, a modern kitchen with stainless steel appliances and granite countertops, and fully renovated bathrooms. The main level offers two bedrooms, a full bath, a half bath, laundry, and an additional room ideal for a small bedroom, walk-in closet, or storage. The walkout lower level features a third bedroom, full bath, and flexible living space perfect for an in-law apartment, guest suite, or home office. Enjoy a private backyard with a fire pit, natural boulder walls, a one-car garage, and an oversize newly asphalted driveway with parking for up to six vehicles. This property is fully renovated with all permits closed and architectural revisions completed, this home offers privacy, versatility, and modern living in a sought-after neighborhood. Recent Improvement: The original spiral staircase connecting the main level to the lower level has been replaced with a full-size staircase, providing improved comfort, accessibility, and functionality. Investment Opportunity: Currently tenant-occupied, generating $5,500 per month in rental income. Lease expires November 30, 2026.
Listing Courtesy of SMART MLS / Listed By: Jury Caceres, Century 21 Allpoints Realty
$789,900 (USD)
Tapestry Park Area Single Family Home
Active
312 Columbus Street Panama City Beach, FL 32407
3 Bed
3 Baths
2937 sqft
MLS# 796207
Basically New Construction Without the Wait! This meticulously cared-for custom-built 3-bedroom, 3-bath home with full size office in the highly desirable Tapestry Park community of Panama City Beach looks and feels like a brand-new home--without the construction timeline or hassle. Built in 2018 and exceptionally maintained, this home is truly move-in ready, with no marks, wear, or projects waiting for its new owner.
Inside, you'll find an inviting open-concept layout with 10 foot high ceilings, engineered hardwood and tile flooring, quality custom finishes, and plenty of natural light. The kitchen features stainless steel appliances, waterfall island, ample cabinetry, and a functional design perfect for everyday living or entertaining. On your way upstairs, you will find a shiplap staircase leading to 3 bedrooms with custom closet organizers that provide exceptional storage and organization. Washer and dryer on first level convey with the home for added convenience.
And the value here is hard to overlook. Priced extremely well for the size of the home, the custom construction, and the highly desirable neighborhood, this property offers an opportunity to get more for your money without sacrificing quality, location, or amenities. It's the kind of home that checks all the boxes and is exceptionally difficult to replicate at this price point.
Location is hard to beat. This home sits directly across from the community clubhouse and pool, with easy access to the basketball and tennis courts--making the amenities feel like an extension of your own backyard. When it's time to enjoy the best of Panama City Beach, you're just minutes from the sugar-white sand and emerald waters of the Gulf, as well as dining, shopping, entertainment, and everything that makes PCB such a sought-after coastal destination.
Whether you're looking for a full-time residence, second home, or investment property, this is a rare opportunity to own a home that truly feels like new construction, without the wait. Meticulously maintained, beautifully finished, custom built, and ideally located in the heart of Panama City Beach--this one is ready to enjoy from day one.
Inside, you'll find an inviting open-concept layout with 10 foot high ceilings, engineered hardwood and tile flooring, quality custom finishes, and plenty of natural light. The kitchen features stainless steel appliances, waterfall island, ample cabinetry, and a functional design perfect for everyday living or entertaining. On your way upstairs, you will find a shiplap staircase leading to 3 bedrooms with custom closet organizers that provide exceptional storage and organization. Washer and dryer on first level convey with the home for added convenience.
And the value here is hard to overlook. Priced extremely well for the size of the home, the custom construction, and the highly desirable neighborhood, this property offers an opportunity to get more for your money without sacrificing quality, location, or amenities. It's the kind of home that checks all the boxes and is exceptionally difficult to replicate at this price point.
Location is hard to beat. This home sits directly across from the community clubhouse and pool, with easy access to the basketball and tennis courts--making the amenities feel like an extension of your own backyard. When it's time to enjoy the best of Panama City Beach, you're just minutes from the sugar-white sand and emerald waters of the Gulf, as well as dining, shopping, entertainment, and everything that makes PCB such a sought-after coastal destination.
Whether you're looking for a full-time residence, second home, or investment property, this is a rare opportunity to own a home that truly feels like new construction, without the wait. Meticulously maintained, beautifully finished, custom built, and ideally located in the heart of Panama City Beach--this one is ready to enjoy from day one.
Listing Courtesy of CENTRAL PANHANDLE / Listed By: Chris Jennings, Century 21 Allpoints Realty
$784,900 (USD)
Southington Area Single Family Home
Active
558 Lazy Lane Southington, CT 06489
4 Bed
3 Baths
2480 sqft
MLS# 24164849
New Construction - Great Location! Custom designed and built Colonial style property, by local architect R.D. Wolf Inc. 4 bedrooms, 2.5 baths, spacious room above garage, 2 car attached garage, and 2480 sq. ft. of living space. Main floor offers a custom, wide open design for easy living and entertaining. Double hung thermopane , tilt-in windows installed throughout the house and added insulation make the property extremely energy efficient. A large Bluestone patio is just steps away from the spacious family room through the large sliding doors. The attached 23' x 23' two car garage, with a bump-out storage area, provide ample space for vehicle and seasonal item storage. The covered front porch, with composite Trex decking and beadboard ceiling, create the perfect location for relaxing and conversation. A full basement, 940+ sq. feet with a hatchway access, provides numerous opportunities for finishing and or creating a workshop / recreation area. Mechanicals located at basement end for full basement finishing.
Listing Courtesy of SMART MLS / Listed By: Robert Mlynick, Century 21 Allpoints Realty
$779,900 (USD)
Providence Area Multi-Family Home
Pending
132 Putnam Street Providence, RI 02909
9 Bed
4 Baths
5500 sqft
MLS# 1421647
Calling investors or homeowner occupied for this 4 family house, totally rented, producing over $80,000 a year from rental income. Do not let this opportunity to pass by, if you are looking for a multifamily house to live in, or for investment. This property consist of two buildings, one with three units and the other building with a single family house, on the same lot.
Listing Courtesy of RHODE ISLAND / Listed By: Gustavo Sanchez, Century 21 Allpoints Realty
$754,000 (USD)
Bluewater Bay Home For Sale
Active
343 Oaklake Lane Niceville, FL 32578
3 Bed
2 Baths
2403 sqft
MLS# 987235
Some homes offer more square footage. Few offer more life. At the end of a quiet Bluewater Bay cul-de-sac, situated on 0.40 acres, 343 Oaklake Lane was designed around the moments you'll remember most. Its standout feature is something rarely found: an incredible 833 SF screened porch that functions as a true extension of the home. Morning coffee, game-day gatherings, dinner w/friends or a quiet evening outside, you have space for multiple seating/dining areas. This is your outdoor living room designed to be enjoyed.
When the weather shifts, the heated/cooled Florida room keeps the connection between indoor/outdoor living alive. Envision a home gym, art studio, game room, office, or relaxed lounge space, it adapts to the way you live. Each space flows effortlessly to the next. The chef's kitchen anchors it all w/stunning quartzite countertops, solid maple cabinetry, & premium stainless-steel appliances. Elevate your cooking game: easy meal prep, holiday entertaining, a natural gathering place where conversations begin & memories are made. The hard work is done: Spray-foam insulation, premium Trane HVAC system, copper wiring, & hurricane upgrades buyers appreciate.
Bluewater Bay lifestyle offers golf, tennis, pickleball, swimming, walking paths, parks, waterfront dining, & marina access nearby. Minutes to Destin's white-sand beaches, shopping & dining. This isn't simply a house w/a great porch. It's a home designed for the way people actually want to live.
When the weather shifts, the heated/cooled Florida room keeps the connection between indoor/outdoor living alive. Envision a home gym, art studio, game room, office, or relaxed lounge space, it adapts to the way you live. Each space flows effortlessly to the next. The chef's kitchen anchors it all w/stunning quartzite countertops, solid maple cabinetry, & premium stainless-steel appliances. Elevate your cooking game: easy meal prep, holiday entertaining, a natural gathering place where conversations begin & memories are made. The hard work is done: Spray-foam insulation, premium Trane HVAC system, copper wiring, & hurricane upgrades buyers appreciate.
Bluewater Bay lifestyle offers golf, tennis, pickleball, swimming, walking paths, parks, waterfront dining, & marina access nearby. Minutes to Destin's white-sand beaches, shopping & dining. This isn't simply a house w/a great porch. It's a home designed for the way people actually want to live.
Listing Courtesy of EMERALD COAST / Listed By: Kenneth Wright, Century 21 Allpoints Realty
$749,900 (USD)
Woodbury Area Single Family Home
Active
24 Scuppo Road Woodbury, CT 06798
6 Bed
4 Baths
5815 sqft
MLS# 24187148
Impressive and spacious 5,815 sq. ft. well maintained residence with BRAND NEW ROOF and all new skylight windows(installed 8/15/26) offering exceptional one-level living with 6 bedrooms, 4 full bathrooms, and an oversized heated 3-car garage. A welcoming 12' x 9' slate-floor foyer introduces the home and leads to generously proportioned living spaces designed for both everyday comfort and entertaining. The oversized formal dining room provides an impressive setting for large gatherings, while the well-appointed kitchen features granite countertops, a casual eat-in area, double Viking ovens, a Viking 6-burner cooktop, and Miele dishwasher. Two fireplaces add warmth and character throughout the home, while a whole-house sound system enhances both indoor and outdoor entertaining. The expansive 37' x 23' heated three-car garage offers abundant room for vehicles, storage, hobbies, or workshop space, feel secure with a whole house generator. Outdoors, enjoy a large slate patio entertainment area complete with a wood-fired grill, overlooking a spacious, level yard with plenty of room for recreation and gatherings. With six bedrooms, expansive living areas, quality amenities, and the convenience of true one-level living, this distinctive Woodbury property offers an exceptional combination of space, comfort, and versatility.
Listing Courtesy of SMART MLS / Listed By: David Hughes, Century 21 Allpoints Realty
$725,000 (USD)
West Suffield Area Single Family Home
Active
309 North Grand Street Suffield, CT 06093
4 Bed
3 Baths
3159 sqft
MLS# 24213227
Experience the perfect blend of timeless charm and modern convenience in this beautifully updated 3,100-square-foot farmhouse. Set on over three acres, this exceptional property is ideal for equestrian enthusiasts or those seeking a private retreat. The home features four spacious bedrooms, including a primary suite with an ensuite bath, a private office, and an inviting main living area. Enjoy outdoor entertaining on the new patio or within the expansive, fenced grounds. The estate is complete with an detached two-car garage, a two-story barn with horse stalls, and a large, refurbished tobacco barn with a newer roof offering incredible potential for storage or supplemental rental income. A rare opportunity to embrace a classic country lifestyle in a premier Suffield location.
Listing Courtesy of SMART MLS / Listed By: Robert Mlynick, Century 21 Allpoints Realty
$725,000 (USD)
Barry Square Area Multi-Family Home
Active
229 Franklin Avenue Hartford, CT 06114
12 Bed
6 Baths
5248 sqft
MLS# 24192419
Exceptional Investment Opportunity in the Heart of Hartford's Little Italy! Welcome to 229 Franklin Avenue, a well-maintained 6-unit brick apartment building with condominium tax status, offering an outstanding opportunity for investors seeking strong cash flow and long-term value. The property features six spacious two-bedroom, one-bathroom apartments, each offering generous floor plans with hardwood flooring, bright living and dining areas, eat-in kitchens with dishwashers, remodeled kitchens and bathrooms, stacked in-unit laundry, exposed brick accents, and foyer coat closets. Recent capital improvements include a 2-year-old flat rubber roof with a 25-year warranty, replacement windows, updated electrical service with individual subpanels, and separate tenant-paid natural gas heat and hot water, which minimizes owner expenses. The attractive brick exterior provides timeless curb appeal, and the property also offers off-street parking for tenant convenience. Located in the heart of Hartford's historic Little Italy neighborhood, this property is just minutes from Downtown Hartford, Hartford Hospital, Trinity College, Bushnell Park, major highways, restaurants, shopping, and public transportation. Benefiting from condominium tax status and a prime location in one of Hartford's most established neighborhoods, this is an excellent opportunity to add a quality multifamily asset to your investment portfolio.
Listing Courtesy of SMART MLS / Listed By: Tyler DeVecchis, Century 21 Allpoints Realty
$719,999 (USD)
Guilford Area Condo
Active
20 Long Hill Farm Guilford, CT 06437
3 Bed
2 Baths
2645 sqft
MLS# 24186957
Welcome to Long Hill Farm - where everyday life feels a little like a fairytale. Tucked into the serene Guilford countryside, this free-standing residence has been lovingly remodeled to deliver a lifestyle you'll adore: a rare blend of privacy, luxury, and easy, joyful living, all anchored by a private heated in-ground pool that feels like your very own slice of paradise. Step inside, where gleaming new hardwood floors flow throughout the majority of the home. The graceful open floor plan gathers the living and dining spaces around a crackling wood-burning fireplace - the kind of spot made for slow mornings and storybook evenings. The primary suite is a dreamy retreat all its own, crowned by a soaring cathedral ceiling with exposed beams, a walk-in closet, full bath, and glass sliders that invite the outdoors in. A second bedroom and full bath complete the main level, while a third bedroom charms with custom built-ins and a private balcony. Up above, a spacious loft floats over the living room, perfect for curling up with a good book. Wrapped in lush greenery and mature trees yet just minutes to Route 1, commuter rail, and the historic Guilford Green - and perfectly poised between New York City and Boston - this is shoreline-adjacent living at its most enchanting. A turn-key sanctuary you'll be proud, and delighted, to call home. Note AC is being replaced "One of the parties to the LLC has an active real estate license"
Listing Courtesy of SMART MLS / Listed By: Lisa Cozzi, Century 21 Allpoints Realty
$699,900 (USD)
Glastonbury Area Single Family Home
Active
650 Manchester Road Glastonbury, CT 06033
3 Bed
4 Baths
2218 sqft
MLS# 24212031
Tucked away in a picturesque setting aside Eastbury Pond, this thoughtfully renovated Cape Cod is a warm and inviting retreat. Step inside and you'll find much more than you'd expect, with a flexible layout that adapts to the way you live. With 3 bedrooms + additional office/bedroom and 3.5 bathrooms, this home has plenty of space to spread and grow. Upon entering, you are greeted by a bright living room anchored by a wood-burning fireplace and rustic stone surround. The home flows seamlessly into the remodeled kitchen with granite countertops/backsplash, stainless steel appliances and breakfast bar. The formal dining and family rooms extend your living spaces and offer flexibility. The main level is surrounded by a wraparound porch to enjoy the extensive light and peaceful wooded views. The home includes a first-floor bedroom and full bath along with two upstairs en-suite bedrooms and a home office/additional bedroom. The freshly refinished walk-out lower level adds room for work and play with an updated half bath and laundry room. Additional updates include new windows and new flooring throughout and a 2 year old HVAC system. Shopping, dining and schools are all just minutes away, but this home feels like a quiet escape. Come see this one-of-a-kind home today!
Listing Courtesy of SMART MLS / Listed By: Maddy Ceruti, Century 21 Allpoints Realty
$699,900 (USD)
East Granby Area Single Family Home
Active
116 North Main Street East Granby, CT 06026
3 Bed
3 Baths
2645 sqft
MLS# 24197847
East Granby lot where the Bates Tavern once stood, This custom Colonial, built in 2007, features 2,645 sq ft of bright, open living space on 1.2 private acres abutting protected wetlands for added privacy and natural views. The main level offers a spacious living room with a fireplace and patio access, a beautifully remodeled kitchen with granite counters and breakfast bar, dining nook, and a pantry. Additional first floor features include large full bath with walk-in shower, a bedroom or a versatile home office, large foyer, half bath, cork flooring in kitchen and mudroom, radiant floor heating throughout the home with first and second floor high velocity air conditioning/heat pump system. Upstairs you'll find three generous sized bedrooms, an additional full bath including a primary suite with walk-in closet, large unfinished full bath. Laundry is located on the second floor with storage. A finished bonus room over the garage includes roughed in plumbing for a future in law or studio space. The lower level offers 9' ceilings, potential for additional finished living space. The home includes a 2-car garage and storage shed. Enjoy a private backyard perfect for outdoor activities, plus agricultural zoning. Conveniently located near Bradley International Airport, I91, commuter routes, local amenities, short distance to East Granby Farms Recreation with access to tennis and basketball courts and Metacomet trail
Listing Courtesy of SMART MLS / Listed By: Theresa Paciga, Century 21 Allpoints Realty
$699,500 (USD)
Freeport Area Land
Active
779 Fl-20 Freeport, FL 32439
Bed
0 Baths
sqft
MLS# 992121
PRIME VACANT LAND FOR SALE - FREEPORT, FL. Exceptional 1.00± acre commercial opportunity located directly across from the Walton County Governmental Complex in the heart of rapidly growing Freeport. Positioned along the highly traveled Highway 20 corridor, this high-visibility parcel offers outstanding frontage, strong traffic exposure, and immediate proximity to the area's expanding residential and commercial growth.
Surrounded by major growth drivers including Hammock Bay, Publix, new residential development, and the expanding Highway 331 corridor, the property is ideally suited for professional office, medical, retail, restaurant, financial, service-oriented commercial, or mixed-use development. The site benefits from its strategic location near county administrative offices, creating consistent daytime traffic from contractors, engineers, attorneys, developers, surveyors, inspectors, and surrounding business activity.
Freeport continues to experience substantial population and infrastructure growth as South Walton expansion pushes northward, making this a compelling opportunity for both owner-users and long-term investors seeking positioning within one of Northwest Florida's fastest-growing commercial corridors. Utilities nearby. Excellent accessibility and visibility. Rare opportunity to secure a premier commercial site within the emerging administrative and professional center of Freeport. All information is believed to be accurate but is not guaranteed. Prospective tenants and buyers are responsible for independently verifying all information and determining the property's suitability for their intended use. All final terms are subject to negotiation and shall be set forth in a fully executed commercial lease or sales agreement between the parties.
Surrounded by major growth drivers including Hammock Bay, Publix, new residential development, and the expanding Highway 331 corridor, the property is ideally suited for professional office, medical, retail, restaurant, financial, service-oriented commercial, or mixed-use development. The site benefits from its strategic location near county administrative offices, creating consistent daytime traffic from contractors, engineers, attorneys, developers, surveyors, inspectors, and surrounding business activity.
Freeport continues to experience substantial population and infrastructure growth as South Walton expansion pushes northward, making this a compelling opportunity for both owner-users and long-term investors seeking positioning within one of Northwest Florida's fastest-growing commercial corridors. Utilities nearby. Excellent accessibility and visibility. Rare opportunity to secure a premier commercial site within the emerging administrative and professional center of Freeport. All information is believed to be accurate but is not guaranteed. Prospective tenants and buyers are responsible for independently verifying all information and determining the property's suitability for their intended use. All final terms are subject to negotiation and shall be set forth in a fully executed commercial lease or sales agreement between the parties.
Listing Courtesy of EMERALD COAST / Listed By: Jim Ball, Century 21 Allpoints Realty
$699,000 (USD)
Venetian Village Area Single Family Home
Active
9986 Mar Largo Circle Fort Myers, FL 33919
4 Bed
3 Baths
2470 sqft
MLS# 226029892
Stunning Estate Home in Venetian Village
Welcome to your private Florida paradise on a large corner lot, where elegance, comfort, and resort-style living come together in perfect harmony. This beautifully remodeled 4-bedroom, 3-full-bath residence with a den showcases spacious open-concept living areas, a private dining room, abundant natural light, and seamless indoor-outdoor flow designed for both everyday living and unforgettable entertaining.
The gourmet kitchen serves as the heart of the home, featuring premium finishes, ample cabinetry, new appliances, gorgeous granite countertops, and generous gathering spaces.
This home offers a rare and highly desirable feature: an exceptional floor plan with two private primary suites. Retreat to the first luxurious primary suite, a peaceful sanctuary complete with spa-inspired amenities. The private courtyard provides the perfect space to add a spa, sauna, or private outdoor yoga area.
The second suite offers unparalleled flexibility for multigenerational living, long-term guests, or a luxurious private retreat. Thoughtfully designed with an adjoining den, it can serve as a private sitting room, home office, or additional bedroom, complemented by a full bath for complete comfort and privacy.
Functioning as an ideal guest or in-law suite, this secluded wing is conveniently located off the family room and features its own living area, wet bar with sink, microwave, compact refrigerator, and wine cooler. Guests will enjoy the added convenience of a private double-door entrance from the pool area, creating a true resort-style retreat with independent access and exceptional privacy.
Outside, the solar-heated pool, complete with a built-in pool cooler, boasts southern exposure and is surrounded by an oversized deck with plenty of room for dining, lounging, and entertaining. The tranquil backyard oasis provides ample space to relax, entertain, and embrace the Florida lifestyle year-round.
Ideally situated near shopping, dining, recreation, and just minutes from the Gulf beaches, including the world-famous Sanibel and Captiva Islands, this exceptional property offers the perfect blend of convenience and sophistication. Welcome Home!
Welcome to your private Florida paradise on a large corner lot, where elegance, comfort, and resort-style living come together in perfect harmony. This beautifully remodeled 4-bedroom, 3-full-bath residence with a den showcases spacious open-concept living areas, a private dining room, abundant natural light, and seamless indoor-outdoor flow designed for both everyday living and unforgettable entertaining.
The gourmet kitchen serves as the heart of the home, featuring premium finishes, ample cabinetry, new appliances, gorgeous granite countertops, and generous gathering spaces.
This home offers a rare and highly desirable feature: an exceptional floor plan with two private primary suites. Retreat to the first luxurious primary suite, a peaceful sanctuary complete with spa-inspired amenities. The private courtyard provides the perfect space to add a spa, sauna, or private outdoor yoga area.
The second suite offers unparalleled flexibility for multigenerational living, long-term guests, or a luxurious private retreat. Thoughtfully designed with an adjoining den, it can serve as a private sitting room, home office, or additional bedroom, complemented by a full bath for complete comfort and privacy.
Functioning as an ideal guest or in-law suite, this secluded wing is conveniently located off the family room and features its own living area, wet bar with sink, microwave, compact refrigerator, and wine cooler. Guests will enjoy the added convenience of a private double-door entrance from the pool area, creating a true resort-style retreat with independent access and exceptional privacy.
Outside, the solar-heated pool, complete with a built-in pool cooler, boasts southern exposure and is surrounded by an oversized deck with plenty of room for dining, lounging, and entertaining. The tranquil backyard oasis provides ample space to relax, entertain, and embrace the Florida lifestyle year-round.
Ideally situated near shopping, dining, recreation, and just minutes from the Gulf beaches, including the world-famous Sanibel and Captiva Islands, this exceptional property offers the perfect blend of convenience and sophistication. Welcome Home!
Listing Courtesy of FLORIDA GULF COAST MLS / Listed By: Virginia Lesko, Century 21 Allpoints Realty
TREC Consumer Protection Notice
TREC Information About Brokerage Services
© 2026 MoxiWorks
© CENTURY 21 2023 - 2024. All rights reserved. CENTURY 21®, C21® and the CENTURY 21 Logo are registered service marks owned by Century 21 Real Estate LLC. Franchisee Legal Entity Name (not the dba) fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Century 21 Real Estate LLC nor any of its affiliated companies.
