Title Page Background
HFQUERY 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 = 1867 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1867 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1867 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

2 Perch Bay Road
Ogdensburg, NY 13669

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 3
Baths: 4
Status: Active
SqFt: 3300
Agency: America 1 Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2019
Notes: Introducing this amazing residence. An entertainer's dream come true, this property features a spacious open floor plan and stunning outdoor spaces. In floor radiant heat, reverse osmosis water filter, forced and central air throughout. The siding is LP Smart siding. The kitchen exudes high style and high end finishes as well as a huge center island perfect for entertaining. Gorgeous solid wood cabinets, stainless steel KitchenAid appliances, and designer pendant lights. A popular kitchen-great room open concept wastes no space and connects the living spaces brilliantly for comfort, conversation and dining. The living room is cozy and inviting with cathedral ceilings and a massive stone faced, gas fired, wood burning fireplace. Light from the setting sun fills the living room, creating a warm and inviting space. French doors line the exterior wall and lead to a deck overlooking the water and grounds. The master bedroom features Anderson French doors that lead to the deck and the luxurious master suite bath. The centerpiece of the living room is the grand staircase leading to the second floor. The second floor has a full office, second bedroom with double closets and attached full bath. There is a family room in the center of the second floor that offers a cozy spot to relax and enjoy the view of the river and Canada through the large picture windows. As you travel back downstairs to the walk-out basement you pass on the stairs the utility room with large storage availability. The bonus room, lower level features a guest ensuite lined with patio doors leading to a lower deck. It is the perfect spot for entertaining guests. There is a full ensuite bath with double vanities and gorgeous counter. The main deck upstairs has a Trex Rain Escape drainage system that keeps the lower deck dry on those rainy days. There is a large multi-person hot tub on the lower deck as well. Additionally the home features 2 attached garages with lots of storage as well as potential living space above. Completely paved circular driveway with lots of parking. There is also a back lot with limitless potential. The water side of the property boasts 182 feet of St. Lawrence River waterfront. The home is landscaped with gorgeous stone walkways and mature flower gardens. Come and take a look today! This could be your new home.
MlsNumber: 49808


Listing Provided By: America 1 Realty, original listing
Name: America 1 Realty
Phone: (315) 394-1116
Office Name: America 1 Realty
Office Phone: (315) 394-1116
Agent Name: Andrea J. Chadwick
Disclaimer: Copyright © 2024 St. Lawrence Board of Realtors. 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