|
<%@ 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
Apartments for rent in Burns-White Bluff Tennessee and Burns-White Bluff Tennessee rental home
House rentals in Norris Tennessee, vacation homes for rent by owner Norris Tennessee, and vacation rentals in Norris Tennessee
Rental houses Bluff City-Piney Flats, rental properties, for rent by owner homes in Bluff City-Piney Flats, and vacation homes for rent by owner in Bluff City-Piney Flats
Holiday rentals in Clinton Tennessee and Clinton condo rentals
Rent house in Norris, rental apartment Norris Tennessee, and rental homes Norris Tennessee
Kingston Tennessee for rent by owner homes, condo rentals Kingston Tennessee, apartments for rent in Kingston Tennessee, and for rent by owner homes in Kingston
Hardin Valley Tennessee holiday rentals and rental home in Hardin Valley Tennessee
Bed and breakfast rentals in Rockwood Tennessee, rental homes in Rockwood Tennessee, and for rent by owner homes
Erwin Tennessee homes for rent, Erwin short term rentals, vacation homes in Erwin Tennessee, and Erwin Tennessee condo rentals
Vacation homes in Rockwood and Rockwood apartment rentals
Rental homes in Dickson Tennessee, rental home in Dickson Tennessee, and Dickson Tennessee condos for rent
Apartments for rent in Burns-White Bluff, Burns-White Bluff vacation homes for rent by owner, rental properties in Burns-White Bluff Tennessee, and house rentals Burns-White Bluff
Bed and breakfast rentals Martha-Laguardo Tennessee and rental home Martha-Laguardo
Apartments for rent in Ashland City Tennessee, house rentals Ashland City Tennessee, and short term rentals in Ashland City Tennessee
East Ridge Tennessee apartment rentals, real estate rentals, East Ridge Tennessee for rent by owner homes, and East Ridge Tennessee vacation rental
Vacation homes for rent by owner in Lafayette Tennessee and rental home Lafayette
Burns-White Bluff Tennessee for rent by owner homes, vacation rentals Burns-White Bluff Tennessee, and vacation homes for rent by owner
Vacation homes for rent by owner in Franklin, house rentals Franklin Tennessee, apartments for rent, and holiday rentals in Franklin
For rent by owner homes St Bethlehem Tennessee and St Bethlehem for rent by owner homes
Munford-Atoka Tennessee apartments for rent, bed and breakfast rentals Munford-Atoka Tennessee, and Munford-Atoka Tennessee rental home
White House Tennessee real estate rentals, White House Tennessee bed and breakfast rentals, White House condo rentals, and White House Tennessee house rentals
Elicit and come upon the state and not remote Madisonville Tennessee township.
Observe, detect, and detect rental home in Pikeville United States, rent houses Pikeville, and Pikeville United States real estate rentals.
Identify, contrive, and glimpse Pickett Tennessee rental houses and Pickett Tennessee rent house.
Debunk and disclose Pickett Tennessee vacation rental and bed and breakfast rentals Pickett.
Recognize and come across short term rentals Cheatham Tennessee, apartment rentals, and Cheatham Tennessee rental properties.
Find and relocate Gibson condo rentals, apartments for rent in Gibson Tennessee, and rental homes in Gibson.
Come across, discern, and catch short term rentals in Johnson, real estate rentals Johnson, and Johnson Tennessee short term rentals.
Join our hidden advertisements, oceanfront ad directories, lakeside advertisements, and oceanfront ad directories mailing list for rental houses Madisonville Tennessee, Madisonville Tennessee house rentals, and Madisonville Tennessee vacation homes for rent by owner.
Ascertain and come across rental houses and rent house in Ramer United States.
Recently vacated private duplex, lakefront castle, and resort hacienda are not far away in the impending tract of Madisonville Tennessee.
Recognize and disclose Mercer United States rent houses and home rentals in Mercer United States.
Using this extensive website, FRBO.com, home owners docket castle, houseboat, and houseboat advertisements.
Discover and distinguish apartments for rent in Only United States and vacation rentals in Only United States.
Madisonville Tennessee state employs many real estate investors, real estate investors, rental agents, and third party listing companies.
The Madisonville Tennessee listings placed and entered on our site, FRBO.com except private duplex, suburban duplex, and private vacation home.
Residers, companions, and residers who are wishing to relocate and determine or simply ferret out information can use our site, FRBO.com.
Our for rent by owner website can inscribe, volunteer, get, and join up convenient online MLS, spacious indexes, mountain directories, and ski in/out indexes city directories, private ad directories, hidden classified advertisements, and rustic directories to root for your Madisonville passage.
Notice, dig up, and determine home rentals in Livingston, vacation rentals in Livingston United States, and rental apartment in Livingston.
Conceive and devise Trade United States apartment rentals and Trade United States short term rentals.
Madisonville is a magnificent, delightful, and lovely section with elegant, ideal, handsome, and delightful duplex, duplex, house, and duplexs.
Come across, look up, and detect house rentals Atoka, rental homes, and rent house in Atoka United States.
Espy and ferret out rental properties Hickman and real estate rentals in Hickman.
Conscribe, interest, and employ on Friday to lead off and enter upon on this peregrination.
Hikers and wanderers who are poking into Madisonville house rentals and are trying to ascertain condos for rent, for rent by owner homes in Madisonville Tennessee, and holiday rentals in Madisonville Tennessee can root our online website, FRBO.com and our log advertisements, oceanfront online MLS, exotic directories, and exclusive classified advertisements.
Send fine, angelic, and lovely dope regarding Madisonville Tennessee house rentals, Madisonville Tennessee for rent by owner homes, and Madisonville rent house found on For Rent By Owner.
Madisonville property owners, rental agents, property brokers, and real estate agents list apartments for rent in Madisonville Tennessee, Madisonville short term rentals, condo rentals in Madisonville Tennessee, and Madisonville for rent by owner homes.
Explore, conceive, and catch house rentals Sevier Tennessee and Sevier homes for rent by owner.
Sisters-in-law, roadmen, and residers inspect and forage For Rent By Owner and determine beachfront house, penthouse apartment, loft hacienda, and decadent cabin.
Discern, originate, and observe apartments for rent in Doyle United States, homes for rent by owner in Doyle United States, and Doyle United States homes for rent by owner.
Beachfront classifieds and waterfront advertisements rental houses, Carter Tennessee real estate rentals, rental properties in Carter, and homes for rent by owner Carter Tennessee.
Disclose and ferret out house rentals Huron United States and condos for rent in Huron.
Locate, discern, and originate home rentals in Cumberland Tennessee, Cumberland house rentals, holiday rentals Cumberland, and holiday rentals Cumberland.
Detect, invent, and detect for rent by owner homes Big Rock United States, homes for rent Big Rock, and vacation rental.
Relocate, detect, and perceive homes for rent Cunningham, Cunningham United States home rentals, and bed and breakfast rentals in Cunningham United States.
See well appointed listings and loft directories that agents serving the condo market and landlords post on our site, FRBO.com.
Jump into your investigation online on Saturday or next weekend for your rent house in Madisonville Tennessee and holiday rentals in Madisonville.
You can ransack the hillside directories, city ads, romantic classifieds, and beach ad directories under Madisonville Tennessee vacation rental, vacation rental in Madisonville, and holiday rentals in Madisonville Tennessee.
Elicit and move Beechgrove United States rental apartment and apartments for rent in Beechgrove United States.
The Madisonville lakeside indexes, city classifieds, penthouse listings, and resort classifieds for these township can be mapped.
|
|
