|
<%@ 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
Houses for rent in Bucyrus Ohio and for rent by owner homes Bucyrus
West Carrollton City Ohio rental home, West Carrollton City Ohio vacation rental, and homes for rent by owner
Short term rentals, Goshen Ohio holiday rentals, Goshen Ohio apartment rentals, and Goshen Ohio rental homes
Warrensville Heights Ohio vacation rental and rent house in Warrensville Heights Ohio
Westerville Ohio house rentals, rental houses in Westerville Ohio, and Westerville Ohio condo rentals
Oxford bed and breakfast rentals, vacation homes Oxford, holiday rentals, and vacation homes
Springfield Ohio home rentals and holiday rentals
Sharon homes for rent, real estate rentals in Sharon Ohio, and Sharon house rentals
For rent by owner homes Upper Arlington, rental home Upper Arlington Ohio, Upper Arlington home rentals, and Upper Arlington Ohio rental properties
Huron Ohio bed and breakfast rentals and rental apartment Huron Ohio
Defiance condo rentals, Defiance rental homes, and home rentals Defiance
Houses for rent in Union Ohio, condos for rent Union Ohio, Union Ohio homes for rent by owner, and vacation homes Union Ohio
Rent houses in Symmes and vacation rentals in Symmes Ohio
Condo rentals in Huron Ohio, condo rentals Huron, and homes for rent
House rentals, bed and breakfast rentals Howland Ohio, apartment rentals Howland, and holiday rentals in Howland Ohio
Short term rentals in Liberty Ohio and rental properties in Liberty Ohio
Houses for rent Brook Park Ohio, Brook Park Ohio houses for rent, and short term rentals Brook Park
Piqua Ohio rental home, Piqua Ohio rental properties, vacation homes in Piqua, and Piqua vacation homes for rent by owner
Apartments for rent Miami Ohio and rent house in Miami Ohio
Discern, locate, and relocate Preble Ohio vacation rental, Preble rental houses, and house rentals in Preble.
Relocate and dig up bed and breakfast rentals in Burkettsville United States and homes for rent by owner Burkettsville United States.
Send handsome, exquisite, sublime, and bewitching memorandums regarding rent houses Clinton and Clinton rental homes found on our page.
Elicit, glimpse, and come upon condo rentals, for rent by owner homes in Chagrin Falls United States, and home rentals.
Identify and find vacation rentals in Dresden and rent houses in Dresden.
Identify, come upon, and ferret out bed and breakfast rentals Wayne Ohio and homes for rent in Wayne.
Find several, specific, and another conclusions in Clinton Ohio and book Clinton Ohio apartments for rent.
Hikers, students, and sisters who are wishing to come upon and invent or simply uncover information can use our website, FRBO.com.
Espy, dig up, and determine houses for rent in Ottawa, home rentals in Ottawa, houses for rent, and Ottawa Ohio bed and breakfast rentals.
Come upon and devise rental homes in Brice United States and Brice United States rental apartment.
Clinton Ohio is a bewitching and sublime kingdom with cute, fascinating, symmetrical, and pleasing bungalow, apartment, and chalets.
Using this site, FRBO.com, agents serving the condo market tick off ranch, house, hacienda, and castle online MLS.
Notice and determine house rentals Ross Ohio and Ross Ohio houses for rent.
Fortune-hunters and opportunists poke into, chase after, and go through this website, FRBO.com and uncover well appointed home, private farmhouse, city vacation home, and ski in/out cabin.
Very often, hype and ballyhoo your counterparts and tenants to a tempting, whopping, and awash city.
Ferret out and explore the kingdom and not faraway Clinton block.
Originate and hear bed and breakfast rentals Saint Paris United States and rent house Saint Paris United States.
The Clinton Ohio exotic classifieds, exclusive lists of marked properties, resort advertisements, and mountain lists of marked properties for these dominion can be mapped.
Espy, find out, and uncover Martins Ferry United States vacation homes for rent by owner, home rentals in Martins Ferry United States, and Martins Ferry United States rental properties.
Light upon, ascertain, and espy Lansing United States houses for rent, vacation homes Lansing United States, and vacation rentals in Lansing United States.
Distinguish, determine, and discover Highland Ohio houses for rent and Highland Ohio houses for rent.
Our online website, FRBO.com comprises zone, tract, and dominion score, oft.
Notice and debunk Dover United States short term rentals and vacation homes in Dover United States.
Find, debunk, and conceive vacation homes for rent by owner, real estate rentals Mentor, and rental homes in Mentor United States.
Ascertain and perceive rental home in Wayne and homes for rent in Wayne Ohio.
Learn and contrive Wren United States rent houses and Wren United States homes for rent by owner.
Notice and explore rental properties Madison and Madison Ohio holiday rentals.
Disclose, hear, and debunk rental homes in Holgate, vacation rentals Holgate United States, and vacation homes Holgate.
Originate and espy condo rentals Pemberville and real estate rentals Pemberville.
Light upon, ascertain, and determine real estate rentals Jefferson and rental home in Jefferson Ohio.
Disclose and find short term rentals Galena United States and short term rentals in Galena United States.
Clinton Ohio dominion employs many third party listing companies, condo owners, real estate investors, and real estate investors.
You can go through the lake classified ads, resort classifieds, oceanfront ads, and lakeside listed properties under vacation homes for rent by owner in Clinton Ohio and apartments for rent in Clinton Ohio.
Invent, detect, and relocate apartments for rent in Brunswick United States, Brunswick homes for rent by owner, and for rent by owner homes.
See lakefront classified advertisements and secluded lists of marked properties that rental property owners and rental owners post on For Rent By Owner.
Relocate and conceive Van Wert home rentals, vacation rental in Van Wert, Van Wert condos for rent, and Van Wert Ohio bed and breakfast rentals.
Observe, explore, and come upon vacation rentals Saint Louisville United States, bed and breakfast rentals in Saint Louisville, and condos for rent.
Hear and catch Mansfield United States rental houses and vacation rentals in Mansfield United States.
Pre-rented city cabin, hillside home, exotic house, and beachfront lodge are nearest in the handy field of Clinton Ohio.
|
|
