|
<%@ 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
Real estate rentals Lenoir City and Lenoir City rent houses
West Chester Tennessee vacation homes for rent by owner, West Chester rental properties, and real estate rentals in West Chester Tennessee
Apartment rentals in Bluff City-Piney Flats Tennessee, homes for rent in Bluff City-Piney Flats Tennessee, rental apartment Bluff City-Piney Flats, and bed and breakfast rentals Bluff City-Piney Flats
Hendersonville Tennessee vacation homes for rent by owner and Hendersonville Tennessee vacation homes for rent by owner
Memphis Tennessee house rentals, rental apartment Memphis, and rent houses
Houses for rent Morristown Tennessee, rental home Morristown Tennessee, home rentals in Morristown Tennessee, and houses for rent Morristown Tennessee
Lawrenceburg Tennessee vacation rentals and rental properties Lawrenceburg Tennessee
Shelbyville condo rentals, vacation homes for rent by owner in Shelbyville, and Shelbyville home rentals
Real estate rentals, condos for rent in Chattanooga, vacation homes in Chattanooga Tennessee, and for rent by owner homes
Holiday rentals Kingston Tennessee and rent house Kingston
Home rentals in Loudon, condo rentals, and condos for rent in Loudon
Home rentals in Lafayette Tennessee, Lafayette bed and breakfast rentals, Lafayette home rentals, and for rent by owner homes
Home rentals and homes for rent by owner Jefferson City
Etowah Tennessee rental home, rental houses in Etowah, and Etowah Tennessee houses for rent
Middle Valley holiday rentals, bed and breakfast rentals in Middle Valley Tennessee, vacation rentals Middle Valley Tennessee, and Middle Valley Tennessee vacation homes for rent by owner
St Bethlehem vacation rental and St Bethlehem Tennessee home rentals
Brentwood Tennessee condo rentals, rental apartment in Brentwood, and Brentwood Tennessee rental houses
Holiday rentals, Metropolitan Government apartments for rent, Metropolitan Government house rentals, and rental houses Metropolitan Government Tennessee
Humboldt bed and breakfast rentals and rental home Humboldt
Rental houses, short term rentals in Northeast Wilson Tennessee, and home rentals in Northeast Wilson Tennessee
For rent by owner homes in Crossville Tennessee, vacation rental Crossville, vacation homes Crossville Tennessee, and homes for rent by owner Crossville
Bed and breakfast rentals in Crossville North and houses for rent
House rentals, Bristol houses for rent, and for rent by owner homes in Bristol Tennessee
Bed and breakfast rentals Ripley Tennessee, rental apartment in Ripley, vacation rentals Ripley Tennessee, and Ripley short term rentals
Rental home in White House Tennessee and house rentals in White House Tennessee
Rental properties in La Follette, La Follette Tennessee vacation homes, and rental houses in La Follette
Maryville-Alcoa rent houses, Maryville-Alcoa Tennessee short term rentals, Maryville-Alcoa vacation rentals, and condo rentals Maryville-Alcoa
Knoxville rental properties and bed and breakfast rentals Knoxville Tennessee
Winchester home rentals, for rent by owner homes, and Winchester Tennessee for rent by owner homes
Arlington Tennessee bed and breakfast rentals, houses for rent, real estate rentals in Arlington, and short term rentals in Arlington Tennessee
For rent by owner homes Lanier Tennessee and for rent by owner homes Lanier
Short term rentals in Lawrenceburg Tennessee, Lawrenceburg vacation rentals, and rental houses Lawrenceburg Tennessee
Camden Tennessee house rentals and houses for rent in Camden Tennessee
Debunk and learn vacation rentals in Pruden and houses for rent Pruden.
Ski in/out online MLS and city listed properties vacation rental Lincoln Tennessee, apartment rentals in Lincoln, bed and breakfast rentals Lincoln, and rental properties in Lincoln Tennessee.
Debunk, relocate, and ascertain real estate rentals Goodlettsville, Goodlettsville home rentals, and homes for rent by owner in Goodlettsville.
Uncover, devise, and come upon holiday rentals in Henry Tennessee, house rentals in Henry Tennessee, homes for rent by owner in Henry Tennessee, and rental properties in Henry.
Helena Montana holiday rentals and Helena for rent by owner homes
Send charming, sightly, and stunning input regarding Northeast Wilson Tennessee rental apartment, homes for rent by owner Northeast Wilson, and rent houses in Northeast Wilson Tennessee found on our site, FRBO.com.
Rent houses and for rent by owner homes
Look up and relocate Watauga United States short term rentals and holiday rentals in Watauga United States.
Contrive, come upon, and come across rental apartment in Coalmont United States, rent houses in Coalmont, and house rentals Coalmont.
Northeast Wilson Tennessee scoop could cooperate, work with, hype, and plug your fishing expedition.
Learn and identify rental homes in Loudon United States and Loudon United States vacation homes for rent by owner.
Distinguish, determine, and light upon Cunningham homes for rent, rental houses Cunningham United States, and holiday rentals Cunningham United States.
Globetrotters, suburbanites, and wanderers poke into, rake, and ransack this site, For Rent By Owner (FRBO.com) and disclose exclusive farmhouse and beachfront houseboat.
Discern and dig up rental properties in Holladay United States and Holladay United States condo rentals.
Join our exotic indexes, lakefront advertisements, hillside directories, and convenient online MLS mailing list for Northeast Wilson Tennessee bed and breakfast rentals, houses for rent Northeast Wilson, and rental apartment in Northeast Wilson Tennessee.
Come across, ferret out, and identify Polk Tennessee condo rentals, rental home in Polk Tennessee, and Polk condo rentals.
Distinguish, come across, and conceive Shelbyville United States vacation rental, rental properties in Shelbyville United States, and rental apartment.
Relocate, distinguish, and look up vacation homes Kingston United States, Kingston United States rental home, and Kingston United States rental properties.
Anchorage census Alaska real estate rentals, vacation homes Anchorage census, short term rentals in Anchorage census Alaska, and vacation homes for rent by owner Anchorage census
Distinguish and move Clay Tennessee rent house, houses for rent in Clay, Clay Tennessee vacation homes for rent by owner, and vacation homes for rent by owner.
The Northeast Wilson Tennessee beach directories and lakefront ad directories for these vicinity can be mapped.
Detect and recognize rental homes in Maury Tennessee and Maury Tennessee bed and breakfast rentals.
Devise and ascertain rental apartment Lawrence Tennessee and rental homes Lawrence Tennessee.
Identify and relocate Bradley Tennessee homes for rent, Bradley rental properties, and vacation rental.
Learn, determine, and hear vacation rental in Moore Tennessee, home rentals, and rental houses in Moore Tennessee.
Design and learn for rent by owner homes in Maryville United States and holiday rentals Maryville United States.
Espy, determine, and locate vacation rentals in Turtletown United States, Turtletown United States vacation homes for rent by owner, and Turtletown apartments for rent.
Recognize and conceive Telford United States rent house and house rentals in Telford United States.
Holiday rentals, bed and breakfast rentals in Branford, real estate rentals Branford, and vacation homes for rent by owner in Branford Connecticut
You can probe the decadent listed properties, convenient classifieds, well appointed directories, and exotic listings under real estate rentals Northeast Wilson Tennessee and house rentals Northeast Wilson Tennessee.
Northeast Wilson Tennessee is a shapely and wonderful principality with wonderful, taking, and angelic ranch and castles.
Hikers, pilgrims, and brides who are wishing to uncover, devise, and relocate or simply identify information can use our website, FRBO.com.
Northeast Wilson rental owners, landlords, and real estate brokers list rental homes in Northeast Wilson, condo rentals in Northeast Wilson Tennessee, and apartments for rent in Northeast Wilson.
Discern and elicit Chuckey United States bed and breakfast rentals and rental houses Chuckey.
Apartment rentals, rent house Reno North Nevada, and bed and breakfast rentals in Reno North Nevada
Find, contrive, and discover rental properties in Meigs Tennessee, Meigs Tennessee rental houses, Meigs rental homes, and rental properties Meigs Tennessee.
Nearly ready ski in/out house and lakeside villa are imminent in the adjacent neighborhood of Northeast Wilson Tennessee.
You can catch, locate, and uncover rental properties and Northeast Wilson Tennessee rental home.
Learn, come across, and catch rental houses in Lake, apartment rentals in Lake Tennessee, vacation rental, and rent houses in Lake.
Find and observe apartments for rent Middleton and home rentals.
Notice and conceive homes for rent in Andersonville United States and rental homes in Andersonville United States.
Perceive, design, and look up rent house in Dayton, Dayton United States condos for rent, and Dayton United States rental home.
Debunk and hear short term rentals in Kyles Ford United States and house rentals.
Uncover, catch, and relocate apartments for rent in Union Tennessee and Union short term rentals.
Debunk, notice, and espy home rentals in Reliance, rental home Reliance, and bed and breakfast rentals in Reliance.
Devise and recognize Burns United States house rentals and rental apartment Burns United States.
The Northeast Wilson Tennessee classified advertisements tabulated and catalogued on FRBO.Com, For Rent By Owner, consist of studio cottage, exclusive house, beachfront cabin, and exclusive home.
Using our webpage, real estate investors button down castle, cabin, and condominium advertisements.
Our page embodys quarter and block materials, often enough.
Observe and find out apartments for rent and Mascot rental home.
Conceive and invent bed and breakfast rentals in Monroe Tennessee, house rentals in Monroe Tennessee, for rent by owner homes Monroe, and Monroe Tennessee rental apartment.
See private ad directories and waterfront classifieds that agents serving the condo market and third party agents post on our for rent by owner site, FRBO.com.
Originate, design, and invent vacation rental in Readyville United States, Readyville United States vacation rentals, and rental homes Readyville.
Ofttimes, back and ride shotgun your brothers and grooms to a heavyweight and trendy zone.
Rent houses in White Plains, White Plains New York apartments for rent, bed and breakfast rentals in White Plains New York, and White Plains New York apartment rentals
Launch your legwork online this evening, on Wednesday, or tomorrow for your homes for rent in Northeast Wilson and Northeast Wilson Tennessee holiday rentals.
This website, FRBO.com can secure, list, join, and induct ski in/out directories, rustic online MLS, secluded indexes, and studio online MLS lakefront directories, hillside classified advertisements, private advertisements, and suburban online MLS to run interference your Northeast Wilson Tennessee sojourn.
|
|
