Brian O'Connor
Real Estate Salesperson
REALTOR®
BEDS5
BATHS3 full
SQUARE FEET3,796
MLS#987782
STATUSActive
PROPERTY TYPEResidential - Single Family
SCHOOLSewanhaka Central
Property Description
Attention all cash buyers, investors and reno enthusiasts: This 5 bdrm, 3 bath, classic brick Center Hall Colonial is set on an expansive 0.48 acres (70'x289') with inground salt water pool. All large rooms -- elegant entry foyer w/2closets, banquet-sized formal dining room w/crown molding, spacious living room w/fireplace, stately den w/fireplace, EIK w/pantry & stained glass (in cabinets), & laundry rm on 1st floor. Generous primary bdrm w/bath & 2 WICs, 4 addt'l bdrms (1 w/WIC) & 2nd flr main bath. Full basement (prior flooding), pull-down attic, oil heat (inground oil tank), gas cooking, appliances As Is, 2 car garage (fits 4 cars in tandem), long driveway & circular front driveway. The backyard oasis features a patio, inground pool w/diving board, & inground sprinklers (not on). Cash preferred. Sold As Is.
Property Features
Property Type: Residential - Single Family
Basement: Full
Basement: Yes
Cooling: None
Garage: 2
Heating: Oil
Home Style: Colonial
Lot Size: 0.48 Acres
Taxes: $28,864
Year Built: 1925
Amenities
Central Vacuum
Crown Molding
Eat-in Kitchen
Formal Dining
High Ceilings
His and Hers Closets
Pantry
Primary Bathroom
Walk-In Closet(s)
Washer/Dryer Hookup
Feature Descriptions
Appliances: Gas Oven, Refrigerator
Attic: Pull Stairs
Building Area Total: 3796
Days on Site: 1
Exterior: Brick, Frame
Fireplace Features: Family Room, Living Room, Wood Burning
Formal Dining: Yes
GarageY/N: Yes
Heating Zones: 4
Lot Dimensions: 70'x289'
Lot Features: Back Yard, Near Shops, Sprinklers In Front, Sprinklers In Rear
Number Of Kitchens: 1
On Market Date: 2026-04-21
Parcel Number: 2007-32-273-00-0026-0
Parking Features: Detached, Driveway, Garage, Tandem
Parking Total: 4
Patio And Porch: Patio
Pool Features: Diving Board, In Ground, Outdoor Pool, Salt Water
Rental Term: Monthly
Rooms Total: 10
Sewer: Public Sewer
Swimming Pool: Yes
Utilities: Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water: Public
Local Schools
High School: Floral Park Memorial High School
Middle School: Floral Park Memorial High School
Elementary School: John Lewis Childs School
School District: Sewanhaka Central
Estimate Your Payment
Estimated Payment
$ 8,817.84 per month $6,062.80 Principal & Interest $2,405.33 Property Tax $349.71 Homeowner's InsuranceChange Payment Information
Listed By / Shown By
Listing By
Agency Name: Signature Premier Properties
Agency Contact: 516-546-6300
Shown By
Agent Name: Brian O'Connor
Agent Phone: (516) 825-6511
Agency Title: Coldwell Banker American Homes
Member Participants (and their affiliated licensees, if applicable) shall indicate on their websites that IDX information is provided exclusively for consumers’ personal non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, that the data is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant’s applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Agent License Information: Real Estate Salesperson
497 Tulip Avenue | MLS# 987782
This single family home located at 497 Tulip Avenue , Floral Park, NY 11001 is currently listed for sale with an asking price of $1,199,000. This property was built in 1925 and has 5 bedrooms and 3 full baths with 3796 sq. ft. Tulip Avenue is located within the Sewanhaka Central school district. Search Floral Park real estate on brianoconnor.cbamhomes.com today.