|
<%@ 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 home and Milan Tennessee rental properties
House rentals Jefferson City Tennessee, Jefferson City rental homes, and bed and breakfast rentals in Jefferson City
Kingston Tennessee rental home, rental homes in Kingston, Kingston condos for rent, and Kingston Tennessee rental home
Rent house Brownsville Tennessee and apartment rentals in Brownsville Tennessee
Rental properties in Munford-Atoka Tennessee, short term rentals Munford-Atoka Tennessee, and Munford-Atoka Tennessee homes for rent
Murfreesboro Tennessee homes for rent, rent house, Murfreesboro Tennessee apartments for rent, and rental homes in Murfreesboro Tennessee
Condo rentals in Pulaski and homes for rent in Pulaski
Home rentals, rent houses Lexington Tennessee, and vacation rentals in Lexington Tennessee
House rentals in Newport Tennessee, Newport Tennessee rental apartment, bed and breakfast rentals Newport, and Newport Tennessee real estate rentals
Hendersonville Tennessee rent houses and home rentals in Hendersonville
Rental houses Mountain City Tennessee, Mountain City Tennessee short term rentals, and vacation rentals in Mountain City Tennessee
Holiday rentals in East Ridge Tennessee, vacation homes in East Ridge Tennessee, rent house East Ridge Tennessee, and rent house in East Ridge Tennessee
Northeast Wilson houses for rent and Northeast Wilson Tennessee rental apartment
Apartment rentals in Charleston Tennessee, bed and breakfast rentals in Charleston Tennessee, and rental apartment in Charleston
Short term rentals in Gallatin Tennessee, bed and breakfast rentals in Gallatin Tennessee, Gallatin Tennessee short term rentals, and home rentals
Bed and breakfast rentals Elizabethton and rent house Elizabethton
La Follette rental houses, rent houses, and La Follette homes for rent
Houses for rent in Pulaski Tennessee, rental houses Pulaski, bed and breakfast rentals in Pulaski Tennessee, and Pulaski homes for rent by owner
Mount Juliet Tennessee vacation rentals and Mount Juliet Tennessee short term rentals
Rent houses in Sulphur Springs, bed and breakfast rentals in Sulphur Springs Tennessee, and Sulphur Springs Tennessee for rent by owner homes
See exclusive indexes and convenient lists of marked properties that agents and brokers leasing foreclosures post on this website, FRBO.com.
Many times, cooperate and help your trippers and lodgers to a inviting, captivating, roomy, and sizable quarter.
Send charming, bewitching, and shapely compilations regarding rent house, Kingston Tennessee homes for rent, and vacation homes for rent by owner found on our site, FRBO.com.
Move, recognize, and dig up Van Buren Tennessee short term rentals, house rentals, and rental home in Van Buren Tennessee.
Hear, locate, and contrive short term rentals Carter, homes for rent in Carter Tennessee, apartments for rent Carter Tennessee, and rental home.
Observe and disclose homes for rent by owner Sewanee and Sewanee rental apartment.
We established and designed our page to be delightful, comely, sublime, and refined.
Available ski in/out apartment, secluded castle, exotic flat, and resort flat are imminent in the near-at-hand neighborhood of Kingston.
Distinguish and elicit holiday rentals in Sardis and houses for rent.
Identify, ferret out, and distinguish vacation rental in Henderson Tennessee and Henderson Tennessee vacation homes for rent by owner.
Drifters, comrades, and householders who are wishing to explore, discern, and discover or simply explore information can use this website, FRBO.com.
The Kingston private classified ads, loft directories, convenient lists of marked properties, and private listed properties for these can be mapped.
Dig up and determine homes for rent by owner Scott Tennessee and Scott Tennessee real estate rentals.
This site, FRBO.com accommodates dominion and field memorandums, not often.
Kingston Tennessee is a radiant and fair plot with taking, refined, and well-formed bungalow and castles.
Identify and debunk bed and breakfast rentals Johnson, Johnson Tennessee houses for rent, and rent house in Johnson.
Contrive, ascertain, and relocate holiday rentals and houses for rent in Houston Tennessee.
Join our convenient indexes, resort classified advertisements, beach classifieds, and lake directories mailing list for Kingston Tennessee vacation rentals and Kingston Tennessee short term rentals.
Look up and originate Lake Tennessee vacation homes, rental apartment in Lake Tennessee, and Lake Tennessee condos for rent.
|
|
