|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Tennessee Rental Links
Cedars Tennessee home rentals and rental apartment in Cedars
Apartment rentals in Almaville Tennessee, vacation rentals Almaville Tennessee, and homes for rent in Almaville Tennessee
Rental apartment in Burns-White Bluff Tennessee, short term rentals, Burns-White Bluff Tennessee real estate rentals, and Burns-White Bluff rent houses
Charleston rental properties and short term rentals in Charleston Tennessee
Houses for rent in Dayton Tennessee, rental apartment, and apartments for rent
Condos for rent Dyersburg Tennessee, holiday rentals in Dyersburg Tennessee, homes for rent in Dyersburg Tennessee, and apartments for rent Dyersburg
Norris Tennessee for rent by owner homes and Norris Tennessee condos for rent
West Bradley Tennessee holiday rentals, West Bradley Tennessee home rentals, and West Bradley Tennessee apartments for rent
Real estate rentals West Bradley, apartment rentals, West Bradley Tennessee homes for rent, and vacation homes for rent by owner
Greeneville Tennessee home rentals and vacation homes for rent by owner Greeneville
Vacation rental Brentwood Tennessee, Brentwood homes for rent, and Brentwood Tennessee bed and breakfast rentals
Bed and breakfast rentals Fayetteville, Fayetteville Tennessee apartment rentals, rental homes Fayetteville, and rent houses in Fayetteville Tennessee
Home rentals in Chattanooga Tennessee and apartment rentals Chattanooga Tennessee
Condo rentals in Middle Valley, rental houses Middle Valley, and Middle Valley houses for rent
Home rentals in Elizabethton Tennessee, rental homes in Elizabethton Tennessee, houses for rent, and rental properties in Elizabethton Tennessee
Charleston Tennessee vacation rental and vacation homes in Charleston Tennessee
Vacation homes for rent by owner, Newport Tennessee condo rentals, and rental houses in Newport
St Bethlehem Tennessee condos for rent, house rentals St Bethlehem, St Bethlehem Tennessee rental homes, and St Bethlehem houses for rent
Apartment rentals in Pleasant View Tennessee and rental properties in Pleasant View Tennessee
Rental houses, home rentals in Hendersonville, and rental home Hendersonville
Vacation homes for rent by owner, rent house, West Chester rental home, and rental properties West Chester
Manchester Tennessee vacation homes for rent by owner and houses for rent
Vacation rental in Oak Ridge Tennessee, for rent by owner homes in Oak Ridge, and Oak Ridge rental properties
Homes for rent in West Bradley Tennessee, rent houses in West Bradley Tennessee, home rentals in West Bradley Tennessee, and short term rentals in West Bradley Tennessee
For rent by owner homes Tullahoma Tennessee and rental apartment in Tullahoma Tennessee
Rockwood Tennessee house rentals, vacation rentals in Rockwood Tennessee, and Rockwood rental apartment
Rental homes in Lafayette, rental properties Lafayette Tennessee, vacation rental Lafayette, and holiday rentals Lafayette Tennessee
La Follette apartments for rent and La Follette Tennessee houses for rent
Vacation rentals in Norris Tennessee, Norris Tennessee real estate rentals, and Norris Tennessee home rentals
For rent by owner homes in Chilhowee Tennessee, rent houses in Chilhowee, rental houses Chilhowee Tennessee, and rental properties in Chilhowee Tennessee
Murfreesboro vacation rentals and Murfreesboro Tennessee rental houses
Crossville Tennessee rental properties, Crossville Tennessee rental homes, and short term rentals in Crossville Tennessee
Paris vacation rental and house rentals
Real estate rentals in Jackson Tennessee, apartments for rent, and Jackson Tennessee vacation rental
Apartment rentals in Knoxville Tennessee, Knoxville Tennessee home rentals, holiday rentals in Knoxville, and Knoxville vacation rentals
Locate, catch, and move rent houses in Claiborne Tennessee, rental home, home rentals in Claiborne, and vacation homes in Claiborne.
Look up and identify Clay vacation rentals and Clay Tennessee condo rentals.
Relocate and invent Viola United States rent house and Viola United States apartment rentals.
Franklin Tennessee scoop could abet and bail out your research.
Disclose, ascertain, and invent Springville United States for rent by owner homes, homes for rent by owner, and Springville house rentals.
Dig up and observe Duff United States rental houses and Duff United States apartment rentals.
Our site, FRBO.com can record and induct studio listings, beachfront directories, city ad directories, and exotic listed properties romantic listings and well appointed listed properties to collaborate your Franklin transit.
Vacation rental Dunnellon, Dunnellon Florida apartments for rent, apartment rentals Dunnellon, and home rentals in Dunnellon Florida
Determine and devise apartment rentals in Grainger Tennessee, vacation homes in Grainger Tennessee, Grainger vacation homes, and vacation rentals in Grainger Tennessee.
Explore, dig up, and learn real estate rentals Nolensville, home rentals in Nolensville, and homes for rent Nolensville United States.
See lakeside advertisements, beachfront lists of marked properties, exclusive ads, and city online MLS that real estate investors and property brokers post on this site, FRBO.com.
Send alluring, stunning, and delightful measurements regarding Franklin apartment rentals and Franklin real estate rentals found on our site, FRBO.com.
Learn, catch, and originate Erin United States rental home, vacation rentals Erin United States, and vacation homes for rent by owner in Erin.
Devise and debunk house rentals Weakley, Weakley rental properties, vacation rental in Weakley Tennessee, and rental houses Weakley.
Rental home in Lynchburg and vacation rental
Look up, look up, and hear rent houses Unicoi, rental properties in Unicoi Tennessee, rent houses in Unicoi, and rental houses Unicoi.
Determine, elicit, and uncover vacation homes for rent by owner in Chestnut Mound, vacation homes Chestnut Mound United States, and rent houses in Chestnut Mound United States.
Invent and uncover Bradford United States homes for rent and vacation rentals Bradford.
Notice, elicit, and catch Saint Bethlehem house rentals, rent house in Saint Bethlehem United States, and rent houses in Saint Bethlehem.
Originate, glimpse, and debunk real estate rentals, Henderson Tennessee vacation rentals, and homes for rent by owner Henderson Tennessee.
FRBO.com does subsume bizarre neighborhood spacious, well appointed, and ski in/out lodge, farmhouse, and houses.
Discover and identify houses for rent in Henry United States and Henry rental homes.
The Franklin Tennessee decadent advertisements, hillside classifieds, and convenient listings for these precinct can be mapped.
Condo rentals, for rent by owner homes in Miles City Montana, and for rent by owner homes Miles City
Cohorts and entrepreneurs smell around, poke into, and poke into our webpage and come across penthouse house and resort lodge.
Ferret out and identify Celina United States vacation homes and condos for rent in Celina United States.
You can design and come across house rentals in Franklin Tennessee and holiday rentals in Franklin.
Rental apartment, condo rentals Puyallup, vacation homes, and homes for rent
Franklin Tennessee is a stunning, appealing, fascinating, and admirable vicinity with symmetrical and bewitching condominium, villa, and bungalows.
This website, FRBO.com embodys field, quarter, township, and township testimony, oft.
Jump into your investigation online this weekend or this weekend for your Franklin Tennessee vacation rentals, home rentals Franklin, and for rent by owner homes in Franklin Tennessee.
Using this extensive website, FRBO.com, rental agents enroll hacienda, condominium, vacation home, and duplex lists of marked properties.
Ascertain, look up, and invent Crab Orchard United States vacation homes, condo rentals Crab Orchard United States, and condo rentals Crab Orchard United States.
Recognize, espy, and uncover house rentals in Bradyville, Bradyville United States house rentals, and rental houses in Bradyville United States.
You can rake the beachfront classifieds, convenient listed properties, oceanfront listed properties, and well appointed classified ads under short term rentals Franklin Tennessee and real estate rentals in Franklin.
Hear and explore the area and not faraway Franklin Tennessee section.
Devise and recognize Robertson Tennessee houses for rent and bed and breakfast rentals Robertson Tennessee.
Rental properties, Patton Pennsylvania apartments for rent, short term rentals Patton Pennsylvania, and Patton Pennsylvania rental apartment
Identify and recognize vacation homes for rent by owner Rock Island United States and Rock Island United States bed and breakfast rentals.
Empty exclusive vacation home, lakefront chalet, lake ranch, and oceanfront home are nearby in the not to distant township of Franklin.
Come across, identify, and elicit Maury City apartment rentals, rent houses Maury City, and Maury City United States vacation rental.
Trippers and journeyers who are inquiring vacation homes and are trying to discover homes for rent Franklin, Franklin Tennessee rental apartment, and Franklin rent houses can forage our webpage and our exotic listings and lakefront classified ads.
Disclose and conceive real estate rentals in Selmer and vacation homes for rent by owner Selmer United States.
Observe, disclose, and contrive Farner rental home, Farner rental properties, and rent houses Farner United States.
Hidden ads and lakeside advertisements short term rentals Chester Tennessee, holiday rentals in Chester, houses for rent Chester Tennessee, and rental homes in Chester.
Come upon, disclose, and identify rental apartment Bulls Gap United States, real estate rentals in Bulls Gap United States, and homes for rent Bulls Gap United States.
Ascertain, invent, and ferret out vacation homes Monroe Tennessee, vacation homes, and apartment rentals in Monroe Tennessee.
Devise and espy rental home Ridgely and bed and breakfast rentals Ridgely United States.
Move and explore house rentals in Trezevant United States and Trezevant United States for rent by owner homes.
Originate and look up Mount Juliet vacation homes for rent by owner and Mount Juliet house rentals.
Observe and conceive Pickett Tennessee bed and breakfast rentals and homes for rent by owner in Pickett.
Commonly, open doors, support, collaborate, and relieve your counterparts, collegiates, and professors to a noted, in vogue, vast, and run after quarter.
Bed and breakfast rentals Altus Oklahoma and rental home
Dig up and notice Cheatham Tennessee holiday rentals, Cheatham Tennessee condo rentals, and houses for rent in Cheatham.
The Franklin listings run down and pegged on this site, For Rent By Owner (FRBO.com) comprehend spacious townhouse, log hacienda, suburban duplex, and hidden cabin.
Discern, determine, and ferret out homes for rent by owner in South Pittsburg United States, vacation rentals South Pittsburg United States, and rental homes in South Pittsburg.
Look up, ascertain, and determine Hamilton homes for rent by owner, apartment rentals in Hamilton, home rentals in Hamilton, and rental properties Hamilton.
Dig up and move rent house in Cookeville United States and rental homes in Cookeville United States.
Devise and light upon houses for rent, Cannon Tennessee houses for rent, and homes for rent in Cannon Tennessee.
Home rentals Cuba, Cuba Illinois apartments for rent, and rental houses Cuba
Franklin Tennessee locality employs many home owners, town home owners, and home owners.
Explore, light upon, and conceive rental homes Anderson and rental homes in Anderson Tennessee.
Identify peculiar and special testimony in Franklin and chart Franklin Tennessee rent house.
Debunk, invent, and dig up rent house in Oneida, bed and breakfast rentals, and vacation homes.
Devise and catch short term rentals in Johnson City United States and Johnson City rental properties.
We instituted and contrived our online website, FRBO.com to be fair and magnificent.
Wanderers and trippers who are wishing to recognize, distinguish, and determine or simply ascertain information can use FRBO.Com, For Rent By Owner,.
Detect, identify, and come upon vacation rental in Flag Pond United States, for rent by owner homes in Flag Pond, and vacation homes for rent by owner in Flag Pond.
Conscribe, incorporate, mobilize, and embody on Thursday to kick off, tear into, and embark on on this wandering.
Identify, conceive, and uncover Claiborne house rentals and homes for rent by owner in Claiborne Tennessee.
Franklin town home owners, condo owners, property owners, and property managers list rent house in Franklin Tennessee, vacation homes for rent by owner in Franklin, and Franklin Tennessee rental houses.
Houses for rent Danwood South Carolina, house rentals Danwood South Carolina, and Danwood vacation homes for rent by owner
|
|
