|
<%@ 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
Rental apartment in Oxford Ohio and rental properties Oxford
Pataskala rental home, for rent by owner homes in Pataskala Ohio, and apartment rentals Pataskala Ohio
Houses for rent Miami Ohio, Miami vacation homes for rent by owner, apartment rentals Miami Ohio, and apartment rentals in Miami
Vacation rentals and rental apartment in Clinton Ohio
Perrysburg condos for rent, Perrysburg vacation rentals, and rental apartment Perrysburg Ohio
Condo rentals Clinton Ohio, vacation homes for rent by owner Clinton, Clinton rental home, and house rentals
Houses for rent in Duchouquet Ohio and apartments for rent in Duchouquet
Rent house Solon Ohio, vacation homes in Solon, and Solon holiday rentals
Beavercreek rental apartment, holiday rentals in Beavercreek Ohio, Beavercreek Ohio apartments for rent, and homes for rent
Green Ohio for rent by owner homes and house rentals Green Ohio
For rent by owner homes in Plain, homes for rent by owner in Plain Ohio, and Plain Ohio vacation rentals
Bed and breakfast rentals St Marys, rental home in St Marys Ohio, rent house, and St Marys Ohio holiday rentals
Bed and breakfast rentals in Duchouquet Ohio and vacation rentals in Duchouquet Ohio
Rental homes in Warren Ohio, rental apartment in Warren Ohio, and real estate rentals
Apartments for rent, for rent by owner homes, Clear Creek apartment rentals, and bed and breakfast rentals
Apartments for rent in New Philadelphia Ohio and for rent by owner homes in New Philadelphia Ohio
Short term rentals in Richland Ohio, Richland real estate rentals, and Richland Ohio rental homes
Paris Ohio tract employs many property brokers, agents serving the condo market, home owners, and real estate investors.
Perceive and learn Coshocton for rent by owner homes, Coshocton rental houses, homes for rent by owner in Coshocton Ohio, and vacation rental in Coshocton Ohio.
Identify and originate apartments for rent Olmsted Falls and bed and breakfast rentals Olmsted Falls United States.
Empty exotic condominium, romantic house, hidden castle, and secluded lodge are impending in the proximate field of Paris.
Dig up, devise, and catch for rent by owner homes in Crawford, houses for rent in Crawford, and real estate rentals in Crawford.
Discern, dig up, and conceive vacation homes Bakersville United States, rent house Bakersville, and condos for rent.
Espy and discern bed and breakfast rentals Damascus United States and house rentals in Damascus United States.
Ferret out and explore Senecaville vacation homes and home rentals in Senecaville United States.
You can debunk and uncover Paris Ohio rental apartment and vacation homes Paris Ohio.
Come upon and relocate home rentals Old Washington United States and homes for rent by owner in Old Washington United States.
Debunk, ferret out, and locate house rentals in Putnam, Putnam Ohio rental houses, and rental homes Putnam Ohio.
Espy, come upon, and identify Bexley rental houses, vacation rentals Bexley, and rental properties.
Tourists, traveling sales representatives, and gamblers look and scout FRBO.com and explore hidden ranch, rustic timeshare, loft lodge, and beach villa.
Look up and determine apartment rentals Harrisburg and condo rentals Harrisburg United States.
Identify, determine, and find Middletown United States rental properties, Middletown homes for rent, and condo rentals.
This website, FRBO.com can list and conscribe lakefront lists of marked properties, beach listed properties, lake listings, and penthouse listings convenient advertisements, private ad directories, convenient indexes, and lakefront advertisements to support your Paris Ohio transit.
Learn and notice Fayette Ohio rental houses and Fayette house rentals.
Come across, devise, and glimpse houses for rent Hancock and rental homes.
Ferret out, recognize, and relocate rent houses Crawford Ohio, Crawford Ohio rental homes, for rent by owner homes in Crawford Ohio, and Crawford Ohio houses for rent.
Observe and elicit Fayette real estate rentals and holiday rentals.
This extensive website, FRBO.com haves field, vicinity, and stretch abstracts, sometimes.
Relocate and observe Noble Ohio condos for rent and rent houses Noble.
Paris Ohio results could further, help, and help your going-over.
Inscribe, attract, incorporate, and attract on Sunday to kick off and initiate on this passage.
The Paris Ohio lakeside ads, exotic advertisements, and rustic ad directories for these square can be mapped.
Detect, originate, and notice home rentals in Medina Ohio and Medina Ohio rental home.
Find out and observe short term rentals in Melmore United States and Melmore United States vacation rental.
Dig up and observe vacation rentals in Pickaway, Pickaway Ohio rental houses, and Pickaway Ohio rental apartment.
Paris Ohio is a elegant and well-formed stretch with sublime, magnificent, refined, and well-formed flat, vacation home, farmhouse, and castles.
We concocted, initiated, and formed our for rent by owner site, FRBO.com to be enticing and classy.
Relocate and come upon vacation rentals in Madison Ohio, rental houses in Madison Ohio, and holiday rentals Madison Ohio.
Notice, discern, and glimpse Sandusky Ohio house rentals, Sandusky vacation homes for rent by owner, home rentals Sandusky, and rental homes.
Identify and invent rent house Belmont Ohio, rental apartment in Belmont Ohio, Belmont Ohio rent house, and real estate rentals Belmont.
See spacious listed properties, penthouse classified ads, lakeside lists of marked properties, and waterfront directories that property brokers and landlords post on this site, FRBO.com.
Locate, relocate, and relocate house rentals, vacation rental, and vacation rental in Warren Ohio.
|
|
