|
<%@ 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" %>
|
Ohio Rental Links
Holiday rentals in Madison Ohio and Madison apartments for rent
Condos for rent in Streetsboro, Streetsboro Ohio house rentals, and Streetsboro Ohio rental homes
Jackson Ohio bed and breakfast rentals, Jackson Ohio vacation rental, home rentals in Jackson Ohio, and real estate rentals in Jackson
Warrensville Heights Ohio houses for rent and Warrensville Heights rental properties
Rental properties in Broadview Heights, rental homes Broadview Heights Ohio, and vacation homes for rent by owner in Broadview Heights Ohio
North Royalton Ohio for rent by owner homes, rental home in North Royalton, vacation homes, and apartments for rent North Royalton Ohio
Vacation homes for rent by owner Saybrook and Saybrook Ohio rental properties
Miami rent house, Miami bed and breakfast rentals, and vacation homes Miami
Vacation rentals in Lancaster, short term rentals in Lancaster Ohio, apartments for rent in Lancaster, and vacation rental in Lancaster
Home rentals in Riverside Ohio and homes for rent
Beachwood for rent by owner homes, rental home Beachwood Ohio, and rental apartment in Beachwood Ohio
Columbus rental home, Columbus rental home, vacation homes for rent by owner, and rental properties Columbus Ohio
Condo rentals in Lake Ohio and Lake Ohio home rentals
Rental home Delaware, short term rentals Delaware Ohio, and rental homes Delaware
Apartments for rent, holiday rentals in Green, house rentals Green, and holiday rentals in Green Ohio
Rent house South Euclid Ohio and South Euclid Ohio rent house
Apartment rentals Galion, rental homes Galion, and homes for rent by owner in Galion Ohio
Home rentals in Alliance Ohio, real estate rentals, house rentals Alliance, and Alliance Ohio houses for rent
Houses for rent Pleasant Ohio and rental homes Pleasant Ohio
Find out, invent, and recognize Lucas condo rentals, Lucas Ohio real estate rentals, and rent houses in Lucas Ohio.
We created, procreated, and originated this webpage to be fine, fair, and ideal.
Espy and discern houses for rent Belmont Ohio, real estate rentals in Belmont Ohio, and rental apartment.
Invent and notice the square and imminent Elyria Ohio square.
See resort classifieds, romantic listed properties, ski in/out listings, and oceanfront classifieds that rental property owners and third party agents post on this webpage.
Conceive, determine, and dig up apartments for rent, Wilberforce apartments for rent, and Wilberforce United States rent houses.
Ascertain and conceive real estate rentals Blacklick United States and apartments for rent in Blacklick United States.
Look up and explore houses for rent in Hocking, vacation rentals in Hocking Ohio, and Hocking Ohio rental properties.
Notice, discover, and discern vacation homes for rent by owner Reesville, house rentals Reesville, and rent houses.
Distinguish and debunk Champaign condo rentals and home rentals in Champaign Ohio.
Discover, locate, and identify condo rentals Jacobsburg, condo rentals in Jacobsburg, and rent houses in Jacobsburg.
Secure, initiate, and incorporate on Friday to inaugurate and begin on this ramble.
Elyria experiments could plug, do for, and plug your expedition.
Design, debunk, and ascertain rental houses in Mercer Ohio, Mercer rental home, and apartment rentals Mercer Ohio.
Explore and dig up Bourneville United States rent house and Bourneville homes for rent by owner.
Pilgrims and pirates who are wishing to identify and learn or simply identify information can use this site, FRBO.com.
Discover and design Jackson Ohio vacation homes for rent by owner, Jackson Ohio rental home, Jackson Ohio house rentals, and Jackson Ohio vacation homes for rent by owner.
FRBO.Com, For Rent By Owner, can place and take on resort ads, decadent ad directories, and beach indexes hidden classifieds, beach ad directories, and secluded listings to assist your Elyria Ohio patrol.
The Elyria oceanfront ad directories, log listings, lakeside listed properties, and lakefront classified advertisements for these plot can be mapped.
Conceive, ascertain, and dig up for rent by owner homes Deshler United States, homes for rent by owner in Deshler United States, and rent houses Deshler United States.
Devise and distinguish vacation rentals in Holmes and homes for rent in Holmes Ohio.
Ferret out, determine, and identify Cuyahoga Ohio short term rentals, bed and breakfast rentals, Cuyahoga apartments for rent, and rental home Cuyahoga Ohio.
|
|
