ERA Logo My ERA.com | Find an Office | Find a Sales Associate | Find a Relocation Specialist | Español.era.com
5 miles from zip code 15044
Search Criteria Arrow Search Results Arrow Search for Other Houses in this County
Arrow View All Broker Listings

Showing 1 - 5 of 156 homes
Previous | Next
Address
Beds Baths
Full  Half
Graphic Price Sq.Ft.
332 Overbrook Road Middlesex Twp, PA 16059 3 20 $2,500,000 1900
Photo
View Details
This property features:
Photo Gallery
Description: This beautiful 33 acre farm surrounded by 3 miles of white vinyl fencing. Bring your horses. A 64 stall capacity barn with an indoor arena and cozy great room await you and your friends. As you see it, Silver Crest is in ready on day one condition. It has been well thought out to minimize labor and over $100,000 in new equipment has been added. A 1900 square foot home with a sunken great room and island kitchen was added in October 2005. You can begin utilizing and running this farm immediately as a riding academy and boarding facility---or---turn it into a show facility---or, make it a top notch breeding farm. It is near all proposed western Pennsylvania track sites. Located in the Mars Area School District, recent development of the area verifies Silver Crest's current value and its potential. Developers with vision are encouraged to view this location keeping in mind its close proximity to Route 79, Route 8, Route 228, the PA Turnpike and the new Westinghouse location. ****24 HOUR NOTICE IS REQUIRED****CALL CAROL 412-596-0929

Listing Courtesy: Coldwell Banker Real Estate Services



Compare - NoAdd to Compare
Save in My ERA.comCompareApply for Mortgage
61 Palomino Drive West Deer, PA 15101 2 31 $1,300,000 N/A
Photo
View Details
This property features:
Virtual TourPhoto Gallery
Description: Ask me about the $7500 government tax credit when buying your home! This unique estate greets you with 50 acres of manicured and wooded grounds incorporating 1.3 miles of trails wandering through mature woods and landscaped acreage dotted with an assortment of finely detailed functional outbuildings. This home is perfect for an active outdoor life or formal entertaining. You will never find anything quite like this!

Listing Courtesy: Coldwell Banker Real Estate Services



Compare - NoAdd to Compare
Save in My ERA.comCompareApply for Mortgage
2194 Grandeur Drive Hampton, PA 15044 5 42 $1,299,800 N/A
Photo
View Details
This property features:
Virtual TourPhoto Gallery
Description: Ask me about the $7500 government tax credit when buying your home! Luxury Redefined! A world you never thought could exist. Enjoy the privacy and seclusion offered on this private 1.6 acre lot in the Estates of the Villa. Masterful craftsmanship is evident in this 5 bedroom 4+2 bath home with a three car attached garage framed by mature landscaping replete with 2 fireplaces, custom woodworking, neutral décor, spacious gourmet kitchen, Great Room, offering natural light from the spectacular wall of windows and custom touches throughout. Enjoy the magnificent view from the deck overlooking the pool and yard. Virtual perfection in a home, neighborhood and location. Close to shopping, major highways and schools for either commuting or pleasure.Features: Estates at the Villa, 1.6 Acres, Electric dog fence, Built by Angelo Spagnolo, 36’x18’ swimming pool, with heat, chlorine processing, outdoor speakers, decorative rocks, pool cover and Aquabot cleaner Gas pit, landscape lighting on over 1.6 acres 2 Lennox furnaces, 132 gallon hot water heater, 2 Aprilaire humidifiers, 2 Lennox air cleaners, 10 zone/40 head sprinkler system, 400 AMP service, Vector security system, Home theater equipment, Televisions in Kitchen, Great Room and Game Room Hampton School District Call Carol Bagaley at 412-551-8850

Listing Courtesy: Coldwell Banker Real Estate Services



Compare - NoAdd to Compare
Save in My ERA.comCompareApply for Mortgage
572 MacLeod Drive Pine Twp, PA 15044 4 42 $1,299,000 N/A
Photo
View Details
This property features:
Virtual TourPhoto Gallery
Description: Ask me about the $7500 government tax credit when buying your home! Luxury Home Custom Built by Richey Construction featuring 4 Bedrooms, 4 Full Baths, 2 Half Baths, 4 Car Attached Garage, Governor's Drive, Vaulted Covered Rear Patio, Full Home Automation/Lighting, State-of-the-Art Sound System/Invisible Surround Sound, Complex 2 Story, Vaulted & Tray Ceilings with spectacular lighting effects, Vaulted Foyer, gorgeous open Circular Staircase, Wrought Iron Railings, Arched Balconies, 2 Story Greatroom Stone Fireplace, 2 Story Stone Architectural Columns, 60 Greatroom Plasma, 2 Story Turret Den exquisite Woodwork, Built-ins & Double Leaded Glass Doors, Formal Bayed Dining Room Coffered Ceiling & Granite Butlers Pantry, Gourmet Chef's Stone,Granite & Stainless Center Island Kitchen, Large Walk-in Pantry, Sunny Breakfast Area with Walls of picture Windows & Covered Rear Porch Access, Gracious 1st Floor Master Suite with Double Tray Ceiling,Huge Master Walk-in Wardrobe Granite Vanity & Custom Organizers, 1st Floor Vaulted Laundry Room Skylights & Custom Cabinetry, Mud Room Locker Storage, Fully Equipped Home Theatre with adjoining Granite Bar Room, Walkout Lower Level, 3 Upper Level Bedrooms ensuite and Hi-Tech Cameras/Automated Control for access & view of this fabulous luxury residence from anywhere via the Internet to name a few of its luxury amenities sure to please... Lake MacLeod offers amenities that compliment and enhance its beautiful surroundings. A scenic 10-acre lake sits at the heart of this community, and is accessible from every lot through an extensive system of hiking trails and walking paths. The nearly mile-long Lake Trail encircles the water and provides five fitness stations. The Lake Trail is partially ADA-compliment and serves as access to two neighborhood parks, picnic areas, the boathouse, and separate fishing and swimming piers. The 1200 square foot boathouse, with its stone fireplace and waterfront views, provides a magnificent commu

Listing Courtesy: Coldwell Banker Real Estate Services



Compare - NoAdd to Compare
Save in My ERA.comCompareApply for Mortgage
Lot 103 Enclave Gibsonia, PA 15044 5 41 $1,250,000 N/A
Photo
View Details
This property features:
Photo Gallery
Description: Exclusive cul-de-sac of custom designed luxury homes on large estate lots. Still time to make custom selections! Gorgeous 5 BR home with walkout lower level on wooded lot! Luxury Master Suite on 1st Flr w/fireplace & lrg 13x12 closet. 2 St Ent w/turret stairwell. Lib w/built-ins. 2 st Grt Rm w/FP!

Listing Courtesy: CENTURY 21 Town & Country Real Estate Services



Compare - NoAdd to Compare
Save in My ERA.comCompareApply for Mortgage
Change Search Criteria Local Office Websites

Previous | Next

Area Map



Loading Map...
Map Legend:
Home Resort Property
Land Commercial Property
ERA Office   International Collection Property

Adjust Your Search
Price Range:
Minimum Bedrooms:
Minimum Bathrooms:


RSS Feeds
These search results are available as an RSS feed.
Subscribe | More Info

My ERA.com - Save this search
Name your search:
My ERA.com
My ERA.comLogo
Manage your home buying or selling process here!

Join My ERA now

Already a member? Login now!
User Name/email address:
Password:
 
Forgot your password?
ERA® Mortgage
Path to Homeownership

ERA Mortgage Logo

Making home loans easy in 4 simple steps.

Go

Equal Housing Opportunity ©2008 ERA Franchise Systems LLC. All Right Reserved. ERA® and Always There For You® are registered trademarks licensed to ERA Franchise Systems LLC.
An Equal Opportunity Company. Equal Housing Opportunity. Each Office is Independently Owned and Operated.
View our Privacy Policy and Terms and Conditions.