30096.23.10.001.Cover:TREB_CVR_US_ChangeWeb
4/19/11
5:40 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. 10
DETAILS ON THIS PROPERTY Page 6 RealEstateBook.com
Liberty Grand Villas 513/777-2210
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.10.002.Beebe1
4/19/11
5:40 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
MASON 4302 Grasmere Run
SO
SO
SO LOVELAND 10094 Fox Chase Dr
LD
MASON 4823 Bordeaux Ln $126,500 MLS # 1258922
LD
MASON 3791 Crooked Tree $379,000 MLS # 1255744
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.10.003.Beebe2:Layout 1
4/19/11
5:39 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
LD
MASON 5822 Running Fox Ln
SO
LD
LIBERTY TWP 6362 Woodgate Way
SO
SO
LD
MASON 6574 Quail Lake
LIBERTY TWP 6119 Blackberry Ct
FREE Home Evaluation! Visit www.BBTeamHomes.com
30096.23.10.004.QR:1002
4/19/11
5:43 PM
Page 1
Page 4 - Why Buy Now? Ask a REALTOR® - Vol. 23, No. 10
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.10.005.RealtyBid:30003.17.8.038
4/19/11
5:41 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 10 - Page 5
30096.23.10.006.Masthead:0100
4/19/11
5:41 PM
Page 1
Page 6 - Get More Details With RealEstateBook.com - Vol. 23, No. 10
ON THE COVER For advertising information in The Real Estate Book of Greater Cincinnati, contact:
7100 Liberty Grand Drive, West Chester, Ohio 45069 Private Entrance to each Condo One Story Floor Plans Owner's Suites Vaulted Ceilings Clubhouse with fitness center, pool, media room Gas log Fireplaces Sun Room and Patio Available Options and Upgrade to Personalize Your Home
Tricia Green 513-545-6790 Email: tgreen@treb.com
For your private tour, contact:
513-777-2210 www.libertygrandvillas.com
It’s a Wonderful Life Style!
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.10.007.Zeilman:0400
4/19/11
5:48 PM
Page 1
Get More Details With RealEstateBook.com - Vol. 23, No. 10 - Page 7
30096.23.10.008.Dwyer:30003.17.8.038
4/20/11
9:38 AM
Page 1
The Dwyer Sells Team (513) 312-8813 See Interior Photos on Our Website:
www.DwyerSells.com Email: SOLD@DwyerSells.com
Great Deal!
LEASE or PURCHASE ANDERSON - Professional Building, Great location on Beechmont Ave 3000sq ft + usable 1500sq ft basemnt, Kitchen, bathroom, paved parking lot $375K or lease $10/sq ft
SPRINGDALE - Immaculate 3BR, 1.5 BA, 2c garage, virtually maint free exterior, many updates: A/C, carpet, paint, garage opener, windows, concrete drive & more. $105,000
Newly Remodeled!
NEW HOME w/5ac! 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
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
! D L
Approx 3 ac ANDERSON TWP - Development opportunity. Almost 3 acre vacant lot zoned C Residential. Water and Sewer at lot. Seller will consider subdividing. $300K
Preferred Group
SO
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
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.10.009.KopfRealEstate.BringUsHome:WintonSalem
4/19/11
5:47 PM
Page 1
Why Buy Now? Ask a REALTOR® - Vol. 23, No. 10 - 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.10.010.Henson.Trautman:1500
4/19/11
5:46 PM
Page 1
Page 10 - Get More Details With RealEstateBook.com - Vol. 23, No. 10
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.10.011.Khomes
4/19/11
5:51 PM
Page 1
30096.23.10.012.013.KramerAB:1202
4/20/11
9:42 AM
Page 1
One Goal. One Passion.
MASON 6275 Bridgewater Ct $467,900 MLS#1255919
MASON 4831 Hampton Village $400,000 MLS#1251022
MASON 4053 Melampy Creek $379,900 MLS#1258626
WESTCHESTER 4766 Silver Fox Ct $489,900 MLS#1258430
WESTCHESTER 7173 Harbour Town Dr $439,900 MLS#1243591
WESTCHESTER 7572 Hidden Trace $209,900 MLS#1264720
WESTCHESTER 5420 Fallen Timber Dr $300,000 MLS#1260799
WESTCHESTER 8851 Eagleview #8 $77,900 MLS#1240252
WESTCHESTER 7323 Country Club $624,900 MLS#1259783
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.10.012.013.KramerAB:1202
4/20/11
9:42 AM
Page 2
Kathy Kramer Company Sales Leader 2010 Senior Sales Vice President
kkramer@starone.com
513-265-8650 LIBERTY TWP 5642 Autumn Creek $309,900 MLS#1263721
LIBERTY TWP 7188 Tarragon Ct $364,900 MLS#1240313
LIBERTY TWP 5865 Maud Hughes Rd $499,900 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 $219,900 MLS#1232395
LIBERTY TWP 5557 Hamilton Trail $252,900 MLS#1233115
LIBERTY TWP 6322 Cougar Path $250,000 MLS#1248634
LIBERTY TWP 4305 Pheasant Trail Ct $173,000 MLS#1261053
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
LIBERTY TWP 6311 Breckenridge Ln $174,900 MLS#1263958
GREENHILLS 387 Inman Lane $107,900 MLS#1248174
www.starone.com
30096.23.10.014.Comisar
4/19/11
5:50 PM
Page 1
Page 14 - Why Buy Now? Ask a REALTOR® - Vol. 23, No. 10
1 Roebling Way - #1806, #1005, #704, #505 Covington Kentucky Extraordinary opportunity to live at The Ascent! Amazing city and river views from several levels.
223 E 2nd Street Covington, Kentucky 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 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
7507 Pinehurst Newtown Classic & beautiful 4 BR traditional/pristine. 2 story foyer w/marble + leaded glass side light. Updated fl plan perfect for today’s lifestyle. Scrn porch, fin LL & wonderful private backyard. New roof, granite counters & updated kitchen.
5831 Ridge Avenue Pleasant Ridge Charming frame house has good bones but needs total TLC. Opportunity to make it your own. Brand new roof, garage & deep lot. Hardwood floors, tile fireplace & very nice room sizes. Mechanicals reported to be in working order. As Is
9779 Troon Ct Blue Ash WOW! WOW! Total transformation to chic condo for today’s buyer. Hrwd’s redone, granite, Ba’s have custom tile that is beautiful. Kit is tile backsplash+great fixtures+details thruout. List of changes+upgrades to be attached. Amenities of BA.
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.10.015.EdHoward:1500
4/19/11
5:49 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 10 - Page 15
We offer full home repairs... FREE Estimates...
Let us do the work!
Q.U.E.S.T. Call 513-477-5332
Your local home services... Insured and ready for any job!
30096.23.10.016.Huff:0100
4/19/11
5:55 PM
Page 1
Page 16 - Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 10
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.10.017.Homearama
4/19/11
5:55 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 10 - Page 17
30096.23.10.018.019.ChabrisAB:0100
4/19/11
6:02 PM
Page 1
Page 18 - Get More Details With RealEstateBook.com - Vol. 23, No. 10
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.10.018.019.ChabrisAB:0100
4/19/11
6:02 PM
Page 2
Get More Details With RealEstateBook.com - Vol. 23, No. 10 - 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.10.020.SOAR:1500
4/19/11
5:51 PM
Page 20 - Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 10
Page 1
30096.23.10.021.SorgHouse:0100
4/19/11
5:58 PM
Page 1
Why Buy Now? Ask a REALTOR速 - Vol. 23, No. 10 - 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.10.022.Gerbus
4/19/11
5:58 PM
Page 1
Debi Gerbus, SRS Sales Vice President
513-295-6425
9857 Montgomery Rd Cincinnati, Ohio 45242
WEST CHESTER 7404 Preserve MLS#1258098 $465,000
LOVELAND 14 Bares Creek Ct MLS#1254124 $108,900
HAMILTON 2837 Morgan Ross Road MLS#1263253 $275,000
LOVELAND 100 Bares Creek Court MLS#1242140 $549,900
MIAMI TWP 6322 E Miami River Road MLS#1255478 $199,900
HAMILTON 729 Clinton Avenue MLS#1263581 $94,900
WEST CHESTER 30 Preserve Pl MLS#1254126 $99,900
SPRINGFIELD 11993 Elmgrove Circle MLS#1261115 $144,900
FOREST PARK 1190 Kemper Meadow Dr MLS#1242895 $599,000
LOVELAND 12 Bares Creek Ct MLS#1255270 $875,000
HAMILTON 914 Park Ave. MLS# 1252854 $29,900
WEST CHESTER 7443 Preserve Place MLS# 1257850 $544,500
WWW.COMEY.COM
30096.23.10.023.LibertyGrandVillas
4/19/11
5:57 PM
Page 1
Page 1 5:56 PM 4/19/11 30096.23.10.024.Greystone:1002
ANOTHER FINE PRODUCT FROM NETWORK COMMUNICATIONS, INC. • LAWRENCEVILLE, GA © 2011, Network Communications, Inc. • Printed In The USA
Please Recycle.