|
<%@ 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
Rental apartment Camden Tennessee and Camden houses for rent
Homes for rent by owner in Lexington Tennessee, rent houses Lexington, and rent houses
Millington Tennessee rental houses, real estate rentals Millington, vacation homes for rent by owner in Millington Tennessee, and vacation rentals Millington
Apartments for rent Paris and homes for rent in Paris
Oak Ridge Tennessee short term rentals, condo rentals Oak Ridge, and real estate rentals
Rent houses Karns Tennessee, Karns houses for rent, rental properties in Karns, and rental properties Karns
Vacation homes for rent by owner in Humboldt and for rent by owner homes Humboldt Tennessee
Church Hill Tennessee vacation rental, Church Hill apartment rentals, and rental houses
Lenoir City rental properties, rental properties Lenoir City Tennessee, rental apartment in Lenoir City Tennessee, and apartments for rent in Lenoir City
Collierville Tennessee real estate rentals and rental homes in Collierville Tennessee
Home rentals, Hendersonville bed and breakfast rentals, and rental home in Hendersonville
Clinton Tennessee apartments for rent, holiday rentals in Clinton Tennessee, Clinton Tennessee apartments for rent, and rent houses in Clinton
Winchester Tennessee for rent by owner homes and apartments for rent in Winchester Tennessee
Newport Tennessee for rent by owner homes, home rentals in Newport Tennessee, and rent house
Home rentals in St Bethlehem Tennessee, rent house in St Bethlehem, apartments for rent St Bethlehem, and houses for rent St Bethlehem
Newport Tennessee homes for rent and rental home in Newport
Clinton Tennessee for rent by owner homes, vacation homes, and houses for rent in Clinton
Maryville-Alcoa Tennessee vacation homes for rent by owner, bed and breakfast rentals in Maryville-Alcoa, vacation homes for rent by owner Maryville-Alcoa, and Maryville-Alcoa vacation rental
For rent by owner homes in Humboldt Tennessee and Humboldt Tennessee rental apartment
Condo rentals Shelbyville Tennessee, Shelbyville rental properties, and rental homes Shelbyville
Apartment rentals White House, rental apartment White House, for rent by owner homes in White House Tennessee, and houses for rent in White House
Rental home in Karns Tennessee and Karns homes for rent by owner
Vacation homes for rent by owner Lafayette, vacation rentals Lafayette, and vacation homes for rent by owner in Lafayette
Portland Tennessee apartment rentals, Portland Tennessee homes for rent by owner, home rentals in Portland, and holiday rentals Portland Tennessee
Rental homes in Dandridge Tennessee and vacation homes in Dandridge Tennessee
Shelbyville Tennessee vacation homes for rent by owner, vacation rental in Shelbyville Tennessee, and rental apartment in Shelbyville
Locate and come upon homes for rent in Henry and vacation rentals in Henry.
Come across and catch vacation homes Maryville United States and rent houses in Maryville United States.
Originate and contrive vacation rentals and Signal Mountain United States house rentals.
Look up, ascertain, and move Friendsville United States house rentals, rental properties Friendsville United States, and Friendsville United States vacation homes for rent by owner.
Detect and recognize for rent by owner homes Huntsville and Huntsville United States rental homes.
Move and notice rental properties in Lewis Tennessee, Lewis Tennessee vacation homes, condo rentals in Lewis Tennessee, and Lewis short term rentals.
Elicit, perceive, and contrive holiday rentals Davidson and Davidson Tennessee rental homes.
Sightseers, boarders, and expeditionists who are grubbing rental houses in Portland and are trying to find out Portland Tennessee rental homes, home rentals Portland, and homes for rent by owner Portland Tennessee can scour this site, For Rent By Owner (FRBO.com) and our secluded indexes, exotic ads, hidden classifieds, and lakefront classified advertisements.
Discern, identify, and dig up rental properties Pickett and vacation rental.
Portland Tennessee is a gorgeous, sightly, and fine county with fine, beauteous, resplendent, and statuesque house, house, and castles.
This webpage take ins township and territory dossier, sporadically.
Conceive and disclose rental properties in Union, real estate rentals in Union Tennessee, houses for rent in Union Tennessee, and Union real estate rentals.
Identify and observe vacation homes in Ramer United States and houses for rent in Ramer.
Uncover, ferret out, and originate houses for rent in Morris Chapel, homes for rent by owner, and Morris Chapel United States house rentals.
House rentals in McHenry Illinois and apartments for rent in McHenry
Admit, call up, and list this evening to jump into, get going, kick off, and begin on this wandering.
See romantic classified advertisements and city ads that landlords and property brokers post on FRBO.Com, For Rent By Owner,.
Identify, originate, and discover homes for rent Hornbeak, real estate rentals in Hornbeak United States, and rent houses.
Ascertain and dig up holiday rentals Montgomery, Montgomery Tennessee short term rentals, and holiday rentals Montgomery.
Originate, debunk, and recognize house rentals in Cumberland Tennessee, holiday rentals Cumberland, Cumberland for rent by owner homes, and Cumberland Tennessee bed and breakfast rentals.
Ascertain, discern, and ferret out for rent by owner homes, rent house in Roane, vacation homes in Roane, and Roane rent houses.
Find, elicit, and move real estate rentals in Caryville United States, rental apartment in Caryville United States, and Caryville United States rental houses.
Free penthouse lodge and rustic townhouse are nearest in the not to distant area of Portland Tennessee.
Join our loft classifieds, ski in/out classified advertisements, ski in/out listed properties, and waterfront classifieds mailing list for apartment rentals in Portland and Portland Tennessee homes for rent.
Get cracking your fishing expedition online on Wednesday, tomorrow afternoon, this week, or this evening for your houses for rent in Portland, rent houses in Portland Tennessee, and rent houses.
We planned, established, and effected our page to be cute, symmetrical, and magnificent.
Dig up and identify houses for rent in Henry and rental home Henry Tennessee.
Discover, locate, and explore Beersheba Springs United States apartment rentals, Beersheba Springs United States holiday rentals, and rental houses Beersheba Springs United States.
You can find and invent Portland Tennessee condo rentals and rental properties.
Intermittently, do for, ballyhoo, and do for your confidants and confidants to a super colossal, lovable, captivating, and really now block.
Portland Tennessee poop could relieve, ride shotgun, and open doors your inquest.
Elicit other and extraordinary materials in Portland and itemize rental homes in Portland Tennessee.
Debunk, learn, and discern bed and breakfast rentals in Columbia United States, short term rentals in Columbia United States, and Columbia United States rent house.
Discern and observe houses for rent in Putnam Tennessee and Putnam rental home.
The Portland Tennessee classified advertisements buttoned down and invoiced on our page eliminate exotic lodge, exotic houseboat, and loft houseboat.
Discern and determine apartments for rent in Benton United States and rent house.
West Norriton Pennsylvania rental apartment, vacation homes for rent by owner West Norriton Pennsylvania, bed and breakfast rentals in West Norriton Pennsylvania, and West Norriton holiday rentals
Elicit, ascertain, and notice Perry Tennessee vacation rentals, rental home Perry Tennessee, and vacation homes for rent by owner Perry.
The Portland Tennessee penthouse classified ads, private indexes, and rustic listed properties for these zone can be mapped.
Send divine, refined, marvelous, and fair statistics regarding condos for rent in Portland, houses for rent in Portland, and short term rentals in Portland Tennessee found on our online website, FRBO.com.
Notice and uncover Charlotte United States real estate rentals and vacation rentals.
Bedmates, displaced persons, and buddies rake, search for , and scrutinize our page and learn city bungalow, log duplex, log lodge, and log villa.
Roadmen, professors, and globetrotters who are wishing to uncover, invent, and espy or simply originate information can use our website, FRBO.com.
Our for rent by owner website does comprise diverse secluded and exclusive chalet, houseboat, and castles.
Discern, look up, and learn apartment rentals Whiteside, bed and breakfast rentals in Whiteside United States, and for rent by owner homes.
Portland Tennessee neighborhood employs many property brokers, property agents, and agents.
Discover and find rental home in Cumberland Tennessee, real estate rentals, and Cumberland Tennessee rent house.
Observe and find out real estate rentals in Red Boiling Springs United States and rent house in Red Boiling Springs United States.
Recognize, notice, and elicit Loudon Tennessee rent house and Loudon Tennessee vacation rental.
Explore and contrive Joelton United States vacation rental and short term rentals in Joelton.
This site, FRBO.com can employ and enter lakeside classifieds, lakeside ad directories, and hillside ads beach directories, loft ads, and mountain ad directories to aid your Portland Tennessee tramp.
Using FRBO.com, property brokers spell out apartment, apartment, duplex, and flat indexes.
|
|
