Title Page Background
DEBUG FN args: Array ( [0] => 1872 [1] => [2] => [3] => agent ) BEFORE: Site: 1872 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1872 Igate: njhud LocID: 1872 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1872 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1872 [1] => [2] => [3] => lender ) BEFORE: Site: 1872 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1872 Igate: njhud LocID: 1872 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1872 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1872 [1] => [2] => [3] => other ) BEFORE: Site: 1872 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1872 Igate: njhud LocID: 1872 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1872 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

89 Virginia Street
Waterloo, NY 13165
Jennifer LaRoche with Keller Williams Realty Gateway, original listing - (585) 256-4400

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $144,900
Beds: 5
Baths: Full: 2
Status: Active
SqFt: 2988 Square Feet
Agency: Keller Williams Realty Gateway
Agency Phone: (585) 256-4400

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1852
Notes: Step Back In Time With This Charming 5-Bedroom, 2-Bath Victorian In The Heart Of Waterloo Village. Built In 1852 And Once The Residence Of A Former Mayor, This Nearly 3,000 SqFt Home Blends Historic Character With Modern Potential. Original Wood Floors, Tall Ceilings, And Ornate Window Frames Echo The Character Of A Bygone Era, While A Rebuilt Front Porch And Newer Rear Deck (Both 5Years Old) Enhance Outdoor Living. Enter Through The Foyer. The Spacious Layout Offers Excellent Flexibility,Including A Large Eat-In Kitchen, Formal Dining Room, Oversized Living Room Spaces And Enjoy The Ease Of First-Floor Living With A Bedroom, Full Bath, And Laundry All On The Main Level—Ideal For Multi-Generational Needs. Upstairs Includes Three Additional Bedrooms, With One Featuring An Adjoining Room And Walk-In Closet—Ideal For A Potential Future Primary Suite With Added Plumbing. Outside, The 0.46-Acre Lot Is A Gardener’s Dream: Knockout Roses, Five Rose Of Sharon, Lilac Bushes, And A Mature Apple Tree Frame The Yard In Vibrant Blooms And Shade. With Two Separate Entrances, This Home Has Multiple Possibilities: A Spacious Single-Family Residence, Income-Producing Rental, Or A Potential In-Law Suite. A 2-Car Garage Offers Additional Storage And Convenience. Tucked Between NYS Thruway Exits 41 & 42, This Centrally Located Gem Places You In The Heart Of The Finger Lakes Region, With Easy Access To Wine Trails, Lakes, And Regional Amenities. Whether You're Restoring Or Reimagining, This Rare Historical Offering Presents Endless Opportunity.
MlsNumber: --
ListingId: R1600486


Listing Provided By: Keller Williams Realty Gateway, original listing
Phone: (585) 256-4400
Office Phone: (585) 256-4400
Agent Name: Jennifer LaRoche
Disclaimer: Copyright © 2025 New York State Alliance of MLSs, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App