Michele M. Martinez
Licensed Real Estate Salesperson
REALTOR®
New Hartford, NY
Cell: (315) 982-1918 Office: (315) 768-1680 Fax: (315) 768-1685
New - 20 Hours Ago
View Full Photo Gallery

Property Description

Welcome home to this charming Cape Cod nestled at the very end of a quiet cul-de-sac on a truly exceptional .75-acre double lot. Boasting wonderful curb appeal, a beautiful newer front door welcomes you into this meticulously maintained and tastefully updated home. The bright, spacious living room offers an inviting space to relax, while the updated kitchen features elegant leaded glass cabinetry details that add warmth and character. The beautifully remodeled bathroom showcases a stunning fully tiled walk-in shower with a striking signature accent wall. A remodeled first-floor bedroom provides convenience and flexibility, while the oversized rear mudroom/hallway offers abundant storage and easy access to the partially finished basement, complete with two additional finished rooms ideal for a home office, gym, hobby space, or recreation area. Step outside to an impressive oversized epoxy patio overlooking the expansive backyard-perfect for entertaining, relaxing, or enjoying the privacy of this incredible lot. The large two-car garage includes a dedicated work area, and two additional storage sheds provide even more space for tools, equipment, and outdoor gear. Additional updates and amenities include central air conditioning, forced-air heat, and an efficient tankless hot water system. This rare combination of charm, updates, space, and an extraordinary lot makes this home a truly special opportunity. Double lot (both lots includede in the sale)

4238 Loran Avenue | MLS# B1695710

This single family home located at 4238 Loran Avenue, Hamburg, NY 14075 is currently listed for sale with an asking price of $299,900. This property was built in 1963 and has 1 bedrooms and 1 full baths with 908 sq. ft. Loran Avenue is located in the Holland Land Company's Su subdivision within the Frontier school district. Search Holland Land Company's Su real estate on michele-martinez.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Saturday July 11th, 11:00am - 1:00pm
Open House Sunday July 12th, 11:00am - 1:00pm

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Full, Partially Finished
Cooling: Central Air
Garage: 2
Heating: Gas, Forced Air
Home Style: Ranch
Lot Size: 0.75 Acres
Stories: 1.0
Taxes: $4,168
Year Built: 1963

Amenities

Ceiling Fan(s)
Eat-in Kitchen
Separate/Formal Living Room
Natural Woodwork
Bedroom on Main Level
Blacktop Driveway
Concrete Driveway
Patio

Feature Descriptions

Appliances: Dryer, Dishwasher, Free-Standing Range, Gas Water Heater, Microwave, Oven, Refrigerator, Washer
Exterior: Other, Vinyl Siding
Flooring: Hardwood, Luxury Vinyl, Other, See Remarks, Varies
Laundry: In Basement
Lot: Cul-De-Sac, Rectangular, Rectangular Lot, Residential Lot
Lot Dimensions: 160X200
Parcel#: 144889-171-180-0002-026-200
Parking: Detached, Garage
Parking Notes: Detached, Garage
Patio/Porch: Patio
Sewer: Connected
Utilities: Sewer Connected, Water Connected
Water: Connected, Public
Window: Leaded Glass

Local Schools

School District: Frontier

Estimate Your Payment

Estimated Payment

$ 1,102.25 per month $667.45 Principal & Interest $347.33 Property Tax $87.47 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: WNYbyOwner.com
Agency Contact: 716-523-8508

Shown By

Agent Name: Michele M. Martinez
Agent Phone: (315) 982-1918 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers 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 on this site was last updated 07/07/2026. The listing information on this page last changed on 07/07/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Tue 07/07/2026 12:00:00 AM EST) or Global MLS (last updated Mon 07/06/2026 11:52:19 PM EST) or New York State Alliance MLS (last updated Mon 07/06/2026 11:54:59 PM EST) or Hudson Valley Catskill Region MLS (last updated Mon 07/06/2026 11:51:16 PM EST) or Berkshire MLS (last updated Mon 07/06/2026 8:13:35 PM EST) or OneKey MLS (last updated Mon 07/06/2026 11:53:23 PM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel

THANK YOU FOR
YOUR INTEREST!

Complete the fields below to receive additional details.

Add to Calendar

Reserve A Time

Cancel Your Appointment?

Registration Successful

You are now registered to view virtual open houses for the listings.