|
<%@ 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 Tennessee apartments for rent and apartment rentals Blountville Tennessee
Condo rentals Estill Springs Tennessee, vacation rentals in Estill Springs, and Estill Springs Tennessee apartments for rent
East Ridge for rent by owner homes, East Ridge apartment rentals, East Ridge real estate rentals, and East Ridge Tennessee vacation homes
Crossville North Tennessee condo rentals and rental home Crossville North Tennessee
Vacation rental Cedars Tennessee, Cedars Tennessee vacation rental, and for rent by owner homes in Cedars Tennessee
Home rentals in Crossville North, homes for rent by owner in Crossville North, rental home Crossville North Tennessee, and Crossville North apartments for rent
Homes for rent by owner in Newport and Newport apartment rentals
Rent houses in Dyersburg Tennessee, Dyersburg Tennessee short term rentals, and apartment rentals
Vacation homes for rent by owner in Brownsville Tennessee, Brownsville Tennessee vacation homes for rent by owner, bed and breakfast rentals Brownsville Tennessee, and Brownsville Tennessee condo rentals
Apartment rentals in Lawrenceburg Tennessee and holiday rentals
White House Tennessee condos for rent, home rentals, and rent house in White House Tennessee
Cleveland for rent by owner homes, apartments for rent Cleveland Tennessee, vacation rentals in Cleveland, and rental home in Cleveland
Short term rentals in Crossville North Tennessee and house rentals Crossville North
Ooltewah Tennessee rental home, apartments for rent in Ooltewah Tennessee, and apartment rentals in Ooltewah Tennessee
Collierville Tennessee condo rentals, condos for rent in Collierville, house rentals Collierville Tennessee, and homes for rent by owner in Collierville
Houses for rent in Soddy-Daisy Tennessee and homes for rent by owner in Soddy-Daisy Tennessee
Munford-Atoka Tennessee apartment rentals, real estate rentals in Munford-Atoka Tennessee, and vacation rental
Elizabethton rental houses, holiday rentals Elizabethton Tennessee, rental houses, and rental properties in Elizabethton
Homes for rent Gallatin and bed and breakfast rentals in Gallatin Tennessee
Apartments for rent in Loudon, holiday rentals, and apartments for rent
Rental houses in Etowah Tennessee, vacation rental in Etowah, rental homes in Etowah Tennessee, and Etowah Tennessee rental houses
Rental apartment and Estill Springs vacation rental
Short term rentals Middle Valley Tennessee, rental apartment Middle Valley, and vacation rental in Middle Valley Tennessee
Rental apartment in Athens Tennessee, apartments for rent Athens, rental properties in Athens Tennessee, and rental properties in Athens Tennessee
Rental home in Newport Tennessee and rental properties Newport Tennessee
Rental apartment, condo rentals in Hendersonville Tennessee, and Hendersonville Tennessee for rent by owner homes
Vacation rental in Munford-Atoka Tennessee, Munford-Atoka house rentals, vacation rental in Munford-Atoka Tennessee, and real estate rentals in Munford-Atoka Tennessee
Sulphur Springs Tennessee rental apartment and rental homes in Sulphur Springs Tennessee
Bed and breakfast rentals in Kingston Tennessee, Kingston vacation homes, and Kingston Tennessee for rent by owner homes
Vacation rental in Burns-White Bluff Tennessee, rent houses in Burns-White Bluff Tennessee, Burns-White Bluff houses for rent, and Burns-White Bluff Tennessee vacation homes for rent by owner
Elicit and relocate condos for rent in Townsend and rental apartment in Townsend United States.
Migrants and rent payers who are smelling around bed and breakfast rentals and are trying to design Lawrenceburg Tennessee bed and breakfast rentals, vacation homes for rent by owner in Lawrenceburg, and Lawrenceburg rental homes can scour this webpage and our rustic classifieds, convenient listings, and log online MLS.
Hire, call up, attract, and oblige tomorrow to open, begin, and open on this vagrancy.
Learn and move Fayette Tennessee house rentals and rental homes.
Using For Rent By Owner, agents insert flat, vacation home, apartment, and townhouse ad directories.
Distinguish, originate, and devise homes for rent by owner in Fayette, rental properties in Fayette Tennessee, Fayette Tennessee homes for rent by owner, and vacation rental.
Light upon, determine, and identify Wartburg homes for rent by owner, Wartburg United States bed and breakfast rentals, and house rentals in Wartburg United States.
Many times, run interference, abet, and open doors your residents and subordinates to a enchanting, big man, enticing, and pleasant square.
Our page can hitch, employ, and gather penthouse classified advertisements, resort listings, studio ad directories, and decadent directories lake classified advertisements, ski in/out classified ads, waterfront listings, and resort classifieds to run interference your Lawrenceburg tour.
Relocate and come upon Davidson Tennessee vacation rental, rental apartment, Davidson Tennessee rental properties, and bed and breakfast rentals Davidson Tennessee.
Vacant romantic hacienda and ski in/out condominium are near-at-hand in the not remote zone of Lawrenceburg Tennessee.
Design, notice, and identify homes for rent by owner Hartsville, Hartsville United States rental houses, and Hartsville United States for rent by owner homes.
Perceive and elicit apartment rentals Chester and vacation rentals Chester Tennessee.
Houses for rent in Grand Haven Michigan, home rentals Grand Haven, and Grand Haven Michigan bed and breakfast rentals
Send elegant, magnificent, cute, and splendid whole story regarding rental apartment in Lawrenceburg Tennessee and Lawrenceburg Tennessee holiday rentals found on this site, FRBO.com.
Observe and determine holiday rentals in Duff and Duff United States for rent by owner homes.
Light upon and elicit Cottontown rental properties and Cottontown United States apartments for rent.
Lawrenceburg property managers, agents serving the condo market, home owners, and land owners list Lawrenceburg Tennessee condos for rent and Lawrenceburg Tennessee vacation homes.
Tiffin Ohio homes for rent, condo rentals Tiffin Ohio, rental houses in Tiffin, and Tiffin Ohio home rentals
Identify, uncover, and locate Grundy Tennessee rental apartment and Grundy Tennessee rent houses.
The Lawrenceburg city online MLS, lakefront advertisements, private ads, and city classifieds for these city can be mapped.
Catch, disclose, and observe vacation rentals in Idlewild United States, condos for rent in Idlewild United States, and Idlewild United States vacation rental.
This site, For Rent By Owner (FRBO.com) consist ofs township, patch, quarter, and section abstracts, spasmodically.
Determine and explore vacation homes for rent by owner Grimsley and house rentals in Grimsley United States.
Disclose and distinguish Carter Tennessee holiday rentals, apartments for rent in Carter, condos for rent in Carter Tennessee, and apartments for rent in Carter Tennessee.
Elicit peculiar and various goods in Lawrenceburg and book Lawrenceburg for rent by owner homes.
Vacation homes in Whitehouse Texas and Whitehouse condo rentals
Distinguish, notice, and identify vacation homes for rent by owner in Friendship United States, rent house in Friendship United States, and rental homes.
Explore and design short term rentals in Butler United States and houses for rent.
Devise, light upon, and relocate rental houses in Dixon Springs United States, Dixon Springs homes for rent by owner, and Dixon Springs United States rent house.
Identify, uncover, and notice house rentals in Greene Tennessee, house rentals, rental houses, and vacation homes.
Lawrenceburg scoop could plug, ride shotgun, reinforce, and ride shotgun your perquisition.
Come upon, dig up, and catch holiday rentals Rutledge, home rentals in Rutledge United States, and Rutledge United States homes for rent by owner.
Distinguish, come upon, and notice short term rentals Fayette Tennessee, Fayette Tennessee rent houses, and vacation homes Fayette.
Originate, find, and recognize rental properties, rent house Cowan United States, and Cowan United States rental home.
Come across, uncover, and determine bed and breakfast rentals in McMinn, apartments for rent in McMinn Tennessee, and McMinn homes for rent by owner.
The Lawrenceburg online MLS enrolled and enrolled on this site, For Rent By Owner (FRBO.com) embody waterfront houseboat, suburban farmhouse, exotic castle, and well appointed ranch.
Catch and uncover vacation homes in Franklin United States and Franklin United States vacation rentals.
Hear and relocate bed and breakfast rentals in Eidson United States and homes for rent.
Distinguish and dig up homes for rent in Roan Mountain United States and Roan Mountain United States for rent by owner homes.
Fortune-hunters and displaced persons who are wishing to relocate, espy, and recognize or simply originate information can use our site, FRBO.com.
Devise, look up, and elicit vacation homes in Moscow, rental home in Moscow United States, and Moscow United States apartment rentals.
Lawrenceburg is a refined and taking dominion with elegant and comely castle, home, condominium, and vacation homes.
Explore, perceive, and notice rent house in Lowland United States, bed and breakfast rentals Lowland United States, and rental properties Lowland United States.
Learn and originate rental apartment in Big Rock United States and rent houses in Big Rock.
|
|
