My Office's Listings - Page 3 - Joseph Scarpellino

$2,500,000

Fair Haven Area Commercial

Active

Address Not Disclosed New Haven, CT 06513

Bed

0 Baths

0 sqft

MLS# 24044458

***OPPORTUNITY ZONE and ENTERPRISE ZONE**** 56K SF on the River! REDEVELOPMENT OPPORTUNITY!! BUYERS TO DO THEIR OWN DD. This property consists of 3 separate parcels and a 100KW Wind Turbine. 17 James St is 28,310 SF consisting of 2,752 SF of office space and 25,558 SF of open warehouse with 12 ft clear ceilings, 1 loading dock and 1 drive in door. This space is currently vacant. 15 James St is 28,649 SF consisting of about 3,500 SF of office and 22,000 SF of warehouse space, 1 loading dock, and 6 drive in doors. 5 James St is .93 Acres of land that abuts the Quinnipiac River, this parcel is fenced in and has plenty of room for outside storage and potential development (buyers would have to perform their own Due Diligence).

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino

$1,300,000

Northford Area Commercial

Active

Address Not Disclosed North Branford, CT 06472

0 Bed

2 Baths

4195 sqft

MLS# 24047863

LOCATION, LOCATION, LOCATION! Northford Center! Mixed Use property, with potential to build another building behind the current property, buyers and agents to perform their own DD. 4 retail and 2 residential units. The end retail unit is empty so it is a great opportunity for an owner user to occupy the property and have the tenants help with your mortgage. All tenants pay their own electric, they are all separately metered. The landlord pays for oil to heat all the units.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino

$975,000

N/A Area Commercial

Active

2-8 Ashburton Place West Haven, CT 06516

0 Bed

24 Baths

3780 sqft

MLS# 24061695

This is for the Investors who would like a special project! A 24 Unit 3 story building with plans and approvals in place for "The Westie", an Inn, with 24 independent efficiency apartments designed complete with full kitchens and baths. Plans including mechanicals are available for serious inquiries. Located in downtown West Haven walkable to local stores, banks, post and on a bus route. University of New Haven and a large VA hospital complex only blocks from this property. The VA offering extended care for our Veteran population in the area. This project can provide housing to visiting families of the University and Hospital and can help to provide housing for short term incoming medical personnel. Short term rents are in demand and this location is centrally located to Yale NH Hospital, Milford Hospital and the VA. The area has an extensive beach and boardwalk to enjoy a walk and the seaside views as a point of interest for potential tenants. This project great potential for an excellent return on investment and future growth!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Barbara Altieri

$899,000

Momauguin Area Single Family Home

Active

254 Cosey Beach Avenue East Haven, CT 06512

3 Bed

2 Baths

1742 sqft

MLS# 24058249

Imagine waking up to this every morning! Welcome to your dream home! This beautifully remodeled 1,742 SF beachfront property offers stunning, unobstructed water views and has been meticulously updated to meet FEMA code standards as of 2012. With 3 spacious bedrooms and 2 full baths, this home provides comfortable living for the entire family. The main level features an open floor plan, ideal for entertaining, complete with a chef's kitchen that boasts a peninsula, granite countertops, and stainless steel appliances. This level also includes a full bathroom and a laundry room for added convenience. Three sliding doors lead out to a Trex deck that spans the entire width of the home, providing the perfect setting for al fresco dining and breathtaking sunset views. Elegant hardwood flooring throughout adds warmth and charm to the space. Step outside to enjoy the expansive outdoor area, perfect for relaxation and entertaining. Under the deck, you'll find a garage door that provides access to the basement storage area, an excellent space for storing all your water toys, paddleboards, kayaks, jet skis, and more. The upper level features three generously sized bedrooms, two of which face the water and have sliders leading to another deck that runs the full width of the home. A full bath with a walk-in shower and frameless glass doors completes this level. The beachfront location offers direct access to the sand and surf, making it a paradise for beach lovers.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino

$799,000

N/A Area Single Family Home

Pending

3 Sarah Drive Oxford, CT 06478

4 Bed

3 Baths

3014 sqft

MLS# 24062085

Welcome to 3 Sarah Drive, a breathtaking 4-bedroom, 2.5-bathroom colonial nestled in one of Oxford's most sought-after neighborhoods. Spanning approx. 4,500 sq. ft., this home blends timeless elegance w/modern convenience, offering everything you need for comfortable living & entertaining. Step inside to a bright, open interior adorned w/gleaming hardwood floors and a thoughtfully designed floor plan. The main level features a welcoming foyer, a formal dining room ideal for hosting, a cozy living room, a versatile sitting room/den & a show-stopping grand room. At the heart of the home is the kitchen, complete w/granite countertops & stainless steel appliances, seamlessly flowing into the warm and inviting living room with its charming fireplace. The grand room, boasting striking Palladian windows and a stunning gas fireplace, is sure to impress. The upper level offers 4 spacious bedrooms, including a tranquil primary suite with a walk-in closet, a spa-like ensuite bathroom & a private office or sitting room. The additional bedrooms provide plenty of space for family, guests, or a home office. The finished lower level is a haven for recreation, featuring a movie theater room with a bar and an expansive family room with a gym area. Step outside to your private oasis of 2.85 acres: a beautifully landscaped backyard with a two-tier deck, a sparkling in-ground pool with a cascading waterfall, a built-in spa, and a spacious patio perfect for barbecues or relaxing under the stars.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$750,000

N/A Area Commercial

Active

Address Not Disclosed Meriden, CT 06451

Bed

0 Baths

25587 sqft

MLS# 24039705

OPPORTUNITY ZONE!! 25,587K sf of warehouse with an additional 10,788 usable space in the basement! 19 North George St is a masonry building all floors are accessed with a freight elevator. The building also has approximately 2K sf of nicely finished office space on the second floor. There are 4 loading docks and 3 overhead doors. The sale also includes 4 buildings lots which 3 are contiguous, those lots are currently used for parking. Signage can be seen from I-691 East. Buildings will be delivered empty. Property can also be bought with 30 Camp St see MLS #

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino

$740,000

City Center Area Single Family Home

Active

23 Segar Street Danbury, CT 06810

4 Bed

4 Baths

3588 sqft

MLS# 24041688

This is a rare and unique chance to own a versatile property that adapts to various needs. In today's era of remote work and home businesses, this home could be ideal for you! It includes a well-designed home office with a separate, private entrance, perfect for maintaining a dedicated workspace separate from the main living areas. The property also features a driveway accommodating up to 8 cars. The office provides a professional setting with its own access, ensuring both convenience and privacy. It includes an open bonus area, two private rooms, and a full bathroom. If a home office isn't needed, it may be possible for the space to be transformed into an in-law suite or adapted for multi-generation use or investment opportunities. The main residence boasts a modern and contemporary layout with ample space for entertaining. It includes four bedrooms and three full bathrooms. The welcoming foyer leads into a living room with a central fireplace, a dining room with a sculpted ceiling, and a fabulous eat-in kitchen that opens onto a 1,000 sq ft deck spanning the width of the home. The kitchen features a large central island and French doors leading to the great room. Additional conveniences include a new roof and skylights (installed 4 years ago with a lifetime warranty), three laundry setups (one on each level), and city water and sewer services. With approximately 6,300 sq ft of space, this home is unbeatable in price and provides room for everyone!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$699,000

Indian Neck Area Townhouse

Active

70 Quarry Dock Road 70 Branford, CT 06405

2 Bed

3 Baths

1764 sqft

MLS# 24058116

Experience year-round vacation living in this stunning waterfront condo on the Branford River, located within the Sylvan Point condominium community. The southeast-facing unit has breathtaking sunrises and serene views of the salt marsh, Branford River and Safe Harbour Marina. Unwind on your private deck, where you can watch boats pass by, along with sightings of birds, waterfowl and deer. The Kitchen boasts granite countertops, premium stainless steel appliances, and a full size washer and dryer. Its tiled flooring seamlessly transitions into the hallway, leading to a living room adorned with gleaming chery wood floors and a cozy new gas fireplace with a river stone surround. The cherry wood flooring continues into the dining area, and a nearby powder room features a modern vessel sink. Ample storage options, including a pantry closet, are conveniently located in the hallway. The spacious primary bedroom is a true retreat, featuring cherry wood floors, a celing fan and large windows offering stunning views of the water and marina. The guest bedroom is on the second floor and includes a full bath, storage and water and marina views. The condo includes a one-car grage located under the building. Enjoy a prime location within walking distance of the Branford Train Station, Stony Creek Brewery, Branford Green, Branford Point and Foote Park. Sylvan Point is a Special Tax District and reserves the right of first refusal for buyers.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Carol "Carol R" Reilly

$659,900

North Guilford Area Single Family Home

Active

40 Whispering Woods Road Guilford, CT 06437

3 Bed

3 Baths

2088 sqft

MLS# 24052096

Welcome to 40 Whispering Woods Road situated on 3.44 acres in North Guilford surrounded by Guilford Land Trust & Regional Water Authority property with hiking trails all around. The stunning front porch, perennial gardens and in-ground pool with patio and deck will have you outside almost year round. If your a nature lover this is the home for you. The wildlife is breathtaking. This meticulously maintained home offers a formal living room with a fireplace perfect for cool evenings, a formal dining area, spacious kitchen with stainless appliances, granite counters & walk-in pantry/laundry room. The family room with a 2nd fireplace opens to the deck through a french door overlooking the in-ground pool, patio and gardens. An oversized 2-car garage with a loft has an abundance of storage and the possibility of a workshop, studio or in-home gym. Upstairs the primary bedroom suite has a full-bath and walk-in closet. 2-additional bedrooms and a full-bath complete the second floor. The unfinished basement offers tons of storage or the ability to finish and add more living space.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Jana Ghidossi

$650,000

Mount Carmel Area Single Family Home

Coming Soon

5 Lancelot Way Hamden, CT 06518

4 Bed

4 Baths

3960 sqft

Welcome to this exquisite, meticulously maintained home situated in one of Hamden's most sought-after neighborhoods. Tucked away on a cul-de-sac, this 4-bedroom, 3.5-bathroom residence offers over 5,000 square feet of thoughtfully designed living space, perfectly balancing modern convenience with classic elegance. As you step into the sun-drenched two-story foyer, you'll be captivated by the welcoming atmosphere. The gourmet eat-in kitchen features granite countertops, a spacious central island with seating, and abundant cabinetry-ideal for both casual meals & entertaining. The kitchen flows into a cozy family room w/ a fireplace, creating the perfect setting for relaxation. Steps away, you'll find a formal dining room & formal living room, offering additional spaces for hosting. Completing the main level are a convenient half bath, a generously sized laundry room, and access to the attached 3-car garage. Upstairs, the primary suite is a retreat unto itself, boasting a double walk-in closet & an en-suite bath w/a soaking tub, dual sinks & walk-in shower. 3 additional bedrooms, a full bath, & an open loft area provide versatility & ample space for family or guests. The finished walk-out basement adds more living space, offering a full bath, a cedar closet & flexible options for a home office/gym or rec area. Energy-efficient updates include 2 new furnaces, 2 new a/c units, new tankless on-demand hot water system, new roof & Generac generator, ensuring comfort and peace of mind

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$599,999

N/A Area Single Family Home

Active

1333 West Woods Road Hamden, CT 06518

3 Bed

2 Baths

2035 sqft

MLS# 24057322

Welcome to this charming country home set on 14.21 acres. The inviting atmosphere greets you as you step inside! The main level features a lovely kitchen with granite countertops and original painted cabinets, preserving that warm, homey feel. Adjacent to the kitchen is a spacious dining room, perfect for gatherings. Also on this level, you'll find a half bathroom, an office, and an oversized living room equipped with a wood-burning fireplace and French doors leading to the backyard. Upstairs, discover three comfortable bedrooms and a full bathroom. The primary bedroom offers access to an unfinished storage area above the garage, providing endless possibilities for expansion. The unfinished basement offers ample storage space as well. Enjoy the enclosed porch with a wood-burning stove, ideal for relaxation year-round. Outside, you'll find a two-car attached garage and a spacious driveway. With 14.21 acres at your disposal, the potential is limitless-let your imagination run wild! Schedule a visit to explore this property today! Buyer to do their own due diligence in regards to doing anything additional with the property.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Samantha Celentano

$595,000

Westville Area Multi-Family Home

Pending

105 West Elm Street New Haven, CT 06515

5 Bed

3 Baths

3433 sqft

MLS# 24053746

A spacious and loved 3 family home located in the Heart of Westville.Ideal for the investor or to live in and enjoy this location. A short walk to the Village of Westville to enjoy the quaint shops and restaurants.An easy commute to Yale University and Hopital or downtown to enjoy the theatre and restaurants. First time offered since the 1950s, loved and cared for,owned and occupied by this family. Ideal for an owner occupant to subsidize the mortgage with income or an investor looking for an option as a value add with cosmetic updates. Offering three spacious apartments, first and second floor offering 5 rooms, 2 bedrooms, 1 bath, with a front and back porch on the s 2nd floor. First floor with a porch or sunroom. Third floor 4 room apartment with 1 bedroom and sitting room or office updated kitchen and back porch. the 1st and 2nd floor with Hdwd floors, 3rd floor carpet. Updates include replacement windows 3rd fl.and some on other floors, Hotwater heaters +/- 2 yrs old. Furnaces 5+/- yrs. Mechanicals are in good condition. Make this your property adding the cosmetic updates in this wonderful home in a great location.There is potential in lower level with additional living space,interested parties are responsible to do their own research with the City to see if this is an option. Also, this home has off street parking and a 2 car detached garage for convenience or additional income. Limited times for viewing POF /Pre approval letter required prior to viewing

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Barbara Altieri

$499,999

Old Lyme Shores Area Commercial

Active

284 Shore Road Old Lyme, CT 06371

0 Bed

1 Baths

936 sqft

MLS# 24037861

Now available is a rare and unique mixed-use property located just steps from the water. Situated on a high-traffic road, this property offers excellent visibility for your business. Formerly a well-known pizzeria, the first-floor commercial space includes all existing equipment and indoor booths/seating, plus a half bathroom. Although there is a fire system in place, it requires repair. Above the commercial space, you'll find a three-bedroom, one-bathroom apartment with a back porch and an unfinished walk-up attic. The property is being sold as-is and will need some work. It features a large parking lot with ample parking, and the apartment benefits from both a side and back entry with stairs leading down to the main floor. Each level of the property has its own electrical panel. Old Lyme is a picturesque town along the Connecticut shoreline, known for its charming homes, coastal views, and historic character. Shore Road typically features properties that are close to the water, with many offering scenic views of the Long Island Sound or direct access to the beach.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$499,900

N/A Area Single Family Home

Pending

72 Notch Hill Road North Branford, CT 06471

3 Bed

3 Baths

0 sqft

MLS# 24051834

Exciting New Construction Opportunity! Introducing a fantastic new home featuring 3 bedrooms and 3 full bathrooms, complete with a 1-car attached garage, all set on a tranquil 1.50-acre private lot. This elevated lot provides stunning views and a serene atmosphere, ensuring both privacy and seclusion. The home will have its own dedicated driveway from Notch Hill Road, with gas and electrical easements already in place. It will be connected to public water and septic. Spanning approximately 2,000 sq ft (see plans), the layout includes a ground-level finished bonus room off the garage. The main floor offers an open-concept design for the dining, living, and kitchen areas, along with a primary bedroom featuring a walk-in closet and an en-suite full bathroom, accessible from both the bedroom and the hallway. On the second floor, you'll find two additional bedrooms and another full bathroom. The finished lower level off the garage also includes a full bathroom, providing versatile space for guests or a home office. Additionally, there is one other approved identical home to be built at 66 Notch Hill Road, also available for sale. The foundation is already in place, so don't miss out on this incredible opportunity!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$499,900

N/A Area Single Family Home

Active

66 Notch Hill Road North Branford, CT 06471

3 Bed

3 Baths

0 sqft

MLS# 24051837

Exciting New Construction Opportunity! Introducing a fantastic new home featuring 3 bedrooms and 3 full bathrooms, complete with a 1-car attached garage, all set on a tranquil 1.97-acre private lot. This elevated lot provides stunning views and a serene atmosphere, ensuring both privacy and seclusion. The home will have its own dedicated driveway from Notch Hill Road, with gas and electrical easements already in place. It will be connected to public water and septic. Spanning approximately 2,000 sq ft (see plans), the layout includes a ground-level finished bonus room off the garage. The main floor offers an open-concept design for the dining, living, and kitchen areas, along with a primary bedroom featuring a walk-in closet and an en-suite full bathroom, accessible from both the bedroom and the hallway. On the second floor, you'll find two additional bedrooms and another full bathroom. The finished lower level off the garage also includes a full bathroom, providing versatile space for guests or a home office. Additionally, there is one other approved identical home to be built at 72 Notch Hill Road, also available for sale. The foundation is already in place, so don't miss out on this incredible opportunity!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$499,000

N/A Area Single Family Home

Active

492 Shore Drive Branford, CT 06405

3 Bed

2 Baths

1796 sqft

MLS# 24053799

Nestled in the highly sought-after Short Beach community, this fully renovated home comes with beach rights and is packed with modern updates. The home features a fully updated kitchen with brand-new appliances and two beautifully remodeled bathrooms with modern finishes. The newly finished basement provides extra living space, perfect for a family room, office, or gym. Enjoy the comfort of a new air conditioning system and additional storage with a brand-new shed. Step outside to a newly added patio and fire pit area, perfect for entertaining and relaxing in your spacious backyard. Don't miss this rare opportunity to own this gem with top-notch upgrades-schedule your tour today!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Brian Gallagher

$485,000

Brushy Plain Area Townhouse

Active

312 Field Point Road 312 Branford, CT 06405

3 Bed

3 Baths

1556 sqft

MLS# 24043387

EXTRAORDINARY IMPROVEMENTS MUST BE SEEN! The quality of the materials and workmanship evident in this totally renovated tri-level townhouse are rarely seen. From the solid mahogany doors (imported from Spain), to the kitchen countertops and double sink, fashioned out of zinc, to the Italian marble in the primary bath, there are so many custom features for the discerning buyer to appreciate. The kitchen was designed and equipped by a chef, and features appliances by Miele, Wolf, and Sub Zero. The custom woodwork and built-ins in the lower level, provide an inviting space for those working from home. With 2,300 sq. ft. of finished space, this 3 BR 2.5 Bath home provides all the space you may need, while allowing you to enjoy the condominium, turn-key, lifestyle. Additionally, there are four, energy efficient, ductless mini-split systems providing heat and air conditioning throughout. Located at the end of a cul-de-sac, it would be hard to find a more serene setting. The Meadows association has a beautiful pool and clubhouse facility for the exclusive use of the community.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Charles Conti

$485,000

Kelseytown Area Single Family Home

Active

9 Marian Lane Clinton, CT 06413

3 Bed

2 Baths

1970 sqft

MLS# 24057262

Welcome to 9 Marian Ln. located on a lovely 1.75 acre quiet cul-de-sac with a spacious yard. There is a large 25x40' foundation in rear that could be a build out for a 2-3 car garage, studio, or other options to meet your lifestyle needs. The 3 bedroom 2 bath cape comes with two additional rooms on the main level also with many options and separate entrance. Possibility for an in-law apt with easy access and main level entry. Newer kitchen and baths, central air, new well water holding tank and hot water heater. Upper level has a spacious unfinished room waiting to be finished, again many possibilities to expand living space if needed. Lots of light, fireplace and rear deck overlooking a serene property. So many possibilities here! Property viewings will begin on Monday November 4th. by appointment. Come see it, love it, buy it!!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Frank Balisciano

$449,000

Wooster Square Area Multi-Family Home

Pending

88 Lyon Street New Haven, CT 06511

4 Bed

2 Baths

2010 sqft

MLS# 24058028

Welcome to 88 Lyon St! This two-family home requires some sweat equity, but the effort will be well worth it. Just a short 5-block stroll to historic Wooster Square, you can indulge in world-famous pizza and AUTHENTIC cuisine, as well as enjoy the lovely Wooster Square Park! The home features stacked units, each with 2 bedrooms and 1 bath. The second-floor unit will be delivered empty, while the first-floor unit is currently on a month-to-month lease. Additionally, the property includes a 4-car garage, providing an extra revenue stream, along with ample off-street parking-a rare find in this part of the city. You're just a couple of blocks from the Yale Shuttle Line, downtown New Haven, the train station, and only a 10-minute drive to Tweed New Haven Airport! House is being Sold As Is.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino

$448,900

N/A Area Single Family Home

Pending

34 Ridge Acres Road Branford, CT 06405

3 Bed

2 Baths

1620 sqft

MLS# 24051923

A HOME FOR ALL AGES! Whether you are young or old, or somewhere in between, this home has so much to offer you. It is well sited on a picturesque 1.55 acre lot, with an array of beautiful stone walls, and borders Branford Land Trust property to the rear. There is plenty of room for Rover, gardens, and outdoor entertaining. The interior space is highlighted by beamed cathedral ceilings and a raised hearth fireplace in the living room. The family room has a striking pine ceiling, slate flooring, and sliders that open to an inviting deck; the perfect place for your grill. There are hardwood floors in each of the three bedrooms, and the primary bedroom features a custom made granite vanity. This home also offers a second driveway which provides abundant off-street parking, direct access from the garage, city water, and a new roof (2023). Come for a visit, then make 34 Ridge Acre Road your new home!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Stephen "Steve" Burke

$424,900

N/A Area Townhouse

Active

26 Fieldstone Court 26 North Haven, CT 06473

4 Bed

3 Baths

1698 sqft

MLS# 24064586

Enjoy carefree living at Regency Meadows, a 55 and over condo community. This end unit is beautifully maintained boasting 4 bedrooms and 2.5 baths, showcasing a primary suite on the main level with vaulted ceilings. Features include 9' ceilings on the main level and hardwood floors throughout the first floor. There is also a convenient first floor laundry and a powder room. Easy access from your one car attached garage. Kitchen is newly updated with granite counters and stainless steal appliances. Open concept living for your entertaining needs. Three bedrooms and a full bath complete the upper level. This unit is sun filled and spacious.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Gerald "Jerry" Caturano

$369,999

Northford Area Single Family Home

Pending

462 Village Street North Branford, CT 06472

3 Bed

1 Baths

1316 sqft

MLS# 24054399

Welcome to your charming farmhouse colonial home, nestled on a perfectly flat 1.55-acre lot. The eye is immediately drawn to the lovely wraparound front porch and the circular driveway. Inside, you'll discover an inviting open layout featuring a kitchen, dining area, and living room, all warmed by an energy-efficient wood stove. A door at the back leads to a wonderful patio that overlooks the yard, hot tub area and BARN! The main level also includes a mechanical room, laundry room, and ample storage. Additionally, there's a heated one-car attached garage. Upstairs, you'll find three bedrooms, two of which are connected, along with a full bathroom. BEST OF ALL, WALLINGFORD ELECTRIC, LOWEST COST ELECTRIC PROVIDER IN THE STATE! **multiple offers **

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$369,999

N/A Area Single Family Home

Active

4 Gerrish Avenue East Haven, CT 06512

3 Bed

2 Baths

1344 sqft

MLS# 24061198

Welcome to 4 Gerrish, a charming, newly built colonial home (2011) that blends modern comfort with thoughtful updates. This 1,344 sq ft home offers 3 bedrooms, 1.5 bathrooms, and an open-concept layout perfect for contemporary living. Located on a peaceful side street just outside the town center, this property provides both tranquility and convenience. Step outside to enjoy a spacious .38-acre lot overlooking a peaceful creek, ideal for entertaining and relaxing. The private, flat yard features a back patio and a large side deck, offering plenty of room for outdoor activities. The covered front entryway leads to the home's inviting interior, where a generous living and dining area flows seamlessly into a well-equipped kitchen. The kitchen showcases new cabinetry, stainless steel appliances, and elegant granite countertops, with slider doors that lead to the backyard and deck. The main level also includes a convenient laundry area and a half bathroom. Upstairs, the second floor is home to 3 generously sized bedrooms and a beautifully renovated full bathroom. The house is equipped with gleaming hardwood floors along with natural gas heating and central air, ensuring year-round comfort and efficiency. This home is a perfect combination of modern style, functional layout, and outdoor space, making it a fantastic place to call home.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$339,900

N/A Area Single Family Home

Pending

12 Hemingway Place New Haven, CT 06513

3 Bed

1 Baths

1188 sqft

MLS# 24061523

Situated in a peaceful residential enclave, 12 Hemingway Place offers a perfect blend of comfort and convenience in the vibrant city of New Haven in the Quinnipiac Meadows area, just over the East Haven line and minutes to the North Haven line.. This charming home is set on a quiet street, providing a serene retreat while being close to all the city's amenities. The property features a well-maintained exterior with attractive landscaping that adds to its curb appeal. Inside, you'll find a spacious and functional layout with sunlit living areas, perfect for family living or entertaining. Key features include hardwood flooring, cozy fireplace, and modern updates throughout including fresh paint, brand new boiler/hot water, new paved driveway and more! The eat in kitchen is renovated featuring new cabinetry, sleek marble countertops and new stainless-steel appliances. There are three bedrooms and a full renovated bathroom on the main level along with a side sunroom/mud room. For added space there is a finished lower level. The backyard is ideal with .35 acres of flat, level yard for outdoor activities, offering space for gardening, play, or alfresco dining. Its location provides easy access to nearby parks, schools, shopping centers, and the cultural attractions of downtown New Haven. Whether you're a first-time buyer, looking to upgrade, or seeking an investment opportunity, 12 Hemingway Place is a delightful property that promises a comfortable and convenient lifestyle.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$319,900

Foxon Area Townhouse

Active

140 Thompson Street Apt 5F East Haven, CT 06513

2 Bed

2 Baths

1210 sqft

MLS# 24055008

Welcome to Thompson Gardens West condominium complex in the Foxon area of East Haven. This stunning and immaculate townhouse style condo is located in a great area of the complex. It is an end unit which has privacy and a little more natural light. It is a two bedroom, 1.1 bath condo with a garage under. The kitchen was beautifully remodeled about four years ago with many white cabinets with soft close doors and drawers, tile back splash, granite countertop, premium stainless-steel appliances and tiled floor. There is crown molding on the main living level. The living room/dining area has hardwood floors and there's a slider leading to an oversized deck with stairs to the side yard. On the upper level are two bedrooms, both with newer wall-to-wall carpeting and newer closet doors. The main bath was also recently remodeled with tiled tub/shower surround, white cabinets with soft close doors and quartz countertop. The laundry area in the basement boasts an LG washer and gas dryer, utility sink, gas furnace and hot water heater and still room for storage, crafts or exercise area. The garage has an automatic door opener. Windows were replaced approximately eight years ago. There are no amenities at TGW, however, that keeps the HOA costs low. This is a very well run complex. It is close to shopping and bus line. East Haven has the Trolley Museum, live concerts on the Green and many fine eating establishments. This unit is truly move in ready! Just unpack and enjoy!!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Carol "Carol R" Reilly

$315,000

Momauguin Area Single Family Home

Active

140 Vista Drive East Haven, CT 06512

3 Bed

1 Baths

1128 sqft

MLS# 24065627

Welcome to 140 Vista Drive with water views, marsh views, Nature & wildlife in your private backyard! This property is a renovated home that perfectly blends modern updates with timeless charm. Nestled in a desirable neighborhood, this move-in-ready property is ideal for those seeking comfort, style, and convenience. Step inside to discover an inviting floor plan, filled with natural light and thoughtful upgrades throughout. Upon entering the front door, The main level offers a large living room, an eat in kitchen perfect for both casual dining and entertaining which flows into the dining room/family room with slider doors to the fabulous screened porch. This home boasts 2 bedrooms and an updated bathroom on the main level. Upstairs there is an open loft area perfect for an office or hangout space and also the third bedroom. The living areas are freshly painted and accented with modern finishes, while the refinished floors/new flooring add warmth and elegance. Outside, enjoy a private backyard oasis with plenty of room for outdoor gatherings, gardening, or relaxation with a fully cleared, flat, level lot. The property also includes a side entry from the paved driveway. Conveniently located near schools, parks, shopping, and major commuter routes! Brand new 2024 new mini split heat pump systems, brand new top of the line Anderson windows and doors, and new roof 2017!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$290,000

N/A Area Condo

Pending

529 Emerson Drive 529 Branford, CT 06405

2 Bed

2 Baths

1152 sqft

MLS# 24064432

RARE END UNIT IN THE GREENS - FIRST TIME ON THE MARKET IN OVER 30 YEARS! This charming end-unit ranch is located less than 2 miles from the beach and conveniently close to shopping, dining, and public transportation. With plenty of guest parking and an easily accessible entrance, this home is perfect for those seeking both convenience and comfort. Upon entering, you'll be greeted by a spacious living room with vaulted ceilings, creating an open, airy atmosphere. Cozy up by the fireplace on chilly winter nights or enjoy the abundant natural sunlight streaming in through multiple windows. The main floor features hardwood flooring throughout the living area and tile in the kitchen and baths for easy maintenance. To your left, the dining area offers sliding doors that lead to a multi-use deck, ideal for summer entertaining or relaxing outdoors. The remodeled kitchen boasts granite countertops, stainless steel appliances, and oak cabinetry, with a neutral backsplash that complements any decor. Sliding doors in the kitchen provide easy access to the garage, adding convenience to your daily routine. The main floor features two bedrooms, including the master suite with its own private deck, a double closet for extra storage, and access to a full bath. The lower level is framed and ready to be finished as a rec room, office, or additional bedroom, offering endless possibilities. All major mechanicals have been updated for peace of mind.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Megan Brennan

$275,000

N/A Area Single Family Home

Pending

58 Asylum Street New Haven, CT 06519

4 Bed

2 Baths

1440 sqft

MLS# 24061883

Nestled in a charming neighborhood of New Haven, just steps to Yale Hospital, 58 Asylum Street is a one way road, and boasts a blend of historic charm and modern convenience. This inviting residence features a classic architectural design that complements the character of the area, with a facade that exudes appeal. Inside, the home offers a thoughtfully designed layout, with spacious rooms filled with natural light. Gleaming Hardwood floors enhance the charm of the living spaces, while modern updates in the kitchen and bathrooms provide functionality for today's lifestyle. The first floor offers accommodation kitchen and dining space with the kitchen having granite countertops and stainless steel appliances. There is a large living room on the main level along with a full bathroom. Head upstairs and you will find 3 guest bedrooms and then a fourth bedroom which also has a bonus room off of the room perfect for a small office or a nursery. The 2nd floor also has a second full bathroom. There is a large unfinished basement for storage along with your laundry. The property includes a flat, level backyard, perfect for outdoor gatherings. Conveniently located, the home is just a short distance from downtown New Haven, offering easy access to shops, restaurants, cultural attractions, and Yale University. Whether you're looking for a family home or an investment property, 58 Asylum Street presents a unique opportunity to enjoy the vibrant New Haven community. Multiple offers. **

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$275,000

N/A Area Multi-Family Home

Pending

784 Plainfield Road Griswold, CT 06351

4 Bed

2 Baths

1700 sqft

MLS# 24060327

Great opportunity to own this two, possibly three family as an investment or owner occupied property. Nicely located on Plainfield Rd this multifamily has a roughed in ground level walkout ready for a third 2 bedroom 1 bath apt, accessory apt, or legal 3 family ** WITH TOWN APPROVAL**. Electrical and plumbing in place and ready for completion. The other two units are in very good condition with some updates. Large off street parking area for several vehicles and a shed. This property is generating monthly positive net income considering rents are currently under market value. Property has been well managed by a professional management company that is willing to continue management with new owner . Come see it, love it, buy it! buy it !!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Frank Balisciano

$255,000

N/A Area Condo

Active

101 East Broadway C Milford, CT 06460

1 Bed

1 Baths

902 sqft

MLS# 24056917

Welcome to this charming ranch-style condo by the Connecticut shore, where comfort meets convenience. Enjoy the ease of one-level living in this beautifully seamless floor plan, offering a spacious 1 bedroom with two closets and one full bathroom. With private 1 year old washer and dryer right in the unit, day-to-day tasks are a breeze. Other new appliances include the 1 year old refrigerator. Step onto your private deck to take in the peaceful sounds and views of the coastal surroundings, the perfect retreat for relaxation. Additional storage is a plus, with an outdoor closet accessible from the deck and an extra private storage area in the shared basement. Located close to I-95 for easy commuting, this condo combines tranquility with convenience, making it a delightful coastal oasis.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Amy Bartolucci

$250,000

N/A Area Commercial

Active

Address Not Disclosed Meriden, CT 06451

Bed

0 Baths

0 sqft

MLS# 24039709

OPPORTUNITY ZONE!! 9,600 + sf on two floors, with one drive in door and a 8K sf fenced in yard. The portfolio also includes 1 building lot across the street from the property for additional parking or development. Building will be delivered empty. Can also be purchased with 19 North George St, See MLS # 24039705.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino

$145,000

N/A Area Townhouse

Active

1423 Quinnipiac Avenue 709 New Haven, CT 06513

2 Bed

2 Baths

1032 sqft

MLS# 24046246

Prime investment opportunity! This townhouse offers strong rental potential with spacious living areas and great location near shopping,dining,and transit. Schedule a showing today!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Brian Gallagher

$143,000

N/A Area Townhouse

Active

1423 Quinnipiac Avenue 103 New Haven, CT 06513

2 Bed

2 Baths

1021 sqft

MLS# 24052228

Come check out this 2-bed, 1.5-bath with open living. Easy access to 95 and 91. Close to Restaurants,shopping, and public transportation.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Brian Gallagher

$139,900

Northford Area Land

Active

1452 Middletown Avenue North Branford, CT 06472

Bed

0 Baths

0 sqft

MLS# 24063103

The feeling of country living with the conveniences minutes away. This is the last of a 7 lot subdivision with almost 2 acres With the clearing of trees for construction there will be views of the Totoket Mountain and still retain privacy to the home. Convenient location close to town center, library and a 5 minute drive to major highways. A building site with character, a country setting the convenience of city water. If you would like to build your dream home and are looking for location with privacy, views and the home will located off the road. Additional information available or to schedule a walk of the site available by request.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Barbara Altieri

$139,000

N/A Area Townhouse

Active

1423 Quinnipiac Avenue 602 New Haven, CT 06513

2 Bed

2 Baths

1032 sqft

MLS# 24046226

Attention investors! This two-bedroom,one and a half-bath townhouse offers excellent rental income potential. Located close to shopping, dining, and public transportation.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Brian Gallagher

$134,000

N/A Area Condo

Active

1423 Quinnipiac Avenue 807 New Haven, CT 06513

2 Bed

1 Baths

1018 sqft

MLS# 24052247

Come check out this 2-bed, 1-bath ranch style condo.Convenient location near transportation, food, shopping.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Brian Gallagher

$127,000

N/A Area Condo

Active

1423 Quinnipiac Avenue 704 New Haven, CT 06513

2 Bed

1 Baths

1018 sqft

MLS# 24045957

Great Investment opportunity! This first -floor condo offers two bedrooms,one bath,an open living/dining area. Located close to shops,dining,and public transportation. Perfect for rental income or futute resale. Don't miss out-schedule a showing today.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Brian Gallagher

$125,000

N/A Area Condo

Active

1423 Quinnipiac Avenue 707 New Haven, CT 06513

2 Bed

1 Baths

1018 sqft

MLS# 24046241

Perfect for investors! This two-bedroom,one bath features an open living concept. Conveniently located near shopping,dining, and transit. make this a smart addition to your portfolio.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Brian Gallagher

$4,750 / mo

Chapman Beach Area Rental Home

Active

42 Chapman Beach Road Westbrook, CT 06498

3 Bed

2 Baths

1176 sqft

MLS# 24057775

YEAR ROUND BEACH HOUSE, Just renovated.1920 Dutch Colonial with detached garage in private beach community. Yearly, unfurnished, 3 Bedroom, 11/2 bath, new high efficiency heat and air conditioning, updated kitchen with stainless steel appliances with quartz counter top, hardwood floors throughout, new washer and dryer, open floor plan and 3 season front porch. Large open lot, private backyard, short walk to beach. The rental is unfurnished and turn-key ready, with an option to rent fully furnished if preferred. Lease dates are flexible, allowing for 1- to 2-year options. Located in the beautiful town of Westbrook, conveniently located between Boston and New York. Just minutes to center of town, train stations, restaurants, shopping, The Katharine Hepburn Cultural Arts Center in Old Saybrook, marinas and much more. Schedule a private tour today. Strong credit score, rental application and references required, no pets, no smoking. Tenant responsible for all utilities.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Marta Elmasry

$4,000 / mo

Mount Carmel Area Rental Home

Active

265 River Road Hamden, CT 06518

3 Bed

3 Baths

2945 sqft

MLS# 24064420

Experience unparalleled tranquility on this expansive estate, spanning over three acres of land and encompassing a sprawling ranch that offers breathtaking views of the Mill River. Nestled amidst nature, this property is equipped with a geothermal heating and cooling system, eliminating the need for oil or gas bills. Your sole utility expense will be your electric bill, which averages approximately $180 per month year-round. As you enter this 2,945 square foot ranch, you will be greeted by a spacious living and dining area that spans 756 square feet. This remarkable room features a striking wall of windows that frame picturesque views of the Mill River, complemented by a magnificent brick fireplace that infuses warmth and character. The wide plank hardwood floors and cathedral ceilings contribute to the inviting ambiance. Exploring the south wing of the house, you will discover a half bath, the primary suite, a second bedroom, a sauna, and a greenhouse. The primary suite serves as a private sanctuary, complete with an en suite bathroom, his and her walk-in closets, and windows that overlook the tranquil natural surroundings and the river. On the opposite end of the home, a spacious eat-in kitchen awaits, featuring stainless steel appliances and access to a Trex deck overlooking the river-an ideal setting for al fresco dining or enjoying your morning coffee.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino

$3,100 / mo

N/A Area Rental Home

Active

33 Rosemary Lane Guilford, CT 06437

3 Bed

2 Baths

1142 sqft

MLS# 24059958

SUN-FILLED, UPDATED CAPE! Located on a quiet, side street mid-way between the historic Guilford Green, with its host of fine restaurants and shops, and Jacob's Beach. Great opportunity to live in a wonderful Guilford location with city water. Available immediately, and offering a beautifully remodeled kitchen and 2 full baths, gleaming hardwood floors, a large deck, and level backyard. There are 3 Bedrooms plus an office. Washer/Dryer hook-ups are in place, and there is off-street parking. Sorry, no pets or smoking. Credit and background check, and two-month's security deposit required.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Charles Conti

$2,700 / mo

N/A Area Rental Home

Active

245 East Main Street Unit 8 Branford, CT 06405

3 Bed

2 Baths

14334 sqft

MLS# 170619999

Welcome to Riverside Crossing... a stunning, new construction modern, luxury style chic building offering 12 units. The building backs up to the Branford River, offering beautiful river and marsh views, and just seconds to everything including the center of town, train station, shops, restaurants and more. Unit is a 3 bedroom, but ideally suited as a 2 bedroom with an office with 2 full bathrooms, (1 of them connected to the master bedroom), in unit laundry, energy efficient heat pump/central air and Juliet balconies. The spacious, bright and open style floor plan offers flexibility with modern style living. Top of the line kitchen with Quartz counters, stainless steel appliances and more. The building has front and rear stairs, along with a central elevator. 9 Indoor Garage Parking Spots (First come, first served) for $50 more a month, plenty of parking in the main parking lot, and pet friendly! AVAILABLE 11/1 - 1-3 YEAR LEASES - * possible for furnished short term also * inquire further **

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Lauren Freedman

$2,500 / mo

Branford Point Area Rental Home

Active

75 Harbor Street 2 Branford, CT 06405

3 Bed

1 Baths

1218 sqft

MLS# 24064367

WELCOME TO 75 HARBOR STREET, BRANFORD. THIS SECOND FLOOR RENTAL SITS UPON THE GATEWAY TO BRANFORD POINT. THIS BEAUTIFULLY UPDATED 3 BEDROOM, 1 BATH UNIT HAS EXPANSIVE SPACE AND AN OPEN FLOOR PLAN. THE EAT IN KITCHEN IS COMPLIMENTED WITH GRANITE COUNTERTOPS, SUBWAY TILE BACKSPLASH, STAINLESS APPLIANCES, PLENTY OF CABINET SPACE, WIDE PLANK VINYL FLOORING AND PLENTIFUL NATURAL SUNLIGHT. THE THREE BEDROOMS ARE SPACIOUS WITH WALL TO WALL CARPETING - ONE OF THE BEDROOMS CAN EASILY BE MADE INTO A DEN OR HOME OFFICE IF NEEDED. THE FULL JACK AND JILL BATHROOM HAS A DOUBLE VANITY AND TUB/SHOWER. LAUNDRY ROOM IN THE UNIT WITH MORE STORAGE OPTIONS. 9 FOOT CEILINGS, THREE PANEL WOOD DOORS THROUGHOUT, 2 INCH FAUX WOOD BLINDS, PULL DOWN ATTIC, CENTRAL AIR, FRONT AND BACK ENTRANCE, OFF STREET PARKING. WALK TO BEAUTIFUL BRANFORD POINT BEACH AND PARK. READY TO MOVE RIGHT IN!

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Donna Ricci

$2,390 / mo

N/A Area Rental Home

Active

87 Thomas Street Second Floor West Haven, CT 06516

3 Bed

1 Baths

3251 sqft

MLS# 24065548

Location location location! Walk to the water from this lovely second floor unit. 3 bedrooms, 1 full bathroom, updated kitchen, hardwood flooring throughout. Theres no much this rent cant offer you! Lease required, 650 and up credit score, only cats and small dogs with an additional fee of $35/pet.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Samantha Celentano

$2,095 / mo

N/A Area Rental Home

Active

85-87 South Main Street 2E Branford, CT 06405

2 Bed

1 Baths

6152 sqft

MLS# 24064204

A TOWN CENTER GEM! Just remodeled with all New Kitchen appliances, a breakfast bar, and sliders to a rear deck, this first floor apartment has so much to offer. There are two large bedrooms and hardwood floors throughout, as well as 9 ft. ceilings and a great front porch on South Main Street. There is also a washer/dryer in the apartment, so no more trips to the laundromat. There is an amazing array of wonderful restaurants within walking distance, as well as coffee and ice cream shops. The Branford Green is a vibrant location that hosts a number of events throughout the year, including a weekly jazz concert series in the summer, the Branford Festival in the June, and the holiday parade and tree lighting in the winter. There are book fairs, and a host of fun community events during every season. Yale, and all that New Haven has to offer, are only a 10 minute car or train ride away, and Tweed-New Haven Airport now has flights to many popular destinations. If you are new to this area, or a local, you will love living at 85 South Main Street.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Stephen "Steve" Burke

$2,000 / mo

N/A Area Rental Home

Active

16 John Street Branford, CT 06405

2 Bed

1 Baths

1728 sqft

MLS# 24065168

LOCATION-LOCATION-LOCATION! THIS ADORABLE 2 BEDROOM 2ND FLOOR APARTMENT HAS BEEN COMPLETELY UPDATED AND IS CONVENIENTLY LOCATED TO WALK INTO BRANFORD CENTER. FRESHLY PAINTED, NEW FLOORING, REMODELED KITCHEN AND UPDATED BATHROOM WITH STALL SHOWER ACCENTED SUBWAY TILE. STACKABLE LAUNDRY IN UNIT, OFF STREET PARKING, AND SPACIOUS BACK YARD FOR OUTDOOR ENJOYMENT. CREDIT CHECK REQUIRED - NO SMOKING AND NO PETS ALLOWED.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Donna Ricci

$1,600

N/A Area Commercial Lease

Active

235 North Main Street 3 Branford, CT 06405

Bed

0 Baths

0 sqft

MLS# 24042753

Very attractive office space in excellent location! 1400 square feet with 2 exam/private offices and large open space with bathroom, front and rear entrance, on 1st floor. $1950/month plus utilities. Currently chiropractor's office, in a professional building with other great tenants. Great start up or satellite office for Medical, Therapist or any professional office. Beautifully maintained building with plenty of parking. High visibility from Route 1.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Marta Elmasry

$1,000

N/A Area Commercial Lease

Active

519 Laurel-Section 1 Street East Haven, CT 06512

Bed

0 Baths

0 sqft

MLS# 24062666

Logistic Storage/Parking for Tractor Trailers, Semi Trucks, Storage Containers. Any amount of 10+ Acres of raw land available for Outside Storage. Stone parking lot is clear, level, dry and secure. Easy access to 95 and 91. Starting at $1000 per month. Also, RV/BOAT/STORAGE CONTAINER STORAGE! Starting at $200 per month/per spot.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Marta Elmasry

$200

N/A Area Commercial Lease

Active

519 Laurel-Section 3 Street East Haven, CT 06512

Bed

0 Baths

0 sqft

MLS# 24047483

RV/BOAT/STORAGE CONTAINER STORAGE! Space available for Outside Storage. Stone parking lot is clear, level, dry and secure. Easy access to 95 and 91. Starting at $200 per month/per spot.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Marta Elmasry

$11

N/A Area Commercial Lease

Active

85 Lupes Drive Stratford, CT 06615

Bed

0 Baths

0 sqft

MLS# 24044642

7595 SF Warehouse Available for NNN LEASE on 4/15/24 - FREE STANDING BUILDING ON .39 ACRES - The space consists of approximately 6,500 sf of warehouse space and 1,000 sf of office space. Ceilings are 12' clear, 1 Drive in door, with 400 AMP - 3 phase, Office and Warehouse have heat and A/C!!! secured parking for vehicles left overnight. Signage can be seen from I-95 south, easy access to I-95. Currently used as a warehouse and distribution center, this space is versatile and can also be used for warehouse with a customer counter, light manufacturing, or R&D. NETS are approximately $2.80 per foot.

Listing Courtesy of SMART MLS / Coldwell Banker Realty / Joseph "Joe" Scarpellino