30096.23.9.001.Cover:TREB_CVR_US_ChangeWeb
3/23/11
3:51 PM
Page 1
THE
Real EstateBook
E X T E N D Y O U R S E A RC H AT R E A L E S TAT E B O O K . C O M CINCINNATI METRO Featuring: Butler, Clermont, Hamilton, Warren Counties and Surrounding Areas Vol. 23 :: No. 9
DETAILS ON THIS PROPERTY Page 6 RealEstateBook.com
Finkelman Real Estate Rachel Lewitt, Broker/Owner 513/423-4688
UPDATED DAILY
RealEstateBook.com RELOCATING? CALL 800/841-3401 for a FREE copy of The Real Estate Book. Available for most North American areas.
FOR ADVERTISING INFORMATION Call Tricia Green: 513/545-6790 Email: tgreen@treb.com
30096.23.9.002.Beebe1
3/23/11
3:46 PM
Page 1
The Beebe Team Larry & Jason Beebe Hotline: 513-459-4663 Each Office is Independently Owned & Operated
MAINEVILLE 1238 Stableview Cir $162,500 MLS # 1252902
FRANKLIN TWP 4131 Jamie Ln $ 209,900 MLS # 1254342
MIAMI TWP 6753 Smith Rd $169,900 MLS # 1255710
MIAMI TWP 1353 Lela Ln $129,900 MLS# 1252675
TURTLECREEK TWP 1948 Union Rd $159,900 MLS # 1234880
PLEASANT RIDGE 2742 Lawndale Ave $159,900 MLS# 1245007
LOVELAND 10094 Fox Chase Dr
MASON 4302 Grasmere Run
SO LD
MASON 4823 Bordeaux Ln $126,500 MLS # 1258922
SO LD
MASON 3791 Crooked Tree $379,000 MLS # 1255744
SO LD
SEVEN MILE 309 N Main St $109,900 MLS # 1258919
MASON 5485 Harvestdale Dr
Buy or Sell a Home With the Beebe Team & Use Our Moving Truck for FREE!
30096.23.9.003.Beebe2:Layout 1
3/23/11
3:47 PM
Page 1
View Virtual Tours on Our Website
www.BBTeamHomes.com Each Office is Independently Owned & Operated
WEST CHESTER 7560 Shawnee # 250 $87,500 MLS # 1244033
MASON 5636 Crestwood Dr $459,900 MLS # 1259225
MASON 5713 Thornberry Ct $294,900 MLS # 1259379
LEBANON 913-B Dillon Way $119,900 MLS # 1259399
HAMILTON TWP River View Ct Lot # 27 $59,900 MLS # 1229789
SO LD
FAIRFIELD 693 Innsbrooke Ln $179,900 MLS # 1257576
LOVELAND 6888 Sweetfarm Ln
MASON 312 Bainbridge Ct
MASON 5822 Running Fox Ln
SO LD
LIBERTY TWP 6362 Woodgate Way
SO LD
SO LD
MASON 6574 Quail Lake
LIBERTY TWP 6119 Blackberry Ct
FREE Home Evaluation! Visit www.BBTeamHomes.com
30096.23.9.004.QR:1002
3/23/11
3:50 PM
Page 1
Page 4 - Why Buy Now? Ask a REALTOR® - Vol. 23, No. 9
Introducing QR Codes! So, what is a QR Code, anyway? A QR Code is a “smartphone readable barcode.” In other words, it is a “print-based hyperlink,” which allows print media to become fully interactive with the digital world!
How do you use them?
Scan this QR code to visit TheRealEstateBook.com
For our advertisers, we will create a custom QR to place on your ad which will link directly to your website! For home shoppers, you can scan these with your smartphone, and view the latest inventory and prices on a Realtor’s® website.
But it doesn’t stop there – a QR Code can also contain a phone number, an SMS message, V-Card data, a video link, or just plain text and the scanning device will respond by opening up the correct application to handle the encoded data appropriately. So go ahead and download a QR Reader on your smartphone, and let the fun begin! Enjoy! Tricia Green 513-545-6790 tgreen@treb.com
Scan this QR code for a Message From Tricia!
30096.23.9.005.RealtyBid:30003.17.8.038
3/23/11
3:47 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 9 - Page 5
30096.23.9.006.Masthead:0100
3/23/11
4:21 PM
Page 1
Page 6 - Get More Details With RealEstateBook.com - Vol. 23, No. 9
ON THE COVER For advertising information in The Real Estate Book of Greater Cincinnati, contact:
SORG MANSION ESTATE Historical S. Main Street Middletown, Ohio 45044 Over 2 acres including Main House, Carriage House and Duplex. This romaneaque castle includes many original details including fine crafted woodwork, inlaid tile, ornate fireplaces, and stained glass. Complex is gated. The Sorg House, as it was then known, was built during 1887-88 in the Romanesque Style.
Tricia Green 513-545-6790 Email: tgreen@treb.com
For further details on this property, please turn to Page 21.
Rachel Lewitt 513-423-4688 finkelmanrealestate.com
Want to see your home advertised in this magazine or featured on RealEstateBook.com? Contact any of the real estate professionals in this magazine.
FOR A
FREE MAGAZINE FROM ANY OF
500+ MARKETS, CALL
1-800-841-3401 Circulation of The Real Estate Book is Independently Audited by BPA
“All real estate advertised herein is subject to the Federal Fair Housing Act which makes it illegal to advertise any preference, limitations, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin, or intention to make any such preferences, limitation, or discrimination. We will not knowingly accept any advertising for real estate which is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis.�
30096.23.9.007.Zeilman:0400
3/23/11
3:57 PM
Page 1
Get More Details With RealEstateBook.com - Vol. 23, No. 9 - Page 7
30096.23.9.008.Dwyer:30003.17.8.038
3/23/11
3:57 PM
Page 1
The Dwyer Sells Team (513) 312-8813 See Interior Photos on Our Website:
www.DwyerSells.com Email: SOLD@DwyerSells.com
NEW HOME w/5ac!
Great Buy! NEW RICHMOND - Affordable & Adorable! Newer raised ranch. Spacious eat-in Kit w/maple cabinets, owner's BR w/attach bath, finshed bsmt for addl living, overszd garage. $120K
PIERCE TWP - NEW custom ranch, 9'+ ceilings.Lg Kit w/island/fireplc/wlk-out deck.Glamorus owner suite,w/sloped vol ceiling.Great views,wlk-out bsmt.Plenty of wildlife. $315K
Newly Remodeled!
Great Deal! SPRINGDALE - Immaculate 3BR, 1.5 BA, 2c garage, virtually maint free exterior, many updates: A/C, carpet, paint, garage opener, windows, concrete drive & more. $103,000
NEW LOOK for ANDERSON BUSINESS - Extensive remodeling Restaurant/Bar & 2 BR Home, liquor license, 732' frtge, addl land avail. Rent nice remodeled 2 sty home for addl income.
Walk-out Bsmt
Private 5ac PIERCE Twp 5+ Acres w/2 access points. Rolling wooded lot, great views, perfect lot for walk-out basemt. Near Legendary Run. Easy access to I-275, downtown, airport. $62,000
ANDERSON - Desirable building lot accommodates walk-out basement. Beautiful view, low traffic no outlet street. Don't miss out on this one! Your Builder or Ours. $144K
Are you ready to make a move?
We work with Buyers and Sellers.
Approx 3 acres ANDERSON TWP - Development opportunity. Almost 3 acre vacant lot zoned C Residential. Water and Sewer at lot. Seller will consider subdividing. $300K
Preferred Group
Call us 513-312-8813
...We Can Sell Your Home! Call Matt Dwyer (513) 312-8813
“ L i ce n se d in Oh io a nd Ke n tu ck y�
Each office independently owned and operated
3 B0096.23.9.009.KopfRealty.BringUsHome:WintonSalem
3/23/11
3:56 PM
Page 1
Why Buy Now? Ask a REALTOR® - Vol. 23, No. 9 - Page 9
office 513.871.4040 CINCINNATI MLS PROPERTY SEARCH | BUYER/SELLER RESOURCES | LIST WITH US | APPRAISAL SERVICES | KOPF RENTAL PROPERTIES | CONTACT US
Scan this QR code to visit all Kopf Real Estate Services
Bring us home. Pick up THE REAL ESTATE BOOK® at locations all over town, where you eat, work, shop & play.
UPDATED DAILY
RealEstateBook.com Call 1-800-841-3401 for a FREE magazine from over 500 markets, or order online @ RealEstateBook.com
©2009, NCI ALL RIGHTS RESERVED
Or, have a magazine mailed directly to your home from any of our 500 markets across the U.S., Canada, Mexico, Central America, & the Caribbean.
30096.23.9.010.Henson.Trautman:1500
3/23/11
3:54 PM
Page 1
Page 10 - Get More Details With RealEstateBook.com - Vol. 23, No. 9
J.A. Trautmann Realtors 513-752-5000 www.jatrealtors.com 901 Ohio Pike • Suite 200 • Cincinnati, Ohio 45245
2106 HUNTERSPOINT LANE located in Anderson. Beautifully maintained home on cul de sac. Enjoy private back yard on new deck. Updated kitchen w/ new granite countertops, bay window & stainless appliances. Finished basement. Priced to sell!! MLS/ID:1239590 46 FLORAL AVENUE located in Amelia Prime property for city development; beautiful cleared land. House is Victorian & in excellent condition. Large 10,000 sq ft barn - ideal for horses. Preliminary Single Family lot layout with quantities available to Builders and Developers MLS/ID:1193816
30096.23.9.011.Khomes
3/23/11
4:06 PM
Page 1
30096.23.9.012.013.KramerAB:1202
3/23/11
4:03 PM
Page 1
One Goal. One Passion.
MASON 6275 Bridgewater Ct $467,900 MLS#1255919
MASON 4831 Hampton Village $414,900 MLS#1251022
MASON 4053 Melampy Creek $379,900 MLS#1258626
WESTCHESTER 4766 Silver Fox Ct $489,900 MLS#1258430
WESTCHESTER 7173 Harbour Town Dr $450,000 MLS#1243591
LIBERTY TWP 6322 Cougar Path $250,000 MLS#1248634
WEST CHESTER 4871 Brantford Court $164,900 MLS#1248921
WESTCHESTER 8851 Eagleview #8 $77,900 MLS#1240252
WESTCHESTER 9315 Hare Drive $159,900 MLS#1252059
LOVELAND 57 Eastbury Drive $359,954 MLS#1237705
LOVELAND 53 Hamil Ct. $369,900 MLS#1215244
WESTCHESTER 7756 Scioto Ct. $75,000 MLS#1258934
BATAVIA TWP 42 Twin Gate $259,900 MLS#1229953
BATAVIA 26 Twin Gate $250,000 MLS#1229949
LOVELAND 9401 Country Trail $219,900 MLS#1258750
www.kathykramer.com
30096.23.9.012.013.KramerAB:1202
3/23/11
4:03 PM
Page 2
Kathy Kramer Company Sales Leader 2010 Senior Sales Vice President
kkramer@starone.com
513-265-8650 WESTCHESTER 7323 Country Club $624,900 MLS#1259783
LIBERTY TWP 7188 Tarragon Ct. $364,900 MLS#1240313
LIBERTY TWP 5865 Maud Hughes Rd $525,000 MLS#1251775
LIBERTY TWP 5405 Autumn Creek $289,460 MLS#1206381
LIBERTY TWP 5525 Princeton Road $379,900 MLS#1254057
LIBERTY TWP 5796 Dickinson Trail $244,900 MLS#1232395
LIBERTY TWP 5557 Hamilton Trail $252,900 MLS#1233115
LIBERTY TWP 60 Dantawood Ln $357,425 MLS#1207666
LIBERTY TWP 4550 Logsdons Meadow $239,900 MLS#1258075
LIBERTY TWP 6960 Cross Creek Ln $499,900 MLS#1255185
LIBERTY TWP 6056 Blueberry Dr $200,000 MLS#1242935
LIBERTY TWP. 49 Dantawood Lane $329,356 MLS#1242557
FAIRFIELD 1612 Oak Valley Dr $239,900 MLS#1251322
GREENHILLS 387 Inman Lane $112,500 MLS#1248174
www.starone.com
30096.23.9.014.Comisar
3/23/11
4:02 PM
Page 1
Page 14 - Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 9
1 Roebling Way #704 Extraordinary opportunity to live at The Ascent with amazing city and river views. THE ONLY 3 bedroom Summit floor plan is now available!
1 Roebling Way #1005 Expect the best! Ascent is worth it-exquisite upgrades thru-out-outstanding sound system, amazing view, floors, granite custom floor plan, pocket doors to guest/flex den. Plus professionally designed.
1 Roebling Way #1806 18th Floor! None higher! Imagine almost 360 degree views in exceptional metropolitan condo home w/all upgrades. Floors are stunning. Open kitchen, views, walls of windows actually lean out! Must see! Beautiful finishes.
1 Roebling Way #505 Amazing views from Ascent. Custom details and design in this transitional home. Guest den has pocket doors for privacy. Amazing amenities. Superb location.
223 E. 2nd Street Stunning, restored, refurbished to the smallest detail. Historic & updated, Federal Townhome on gorgeous tree lined street. Chic, yet charm of period. 3 fireplaces, 2 car garage, hardwood, private patio-walk to restaurants, street of other exquisite historic homes.
1299 Paddock Hills Charming Tudor on quiet culdesac. Impeccably mntnd character & architectural details of the period. Arches, beams, b/i, hdwd flrs-granite/beaut Kit, rookwood FP+baths. Close to univ, hosp. Great location. 2 car gar. Fin 3rd flr + sun rm too
1340 Sharp Rd Gatlinburg atmosphere! Extremely secluded log home on 4 acres with 3 stall stable (now garage). Meticulous and beautifully landscaped, front porch and deck. Property has water frontage Kincaid Lake est. 185ft. Updated and charming.
Scan to search listings
KATHY COMISAR Senior Sales VP (513)378-5895 comisars@gmail.com
30096.23.9.015.Leist:1500
3/23/11
4:01 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 9 - Page 15
513-794-7444 4677 Cooper Road Cincinnati, Ohio 45242
www.leistrealtors.com
NORWOOD 3828 Regent Ave $185,000 MLS#1255654 - 4BS-2BA Debbie Roebel 513-518-6805
CLIFTON - 2 FAMILY 360 Thrall Street MLS#1239851 2 Family $395,000 Amanda Sphire 513-919-7479
HARPLAN TWP - 5 acres 7891 Templin Rd $284,900 MLS#1256612 4BS-3BA Roger Leist 513-794-7444 x102
NORWOOD 5431 Roseland Mount $127,900 MLS#1255291 2BA-1.5BA Debbie Roebel 513-518-6805
AVONDALE - CONDO 3900 Rose Hill Ave #501 $72,000 MLS#1228601 3BD-3BA Jody Barkley 513-543-9097
DEER PARK 7219 Delaware Ave - $124,900 MLS#1254495 3BD-1BA Roger Leist 513-794-7444 x102
FINNEYTOWN 7814 Gapstow Bridge 102 $129,900 MLS#1245860 2BD-2BA Jody Barkley 513-543-9097
MT. WASHINGTON 1708 Tiffany Lane $146,900 MLS#1218072 4BD-3BA Roger Leist 513-794-7444 Ext 102
READING 1222 Sanborn Ct. $149,900 MLS#1252972 3BD-2BA Robert Boehner 513-794-7444
EVENDALE 3023 Cooperhill Drive $295,000 MLS#1221609 4BD-3BA Marie Leist-Smith 513-520-6883
READING - CONDO 8406 Ridge Pointe Ct $105,900 MLS#1235978 2BD-2BA Roger Leist 513-794-7444 x102
DILLONVALE 4131 Larchview Dr $139,900 MLS#1255292 3BD-1BA Debbie Roebel 513-518-6805
DEERFIELD 5974 Irwin Simpson Rd $499,000 MLS#1238648 4BD-3.5BA Elinor Ziv 513-378-1862
MT. ADAMS 953 Hatch Street $259,900 MLS#1222620 2 Units Bob Nyswonger 513-310-1270
FINNEYTOWN 948 Hollytree Dr $88,500 MLS#1255419 3BD-1.5BA Jody Barkley 513-543-9097
30096.23.9.016.Huff:0100
3/23/11
4:13 PM
Page 1
Page 16 - Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 9
REAL ESTATE RELOCATION INSURANCE MORTGAGE TITLE
Your real-time source for property data
Scan to visit us at Huff.com
Serving home buyers and sellers in:
Greater Cincinnati Northern Kentucky Southeastern Indiana
30096.23.9.017.Homearama
3/23/11
4:11 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 9 - Page 17
30096.23.9.018.019.ChabrisAB:0100
3/23/11
4:09 PM
Page 1
Page 18 - Get More Details With RealEstateBook.com - Vol. 23, No. 9
Team Chabris
513-898-1377 www.teamchabris.com
Visit our new office on Mt. Lookout Square!
HYDE PARK 3549 Michigan MLS#1256566
HYDE PARK 3725 Broadview MLS#1237902
HYDE PARK 1308 Grace Ave MLS#1252158
COLUMBIA TUSCULUM 3626 Morris Place MLS#1242891
HYDE PARK 3951 Marburg Ave MLS#1238132
HYDE PARK 1298 Morten MLS#1252551
COLUMBIA-TUSCULUM 525 Vineyard Bluff - Land MLS#1253547
OAKLEY 2878 Markbreit MLS#1256553
OAKLEY 3740 Brotherton MLS#1254462
PLEASANT RIDGE 2825 Cortelyou MLS#1244252
PLEASANT RIDGE 5428 Lester Rd MLS#1247288
MARIEMONT 6641 Chestnut Street MLS#1235221
30096.23.9.018.019.ChabrisAB:0100
3/23/11
4:09 PM
Page 2
Get More Details With RealEstateBook.com - Vol. 23, No. 9 - Page 19
MT. LOOKOUT 1274 Crestwood Ave MLS#1244302
MT. LOOKOUT 3710 Creighton Place MLS#1244855
MT. LOOKOUT 3037 Linview MLS#1250395
MADEIRA 6540 Kenview Drive MLS#1241276
MADEIRA 5666 Kenwood MLS#1241269
MASON 4741 Carriage Dr MLS#1256911
CORRYVILLE 3249 Jefferson Ave #5 MLS#1245501
Scan Code to view all listings
MIAMI TWP 735 Creekwood Bluffs MLS#1257961
ANDERSON 6155 Ramundo Ct MLS#1250398
MIAMI TWP 5848 Stonebridge Circle MLS#1249019
ADAMS CROSSING CONDO - VIEWS 900 Adams Crossing - Unit 4300 MLS#1243747
WALNUT HILLS 964 Auburnview - Condo MLS#1250603
WALNUT HILLS 2324 Park - Condo MLS#1250592
LIBERTY HILL 412 Liberty Hill - Condo MLS#1255656
30096.23.9.020.Anton:1002
3/23/11
4:10 PM
Page 1
Page 20 - Get More Details With RealEstateBook.com - Vol. 23, No. 9
Suzanne Anton 513-519-9455 santon@sibcycline.com
618 Fleming Springfield Twp $239,900 Ad Code 1782 3BD/3BA
723 Worthington Ave 5BD/4BA $169,900
Lockland Ad Code 6911
1721 Fallbrook Ln Pleasant Run Farms $134,900 Ad Code 2901 4BD/3BA
12180 Brookway Dr Brookway Farms 4BD/2.1 BA $164,900 Ad Code 9900
11921 Elmgrove Circle Pleasant Run Farm 4BD/2.1BA $144,000 Ad Code 4611
12024 Elkwood Dr Pleasant Run Farms 4BD/2BA $137,900 Ad Code 4500
1914 Fallbrook Lane Pleasant Run Farm 4BD/2.1BA $149,900 Ad Code 5598
8202 Tollbridge Court 3BD/2BA $229,900
West Chester Ad Code 4342
30 Ridge Wood Dr Monroe 4BD/3.1BA $205,000 Ad Code 6271
10585 Latina Ct Springfield Twp 4BD/2.1BA $159,900 Ad Code 2552
3601-3605 Benhill Dr 2-4 Units $209,900
White Oak Ad Code 5605
10410 Dugan Gap Rd 3BD/2BA $199,900
8008 Pinnacle Point Dr 2BD/2BA $149,900
7005 Okeana Drewburg Rd Morgan Twp 4BD/4BA $525,000 Ad code 9748
West Chester Ad Code 7389
North Bend Ad Code 8879
1774 Fallbrook Ln Pleasant Run Farm 4BD/3BA $134,900 Ad Code 9318
30096.23.9.021.Finkelman_rev:0100
3/23/11
4:27 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 9 - Page 21
SORG MANSION ESTATE
Historical S. Main Street Middletown, Ohio 45044
Over 2 acres including Main House, Carriage House and Duplex. This romaneaque castle includes many original details including fine crafted woodwork, inlaid tile, ornate fireplaces, and stained glass. Complex is gated.
$500,000
The Sorg House, as it was then known, was built during 1887-88 in the Romanesque Style. One time professor of geology at Miami University and past president of the Middletown Historical Society, Kenneth Shafor made a professional analysis of the stone and reported that "it is built of the finest red sandstone you'l find anywhere in the world." It is variegated sandstone, with an "earth-yellow" tinge found only in a few places.
For your private tour contact: Rachel Lewitt 513-423-4688
rachel@finkelmanrealestate.com
30096.23.9.022.Gerbus
3/23/11
4:23 PM
Page 1
Debi Gerbus, SRS Sales Vice President
513-295-6425
9857 Montgomery Rd Cincinnati, Ohio 45242
LOVELAND 12 Bares Creek Ct MLS#1255270 $875,000
WEST CHESTER 30 Preserve Pl MLS#1254126 $99,900
HAMILTON 2837 Morgan Ross Road MLS#1247000 $279,900
WEST CHESTER 7443 Preserve Place MLS# 1257850 $544,500
MIAMI TWP 6322 E Miami River Road MLS#1255478 $199,900
LOVELAND 2 Bares Creek - Land MLS#1258102 $99,900
WEST CHESTER 11 Preseve Pl - Land MLS#1258106 $125,000
HAMILTON 729 Clinton Avenue MLS#1242198 $99,900
WEST CHESTER 7404 Preserve MLS#1258098 $465,000
FOREST PARK 1190 Kemper Meadow Dr MLS#1242895 $599,000
SPRINGFIELD 11993 Elmgrove Circle MLS#1245147 $142,900
HAMILTON WEST Park Avenue - Land MLS#1252854 $34,900
WWW.COMEY.COM
30096.23.9.023.LibertyGrandVillas
3/23/11
4:22 PM
Page 1
Page 1 4:30 PM 3/23/11 30096.23.9.024.Greystone:1002
ANOTHER FINE PRODUCT FROM NETWORK COMMUNICATIONS, INC. • LAWRENCEVILLE, GA © 2011, Network Communications, Inc. • Printed In The USA
Please Recycle.