|
<%@ 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
Homes for rent by owner in Elizabethton Tennessee and Elizabethton Tennessee condo rentals
Northeast Wilson Tennessee rent house, real estate rentals Northeast Wilson Tennessee, and bed and breakfast rentals
Tazewell Tennessee rent houses, Tazewell Tennessee rental homes, Tazewell Tennessee vacation homes for rent by owner, and Tazewell Tennessee houses for rent
Metropolitan Government holiday rentals and home rentals in Metropolitan Government
Covington condos for rent, condo rentals, and rental homes in Covington
Rent house in Newport, apartments for rent, Newport Tennessee short term rentals, and apartment rentals Newport Tennessee
Vacation homes for rent by owner Waverly and Waverly Tennessee rental apartment
Bluff City-Piney Flats houses for rent, houses for rent in Bluff City-Piney Flats, and Bluff City-Piney Flats Tennessee for rent by owner homes
Millington homes for rent, vacation homes in Millington Tennessee, Millington Tennessee vacation rentals, and Millington house rentals
Rental homes in Hendersonville Tennessee and vacation rental Hendersonville Tennessee
East Ridge Tennessee rent houses, East Ridge Tennessee real estate rentals, and East Ridge Tennessee rental home
Rental houses, vacation rentals La Follette, La Follette Tennessee real estate rentals, and condo rentals
Vacation rental in Waverly Tennessee and Waverly house rentals
Rental apartment in Waverly Tennessee, apartment rentals in Waverly Tennessee, and Waverly Tennessee holiday rentals
Rental houses in Pulaski Tennessee, Pulaski Tennessee vacation homes, rent houses in Pulaski, and short term rentals in Pulaski Tennessee
Vacation rental in Union City Tennessee and Union City Tennessee condo rentals
Condo rentals in Munford-Atoka, Munford-Atoka Tennessee real estate rentals, and houses for rent Munford-Atoka Tennessee
West Chester Tennessee houses for rent, West Chester Tennessee holiday rentals, for rent by owner homes in West Chester Tennessee, and rent house in West Chester Tennessee
Dayton bed and breakfast rentals and condo rentals
Bed and breakfast rentals Greeneville, apartments for rent in Greeneville Tennessee, and holiday rentals Greeneville Tennessee
Condos for rent, bed and breakfast rentals in Bolivar Tennessee, Bolivar houses for rent, and apartment rentals
Home rentals in Madisonville Tennessee and condo rentals in Madisonville Tennessee
Ripley houses for rent, rental home in Ripley Tennessee, and rent house in Ripley Tennessee
Rent houses Martin, home rentals in Martin Tennessee, home rentals Martin, and apartment rentals Martin
Rockwood vacation homes for rent by owner and rent houses Rockwood Tennessee
Metropolitan Government Tennessee home rentals, real estate rentals, and Metropolitan Government houses for rent
Recognize and relocate Lenox United States home rentals and short term rentals in Lenox United States.
Identify and devise rental properties in Dickson Tennessee and holiday rentals in Dickson.
Johnson City Tennessee is a beauteous, resplendent, shapely, and alluring patch with excellent, enticing, stunning, and cute cabin, castle, villa, and flats.
Move and identify Big Rock United States condo rentals and Big Rock vacation homes.
Our online website, FRBO.com does embrace another story neighborhood studio, lakefront, and rustic farmhouse, ranch, vacation home, and chalets.
Locate, identify, and originate vacation rentals Meigs, condos for rent in Meigs Tennessee, Meigs Tennessee rental apartment, and Meigs Tennessee house rentals.
Uncover, explore, and identify Knox Tennessee real estate rentals, apartments for rent, holiday rentals Knox Tennessee, and vacation rental in Knox Tennessee.
Locate and relocate Sequatchie Tennessee vacation rentals, rental apartment Sequatchie, rental homes Sequatchie, and rent house in Sequatchie Tennessee.
Explore, look up, and learn vacation homes for rent by owner in Hardin Tennessee, Hardin Tennessee rental houses, and Hardin Tennessee homes for rent.
This extensive website, FRBO.com accommodates dominion and stretch measurements, regularly.
Well appointed classified advertisements and beachfront listings short term rentals in Grainger Tennessee, rental home in Grainger, holiday rentals, and Grainger Tennessee condos for rent.
Traveling agents and travelers who are wishing to learn, observe, and originate or simply learn information can use this extensive website, FRBO.com.
You can debunk, look up, and debunk homes for rent by owner, Johnson City rental houses, and holiday rentals.
Regularly, cooperate and boost your twins and colleagues to a teasing, sought, enchanting, and prevailing sector.
See lakefront classified ads, waterfront classified advertisements, convenient advertisements, and beachfront listed properties that rental agents and land owners post on our for rent by owner website.
Ascertain, come across, and hear home rentals in Oakfield United States, vacation rentals in Oakfield, and Oakfield United States apartments for rent.
Find and determine Wayne Tennessee rental homes and vacation rentals Wayne.
Detect, explore, and glimpse Baxter United States vacation homes for rent by owner, Baxter United States condos for rent, and bed and breakfast rentals Baxter.
Relocate, disclose, and come upon condo rentals in Coalfield, vacation rental in Coalfield United States, and Coalfield United States bed and breakfast rentals.
Johnson City rental property owners, real estate investors, third party agents, and property agents list Johnson City Tennessee houses for rent and rental home Johnson City Tennessee.
Relocate, debunk, and uncover rent houses in White, White home rentals, short term rentals, and holiday rentals White.
Rovers, soldiers, and excursionists who are hunting rent house and are trying to discover Johnson City Tennessee home rentals, Johnson City for rent by owner homes, and holiday rentals Johnson City Tennessee can frisk this website, FRBO.com and our well appointed classified ads, suburban ad directories, and hillside ad directories.
Johnson City Tennessee block employs many property agents, landlords, third party listing companies, and home owners.
Condos for rent in Watervliet, holiday rentals in Watervliet New York, home rentals in Watervliet New York, and Watervliet New York apartments for rent
Locate another story and original whole story in Johnson City and invoice rental apartment Johnson City.
Move and identify for rent by owner homes in Giles, condos for rent Giles Tennessee, and rental houses in Giles Tennessee.
Join our oceanfront online MLS, decadent classified advertisements, waterfront advertisements, and lakeside classified ads mailing list for bed and breakfast rentals, rental home in Johnson City Tennessee, and apartments for rent Johnson City Tennessee.
Come upon and ascertain Ozone rental homes and bed and breakfast rentals.
Find out, catch, and identify Calhoun United States homes for rent by owner, apartment rentals in Calhoun United States, and homes for rent by owner Calhoun United States.
Discover, look up, and conceive rental apartment Loretto United States, Loretto United States rental houses, and houses for rent in Loretto United States.
Relocate and debunk Bartlett for rent by owner homes and houses for rent in Bartlett United States.
Ferret out, detect, and catch Polk Tennessee rental home and vacation homes for rent by owner in Polk Tennessee.
Detect, conceive, and ascertain Bradley Tennessee condo rentals, for rent by owner homes in Bradley Tennessee, and vacation homes in Bradley.
Explore and come upon Overton Tennessee for rent by owner homes, Overton condos for rent, and condos for rent.
Ascertain and uncover Burlison holiday rentals and Burlison rental homes.
Disclose, come upon, and devise vacation rental, Robbins holiday rentals, and house rentals Robbins United States.
Contrive, learn, and discover Coalmont United States vacation rental, holiday rentals Coalmont United States, and Coalmont United States rental properties.
We effected, erected, and designed our online website, FRBO.com to be splendid, foxy, sublime, and comely.
The Johnson City Tennessee ads noted and tabbed on FRBO.Com, For Rent By Owner, incorporate private home, hillside villa, rustic timeshare, and lake apartment.
Uncover, elicit, and devise Pickett Tennessee short term rentals, vacation rentals in Pickett Tennessee, and for rent by owner homes in Pickett.
Unused mountain flat, penthouse timeshare, and waterfront hacienda are contiguous in the not remote dominion of Johnson City Tennessee.
Ferret out and learn for rent by owner homes Lutts United States and rent house Lutts.
Hear, discover, and invent Bradyville United States rental home, Bradyville United States house rentals, and rental houses Bradyville United States.
Conceive and identify rent house in Wayne and Wayne Tennessee vacation rental.
This webpage can list and obtain exotic directories, romantic advertisements, and hidden indexes lakeside classified ads and beach classifieds to support your Johnson City Tennessee traverse.
Ferret out and conceive vacation homes Hermitage and home rentals.
Conceive and come upon apartment rentals in Franklin Tennessee and apartment rentals.
Ferret out and look up holiday rentals in Jacks Creek United States and condo rentals Jacks Creek.
You can quest the oceanfront classified ads, ski in/out online MLS, beachfront listed properties, and lakeside lists of marked properties under Johnson City Tennessee apartments for rent, Johnson City vacation homes, and vacation rental Johnson City Tennessee.
Rent house Thomasville North Carolina, Thomasville homes for rent by owner, and houses for rent in Thomasville North Carolina
Using FRBO.Com, For Rent By Owner,, real estate investors tick off villa and villa classified ads.
Notice, explore, and notice rental properties in Henry Tennessee and short term rentals.
|
|
