$828,000
PENDING

121 Campbell Ave Williston Park, NY 11596

Estimated payment $5,502/month

Total Views 53,456
3 Beds
1.5 Baths
1,344 Sq Ft
$616 Price per Sq Ft

Highlights

  • Colonial Architecture
  • Formal Dining Room
  • Eat-In Kitchen
  • Herricks High School Rated A+
  • 2 Car Detached Garage
  • Back Yard

About This Home

Unbelievable deal for this home that’s zoned Herricks Schools. It’s a charming home in the heart of Williston Park with newer gas heating system and great bones. This 3-bedroom, 1.5-bath home offers spacious living and dining areas. The full basement with storage has excellent potential. The detached 2-car garage is amazing for your sports car or for storage. Conveniently located near schools, parks, shopping, and transportation. A wonderful opportunity to make this home your own!

Listing Agent

Jack Yao

RealMart Realty LLC Brokerage Phone: 888-362-6543 License #10491203908 Listed on: 12/01/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $14,886

Year Built

  • Built in 1928

Lot Details

  • 4,000 Sq Ft Lot
  • Back Yard

Parking

  • 2 Car Detached Garage
  • Driveway

Home Design

  • Colonial Architecture
  • Frame Construction

Interior Spaces

  • 1,344 Sq Ft Home
  • 2-Story Property
  • Formal Dining Room
  • Unfinished Basement
  • Partial Basement

Kitchen

  • Eat-In Kitchen
  • Electric Range
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms

Schools

  • Center Street Elementary School
  • Herricks Middle School
  • Herricks High School

Utilities

  • No Cooling
  • Heating System Uses Natural Gas
  • Natural Gas Connected

Listing and Financial Details

  • Assessor Parcel Number 2257-09-153-00-0020-0

Home Details

Home Type

Single Family

Est. Annual Taxes

$14,886

Year Built

Built in 1928

Lot Details

4,000 Sq Ft Lot

Parking

2

Listing Details

  • Property Type: Residential
  • Architectural Style: Colonial
  • Property SubType: Single Family Residence
  • Levels: Two
  • Year Built: 1928
  • Attribution Contact: 888-362-6543
  • Carport Y N: No
  • CurrentPrice: 828000.00
  • MlsMajorChangeType: Pending
  • CurrentPrice_By_LivingArea: 616.07143
  • ListPrice_By_LivingArea: 616.07143
  • ListPrice_By_OriginalListPrice: 1.00000
  • ListPrice_By_LotSizeAcres: 9019607.8431
  • LivingAreaSearchSqFt: 1344.00
  • CurrentPrice_By_BuildingAreaTotal: 616.07143
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher, Electric Range, Refrigerator
  • Interior Amenities: Eat-in Kitchen, Formal Dining
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Basement: Partial, Unfinished
  • Total Bedrooms: 3
  • Fireplace: No
  • Living Area: 1344
  • Basement YN: Yes

Exterior Features

  • Construction Materials: Frame
  • Pool Private: No
  • Road Frontage Type: Municipal
  • Waterfront: No

Garage/Parking

  • Garage Spaces: 2
  • Garage: Yes
  • Parking Description: Detached, Driveway, Private

Utilities

  • Cooling: None
  • Heating: Natural Gas
  • Sewer: Public Sewer
  • Utilities: Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
  • Water Source: Public

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Middle School: Herricks Middle School

Lot Info

  • Horses: No
  • Lot Size Acres: 0.0918
  • Lot Size Sq Ft: 4000
  • Lot Features: Back Yard
  • Parcel Number: 2257-09-153-00-0020-0
  • Property Attached: No
  • Additional Parcels: No

Rental Info

  • Lease Considered: No

Tax Info

  • Tax Annual Amount: 14886
  • Tax Year: 2025

MLS Schools

  • Elementary School: Center Street School
  • High School: Herricks High School
  • Middle School District: Herricks

Map

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

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 $10,497 $589 $301 $288
2024 $2,125 $589 $301 $288
2023 $7,699 $568 $291 $277
2022 $7,699 $589 $301 $288
2021 $7,233 $631 $323 $308
2020 $6,585 $627 $626 $1
2019 $6,709 $671 $670 $1
2018 $6,709 $716 $0 $0
2017 $5,482 $761 $749 $12
2016 $7,113 $805 $656 $149
2015 $1,874 $850 $693 $157
2014 $1,874 $850 $693 $157
2013 $2,035 $972 $792 $180
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
02/13/2026 02/13/26 Pending -- -- --
12/01/2025 12/01/25 For Sale $828,000 +5.5% $616 / Sq Ft
09/29/2025 09/29/25 Sold $785,000 -8.6% $584 / Sq Ft View Prior Sale
08/13/2025 08/13/25 Pending -- -- --
07/24/2025 07/24/25 Price Changed $859,000 -4.4% $639 / Sq Ft
07/16/2025 07/16/25 For Sale $899,000 -- $669 / Sq Ft
Source: OneKey® MLS

Purchase History

Date Type Sale Price Title Company
Bargain Sale Deed $785,000 Fidelity Natl Title Ins Co
Bargain Sale Deed -- None Available
Source: Public Records

About the Listing Agent

Jack Yao

RealMart Realty LLC

(363) 666-1819

Section Image

I am Qizhan (Jack) Yao, President and CEO of Realmart Realty LLC, a high-tech, discount real estate brokerage transforming the industry across New Jersey, New York, and Connecticut.
We empower home sellers with affordable, technology-driven options to list on the local MLS and major portals—including Homes.com, Realtor.com, Redfin, Zillow, Trulia, StreetEasy etc. —for a low flat fee starting at just $395. This approach lets sellers save thousands by bypassing traditional 3-6% commissions,

Jack's Other Listings

  • 107-40 Queens Blvd Unit 10D, Forest Hills, NY 11375

    $385,000

    • 1 Bed
    • 1 Bath
    • 680 Sq Ft
    • 107-40 Queens Blvd
    • Unit 10D
    • Forest Hills, NY

    LOCATION! LOCATION! LOCATION! This fully renovated, chic 1 bedroom/1bath condo-op is nestled in a luxury high rise building. The Lane Towers is centrally nestled just steps away from the Austin street shops and restaurants, along with major transportation with E / F / M / R express subway stop, many buses, and the Long Island Railroad (15-20 minutes to midtown Manhattan!). Central

    Jack Yao RealMart Realty LLC

    Section Image
  • 104-20 47th Ave, Corona, NY 11368

    $899,000 Open Sun 3PM - 4:30PM

    • 2 Beds
    • 2.5 Baths
    • 862 Sq Ft
    • 104-20 47th Ave
    • Corona, NY

    Beautifully renovated detached 2 bedroom, 2.5 bath home in the heart of Corona. This move-in-ready property features a brand new kitchen with shaker cabinets, quartz countertops, stainless steel appliances, fully updated bathrooms, hardwood floors throughout, new roof and siding, and a full basement with separate entrance. Enjoy a rare oversized backyard and convenient access to public

    Jack Yao RealMart Realty LLC

    Section Image
  • 159-40 95th St, Howard Beach, NY 11414

    $1,099,999

    • 4 Beds
    • 2 Baths
    • 1,736 Sq Ft
    • 159-40 95th St
    • Howard Beach, NY

    Welcome to this beautiful Waterfront newly renovated hi-ranch featuring 4 bedrooms and 2 bathrooms, located in the heart of Howard Beach! This stunning Mother/Daughter home offers versatile living with 2 gas and two electric meters. Step inside to find an updated interior, including an elegant kitchen with custom cabinetry, quartz countertops, and new stainless steel appliances, alongside fully

    Jack Yao RealMart Realty LLC

    Section Image
  • 320 E 42nd St Unit 27th Fl, New York, NY 10017

    $610,000

    • 1 Bed
    • 1 Bath
    • 320 E 42nd St
    • Unit 27th Fl
    • New York, NY

    This remarkable apartment, never offered for sale, boasts unparalleled uniqueness. Situated on the 27th floor of the landmarked Woodstock Tower, the world's first residential skyscraper, it offers extraordinary views that capture the essence of Manhattan. Flooded with natural light, this one-of-a-kind residence features a balcony providing unobstructed vistas of iconic NYC landmarks: the Chrysler

    Jack Yao Realmart Realty LLC

    Section Image
  • 66 Elm St, Englewood Cliffs, NJ 07632

    $1,499,000 Pending

    • 4 Beds
    • 3.5 Baths
    • 66 Elm St
    • Englewood Cliffs, NJ

    WELCOME HOME to this charming 4 bed, 3.5 bath Colonial in sought-after Englewood Cliffs! Situated on a quiet, tree-lined street, this home boasts incredible curb appeal and is conveniently located near NYC transit and the George Washington Bridge. Enjoy relaxing on the lovely front porch and taking in the lush surroundings. The inviting entry leads to a spacious great room, perfect for

    Jack Yao Realmart Realty, LLC

    Section Image
  • 180 Cottage Place, Cliffside Park, NJ 07010

    $749,000

    • 6 Beds
    • 3 Baths
    • 180 Cottage Place
    • Cliffside Park, NJ

    Turn-key 2-family investment property in the heart of Cliffside Park, an area known for exceptional rental demand. Ideal for buy-and-hold investors, 1031 buyers, or owner-occupants looking to offset expenses with rental income. Please note: Cliffside Park is naturally hilly, and this property sits on an incline. While this may not be ideal for every homeowner, it has not impacted rental demand.

    Jack Yao Realmart Realty, LLC

    Section Image
  • 125 Boerum Place Unit 3B, Brooklyn, NY 11201

    $1,375,000

    • 2 Beds
    • 2 Baths
    • 1,004 Sq Ft
    • 125 Boerum Place
    • Unit 3B
    • Brooklyn, NY

    Spacious and sun-filled two-bedroom condo located in the highly desired crossroads of Cobble Hill and Boerum Hill. Ideally located on a quiet, charming tree-lined street, this duplex features soaring 19 foot vaulted ceilings, central air, and hardwood floors with a thoughtful custom design and elegant finishes in one of Brooklyn’s most desirable neighborhoods. Upon entry, you are welcomed by an

    Jack Yao RealMart Realty LLC

    Section Image
  • 24 Avenue at Port Imperial Unit 227, West New York, NJ 07093

    $530,000

    • 1 Bed
    • 1 Bath
    • 736 Sq Ft
    • 24 Avenue at Port Imperial
    • Unit 227
    • West New York, NJ

    Welcome home to this beautifully maintained 1-bedroom, 1-bath corner unit offering 736 sq ft of comfortable, move-in-ready living in the highly desired Hudson Club waterfront community! Overlooking the courtyard, this home enjoys added privacy and a quiet atmosphere. The open living and dining area flows effortlessly to your private balcony - the perfect spot for morning coffee or unwinding at

    Jack Yao REALMART REALTY

    Section Image
  • 209-211 Hackensack Plank Rd Unit 4B, Weehawken, NJ 07086

    $919,000 Pending

    • 3 Beds
    • 2 Baths
    • 1,635 Sq Ft
    • 209-211 Hackensack Plank Rd
    • Unit 4B
    • Weehawken, NJ

    Modern oversized luxury condo completed in 2019. This 4th-floor residence features 1,635 sqft of living space with 3 bedrooms and 2 full baths. The expansive open-concept layout is designed for entertaining, offering unblocked sunlight and open views. Deeded garage parking spot (spot 5) included—the most accessible and premier spot in the garage. For added convenience, the home includes an

    Jack Yao REALMART REALTY

    Section Image

Source: OneKey® MLS

MLS Number: 940053

OneKey® MLS

APN: 2257-09-153-00-0020-0

Your Personal Tour Guide

Ask me questions while you tour the home.