Tour
#202515829, Odilon Campos, Listing office: Campos Real Estate Services
Property details
About 818 Emerald Dr
Welcome to one of Lafayette’s most extraordinary estates. This true one-of-a-kind masterpiece sits on over 25 private acres and boasts more than 2,000 feet of scenic Wildcat Creek frontage. Custom built in 2011 to capture the timeless charm of a 100+ year-old home, every inch of this property blends historic character with modern comfort. From the authentic push-button light switches and custom wood work, to the radiant floor heating throughout, no detail was overlooked. The home is engineered for efficiency with 2x6 construction, foam and batt insulation, radiant coils in all three furnaces, and an outdoor wood boiler that can heat the entire home through winter at virtually no cost. Enjoy peaceful mornings on the screened-in porch, entertain around the outdoor fireplace, or host guests in the full one-bedroom apartment above the heated three-car garage. The long, winding driveway is lined with street lights and surrounded by manicured landscaping, an irrigation system, and abundant wildlife. If you’ve been searching for the perfect mix of land, privacy, craftsmanship, and comfort, this is it.
Highlights
Home typeSingle Family Residence
HeatingPropane, Wood, Forced Air, Radiant, Multi Unit(s)
StatusActive
CoolingCentral Air, Multi Unit(s)
Lot size25.941 Acres
Year built2011
ParkingConcrete, Gravel
MLS #202524606
Attached garage3 spaces
WaterfrontCreek
FireplaceLiving/Great Rm
Virtual tour
Summary
- Full Bathrooms: 4
- Flooring Type: Hardwood Floors, Carpet, Tile
- Fireplace: Living/Great Rm
- Total Bedroom Count: 4
- Garage Space: 3 spaces
- Attached Garage: Yes
- Parking: Concrete, Gravel
- Waterfront: Creek
- Exterior: Cement Board
- Architectural Style: Victorian
- Heating: Propane, Wood, Forced Air, Radiant, Multi Unit(s)
- Cooling: Central Air, Multi Unit(s)
- List Price: $1,575,000
- Price/SqFt: $298
- Annual Tax Amount: $636
- Tax Year: 2023
- Lot: Wooded, Waterfront, Views
- Directions: From 26, take Frontage Road to Shady Creek, then take Emerald Drive. Property at the end of the court on private lane.
- Year Built: 2011
- Lot Size: 25.941 Acres
- MLS Number: 202524606
- Office Name: Raeco Realty
- Listing Agent: Joshua Shives
The data on this website relating to real estate for sale comes in part from the Internet Data Exchange (IDX) program of the Indiana Regional MLS (IRMLS). IDX information is provided exclusively 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. Data is deemed reliable but is not guaranteed accurate by the MLS. ©2011-2025 Indiana Regional MLS. All rights reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
Last updated on: 7/23/2025, 11:45:29 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
| Year | Assessment | Property Tax |
|---|---|---|
| 2023 | $46,800 | $636 |
| 2022 | $46,800 | $710 |
| 2021 | $46,800 | $743 |
| 2019 | $36,500 | $587 |
| 2018 | $36,500 | $602 |
| 2017 | $36,500 | $567 |
History based on county public records data.
Nearby schools
7
Glen Acres Elementary School
Public District KG-4
0.9 mi
•1106 Kensington Dr
7
Vinton Elementary School
Public District KG-4
1.8 mi
•3101 Elmwood Ave
7
Wyandotte Elementary School
Public District KG-5
2.6 mi
•5865 E 50 S
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $62,321. Most Lafayette, IN residents have annual incomes less than $<35k. Residents typically live in single, no kids family. The most common level of education of people living in this area is post secondary degree.
How much money do the neighbors make?
39%
<35k
28%
35k-100k
28%
100k-200k
5%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
57%
Single, No Kids
5%
Single, with Kids
27%
Married, No Kids
11%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
9%
<11 yrs old
5%
12-17 yrs old
26%
18-34 yrs old
41%
35-64 yrs old
19%
65+ yrs old
What do the neighbors do for fun?
Pro Wrestling
Figure Skating
College Football
Where do the neighbors shop?
Family Dollar
Kmart
Express/Express For Men
Where do the neighbors go to eat?
Dominos Pizza
Bob Evans
Sonic
What do the neighbors drive?
Ford
Buick
Kia
What do the neighbors listen to?
New Country
Oldies
Adult Standards
All data provided by Home Junction and Claritas
Similar homes for sale
Tour
#202527281, Brett Walker, Listing office: The Wyman Group
Backup offersTour
#202516645, Tamara House, Listing office: RE/MAX At The Crossing
Tour
#202519608, Robyn Bower, Listing office: The Real Estate Agency
Tour
#202506254, Amy Junius-Humbaugh, Listing office: F.C. Tucker/Shook
Tour
#202525211, Evan Vogel, Listing office: VOGEL REAL ESTATE
6 days on Rocket
#22050581, Jayson Benner, Listing office: F.C. Tucker Company
Tour
#202526311, Grant Thompson, Listing office: Raeco Realty
6 days on RocketTour
#202527987, Kevin Asay, Listing office: Merit Realty - Lafayette
Tour
#202517168, Lisa Hall, Listing office: Trueblood Real Estate
Frequently asked questions
Living in Lafayette, IN
Lafayette's transport infrastructure supports both private and public transit options, with a network of roads and highways that facilitate travel within the city and to neighboring areas. Public transportation services are available, providing residents with alternatives to private vehicle use. The city is also conscious of walkability, with certain areas designed to be pedestrian-friendly. While specific ride-sharing statistics are not mentioned, such services are a part of the city's transportation landscape, complementing the existing mobility options.
The community is served by a comprehensive array of services, including public and private educational institutions that cater to a range of academic preferences. Lafayette is home to several healthcare facilities, offering residents access to primary care, emergency services, and specialized medical treatments. The city's public library system provides educational and cultural resources to the community. Retail and dining options are plentiful, with local businesses and restaurants reflecting the diverse tastes and culture of the residents. City initiatives are in place to continually improve and adapt services to meet the evolving needs of the community.
Lafayette is celebrated for its vibrant community spirit and rich historical heritage. The city prides itself on its blend of urban amenities and small-town charm, offering residents a comfortable and engaging living environment. Annual events, such as the Taste of Tippecanoe, showcase the city's cultural diversity and foster a sense of community. The area's parks and recreational facilities contribute to the overall family-friendly atmosphere, making it an appealing place for a variety of residents.
Lafayette's housing market offers a diverse array of options, with single-family homes being a significant presence. The architectural styles in the area range from historic Victorian homes to contemporary ranch-style houses. The market is balanced with a mix of older homes that exude character and newer constructions that provide modern amenities. While the majority of the housing stock consists of single-family residences, there is also a selection of apartments and townhouses that cater to different lifestyle needs. The homeownership rate in Lafayette is robust, reflecting a community invested in property ownership and stability.
About 818 Emerald Dr
The listing price of 818 Emerald Dr property is $1,575,000.
The property 818 Emerald Dr is a house located in Lafayette, Indiana, 47905.
Active Listing: 818 Emerald Dr is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 818 Emerald Dr are: Glen Acres Elementary School (GreatSchools Rating 7/10), Vinton Elementary School (GreatSchools Rating 7/10), Wyandotte Elementary School (GreatSchools Rating 7/10), Lafayette Sunnyside Intermediate School (GreatSchools Rating 4/10), Lafayette Tecumseh Jr High School (GreatSchools Rating 5/10), East Tipp Middle School (GreatSchools Rating 8/10), Excel Center - Lafayette (GreatSchools Rating 1/10), Jefferson High School (GreatSchools Rating 3/10), West Lafayette Jr/Sr High School (GreatSchools Rating 8/10).
According to the records, the last property tax for 2023 is $636 (source: MLS/based on county public records data).
The property at 818 Emerald Dr has 4 bedrooms and 4 bathrooms.
The year of construction for 818 Emerald Dr is 2011.
This home is located at 818 Emerald Dr in Lafayette, IN and zip code 47905. This home, which was built in 2011, sits on a 25.94 acre lot. Features: 4 bedrooms, 4 bathrooms. It has been listed on Rocket Homes since June 26, 2025 and is currently priced at $1,575,000.
Over 39 listings were sold over their listed price in June 2025 in Lafayette, IN. In the same period over 43 listings were sold below the listed price and 34 listings were sold for the listed price. The number of listings in Lafayette, IN increased by 2.5% between May and June 2025. In June 2025 median list price was $266,000 and the average listing age was 9 days.
From Rocket Homes Real Estate and based on county public records data.