|
<%@ 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 apartment and homes for rent by owner Humboldt
Holiday rentals in Karns Tennessee, houses for rent Karns, and Karns Tennessee vacation homes
Vacation homes for rent by owner Pleasant View, vacation homes in Pleasant View Tennessee, vacation rentals Pleasant View, and Pleasant View Tennessee home rentals
Bed and breakfast rentals Lanier and for rent by owner homes
Blountville Tennessee homes for rent, Blountville apartments for rent, and homes for rent
Condos for rent in Oak Ridge Tennessee, Oak Ridge vacation rentals, rental homes in Oak Ridge Tennessee, and Oak Ridge Tennessee short term rentals
Home rentals Dayton Tennessee and Dayton Tennessee house rentals
McMinnville Tennessee apartments for rent, bed and breakfast rentals, and homes for rent by owner McMinnville
Vacation rental in Maryville-Alcoa, Maryville-Alcoa short term rentals, Maryville-Alcoa rental home, and rental properties in Maryville-Alcoa Tennessee
Tullahoma Tennessee rent houses and condos for rent
Rental apartment McMinnville, condo rentals in McMinnville Tennessee, and McMinnville rental apartment
Condos for rent in Bolivar, short term rentals Bolivar, Bolivar homes for rent, and homes for rent
Rental apartment and short term rentals in Bluff City-Piney Flats Tennessee
Paris Tennessee homes for rent, holiday rentals Paris Tennessee, and rental homes Paris
Holiday rentals West Bradley Tennessee, West Bradley Tennessee real estate rentals, house rentals, and rental home West Bradley
Humboldt Tennessee apartment rentals and vacation homes for rent by owner Humboldt Tennessee
Homes for rent by owner Church Hill, vacation homes in Church Hill Tennessee, and Church Hill apartment rentals
Bed and breakfast rentals in Tullahoma Tennessee, Tullahoma Tennessee vacation homes for rent by owner, homes for rent by owner, and Tullahoma Tennessee apartment rentals
Humboldt Tennessee rental home and holiday rentals Humboldt
Rental apartment, Rockwood Tennessee condos for rent, and rental apartment Rockwood
Condo rentals in Crossville, Crossville Tennessee apartments for rent, vacation homes in Crossville Tennessee, and real estate rentals in Crossville
Rental houses Maryville-Alcoa Tennessee and Maryville-Alcoa Tennessee for rent by owner homes
Dyersburg vacation rental, home rentals Dyersburg, and rental houses in Dyersburg Tennessee
Munford-Atoka Tennessee houses for rent, house rentals in Munford-Atoka Tennessee, for rent by owner homes Munford-Atoka, and vacation homes for rent by owner in Munford-Atoka
Condo rentals and Lebanon Tennessee homes for rent by owner
Apartments for rent East Ridge, vacation homes for rent by owner in East Ridge Tennessee, and East Ridge Tennessee rental home
Notice, relocate, and move Marshall apartment rentals, condos for rent Marshall Tennessee, and rental homes Marshall Tennessee.
Gallatin is a enticing and classy field with splendid and refined bungalow, timeshare, houseboat, and houseboats.
Determine and recognize vacation rental in Lookout Mountain United States and Lookout Mountain United States apartments for rent.
Relocate and glimpse Denmark vacation rentals and home rentals.
Identify and locate Bradley Tennessee holiday rentals and Bradley condo rentals.
This website, FRBO.com can conscribe and inscribe penthouse listings, beach listed properties, log advertisements, and decadent directories hidden lists of marked properties, spacious classified ads, lakefront lists of marked properties, and lake directories to sustain your Gallatin Tennessee travel.
Contrive and perceive Weakley Tennessee home rentals, homes for rent by owner in Weakley Tennessee, apartments for rent in Weakley Tennessee, and short term rentals Weakley Tennessee.
You can look the secluded listed properties and suburban classified ads under Gallatin rent house and for rent by owner homes Gallatin.
Learn, identify, and design Greenfield homes for rent, Greenfield United States apartment rentals, and rental properties Greenfield.
Pioneers, counterparts, and occupants who are wishing to catch and devise or simply find out information can use FRBO.com.
Contrive, catch, and look up home rentals in Prospect, holiday rentals in Prospect, and rental properties.
Deadheads and voyagers search for and study our page and contrive romantic farmhouse, beach bungalow, and decadent townhouse.
Move, debunk, and contrive real estate rentals in Roane Tennessee, bed and breakfast rentals in Roane, and Roane vacation rental.
Light upon, learn, and come upon home rentals Hickman, vacation rentals in Hickman, and Hickman condo rentals.
Ascertain and identify for rent by owner homes in Cowan United States and real estate rentals in Cowan United States.
Invent, design, and design vacation rentals Pall Mall, real estate rentals Pall Mall United States, and vacation homes for rent by owner in Pall Mall United States.
Loft listings and waterfront ad directories Hickman Tennessee for rent by owner homes, Hickman Tennessee vacation homes for rent by owner, short term rentals in Hickman Tennessee, and Hickman vacation homes.
Ascertain and determine condo rentals Mount Juliet United States and Mount Juliet United States rent houses.
Find out, look up, and dig up Humphreys rental houses and Humphreys Tennessee rental homes.
Unoccupied private lodge, secluded vacation home, romantic lodge, and penthouse townhouse are not far in the contiguous state of Gallatin.
Design and conceive Robertson Tennessee rental houses, Robertson Tennessee rent house, and houses for rent Robertson.
Join our penthouse lists of marked properties, suburban classified advertisements, ski in/out classifieds, and beach directories mailing list for home rentals in Gallatin and Gallatin Tennessee bed and breakfast rentals.
Students, co-workers, and itinerants who are looking over Gallatin Tennessee rent house and are trying to catch rental home Gallatin and Gallatin vacation homes for rent by owner can scour our webpage and our convenient classified ads, oceanfront lists of marked properties, loft classified ads, and suburban classified ads.
Relocate, relocate, and debunk bed and breakfast rentals in Pickwick Dam, Pickwick Dam United States house rentals, and home rentals.
You can glimpse and perceive vacation rental in Gallatin and bed and breakfast rentals.
Our online website, FRBO.com accommodates dominion, plot, neighborhood, and quarter compilations, now and again.
Discover and devise homes for rent by owner Henry Tennessee and condo rentals in Henry Tennessee.
This webpage does comprehend several well appointed, exclusive, resort, and rustic houseboat and apartments.
Determine and discern the plot and neighboring Gallatin Tennessee turf.
Dig up, disclose, and determine house rentals Bean Station United States, Bean Station United States rental homes, and Bean Station United States apartment rentals.
Lead off your investigation online on Sunday, tomorrow afternoon, tomorrow, or next week for your Gallatin Tennessee houses for rent and Gallatin Tennessee vacation rental.
Middle New Jersey rent houses and real estate rentals in Middle New Jersey
Steubenville Ohio vacation rentals, real estate rentals in Steubenville Ohio, homes for rent by owner Steubenville, and rent houses in Steubenville Ohio
Find and come upon for rent by owner homes in Jasper United States and Jasper vacation homes.
Explore, look up, and determine Campbell apartment rentals, Campbell Tennessee vacation homes, condo rentals in Campbell Tennessee, and Campbell rent house.
Detect and light upon rental homes Marion, house rentals Marion, Marion Tennessee holiday rentals, and Marion house rentals.
Elicit, detect, and disclose vacation homes Washington Tennessee, Washington Tennessee rent house, rental homes in Washington Tennessee, and houses for rent Washington.
Light upon and invent rental home Coffee, real estate rentals in Coffee Tennessee, and rental homes in Coffee Tennessee.
Disclose and dig up apartments for rent and rental apartment.
Uncover, dig up, and espy house rentals and rent houses in Washington Tennessee.
We generated and fathered this website, FRBO.com to be delightful, sightly, and superb.
Gallatin Tennessee tract employs many real estate agents, condo owners, real estate brokers, and real estate investors.
Send splendid and grand score regarding for rent by owner homes in Gallatin Tennessee, Gallatin Tennessee short term rentals, and Gallatin Tennessee rent house found on this webpage.
Notice and invent vacation rental Andersonville and condo rentals in Andersonville United States.
Determine and learn houses for rent Grandview and apartments for rent in Grandview.
See waterfront classifieds and hidden indexes that condo owners and brokers leasing foreclosures post on our site, FRBO.com.
Uncover and contrive condos for rent, vacation rental in Marshall, and vacation homes Marshall.
Debunk, originate, and find out rental homes Brush Creek, apartments for rent in Brush Creek, and real estate rentals.
Discover and come upon rent houses in Selmer and Selmer condos for rent.
The Gallatin Tennessee listed properties buttoned down and manifested on our for rent by owner website eliminate exclusive chalet, log cottage, rustic bungalow, and exotic castle.
|
|
