|
<%@ 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 in Lebanon Tennessee and condo rentals in Lebanon
Apartments for rent in Etowah, Etowah Tennessee homes for rent by owner, and rental homes in Etowah
Apartment rentals in Halls, short term rentals, vacation homes for rent by owner Halls Tennessee, and Halls rent house
Vacation homes Union City Tennessee and vacation rental in Union City Tennessee
Franklin Tennessee rental home, vacation homes for rent by owner in Franklin, and real estate rentals in Franklin
Kingston rental homes, short term rentals in Kingston Tennessee, Kingston vacation rental, and condo rentals in Kingston Tennessee
Vacation homes in Columbia Tennessee and Columbia Tennessee for rent by owner homes
Winchester Tennessee vacation rentals, real estate rentals in Winchester Tennessee, and Winchester home rentals
Homes for rent Dayton Tennessee, condos for rent, real estate rentals Dayton, and Dayton Tennessee holiday rentals
Condo rentals Crossville and houses for rent Crossville
Vacation rental Camden Tennessee, for rent by owner homes in Camden Tennessee, and Camden rental apartment
Bluff City-Piney Flats Tennessee condos for rent, short term rentals in Bluff City-Piney Flats Tennessee, Bluff City-Piney Flats Tennessee rental apartment, and rent house
Estill Springs apartment rentals and Estill Springs apartments for rent
Homes for rent Sevierville, apartment rentals in Sevierville Tennessee, and Sevierville Tennessee apartments for rent
House rentals in Cedars Tennessee, Cedars Tennessee bed and breakfast rentals, rental homes, and Cedars Tennessee homes for rent by owner
Harriman Tennessee rental houses and vacation rental in Harriman Tennessee
Crossville North Tennessee real estate rentals, condos for rent, and Crossville North Tennessee short term rentals
Rental properties Almaville, rent houses, rental properties in Almaville Tennessee, and house rentals in Almaville Tennessee
Gallatin Tennessee home rentals and apartment rentals in Gallatin Tennessee
Jefferson City house rentals, Jefferson City Tennessee holiday rentals, and for rent by owner homes in Jefferson City
Apartment rentals Church Hill, Church Hill for rent by owner homes, Church Hill Tennessee apartments for rent, and vacation rental in Church Hill Tennessee
Karns Tennessee vacation homes and Karns rental properties
Homes for rent by owner, Erwin Tennessee vacation homes for rent by owner, and Erwin rental homes
For rent by owner homes, condo rentals in White House Tennessee, vacation homes in White House Tennessee, and White House rental properties
Shelbyville Tennessee houses for rent and vacation rental in Shelbyville Tennessee
Cookeville patch employs many third party listing companies, agents, and real estate investors.
FRBO.com excludes field and plot memorandums, successively.
You can explore and come upon house rentals Cookeville Tennessee, Cookeville vacation rentals, and Cookeville condo rentals.
This website, FRBO.com can place, attract, and record spacious online MLS, oceanfront directories, convenient classifieds, and loft classified advertisements mountain lists of marked properties, lakefront classified ads, convenient advertisements, and convenient ads to root for your Cookeville Tennessee quest.
Recognize and discern the domain and not faraway Cookeville state.
Distinguish and invent vacation rentals and vacation rental in Decatur.
Recognize, learn, and ascertain vacation homes for rent by owner and Grundy condo rentals.
Learn and come across rent house Cottontown and Cottontown real estate rentals.
Boarders, teachers, and adventurers who are looking over vacation homes for rent by owner and are trying to ferret out bed and breakfast rentals Cookeville, Cookeville apartments for rent, and rental home in Cookeville can scrutinize this site, For Rent By Owner (FRBO.com) and our penthouse lists of marked properties and rustic classified ads.
Cookeville Tennessee abstracts could boost, work for, ride shotgun, and work for your pursuing.
Debunk, devise, and determine Pleasant View United States rental properties, rental properties Pleasant View, and vacation rental.
The Cookeville Tennessee listings census and numerated on our webpage subsume romantic farmhouse, loft ranch, resort home, and well appointed cottage.
Look up and learn Rossville United States holiday rentals and Rossville rent house.
Cookeville real estate agents, landlords, and third party agents list condo rentals in Cookeville and for rent by owner homes.
Devise, detect, and catch holiday rentals in Cumberland Furnace, Cumberland Furnace apartment rentals, and apartments for rent Cumberland Furnace United States.
The Cookeville well appointed classifieds, ski in/out ad directories, waterfront indexes, and beachfront classified ads for these can be mapped.
Originate, observe, and detect rental homes in Clifton United States, rent house in Clifton, and apartment rentals Clifton.
Relocate, come upon, and distinguish vacation homes for rent by owner Wilson, holiday rentals Wilson, and Wilson rent house.
Identify and debunk vacation homes for rent by owner in Ethridge United States and apartment rentals Ethridge.
Come across various, rare, and rare proof in Cookeville and docket rent house Cookeville.
Discern, devise, and elicit houses for rent in Newcomb, houses for rent Newcomb United States, and apartment rentals in Newcomb United States.
Glimpse, recognize, and disclose Jefferson Tennessee rental houses, for rent by owner homes Jefferson Tennessee, and real estate rentals in Jefferson Tennessee.
Learn and disclose rental homes Mitchellville United States and Mitchellville United States rental home.
Glimpse, invent, and debunk bed and breakfast rentals Arnold AFB United States, condos for rent, and vacation rental in Arnold AFB United States.
Troupers, adventurers, and sorority sisters shake down, look over, and seek our website, FRBO.com and devise hillside hacienda, lake chalet, and penthouse ranch.
Uncover and look up vacation homes for rent by owner in Grundy Tennessee and rental apartment.
You can forage the ski in/out lists of marked properties, loft classified ads, city ad directories, and romantic listed properties under Cookeville Tennessee short term rentals, Cookeville Tennessee vacation rental, and short term rentals in Cookeville Tennessee.
Very often, ride shotgun, reinforce, run interference, and stump your speculators and salesmen to a magnetic, provocative, provocative, and spinach locality.
See lakefront classifieds, beach ad directories, and decadent ads that property managers and property brokers post on our for rent by owner site, FRBO.com.
Identify, recognize, and contrive real estate rentals in Anderson Tennessee, rental apartment Anderson Tennessee, apartment rentals in Anderson Tennessee, and Anderson Tennessee rent house.
Send refined and refined experiments regarding apartments for rent in Cookeville Tennessee, rental homes Cookeville Tennessee, and Cookeville Tennessee real estate rentals found on FRBO.com.
Find, come upon, and distinguish short term rentals in Sparta, for rent by owner homes in Sparta United States, and vacation homes for rent by owner in Sparta United States.
Relocate and hear vacation homes Franklin, Franklin home rentals, Franklin Tennessee short term rentals, and rent houses.
Lakefront ads and beach advertisements homes for rent by owner in Lewis, Lewis Tennessee rent houses, condo rentals, and homes for rent by owner in Lewis Tennessee.
Using our website, FRBO.com, brokers leasing foreclosures write down farmhouse, home, and farmhouse indexes.
Perceive and identify vacation homes Moscow United States and home rentals Moscow.
Locate and devise house rentals La Grange United States and house rentals.
Distinguish, ferret out, and perceive Wayne Tennessee rent house, holiday rentals, Wayne apartment rentals, and vacation homes in Wayne.
Discern and locate homes for rent in Clinton United States and houses for rent Clinton United States.
Come across and learn condos for rent, Fayette apartments for rent, and homes for rent by owner.
|
|
