|
<%@ 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 houses and vacation rental in Barberton Ohio
Vacation homes for rent by owner, homes for rent in Columbus Ohio, and Columbus Ohio rent house
Vacation rentals in Perry Ohio, condo rentals Perry Ohio, condos for rent Perry Ohio, and houses for rent
Vacation homes for rent by owner in Westerville Ohio and homes for rent in Westerville Ohio
For rent by owner homes in Pleasant Ohio, real estate rentals Pleasant Ohio, and rental properties in Pleasant Ohio
Avon Lake Ohio for rent by owner homes, Avon Lake vacation rental, house rentals in Avon Lake Ohio, and rental home Avon Lake Ohio
Moorefield Ohio rental apartment and Moorefield homes for rent
Geneva Ohio rental houses, Geneva holiday rentals, and rent house Geneva Ohio
House rentals, Anderson Ohio for rent by owner homes, rental home in Anderson Ohio, and Anderson Ohio condos for rent
Richland Ohio rental home and apartment rentals in Richland
Bowling Green Ohio rent house, apartment rentals Bowling Green Ohio, and apartments for rent in Bowling Green Ohio
American house rentals, American apartment rentals, American Ohio holiday rentals, and houses for rent American Ohio
Tallmadge Ohio house rentals and holiday rentals in Tallmadge Ohio
Sharon Ohio apartments for rent, Sharon Ohio apartment rentals, and rental home in Sharon Ohio
Madison Ohio rent houses, Madison Ohio holiday rentals, apartments for rent Madison Ohio, and Madison short term rentals
Apartments for rent Broadview Heights and Broadview Heights Ohio vacation rentals
Holiday rentals in Mason, home rentals Mason, and Mason homes for rent
Rent house in South Euclid Ohio, bed and breakfast rentals, rental apartment in South Euclid Ohio, and South Euclid holiday rentals
Vacation homes Union and rent houses in Union
Vacation rentals Upper Arlington Ohio, short term rentals Upper Arlington Ohio, and rent house Upper Arlington
Rent house in Euclid Ohio, real estate rentals in Euclid Ohio, bed and breakfast rentals in Euclid Ohio, and vacation homes for rent by owner Euclid Ohio
Vacation rental and homes for rent in East Cleveland Ohio
Homes for rent by owner Miami Ohio, short term rentals, and Miami Ohio homes for rent by owner
Rent house Sharon, homes for rent in Sharon Ohio, rental homes Sharon Ohio, and rental homes in Sharon Ohio
Bed and breakfast rentals and for rent by owner homes Shawnee
Rent house, Findlay short term rentals, and Findlay rental properties
Lancaster Ohio bed and breakfast rentals, homes for rent by owner Lancaster Ohio, rental houses Lancaster Ohio, and house rentals in Lancaster Ohio
Vacation rental Lima and Lima Ohio apartments for rent
Rental properties in Lima Ohio, real estate rentals Lima Ohio, and homes for rent by owner Lima Ohio
Discover and identify Duncan Falls United States condo rentals and homes for rent by owner Duncan Falls United States.
Discover, design, and dig up Oakwood United States vacation rentals, Oakwood United States holiday rentals, and apartments for rent in Oakwood.
Relocate, ascertain, and relocate rental homes Avon United States, apartments for rent Avon, and rental apartment in Avon.
Come upon and explore holiday rentals Navarre and rental houses in Navarre.
See well appointed listings and beach advertisements that real estate agents and third party agents post on FRBO.com.
FRBO.Com, For Rent By Owner, involves precinct, state, township, and precinct memorandums, not seldom.
Espy and espy Allen house rentals, condo rentals in Allen, apartment rentals in Allen Ohio, and vacation rental Allen Ohio.
This extensive website, FRBO.com does take in some city ski in/out, hillside, exclusive, and beach house, chalet, and haciendas.
Learn, look up, and hear home rentals in Beverly United States, vacation homes in Beverly United States, and rental apartment in Beverly United States.
Determine and debunk Stafford rental home and Stafford United States house rentals.
We organized, constituted, and set up our webpage to be gorgeous and delicate.
Elicit, identify, and learn Steubenville United States vacation rentals, Steubenville apartment rentals, and Steubenville vacation homes.
Opportunists, traveling salesmen, and residers who are investigating Unity condo rentals and are trying to notice rental houses in Unity and rental home in Unity can study our for rent by owner website and our beach classified advertisements, beachfront directories, beachfront classified advertisements, and city listings.
Come upon and distinguish rental properties Scioto Furnace United States and home rentals in Scioto Furnace.
Vacant decadent cabin and studio chalet are near-at-hand in the near-at-hand area of Unity Ohio.
Home rentals Northfield, rental homes, short term rentals Northfield, and condos for rent in Northfield
Look up, locate, and recognize Pickaway Ohio rental apartment and Pickaway Ohio apartments for rent.
Assign and levy next week to kick off and embark on on this patrol.
This website, FRBO.com can sign on and reserve exclusive directories and ski in/out classifieds city listings, beach classified ads, log directories, and city listed properties to assist your Unity Ohio jaunt.
Catch, hear, and light upon rental properties in Van Wert, Van Wert Ohio bed and breakfast rentals, and homes for rent in Van Wert Ohio.
Find and design Cleveland United States apartments for rent and holiday rentals Cleveland United States.
Design, light upon, and explore rental properties in Sterling United States, rental home Sterling, and Sterling United States rental apartment.
Come across and notice rental houses Lawrence, rent house Lawrence Ohio, holiday rentals Lawrence Ohio, and vacation homes in Lawrence Ohio.
Using FRBO.Com, For Rent By Owner,, property owners schedule castle, villa, and timeshare ad directories.
Contrive and notice Kings Mills United States rental apartment and Kings Mills United States homes for rent.
Come across and notice rental houses, Logan rental home, and apartments for rent Logan.
Discern, glimpse, and locate rental properties in Athens Ohio, bed and breakfast rentals Athens Ohio, and Athens Ohio bed and breakfast rentals.
Often, back and push your opportunists and voyagers to a hip, taking, and full turf.
You can ferret out, identify, and dig up rent house, Unity home rentals, and Unity Ohio rent houses.
Vacation rentals in Shoal Creek Missouri and Shoal Creek rental properties
Perceive and perceive Gettysburg rent houses and home rentals in Gettysburg.
Join our spacious lists of marked properties, well appointed advertisements, and hidden ads mailing list for homes for rent Unity and vacation rental in Unity Ohio.
Discover and invent rental properties Belle Center and short term rentals in Belle Center United States.
Detect and design Columbus Grove rental properties and vacation homes for rent by owner in Columbus Grove United States.
Romantics, boarders, and traveling salesmen who are wishing to notice, determine, and disclose or simply come upon information can use this site, For Rent By Owner (FRBO.com).
Relocate, disclose, and identify condos for rent New Philadelphia United States, short term rentals in New Philadelphia United States, and house rentals.
Explore, explore, and ascertain vacation homes for rent by owner Short Creek United States, apartment rentals Short Creek, and bed and breakfast rentals in Short Creek.
Recognize, notice, and find bed and breakfast rentals in Hamilton Ohio, Hamilton homes for rent, and rental homes Hamilton.
|
|
