SELECT * FROM listing,member,user where listing_id <> '' AND listing_purpose LIKE '%rent%' AND listing_status = 'Available' AND listing_status_active = 'yes' AND listing.listing_member = member.member_id AND member.member_id = user.user_id AND user.user_status ='Active' ORDER BY listing_price DESC LIMIT 0, 25
SELECT count(*) FROM listing,member,user where listing_id <> '' AND listing_purpose LIKE '%rent%' AND listing_status = 'Available' AND listing_status_active = 'yes' AND listing.listing_member = member.member_id AND member.member_id = user.user_id AND user.user_status ='Active'
Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554

Warning: DateTime::setDate() expects parameter 1 to be long, string given in /home1/curlydog/public_html/omni/rent.php on line 554
Omni Realty
 
PAY ONLINE NOW  * Application Fees
 * Security  Deposits
Join Our Email List
Email:  
 * Special offers
 * News & Updates
   
Select Region : Select Price Range :  Section 8
Your Property Finder Results ...
   4023 DUMAINE WAY
   1, TN 38117
Printable Flyer More Photos
Availability : NOW
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $2,500
Deposit : $3,500
Type : Condo
Available For : Rent And Lease/Purchase
Year Built : 1981
Bedrooms : 5
Bathrooms : 4+
 
Property Description :
THIS LUXURY CONDOMINIUM HOME IS LOCATED IN THE WOO   More...
 
 
   1072 Mansker Farms Blvd
   74, TN 37075
Printable Flyer More Photos
Availability : Call for details
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $2,195
Deposit : $2,195
Type : Single Family Home
Available For : Rent
Year Built : 2005
Bedrooms : 4
Bathrooms : 3.5
 
Property Description :
Beautiful upgraded Mansker Farms home. Hardwoods,   More...
 
 
   168 Lindsey Hollow Rd
   72, TN 37066
Printable Flyer More Photos
Availability : Call for details
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,895
Deposit : $1,800
Type : Single Family Home
Available For : Rent
Year Built : 2007
Bedrooms : 4
Bathrooms : 2
 
Property Description :
HIGH END 3/4 bedroom 2 bathroom home! Stainless a   More...
 
 
   1411 POPLAR RIDGE DR
   1, TN 38120
Printable Flyer More Photos
Availability : NOW
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,550
Deposit : $1,550
Type : Single Family Home
Available For : Rent
Year Built : 1978
Bedrooms : 4
Bathrooms : 3
 
Property Description :
THIS HOME IS LOCATED IN THE POPLAR RIDGE FARMS SUB   More...
 
 
   1910 CANTERBURY COURT CV
   22, Tennessee 38016
Printable Flyer More Photos
Availability : 1/22/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Virtual Tour
Rent : $1,495
Deposit : $1,495
Type : Single Family Home
Available For : Rent
Year Built : 1989
Bedrooms : 4
Bathrooms : 2.5
 
Property Description :
THIS HOME IS LOCATED IN THE COUNTRYWOOD SUBDIVISIO   More...
 
 
   137 Lakebrink Dr
   2, TN 37209
Printable Flyer    
Availability : Now
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,295
Deposit : $1,200
Type : Single Family Home
Available For : Rent
Year Built : 2006
Bedrooms : 4
Bathrooms : 3
 
Property Description :
4 bedroom 3 bathroom townhome walking distance fro   More...
 
 
   3113 Albion St
   2, TN 37209
Printable Flyer More Photos
Availability : Now
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,295
Deposit : $1,200
Type : Townhouse
Available For : Rent
Year Built : 2006
Bedrooms : 4
Bathrooms : 3
 
Property Description :
4 bedroom 3 bathroom townhome close to TSU! Lower   More...
 
 
   5000 Indian Ridge
   81, TN 37188
Printable Flyer More Photos
Availability : 03/05/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,275
Deposit : $1,200
Type : Single Family Home
Available For : Rent
Year Built : 2001
Bedrooms : 3
Bathrooms : 2.5
 
Property Description :
3 bedroom 2.5 bathroom with huge bonus room over t   More...
 
 
   2414-B Memorial Blvd- Commercial
   77, TN 37217
Printable Flyer More Photos
Availability : Now
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,250
Deposit : $1,250
Type : Office Space
Available For : Rent
Bedrooms : 1
Bathrooms : 1
 
Property Description :
Commercial location at 2414 Memorial Blvd (next do   More...
 
 
   
   1, TN 38117
Printable Flyer    
Availability : 1 WEEK NOTICE
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,250
Deposit : $1,250
Type : Single Family Home
Available For : Rent
Year Built : 1954
Bedrooms : 4
Bathrooms : 2
 
Property Description :
THIS PROPERTY IS LOCATED IN THE GLEN PARK SUBDIVIS   More...
 
 
   9155 BERRY GARDEN CIR
   22, TN 38016
Printable Flyer More Photos
Availability : 12/12/2008
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,225
Deposit : $1,225
Type : Single Family Home
Available For : Rent
Year Built : 2001
Bedrooms : 4
Bathrooms : 2.5
SPECIAL: 50% OFF THE FIRST MONTHS RENT!
Property Description :
THIS HOME IS LOCATED IN THE GARDENS OF BERRYHILL S   More...
 
 
   2679 CENTRAL TERRACE
   1, TN 38111
Printable Flyer More Photos
Availability : NOW
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,195
Deposit : $1,195
Type : Condo
Available For : Rent And Lease/Purchase
Year Built : 1972
Bedrooms : 3
Bathrooms : 2.5
SPECIAL: SPECIAL**** 50% off 1st MONTH RENT!!!
Property Description :
This lovely condo community is located in desired    More...
 
 
   1318 GARDEN
   1, TN 38134
Printable Flyer More Photos
Availability : 4/9/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,095
Deposit : $1,095
Type : Single Family Home
Available For : Rent
Year Built : 1937
Bedrooms : 3
Bathrooms : 2
SPECIAL: $1095 1 YR LEASE, $995 2 YR LEASE, $900 3 YR LEASE
Property Description :
THIS HOME IS LOCATED OFF OF MULLINS STATION AND MA   More...
 
 
   2272 LAKE HILL CT
   22, TN 38016
Printable Flyer More Photos
Availability : 15-30 DAY NOTICE
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,095
Deposit : $1,095
Type : Single Family Home
Available For : Rent
Year Built : 1994
Bedrooms : 3
Bathrooms : 2
 
Property Description :
THIS HOME IS LOCATED IN THE REFLECTIONS OF CARROLL   More...
 
 
   2768 MISTY VALLEY DR.
   1, TN 38002
Printable Flyer More Photos
Availability : 3/05/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,095
Deposit : $1,095
Type : Single Family Home
Available For : Rent
Year Built : 2002
Bedrooms : 3
Bathrooms : 2
SPECIAL: $200 OFF THE FIRST MONTHS RENT!!
Property Description :
THIS PROPERTY IS LOCATED IN THE MORNING SUN SUBDIV   More...
 
 
   6993 COUNTRY WALK
   22, TN 38018
Printable Flyer    
Availability : 30 DAY NOTICE
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $1,095
Deposit : $1,095
Type : Single Family Home
Available For : Rent
Year Built : 1997
Bedrooms : 3
Bathrooms : 2
 
Property Description :
THIS HOME IS LOCATED IN THE COUNTRY WALK SUBDIVISI   More...
 
 
   2664 CENTRAL TERRACE
   1, TN 38111
Printable Flyer More Photos
Availability : Now
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $995
Deposit : $995
Type : Condo
Available For : Rent And Lease/Purchase
Year Built : 1972
Bedrooms : 2
Bathrooms : 2.5
 
Property Description :
This lovely condo community is located in desired    More...
 
 
   293 Delvin Dr
   75, TN 37013
Printable Flyer    
Availability : 03/10/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $975
Deposit : $900
Type : Single Family Home
Available For : Rent
Year Built : 1973
Bedrooms : 3
Bathrooms : 1
 
Property Description :
3 bedroom 1 bathroom w/ 2 living areas and formal    More...
 
 
   7084 BUTTERNUT CV
   1, TN 38133
Printable Flyer More Photos
Availability : 4/8/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $915
Deposit : $915
Type : Single Family Home
Available For : Rent
Year Built : 1983
Bedrooms : 3
Bathrooms : 2
 
Property Description :
THIS PROPERTY IS LOCATED IN THE HILLSHIRE SUBDIVIS   More...
 
 
   3865 BRIAR PLACE
   1, TN 38115
Printable Flyer More Photos
Availability : 1/08/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $900
Deposit : $900
Type : Single Family Home
Available For : Rent
Year Built : 1977
Bedrooms : 4
Bathrooms : 2
 
Property Description :
THIS HOME IS IN THE PATHWAYS SUBDIVISION   More...
 
 
   1175 BRADY HOLLOW LN
   22, TN 38016
Printable Flyer More Photos
Availability : 1 WEEK NOTICE
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $900
Deposit : $900
Type : Zero Lot
Available For : Rent
Year Built : 1997
Bedrooms : 3
Bathrooms : 2.5
 
Property Description :
Very nice zero-lot home located off of Cordova R   More...
 
 
   7144 BELLSFIELD RD
   1, TN 38119
Printable Flyer More Photos
Availability : 3/6/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $900
Deposit : $900
Type : Single Family Home
Available For : Rent
Year Built : 1984
Bedrooms : 2
Bathrooms : 2
 
Property Description :
THIS HOME IS LOCATED IN THE RIVERDALE MANOR PATIO    More...
 
 
   7874 SHADOWLAND CV
   1, TN 38125
Printable Flyer More Photos
Availability : 3/5/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $875
Deposit : $875
Type : Duplex
Available For : Rent
Year Built : 1997
Bedrooms : 3
Bathrooms : 2
SPECIAL: $100 OFF THE FIRST MONTHS RENT!
Property Description :
FEATURING BRAND NEW CARPET!!! NO PETS OR SMOKERS.   More...
 
 
   5717 BURNETTE PL
   1, TN 38141
Printable Flyer More Photos
Availability : Available Now
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $850
Deposit : $850
Type : Single Family Home
Available For : Rent
Year Built : 1989
Bedrooms : 3
Bathrooms : 2
 
Property Description :
THIS HOME IS LOCATED IN THE RIDGEWAY ESTATES SUBDI   More...
 
 
   1776 MYRNA LN
   1, TN 38117
Printable Flyer More Photos
Availability : 2/15/2010
View More Details  
Map it!  
Request a viewing
 		 
Submit an Application
 		 
Pay Application Fee
 		 
Rent : $850
Deposit : $850
Type : Single Family Home
Available For : Rent
Year Built : 1959
Bedrooms : 3
Bathrooms : 2
SPECIAL: $250 OFF THE FIRST MONTHS RENT!!
Property Description :
THIS HOME IS LOCATED IN THE WILLOW PARK SUBDIVISIO   More...
 
 
Showing page 1 of 3 pages
Designed and maintained by
 Buy | Sell | Rent | Lease/Purchase | Property Management | Credit | Forms | Links | Investors | Resources
About Us | Contact Us | Admin
All Rights Reserved
 
Copyright © 2009 http://www.omnirealty.net/ All Rights Reserved.