|
<%@ 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
Millington Tennessee houses for rent and Millington Tennessee for rent by owner homes
Maryville-Alcoa Tennessee rental apartment, holiday rentals Maryville-Alcoa Tennessee, and Maryville-Alcoa Tennessee home rentals
Vacation homes, apartment rentals, bed and breakfast rentals in Bluff City-Piney Flats Tennessee, and condo rentals in Bluff City-Piney Flats Tennessee
Martha-Laguardo condo rentals and house rentals in Martha-Laguardo
Erwin Tennessee short term rentals, vacation rental Erwin Tennessee, and condo rentals Erwin
Lebanon Tennessee condos for rent, Lebanon holiday rentals, home rentals, and homes for rent by owner in Lebanon
Condos for rent Humboldt Tennessee and rental properties
Holiday rentals in Greeneville, apartment rentals in Greeneville Tennessee, and short term rentals in Greeneville Tennessee
Pleasant View real estate rentals, home rentals Pleasant View, apartments for rent, and Pleasant View vacation rental
Homes for rent in Snow Hill Tennessee and rental houses in Snow Hill
Homes for rent by owner Brownsville Tennessee, rental homes, and rental properties
Vacation rental Greeneville Tennessee, houses for rent in Greeneville, Greeneville Tennessee vacation rental, and vacation homes
Rent houses Bristol and real estate rentals in Bristol Tennessee
Apartments for rent Rockwood Tennessee, vacation rentals Rockwood, and Rockwood Tennessee homes for rent by owner
La Follette Tennessee homes for rent, home rentals La Follette, La Follette Tennessee rental homes, and rent houses La Follette Tennessee
House rentals in Pleasant View Tennessee and rent house
Vacation homes for rent by owner in Memphis, Memphis homes for rent, and vacation homes for rent by owner
Holiday rentals in Crossville North Tennessee, holiday rentals Crossville North Tennessee, rent house in Crossville North Tennessee, and houses for rent Crossville North Tennessee
Homes for rent Maryville-Alcoa Tennessee and rent house in Maryville-Alcoa Tennessee
Rent houses, rental houses Springfield-Greenbrier, and Springfield-Greenbrier Tennessee rent house
We made and formed FRBO.Com, For Rent By Owner, to be bewitching, radiant, resplendent, and refined.
You can search for the lakefront classifieds, oceanfront listed properties, hillside listed properties, and lakeside listed properties under home rentals and rental properties Ripley.
Distinguish and explore rental properties and Greene Tennessee condos for rent.
Learn, recognize, and recognize Marion Tennessee for rent by owner homes and apartment rentals Marion.
See penthouse indexes, convenient ads, convenient listed properties, and hillside listed properties that rental agents and landlords post on our for rent by owner site, FRBO.com.
Catch, discern, and determine Ducktown United States holiday rentals, apartments for rent in Ducktown United States, and rent houses in Ducktown United States.
Espy, notice, and catch rental apartment Lewis, real estate rentals in Lewis, and condo rentals Lewis.
You can perceive and debunk apartments for rent in Ripley Tennessee, Ripley Tennessee apartment rentals, and rental homes.
Identify, discern, and come upon Collegedale United States holiday rentals, rental apartment, and apartments for rent in Collegedale United States.
Distinguish, debunk, and perceive vacation rentals Tipton and Tipton Tennessee rental properties.
Catch, debunk, and explore condos for rent in Jefferson City, Jefferson City apartments for rent, and for rent by owner homes in Jefferson City United States.
Identify, ascertain, and detect for rent by owner homes in Etowah United States, Etowah United States vacation rentals, and houses for rent Etowah.
Observe and light upon rental apartment in Obion United States and vacation homes in Obion.
Relocate and glimpse rental homes in Bartlett United States and vacation rental in Bartlett United States.
Explore and move apartment rentals Friendship and vacation rental Friendship.
Come upon various and specialized memorandums in Ripley Tennessee and itemize rent house in Ripley Tennessee.
Mobilize, sign on, and reserve on Saturday to launch, inaugurate, embark on, and embark on on this migration.
Ferret out, contrive, and light upon Sevier Tennessee short term rentals, holiday rentals, and Sevier Tennessee vacation rental.
Find out, light upon, and glimpse real estate rentals Hardin, Hardin Tennessee for rent by owner homes, and Hardin Tennessee rental houses.
Look up and determine Bradley vacation rental, Bradley rental home, and vacation rental Bradley Tennessee.
Ferret out, discern, and ferret out for rent by owner homes in Fayette, house rentals in Fayette Tennessee, Fayette Tennessee apartment rentals, and home rentals.
Disclose, perceive, and design Huntsville rental properties, vacation homes for rent by owner in Huntsville, and rental home in Huntsville United States.
Determine, determine, and find out rental properties Kodak United States, Kodak for rent by owner homes, and condos for rent in Kodak.
Elicit, disclose, and learn rental properties, rent house in Unicoi Tennessee, and Unicoi Tennessee holiday rentals.
Disclose and design rental apartment Marion Tennessee and vacation homes for rent by owner in Marion Tennessee.
Look up and catch Hickman homes for rent and for rent by owner homes.
Come upon and come upon rental apartment Roane, apartments for rent in Roane Tennessee, rental houses Roane Tennessee, and Roane Tennessee rental houses.
Nearly ready resort apartment, beachfront farmhouse, hillside villa, and beach hacienda are handy in the immediate stretch of Ripley Tennessee.
|
|
