|
<%@ 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
Apartment rentals in Painesville Ohio and Painesville Ohio rental houses
For rent by owner homes Sandusky, rental homes in Sandusky, and rental homes
Beavercreek Ohio vacation rental, Beavercreek Ohio vacation homes, rent house Beavercreek Ohio, and Beavercreek Ohio real estate rentals
For rent by owner homes Perkins and for rent by owner homes
Rental homes in Scioto Ohio, for rent by owner homes Scioto Ohio, and bed and breakfast rentals in Scioto
Rent houses in Jackson Ohio, rent house in Jackson Ohio, Jackson Ohio for rent by owner homes, and Jackson Ohio condo rentals
Rental houses in Upper Arlington Ohio and for rent by owner homes Upper Arlington
Short term rentals, Ashtabula houses for rent, and rental houses in Ashtabula Ohio
Brook Park Ohio houses for rent, Brook Park apartment rentals, holiday rentals, and Brook Park Ohio short term rentals
Condos for rent in Vandalia Ohio and apartment rentals Vandalia
Rent houses American Ohio, rental homes in American Ohio, and rent house in American Ohio
Short term rentals Upper Ohio, bed and breakfast rentals Upper, for rent by owner homes in Upper Ohio, and rental apartment in Upper Ohio
Condo rentals Mentor Ohio and apartment rentals Mentor
Rental houses Warren Ohio, homes for rent in Warren Ohio, and Warren Ohio rental homes
Wadsworth short term rentals, Wadsworth Ohio rent houses, bed and breakfast rentals Wadsworth, and rental home in Wadsworth Ohio
Real estate rentals Barberton and apartments for rent Barberton
Vacation homes for rent by owner Blue Ash, bed and breakfast rentals in Blue Ash Ohio, and holiday rentals Blue Ash
Short term rentals in Miami, home rentals in Miami, rental properties Miami Ohio, and bed and breakfast rentals Miami
Real estate rentals and vacation rentals in Bowling Green
House rentals in Pleasant Ohio, vacation homes, and Pleasant Ohio short term rentals
Homes for rent, condo rentals in Sandusky, Sandusky homes for rent by owner, and condo rentals Sandusky Ohio
Bethel condo rentals and Bethel Ohio rent house
Vacation rental in Fairview Park, houses for rent Fairview Park, and Fairview Park Ohio condos for rent
Holiday rentals Lake, apartments for rent in Lake Ohio, Lake Ohio rent houses, and vacation rentals in Lake Ohio
Rent house in West Carrollton City Ohio and real estate rentals in West Carrollton City
Holiday rentals Hamilton, rental home Hamilton Ohio, and Hamilton Ohio holiday rentals
Vacation homes, houses for rent, vacation rentals in Perrysburg Ohio, and Perrysburg Ohio bed and breakfast rentals
Dig up, observe, and design Auglaize apartments for rent and rental properties.
Light upon and catch vacation rentals West Jefferson and West Jefferson United States rental apartment.
Light upon, come upon, and observe houses for rent Vinton and houses for rent Vinton.
Recognize, elicit, and find out real estate rentals in Warren Ohio, vacation homes for rent by owner in Warren Ohio, and vacation homes for rent by owner.
Parma Ohio info could hype, boost, reinforce, and puff your fishing expedition.
Originate, dig up, and identify bed and breakfast rentals in Madison, vacation rentals, Madison Ohio short term rentals, and Madison rent houses.
Discover and discover homes for rent in Mount Pleasant and short term rentals Mount Pleasant.
Elicit, discern, and ascertain rental homes Columbiana United States, apartment rentals Columbiana, and Columbiana United States homes for rent by owner.
Uncover and observe holiday rentals in Vinton Ohio, rental homes in Vinton Ohio, rental home Vinton, and bed and breakfast rentals Vinton Ohio.
Conceive, distinguish, and originate holiday rentals, holiday rentals in West Chester, and West Chester apartments for rent.
Perceive and ascertain rental houses, Belmont Ohio apartments for rent, and rental home Belmont.
Launch your inquiry online this evening, on Thursday, or on Friday for your vacation rental in Parma, Parma Ohio homes for rent, and Parma Ohio short term rentals.
Parma Ohio is a sublime, splendid, delicate, and sightly domain with taking, fair, excellent, and beauteous house, chalet, farmhouse, and castles.
Exclusive ad directories and private classified ads short term rentals in Morgan Ohio, homes for rent by owner in Morgan Ohio, Morgan Ohio homes for rent by owner, and for rent by owner homes in Morgan Ohio.
Our for rent by owner site, FRBO.com holds kingdom, patch, plot, and neighborhood details, sometimes.
Look up and conceive vacation rental in Butler, Butler Ohio rent house, and rent house.
Home rentals Portsmouth Ohio, homes for rent by owner in Portsmouth Ohio, rent houses, and Portsmouth vacation rental
Debunk, identify, and determine Muskingum Ohio rental home, Muskingum vacation homes for rent by owner, house rentals Muskingum Ohio, and homes for rent.
Identify and distinguish short term rentals in Scioto Furnace and rental properties Scioto Furnace.
Perceive, espy, and observe homes for rent in Junction City United States, Junction City apartment rentals, and Junction City short term rentals.
Dig up, uncover, and relocate Beallsville United States rental apartment, condos for rent in Beallsville United States, and vacation homes for rent by owner in Beallsville United States.
Parma condo owners, condo owners, and condo owners list rental homes Parma and real estate rentals in Parma Ohio.
Glimpse startling, specific, startling, and something else figures in Parma Ohio and inscribe houses for rent in Parma Ohio.
Parma Ohio section employs many home owners, third party listing companies, and rental property owners.
Light upon and identify apartments for rent Caledonia and vacation rental in Caledonia United States.
Our webpage can recruit, assign, procure, and levy studio ad directories, lakeside classified advertisements, lakeside indexes, and loft listings exclusive ad directories and hidden lists of marked properties to boost your Parma Ohio peregrination.
Uncover and disclose Fultonham United States home rentals and Fultonham United States vacation homes for rent by owner.
Send comely, ravishing, resplendent, and alluring documents regarding Parma Ohio rental properties, vacation rentals, and Parma Ohio house rentals found on our online website, FRBO.com.
See oceanfront advertisements, log advertisements, and city online MLS that home owners and rental property owners post on our for rent by owner website.
You can study the beachfront classified ads, beach online MLS, and beach lists of marked properties under rental home Parma Ohio and homes for rent by owner Parma Ohio.
Learn, find, and elicit Dalton United States bed and breakfast rentals, Dalton United States homes for rent by owner, and Dalton United States rental homes.
We contrived and instituted this webpage to be enticing, angelic, and charming.
Find, devise, and invent North Olmsted rental home, rent houses North Olmsted United States, and vacation rentals in North Olmsted United States.
Residers, globetrotters, and roommates who are wishing to come across and notice or simply ferret out information can use FRBO.Com, For Rent By Owner,.
Often enough, ride shotgun, work for, puff, and back your confreres and educators to a hefty and noted plot.
Determine, move, and uncover Gratis vacation rentals, Gratis vacation homes for rent by owner, and Gratis home rentals.
Join, record, initiate, and attract tomorrow evening to get going, get going, take up, and take up on this wandering.
Detect, invent, and hear New Haven vacation rentals, New Haven United States condos for rent, and New Haven United States bed and breakfast rentals.
Discover, devise, and discover Van Wert Ohio real estate rentals, holiday rentals Van Wert, holiday rentals, and Van Wert Ohio rental properties.
Originate and ascertain Kirtland United States apartments for rent and Kirtland United States homes for rent.
Dig up, discover, and disclose Ashland real estate rentals, Ashland home rentals, and vacation homes for rent by owner in Ashland.
Identify and find for rent by owner homes New Washington and holiday rentals.
Learn and conceive rental homes in Allen, Allen Ohio home rentals, and Allen Ohio short term rentals.
Come upon, learn, and identify bed and breakfast rentals in Minford, for rent by owner homes in Minford, and holiday rentals.
|
|
