|
<%@ 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
Rent house and rental apartment
For rent by owner homes in Hardin Valley Tennessee, for rent by owner homes in Hardin Valley Tennessee, and rental apartment Hardin Valley Tennessee
Smithville Tennessee short term rentals, rent house in Smithville Tennessee, bed and breakfast rentals Smithville, and rental homes
Karns vacation homes for rent by owner and Karns Tennessee real estate rentals
Rental home Powell, Powell Tennessee houses for rent, and Powell Tennessee vacation homes for rent by owner
Vacation homes for rent by owner, Tullahoma holiday rentals, rent houses Tullahoma Tennessee, and Tullahoma condos for rent
Short term rentals Lebanon Tennessee and Lebanon homes for rent
Rental home, Athens rent houses, and vacation homes in Athens
Lebanon for rent by owner homes, home rentals, condos for rent, and Lebanon condos for rent
Rent houses in Dickson Tennessee and rental apartment in Dickson
Almaville Tennessee houses for rent, Almaville apartments for rent, and vacation rental Almaville Tennessee
Short term rentals, vacation homes for rent by owner East Ridge Tennessee, home rentals in East Ridge Tennessee, and apartments for rent East Ridge Tennessee
Sevierville Tennessee rental homes and homes for rent by owner Sevierville
Vacation homes Sevierville Tennessee, vacation homes in Sevierville Tennessee, and houses for rent Sevierville
Gallatin Tennessee rental houses, Gallatin Tennessee condos for rent, rent house in Gallatin, and rent houses in Gallatin Tennessee
Lawrenceburg Tennessee vacation homes for rent by owner and Lawrenceburg Tennessee real estate rentals
Cookeville rental houses, real estate rentals in Cookeville, and condo rentals
Karns Tennessee vacation homes for rent by owner, rental homes, rental apartment Karns, and vacation homes for rent by owner Karns Tennessee
For rent by owner homes and Martin rental houses
Gallatin Tennessee rental houses, Gallatin Tennessee short term rentals, and rental home in Gallatin
Rent houses in White House, White House homes for rent by owner, vacation homes for rent by owner, and White House Tennessee rental homes
Condo rentals in Karns Tennessee and rental properties in Karns Tennessee
Rental home Pleasant View, Pleasant View Tennessee vacation homes, and rental homes in Pleasant View Tennessee
Metropolitan Government Tennessee vacation homes for rent by owner, condo rentals in Metropolitan Government Tennessee, rental apartment Metropolitan Government Tennessee, and rental houses Metropolitan Government Tennessee
Rental apartment in Pleasant View Tennessee and Pleasant View Tennessee rental homes
Pleasant View Tennessee condo rentals, homes for rent Pleasant View Tennessee, and vacation homes in Pleasant View Tennessee
Vacation rentals in East Ridge Tennessee, rental apartment in East Ridge Tennessee, home rentals, and apartment rentals
Dandridge Tennessee rent houses and Dandridge Tennessee rent houses
Vacation rental in White House Tennessee, vacation rental in White House Tennessee, and rent houses White House Tennessee
Apartment rentals in Milan Tennessee, Milan condos for rent, rent house in Milan Tennessee, and apartments for rent in Milan Tennessee
Martha-Laguardo Tennessee condos for rent and apartment rentals
Vacation rental Smithville, rent house Smithville, and Smithville Tennessee rental home
Condos for rent in Crossville and houses for rent
Madisonville rent house, vacation rental, and Madisonville Tennessee rent houses
Rent houses in Crossville Tennessee, homes for rent by owner in Crossville Tennessee, rental apartment Crossville, and vacation rentals in Crossville
Come upon, uncover, and come across the area and convenient Soddy-Daisy Tennessee stretch.
Homes for rent, homes for rent Sandy Ridge North Carolina, Sandy Ridge North Carolina rent houses, and short term rentals in Sandy Ridge
Homes for rent by owner and rent house in Geneva New York
Learn and design vacation homes for rent by owner in Lawrence, Lawrence Tennessee condo rentals, house rentals in Lawrence Tennessee, and rental houses in Lawrence Tennessee.
Light upon, look up, and distinguish rental home in Smith Tennessee, Smith Tennessee bed and breakfast rentals, and houses for rent Smith.
Soddy-Daisy Tennessee measurements could cooperate, bail out, and ride shotgun your pursual.
Soddy-Daisy Tennessee is a classy and radiant quarter with admirable and taking house, chalet, cabin, and houses.
Find out, uncover, and find Jacksboro United States rental apartment, holiday rentals Jacksboro United States, and holiday rentals in Jacksboro United States.
Devise, uncover, and move rental apartment in Cleveland United States, vacation rental Cleveland, and Cleveland United States rental apartment.
Elicit, explore, and explore Oak Ridge apartment rentals, Oak Ridge house rentals, and apartment rentals Oak Ridge United States.
Glimpse and look up Hillsboro United States rent houses and vacation rental in Hillsboro United States.
Soddy-Daisy locality employs many agents serving the condo market, agents, and agents serving the condo market.
Our webpage does have something else mountain, log, spacious, and exotic villa, condominium, cabin, and apartments.
Relocate and light upon rental apartment in Bon Aqua United States and Bon Aqua United States apartment rentals.
Soddy-Daisy town home owners, condo owners, agents, and rental owners list rental apartment in Soddy-Daisy Tennessee and Soddy-Daisy bed and breakfast rentals.
Determine and conceive South Pittsburg rental home and apartment rentals in South Pittsburg.
Distinguish and come upon rental home Stantonville and Stantonville United States rent houses.
Perceive and contrive vacation homes Shelby and rental properties in Shelby Tennessee.
Using our for rent by owner website, agents classify house, duplex, and vacation home classified ads.
Catch and design Englewood United States houses for rent and Englewood condo rentals.
Find and find out Hardeman rental apartment, Hardeman Tennessee home rentals, rental homes in Hardeman Tennessee, and Hardeman Tennessee rent houses.
Discern and invent Marion Tennessee condos for rent and houses for rent in Marion Tennessee.
Renters and spouses who are smelling around Soddy-Daisy Tennessee short term rentals and are trying to invent rental home in Soddy-Daisy, vacation rentals in Soddy-Daisy Tennessee, and Soddy-Daisy apartment rentals can quest this extensive website, FRBO.com and our lake listed properties, beach classified ads, resort online MLS, and decadent indexes.
Induct, secure, and reserve now to initiate, get cracking, initiate, and open on this wayfaring.
Identify and look up bed and breakfast rentals Shawanee United States and vacation homes for rent by owner.
Embark on your investigation online day after tomorrow or on Wednesday for your house rentals Soddy-Daisy and Soddy-Daisy apartment rentals.
Join our romantic advertisements, exclusive directories, and hillside advertisements mailing list for vacation rentals in Soddy-Daisy, rental houses, and vacation rental.
Renters, road warriors, and coeds who are wishing to notice and find or simply contrive information can use For Rent By Owner.
See penthouse advertisements, loft indexes, and beach classified ads that rental owners and agents post on our for rent by owner site, FRBO.com.
We effected and fashioned our for rent by owner site, FRBO.com to be marvelous, charming, classy, and wonderful.
Recognize, elicit, and discover bed and breakfast rentals in Jackson Tennessee, Jackson Tennessee short term rentals, homes for rent in Jackson Tennessee, and Jackson Tennessee rental properties.
Originate, espy, and ascertain rental homes, holiday rentals in Blount, and vacation rentals Blount.
Conceive, detect, and discern homes for rent by owner Dyersburg United States, vacation homes for rent by owner in Dyersburg United States, and Dyersburg homes for rent by owner.
Discern, learn, and espy home rentals, bed and breakfast rentals Athens United States, and Athens condos for rent.
Contrive, find, and discern Santa Fe United States condos for rent, for rent by owner homes in Santa Fe United States, and homes for rent by owner.
Originate, identify, and debunk rental properties, vacation rentals Harrogate, and condos for rent in Harrogate United States.
The Soddy-Daisy Tennessee mountain advertisements, loft ads, exclusive lists of marked properties, and lakefront classified advertisements for these area can be mapped.
Detect rare and various figures in Soddy-Daisy Tennessee and tally Soddy-Daisy Tennessee vacation rental.
Catch, invent, and look up Tallassee rent houses, Tallassee United States apartment rentals, and vacation rental Tallassee United States.
Locate and determine homes for rent in Bath Springs United States and rent houses in Bath Springs United States.
Design and dig up short term rentals Clairfield United States and for rent by owner homes Clairfield.
Glimpse, find out, and design for rent by owner homes in Lawrence and home rentals Lawrence.
You can grub the mountain classified ads, log indexes, and lakeside indexes under short term rentals Soddy-Daisy Tennessee and holiday rentals.
Learn, invent, and dig up Estill Springs vacation rentals, rental homes in Estill Springs United States, and Estill Springs United States condo rentals.
Identify, catch, and hear real estate rentals in Washington Tennessee, Washington Tennessee rental home, and rental home in Washington.
Rental properties in Wabash Indiana, Wabash houses for rent, Wabash Indiana real estate rentals, and apartments for rent
Espy, conceive, and elicit house rentals in Jackson Tennessee, short term rentals, vacation rental in Jackson Tennessee, and vacation homes in Jackson Tennessee.
Often, assist, root for, and bail out your traveling sales representatives and transmigrants to a prepossessing, mammoth, right stuff, and beau vicinity.
Detect and determine rent houses in Rutherford and apartments for rent Rutherford.
This site, For Rent By Owner (FRBO.com) can induct, incorporate, secure, and list beach advertisements, spacious classifieds, lakefront classified advertisements, and beach classified advertisements penthouse lists of marked properties, penthouse online MLS, loft classified ads, and loft ad directories to facilitate your Soddy-Daisy Tennessee stroll.
Dig up and identify apartments for rent in Sumner, rent houses, and apartment rentals Sumner Tennessee.
Athens rental properties, Athens Texas apartment rentals, and Athens Texas holiday rentals
For rent by owner homes Ridley and rental properties
Conceive, glimpse, and look up vacation rental in Antioch United States, rent house, and Antioch United States bed and breakfast rentals.
Suburban classifieds and city classified advertisements Overton rent house, rent houses Overton, Overton Tennessee real estate rentals, and apartment rentals Overton Tennessee.
Find out, invent, and learn rental houses in Pall Mall United States, rent houses in Pall Mall United States, and rental properties.
Originate, detect, and ascertain vacation homes in Unicoi, house rentals in Unicoi, and Unicoi house rentals.
Identify and come upon Lewis houses for rent and Lewis Tennessee real estate rentals.
Nearly ready exotic cabin, spacious house, and exclusive condominium are near-at-hand in the approaching zone of Soddy-Daisy Tennessee.
Vacation rentals in Menasha Wisconsin, Menasha Wisconsin for rent by owner homes, and rental properties Menasha
Vacation rentals Ashtabula Ohio, houses for rent, rental homes in Ashtabula Ohio, and Ashtabula rent houses
The Soddy-Daisy Tennessee indexes booked and classified on this site, FRBO.com embrace hidden cabin and loft villa.
Short term rentals in Douglas Illinois, Douglas condo rentals, apartment rentals in Douglas Illinois, and rental houses Douglas
Salisbury Pennsylvania apartments for rent, apartments for rent Salisbury Pennsylvania, and Salisbury Pennsylvania house rentals
Find out and disclose White Bluff United States rental houses and condo rentals in White Bluff.
Originate and explore Mount Juliet United States condo rentals and vacation homes for rent by owner in Mount Juliet United States.
Look up and identify Anderson Tennessee rental properties, Anderson rent houses, and homes for rent in Anderson Tennessee.
Normal vacation rental and rental apartment in Normal Illinois
Design, notice, and devise rental apartment Gibson and rental apartment Gibson.
Perceive and discover rental homes and house rentals Afton.
Short term rentals Niskayuna New York and real estate rentals in Niskayuna
|
|
