Loretta Weldner
Licensed Associate Real Estate Broker
REALTOR®
Johnstown, NY
social icon 
New
View Full Photo Gallery

Property Description

154-96 Riverside Drive | Whitestone, NYA Masterpiece of Modern Luxury LivingWelcome to this fully customized smart home on a premier 60x100 corner lot in Whitestone, offering approximately 4,000 square feet of living space (excluding the finished basement), with four bedrooms, two full and two half baths.Radiant heated floors on the first level, heated second-floor bathrooms and laundry, central air, and individual climate controls in every bedroom provide ultimate comfort year-round. A gas fireplace anchors the main living space.Designed for modern living, the home features full smart home integration with app-controlled lighting and systems. Enjoy in-ceiling Bose speakers throughout, a Sonos audio system, and surround sound in both the living room and finished basement for a seamless entertainment experience.The chef's kitchen is equipped with top-of-the-line Wolf and Sub-Zero appliances, including an 8-burner stove, built-in espresso machine, double Bosch dishwashers, wine fridge, disposal/compactor, and two farmhouse sinks with point-of-use filtration. A custom pantry with a pullout desk adds convenience, along with a first-floor powder room.Upstairs, the king-sized primary suite offers a spa-like en-suite bath and California Closets, with Restoration Hardware chandeliers enhancing every bedroom. A top-floor laundry room completes the level.The finished basement extends the living space with indoor-outdoor flow, ideal for entertaining.Outside, enjoy a private resort-style setting with a heated saltwater pool (7 ft to 3 ft) with automated cover, plus an outdoor kitchen featuring a Wolf barbecue and Blaze refrigerator.A rare opportunity to own a turn-key luxury smart home combining scale, comfort, technology, and high-end finishes in one of Whitestone's most desirable locations. Featured Residential Sales.

15496 Riverside Drive | MLS# 974294

This single family home located at 15496 Riverside Drive , Whitestone, NY 11357 is currently listed for sale with an asking price of $2,888,888. This property was built in 1950 and has 4 bedrooms and 2 full and 2 partial baths with 2896 sq. ft. Riverside Drive is located within the Contact Agent school district. Search Whitestone real estate on loretta-weldner.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Sunday March 22nd, 2:00pm - 3:00pm

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Full, Walk-Out Access
Basement: Yes
Cooling: Central Air
Fireplaces: 1
Garage: 1
Heating: Natural Gas
Home Style: Contemporary, Mediterranean
Lot Size: 0.14 Acres
Taxes: $14,840
Year Built: 1950

Amenities

Built-in Features
Ceiling Fan(s)
Chandelier
Chefs Kitchen
Crown Molding
Double Vanity
Dry Bar
Eat-in Kitchen
ENERGY STAR Qualified Door(s)
Entrance Foyer
Formal Dining
Granite Counters
Kitchen Island
Marble Counters
Open Kitchen
Pantry
Primary Bathroom
Smart Thermostat
Whole House Entertainment System

Feature Descriptions

Appliances: Convection Oven, Cooktop, Dishwasher, Disposal, Dryer, Freezer, Gas Cooktop, Gas Oven, Gas Range, Microwave
Attic: Partial, Pull Stairs
Building Area Total: 2896
Days on Site: 2
Exterior: Brick, Stucco
Fireplace Y/N: Yes
Flooring: Hardwood
Formal Dining: Yes
GarageY/N: Yes
Lot Features: Back Yard, Corner Lot, Front Yard, Garden
Number Of Kitchens: 1
On Market Date: 2026-03-20
Parcel Number: 04543-0037
Parking Features: Driveway
Parking Total: 3
Pool Features: Diving Board, Electric Heat, In Ground, Pool Cover, Salt Water
Rental Term: Monthly
Rooms Total: 10
Sewer: Public Sewer
Swimming Pool: Yes
Utilities: Cable Connected, Electricity Connected, Natural Gas Connected, Phone Connected, Sewer Connected, Water Connected
Water: Public
Waterfront Features: Bayfront

Local Schools

High School: Contact Agent
Elementary School: Contact Agent
School District: Contact Agent

Estimate Your Payment

Estimated Payment

$ 8,508.67 per month $6,429.41 Principal & Interest $1,236.67 Property Tax $842.59 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: NY Space Finders Inc
Agency Contact: 718-440-8162

Shown By

Agent Name: Loretta Weldner
Agent Phone: (518) 762-3808 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 03/22/2026. The listing information on this page last changed on 03/22/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 Sun 03/22/2026 12:35:28 PM EST) or Global MLS (last updated Sun 03/22/2026 12:22:12 PM EST) or New York State Alliance MLS (last updated Sun 03/22/2026 12:30:52 PM EST) or Hudson Valley Catskill Region MLS (last updated Sun 03/22/2026 12:31:26 PM EST) or OneKey MLS (last updated Sun 03/22/2026 12:27:10 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.

Listing data and photos distributed by MLSGRID
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.



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