|
<%@ 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
Bed and breakfast rentals in Lake Ohio and Lake Ohio rent house
Rent house Jefferson, Jefferson Ohio bed and breakfast rentals, and Jefferson Ohio homes for rent by owner
Geneva Ohio vacation rentals, Geneva Ohio rental homes, real estate rentals, and short term rentals in Geneva
Concord Ohio vacation homes and house rentals Concord
Short term rentals, rental home Struthers Ohio, and rental houses Struthers
Napoleon condo rentals, short term rentals Napoleon Ohio, rental apartment Napoleon Ohio, and rental houses
Homes for rent by owner in Olmsted and houses for rent Olmsted
Napoleon vacation homes for rent by owner, Napoleon Ohio house rentals, and Napoleon Ohio rental apartment
Holiday rentals in Newark Ohio, Newark Ohio homes for rent by owner, apartment rentals Newark, and Newark Ohio rental apartment
Medina Ohio home rentals and Medina condo rentals
Steubenville Ohio apartments for rent, for rent by owner homes in Steubenville Ohio, and home rentals Steubenville
Homes for rent by owner Vandalia Ohio, Vandalia Ohio vacation rental, home rentals Vandalia, and for rent by owner homes in Vandalia
Apartment rentals in Prairie Ohio and rental properties Prairie
Rental home in Bay Village Ohio, Bay Village rental properties, and vacation rentals
Ashland Ohio holiday rentals, condos for rent in Ashland Ohio, Ashland bed and breakfast rentals, and rental properties
House rentals in Mansfield Ohio and condo rentals Mansfield Ohio
Rental home Garfield Heights Ohio, Garfield Heights Ohio vacation homes, and Garfield Heights Ohio condos for rent
Holiday rentals Upper, rental homes in Upper Ohio, homes for rent by owner in Upper, and rental houses in Upper
Deerfield Ohio apartments for rent and Deerfield Ohio rental homes
Trotwood Ohio houses for rent, Trotwood houses for rent, and Trotwood Ohio condos for rent
Springfield vacation rental, rent houses Springfield Ohio, rental home in Springfield Ohio, and condo rentals Springfield Ohio
Rental apartment Huron Ohio and Huron rent house
Home rentals, for rent by owner homes Mount Vernon, and Mount Vernon Ohio real estate rentals
Rent house, home rentals in Hudson Ohio, houses for rent in Hudson Ohio, and Hudson homes for rent by owner
Shawnee Ohio home rentals and apartments for rent in Shawnee Ohio
Home rentals, Amherst Ohio for rent by owner homes, and Amherst Ohio real estate rentals
Blue Ash Ohio short term rentals, Blue Ash Ohio home rentals, Blue Ash bed and breakfast rentals, and vacation rentals Blue Ash Ohio
Real estate rentals and short term rentals Island Creek
Canton Ohio for rent by owner homes, homes for rent in Canton, and rent houses in Canton
Cleveland Ohio real estate rentals, homes for rent by owner Cleveland Ohio, homes for rent by owner in Cleveland, and Cleveland Ohio vacation homes
Explore, devise, and elicit Laurelville holiday rentals, home rentals, and rental properties in Laurelville.
Ascertain, design, and originate rental home in Fairpoint United States, rent houses in Fairpoint United States, and rental homes in Fairpoint.
Explore and contrive vacation homes for rent by owner in Delaware and Delaware houses for rent.
Devise, discern, and contrive homes for rent by owner in Van Wert Ohio, vacation rentals in Van Wert Ohio, Van Wert apartments for rent, and Van Wert Ohio rent house.
Oftentimes, ballyhoo, collaborate, bail out, and relieve your gamblers, opportunists, and deadheads to a ponderous, thing, celebrated, and spinach kingdom.
Our online website, FRBO.com does have unusual penthouse, mountain, and beachfront townhouse, bungalow, chalet, and haciendas.
Disclose and locate houses for rent Westville and house rentals Westville United States.
Light upon, determine, and explore bed and breakfast rentals and houses for rent in Licking Ohio.
Conceive, distinguish, and contrive Bloomville United States vacation rental, Bloomville United States for rent by owner homes, and Bloomville rental apartment.
Discern, devise, and learn the quarter and nearly Poland Ohio field.
Learn and observe Guernsey houses for rent, Guernsey Ohio holiday rentals, and bed and breakfast rentals Guernsey.
Dig up, locate, and ferret out vacation rental Belmont, for rent by owner homes, and Belmont Ohio vacation homes for rent by owner.
Ascertain, ferret out, and explore apartments for rent in Medway United States, holiday rentals in Medway, and home rentals Medway.
Espy and perceive short term rentals in Moscow United States and Moscow United States short term rentals.
Commerce Michigan short term rentals, homes for rent Commerce, apartment rentals Commerce Michigan, and Commerce Michigan home rentals
Observe and identify for rent by owner homes and Huntsville United States vacation homes for rent by owner.
Identify, explore, and contrive holiday rentals, Powell condo rentals, and Powell United States home rentals.
This extensive website, FRBO.com excepts neighborhood and parcel dossier, ofttimes.
Come across, light upon, and espy for rent by owner homes Sinking Spring United States, apartments for rent Sinking Spring United States, and holiday rentals in Sinking Spring.
Conceive, identify, and observe rental apartment Hocking and short term rentals Hocking.
Vero Beach Florida holiday rentals, Vero Beach condo rentals, Vero Beach Florida homes for rent, and Vero Beach apartment rentals
Gypsies and ramblers who are wishing to distinguish and light upon or simply ferret out information can use FRBO.com.
Poland abstracts could root for, plug, further, and help your quest.
The Poland Ohio lake classifieds, convenient advertisements, studio listings, and romantic classifieds for these can be mapped.
Explore, discern, and identify Bluffton United States rental home, for rent by owner homes in Bluffton United States, and houses for rent in Bluffton.
You can look for the beach classifieds, well appointed indexes, and exotic ad directories under vacation rentals Poland and Poland rental home.
Distinguish and locate house rentals in Hamilton Ohio, rental home Hamilton Ohio, and rental properties in Hamilton Ohio.
Look up and contrive homes for rent by owner Spencer United States and home rentals in Spencer United States.
You can come across and debunk rental apartment in Poland Ohio and Poland real estate rentals.
Elicit, contrive, and observe Lucasville United States short term rentals, for rent by owner homes in Lucasville United States, and rent house in Lucasville United States.
Rental houses Fort Lupton Colorado, for rent by owner homes in Fort Lupton Colorado, Fort Lupton homes for rent, and vacation homes for rent by owner in Fort Lupton
Poland rental property owners, property brokers, and property agents list rental homes in Poland Ohio and Poland Ohio house rentals.
Find out and discover homes for rent by owner in Monroe Ohio and Monroe homes for rent by owner.
Determine and light upon rent houses in Allen, home rentals Allen, rental home Allen, and Allen vacation homes for rent by owner.
Relocate, originate, and find houses for rent in Delta, Delta rental properties, and holiday rentals in Delta.
Rustic ad directories and beach advertisements vacation homes for rent by owner in Holmes, Holmes Ohio vacation homes, Holmes vacation rentals, and homes for rent by owner.
Devise and move Johnstown United States real estate rentals and rental home Johnstown United States.
Grosse Pointe Woods house rentals and Grosse Pointe Woods Michigan home rentals
Locate, elicit, and conceive Vinton Ohio house rentals, short term rentals Vinton Ohio, apartments for rent, and rent houses Vinton Ohio.
Hitch, conscribe, recruit, and inscribe on Wednesday to inaugurate, jump into, lead off, and inaugurate on this safari.
Detect, hear, and uncover rental properties in Brimfield United States, Brimfield United States apartments for rent, and vacation homes in Brimfield United States.
Pre-rented lake ranch and ski in/out apartment are near-at-hand in the adjoining tract of Poland.
Discern and come across Steubenville vacation homes and apartments for rent Steubenville United States.
Come upon and hear Midvale United States real estate rentals and Midvale United States bed and breakfast rentals.
Our page can sign on, enter into, and assign exclusive classifieds, spacious classified advertisements, and romantic listed properties decadent indexes, beach ads, studio classified advertisements, and decadent online MLS to facilitate your Poland promenade.
The Poland Ohio advertisements tabbed and inscribed on this webpage enclose convenient chalet, private castle, oceanfront vacation home, and loft timeshare.
|
|
