RENTED NOV 3, 2025

904 Shepard Ave Hamden, CT 06514

Estimated Value: $467,914 - $523,000

3 Beds
3.5 Baths
2,676 Sq Ft
$182/Sq Ft Est. Value

Highlights

  • 1.59 Acre Lot
  • Deck
  • Attic
  • Cape Cod Architecture
  • Partially Wooded Lot
  • Porch

About This Home

As of November 2025

Welcome to this charming expanded Cape Cod style home offering a perfect blend of comfort, convenience, and versatility. Boasting a thoughtful layout, this residence features a main-level bedroom and full bathroom, making it ideal for guests or multi-generational living. Step inside from a front porch to discover a beautifully renovated kitchen, seamlessly flowing into the spacious dining room, creating the perfect setting for gatherings and entertaining. The heart of the home, the massive living room, perfect for entertaining guests. A slider leads out to the inviting deck, where you can unwind and enjoy the serene surroundings. Upstairs, you'll find additional bedrooms along with another full bathroom, providing ample space for family members or guests. A second staircase leads up to a versatile great room, perfect for use as a primary suite, home office, or in-law quarters, offering endless possibilities to suit your lifestyle needs. Features include hardwood flooring throughout, gas heat, and central air. Conveniently located, this home is just moments away from local stores, area hospitals, and highway access, ensuring that daily essentials and amenities are always within reach. Don't miss the opportunity to make this exquisite Cape Cod-style home your own and experience the epitome of comfortable and convenient living.

Last Agent to Rent the Property

Kelsey Oddo

Kelsey & Co. Real Estate Brokerage Phone: (203) 848-9156 License #REB.0791935 Listed on: 09/10/2025

Last Renter's Agent

Kelsey Oddo

Kelsey & Co. Real Estate Brokerage Phone: (203) 848-9156 License #REB.0791935 Listed on: 09/10/2025

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1948

Lot Details

  • 1.59 Acre Lot
  • Partially Wooded Lot
  • Property is zoned R3

Home Design

  • Cape Cod Architecture
  • Vinyl Siding

Interior Spaces

  • 2,676 Sq Ft Home
  • Basement Fills Entire Space Under The House
  • Attic or Crawl Hatchway Insulated

Kitchen

  • Oven or Range
  • Range Hood
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Garage
  • Parking Deck

Outdoor Features

  • Deck
  • Porch

Schools

  • Hamden Middle School
  • Hamden High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 1142505

Home Details

Home Type

Single Family

Year Built

Built in 1948

Lot Details

0

Rental Info

  • Lease Price Description: Per Month
  • Pets Allowed: No
  • Rental Duration: Yearly Unfurnished
  • Smoking Allowed: No

Listing Details

  • Neighborhood: N/A
  • Property Type: Residential Rental
  • Style: Cape Cod
  • Sq Ft Est Heated Above Grade: 2676
  • Total Sq Ft: 2676
  • Year Built: 1948
  • New Construction: No/Resale
  • Property Sub Type: Single Family Rental
  • Direct Waterfront: No
  • Directions: Shepard Avenue between West Shepard and Sherman Avenue
  • Street Type: Avenue
  • Tenant Responsibility: All Utilities Credit Check
  • Office Attribution Contact: (203) 295-0432
  • Reserve Prospect: No
  • Special Features: None

Interior Features

  • Total Bedrooms: 3
  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Attic Description: Access Via Hatch
  • Basement Description: Full
  • Appliances: Oven/Range, Range Hood, Refrigerator, Dishwasher, Washer, Dryer
  • Attic: Yes

Exterior Features

  • Exterior Features: Porch, Deck
  • Exterior Siding: Vinyl Siding
  • Waterfront Description: Not Applicable
  • Swimming Pool: No

Garage/Parking

  • Garages Number: 2
  • Garage And Parking: Attached Garage, Under House Garage

Utilities

  • Cooling System: Central Air
  • Heat Type: Hot Air
  • Heat Fuel Type: Natural Gas
  • Hot Water Description: Domestic
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Lot Info

  • Acres: 1.59
  • Lot Description: Lightly Wooded
  • Zoning: R3
  • Parcel #: 1142505

MLS Schools

  • Elementary School: Per Board of Ed
  • Middle Jr High School: Hamden
  • High School: Hamden

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 29, 2024
Closed on
Jul 2, 2024
Sold by
Geloso Giuseppe A
Bought by
Giuseppe A Geloso T A and Giuseppe Geloso
Seller's Agent
Kelsey Oddo
Kelsey & Co. Real Estate
Buyer's Agent
Kelsey Oddo
Kelsey & Co. Real Estate
Sold Price
$4,000
Views
131
Current Estimated Value
$485,729

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$481,729

Purchase Details

Closed on
Aug 10, 2009
Sold by
Geloso Giuseppe
Bought by
Geloso Giuseppe and Geloso Rosa

Purchase Details

Closed on
Jun 30, 2009
Sold by
Wetmore Gordon R and Wetmore Gary M
Bought by
Geloso Giuseppe
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Giuseppe A Geloso T A -- None Available
Rosa A Geloso T A -- None Available
Giuseppe A Geloso T A -- None Available
Geloso Giuseppe -- --
Geloso Giuseppe $150,000 --
Geloso Giuseppe -- --
Geloso Giuseppe $150,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Geloso Giuseppe $950,000
Previous Owner Geloso Giuseppe $950,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
11/03/2025 11/03/25 Rented $3,700 -7.5% --
09/10/2025 09/10/25 For Rent $4,000 0.0% --
06/19/2024 06/19/24 Rented $4,000 0.0% --
06/14/2024 06/14/24 Under Contract -- -- --
04/29/2024 04/29/24 For Rent $4,000 -- --
Source: SmartMLS

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $16,023 $308,840 $69,790 $239,050
2024 $13,208 $237,510 $50,540 $186,970
2023 $13,391 $237,510 $50,540 $186,970
2022 $13,177 $237,510 $50,540 $186,970
2021 $12,455 $237,510 $50,540 $186,970
2020 $10,283 $197,820 $84,910 $112,910
2019 $9,665 $197,820 $84,910 $112,910
2018 $9,487 $197,820 $84,910 $112,910
2017 $8,953 $197,820 $84,910 $112,910
2016 $8,973 $197,820 $84,910 $112,910
2015 $8,623 $210,980 $93,870 $117,110
2014 $8,424 $210,980 $93,870 $117,110
Source: Public Records

Agents Affiliated with this Home

  • Kelsey Oddo

    Landlord's Agent in 2025

    Kelsey Oddo

    Kelsey & Co. Real Estate

    (203) 848-9156

    64 in this area

    110 Total Sales

    Kelsey Oddo
    Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 24125847

SmartMLS

APN: HAMD-002827-000005

Connecticut New Haven County Hamden 06514

904 Shepard Ave, Hamden, CT

Not Listed for Sale

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

SmartMLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes