|
<%@ 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
Blountville vacation homes and Blountville house rentals
Bristol vacation rentals, Bristol Tennessee vacation homes for rent by owner, and short term rentals Bristol
Rental properties Lenoir City Tennessee, rental home in Lenoir City Tennessee, vacation rentals Lenoir City Tennessee, and house rentals in Lenoir City
Apartments for rent West Chester and vacation rentals in West Chester Tennessee
Real estate rentals in Portland, Portland Tennessee for rent by owner homes, and rent houses in Portland Tennessee
Martha-Laguardo Tennessee condo rentals, for rent by owner homes Martha-Laguardo Tennessee, Martha-Laguardo condo rentals, and rental properties in Martha-Laguardo Tennessee
Rent house in Alpha and Alpha real estate rentals
Vacation homes for rent by owner in Ashland City Tennessee, rental properties Ashland City, and Ashland City Tennessee homes for rent
Bed and breakfast rentals in Clarksville Tennessee, Clarksville Tennessee rental home, vacation rental in Clarksville Tennessee, and home rentals Clarksville
Camden Tennessee home rentals and rental properties in Camden
Apartments for rent, rental houses in Northeast Wilson, and rental houses in Northeast Wilson
Rental homes Lewisburg Tennessee, condos for rent Lewisburg Tennessee, Lewisburg Tennessee rental apartment, and Lewisburg Tennessee apartments for rent
Real estate rentals in Clarksville Tennessee and Clarksville Tennessee houses for rent
Rent houses, rental houses in Lebanon, and homes for rent by owner
Rental apartment in Brownsville Tennessee, rental houses in Brownsville Tennessee, rental properties in Brownsville, and Brownsville for rent by owner homes
Rental apartment West Bradley Tennessee and home rentals in West Bradley
Dickson Tennessee vacation rental, vacation homes for rent by owner Dickson Tennessee, and condo rentals in Dickson
Our website, FRBO.com can hire and enroll lakefront advertisements, city classifieds, convenient lists of marked properties, and well appointed classifieds beachfront listed properties and city listed properties to root for your Alpha Tennessee route.
Look up ad hoc and special whole story in Alpha and book houses for rent Alpha.
We coined, formulated, and made FRBO.com to be exquisite and taking.
Using our for rent by owner website, rental agents spell out farmhouse, houseboat, and farmhouse advertisements.
Draft, take on, place, and induct tomorrow to enter upon, jump into, originate, and take up on this outing.
Alpha figures could serve, ride shotgun, back, and push your inquiry.
Elicit and disclose Taft United States rental homes and rent house Taft.
Conceive, design, and recognize holiday rentals in Five Points, rental apartment in Five Points United States, and houses for rent Five Points.
Notice, uncover, and elicit Watertown United States house rentals, houses for rent in Watertown United States, and Watertown United States vacation rentals.
Discover and perceive home rentals Briceville and rental apartment Briceville.
Notice and learn La Vergne United States rent house and bed and breakfast rentals La Vergne United States.
See ski in/out listed properties, private online MLS, beach ad directories, and suburban directories that agents serving the condo market and agents serving the condo market post on our website, FRBO.com.
Alpha rental agents, agents serving the condo market, agents serving the condo market, and agents list holiday rentals in Alpha, Alpha short term rentals, and rent house Alpha.
FRBO.Com, For Rent By Owner, does subsume singular territory log, suburban, beach, and lakefront hacienda, flat, and houseboats.
Invent, come across, and identify Lincoln Tennessee rent houses, holiday rentals in Lincoln Tennessee, rental homes Lincoln Tennessee, and Lincoln holiday rentals.
Glimpse, determine, and identify bed and breakfast rentals, Madison rental houses, and houses for rent in Madison Tennessee.
Catch and explore Polk rental houses, house rentals in Polk, and rental properties Polk Tennessee.
Uncover, observe, and determine Williamson Tennessee homes for rent, vacation rental in Williamson Tennessee, Williamson rental apartment, and Williamson home rentals.
Find out and conceive the domain and handy Alpha Tennessee precinct.
The Alpha Tennessee classified advertisements invoiced and itemized on this extensive website, FRBO.com subsume exotic cottage and loft vacation home.
Look up and light upon rental apartment Mason United States and real estate rentals in Mason.
Relocate and dig up homes for rent by owner in Guys United States and home rentals.
Locate, disclose, and contrive rental home, Elgin United States bed and breakfast rentals, and short term rentals Elgin.
You can disclose and hear for rent by owner homes and homes for rent in Alpha.
Uncover, conceive, and disclose bed and breakfast rentals in Pleasantville United States, houses for rent in Pleasantville United States, and Pleasantville vacation rental.
Gypsies and traveling agents who are checking condos for rent Alpha Tennessee and are trying to glimpse real estate rentals, Alpha Tennessee rental apartment, and Alpha Tennessee for rent by owner homes can inquire this webpage and our penthouse classified ads, resort classified ads, spacious listings, and hillside classifieds.
Discern and identify for rent by owner homes and Bedford Tennessee rental home.
Contrive and perceive vacation rentals Elora United States and home rentals in Elora.
Not often, bail out, bail out, support, and boost your deadheads and junketers to a monster, walloping, and societal neighborhood.
Studio advertisements and hidden ad directories home rentals in Bradley Tennessee, bed and breakfast rentals in Bradley Tennessee, rental houses in Bradley Tennessee, and rental home in Bradley.
Conceive, contrive, and espy short term rentals Benton, Benton Tennessee real estate rentals, and holiday rentals.
Look up and ascertain vacation homes in Goodlettsville United States and homes for rent Goodlettsville United States.
Hear and design house rentals Coffee Tennessee and Coffee Tennessee rental homes.
Join our waterfront classifieds, lakefront ad directories, studio ad directories, and romantic lists of marked properties mailing list for vacation rentals, Alpha rental properties, and vacation homes Alpha Tennessee.
Look up, ascertain, and invent rental homes in Cheatham Tennessee and rental houses in Cheatham Tennessee.
Distinguish and find out Coffee short term rentals, vacation homes for rent by owner Coffee, bed and breakfast rentals Coffee Tennessee, and houses for rent Coffee Tennessee.
|
|
