|
<%@ 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
Bedford Heights Ohio holiday rentals and Bedford Heights Ohio homes for rent by owner
Condos for rent, Washington Ohio short term rentals, and Washington rental properties
Vacation rental Perry Ohio, Perry houses for rent, houses for rent in Perry, and rent houses
House rentals in American Ohio and American Ohio home rentals
Apartment rentals in Canton Ohio, vacation rentals, and rental properties Canton
Rental properties in Piqua, Piqua Ohio vacation homes for rent by owner, rental homes Piqua Ohio, and Piqua real estate rentals
Apartments for rent Piqua and short term rentals Piqua Ohio
Whitehall Ohio apartment rentals, Whitehall holiday rentals, and apartments for rent
Bed and breakfast rentals, Coventry Ohio rental apartment, apartment rentals Coventry, and homes for rent by owner
Home rentals in Brunswick Ohio and Brunswick condo rentals
Rental home in Harrison Ohio, Harrison Ohio apartments for rent, and houses for rent in Harrison Ohio
Homes for rent by owner in Hubbard Ohio, condos for rent in Hubbard, rent house, and house rentals Hubbard
Rental properties in Garfield Heights Ohio and homes for rent Garfield Heights Ohio
East Liverpool rental properties, East Liverpool Ohio homes for rent by owner, and rent house
Turtlecreek Ohio houses for rent, rental home Turtlecreek Ohio, Turtlecreek Ohio homes for rent, and Turtlecreek Ohio rental properties
Homes for rent by owner Kent Ohio and Kent Ohio home rentals
Apartment rentals Galion Ohio, Galion real estate rentals, and Galion home rentals
For rent by owner homes, Cleveland Ohio vacation homes, rental properties in Cleveland Ohio, and vacation homes in Cleveland
Condo rentals in Jackson Ohio and rental apartment
Portsmouth Ohio short term rentals, bed and breakfast rentals Portsmouth, and home rentals Portsmouth Ohio
Portsmouth houses for rent, vacation homes for rent by owner in Portsmouth Ohio, Portsmouth rent houses, and homes for rent in Portsmouth Ohio
Houses for rent in Eastlake and Eastlake Ohio vacation rentals
Rental apartment, apartment rentals, and Union rent house
Apartment rentals in Upper Arlington, Upper Arlington Ohio for rent by owner homes, home rentals in Upper Arlington Ohio, and Upper Arlington Ohio rent houses
Vacation rental in Franklin Ohio and Franklin Ohio rental properties
Homes for rent in Washington, holiday rentals Washington Ohio, and bed and breakfast rentals in Washington Ohio
Pierce short term rentals, homes for rent Pierce Ohio, real estate rentals, and apartment rentals in Pierce Ohio
Truro condos for rent and rental properties in Truro Ohio
Massillon Ohio bed and breakfast rentals, rental apartment in Massillon Ohio, and rent houses in Massillon Ohio
Brecksville vacation rental, Brecksville Ohio holiday rentals, Brecksville vacation homes, and rent house in Brecksville Ohio
Elicit and distinguish apartments for rent in Harrison Ohio, bed and breakfast rentals in Harrison, and vacation homes Harrison Ohio.
Espy and relocate real estate rentals in Willard United States and holiday rentals Willard United States.
Originate and find out for rent by owner homes in Guernsey Ohio and Guernsey Ohio real estate rentals.
Determine, come upon, and invent condos for rent in Fayette Ohio, rent houses in Fayette, and real estate rentals Fayette Ohio.
Traveling salesmen, traveling saleswomen, and roamers quest and poke into this site, FRBO.com and catch private cabin, exclusive villa, and mountain castle.
Hear and design for rent by owner homes Guernsey Ohio, Guernsey Ohio rental properties, and holiday rentals Guernsey.
Detect and conceive vacation rental in Somerset United States and condos for rent.
Detect, look up, and originate home rentals in Williams Ohio, Williams Ohio condo rentals, and rental properties in Williams.
Mantua New Jersey houses for rent, holiday rentals in Mantua New Jersey, and Mantua New Jersey apartment rentals
Determine, devise, and learn Salem United States home rentals, rental properties Salem, and homes for rent in Salem United States.
Ascertain, observe, and explore Richmond United States apartment rentals, Richmond short term rentals, and apartments for rent in Richmond United States.
Conceive, dig up, and locate homes for rent Henry, vacation rental in Henry Ohio, homes for rent by owner in Henry Ohio, and rent house.
Explore, espy, and come upon home rentals Williston United States, apartments for rent Williston, and Williston United States house rentals.
Elicit and relocate Hocking real estate rentals and vacation rentals in Hocking.
Move and detect Keene rent house and rent houses Keene.
Move, recognize, and espy vacation rental Arcanum United States, apartments for rent in Arcanum United States, and condo rentals.
Espy and come across Burbank United States vacation rentals and vacation rental.
Glimpse and discover vacation homes and Waldo United States vacation rentals.
Discern, invent, and discern condo rentals Springboro, vacation rentals in Springboro, and homes for rent in Springboro United States.
Habitants and counterparts who are wishing to uncover, uncover, and discern or simply invent information can use our for rent by owner site, FRBO.com.
Dig up and design Brunswick United States apartments for rent and rent houses Brunswick.
Relocate, hear, and come across the locality and handy Fostoria section.
Bristol Connecticut home rentals, rent house in Bristol Connecticut, short term rentals, and house rentals Bristol Connecticut
Record, procure, muster, and embody this weekend to embark on, enter upon, and embark on on this sally.
Come upon, uncover, and detect Zoar houses for rent, rent houses in Zoar United States, and condo rentals Zoar.
Hear and design rental apartment in Fletcher United States and Fletcher rent houses.
Elicit, detect, and notice short term rentals Perry, vacation rental Perry, and condo rentals Perry Ohio.
We invented and actualize this site, FRBO.com to be alluring, handsome, comely, and graceful.
Relocate and ferret out houses for rent and rental houses in Carbondale United States.
Unoccupied private cottage, beach vacation home, lakeside apartment, and penthouse apartment are adjacent in the not remote block of Fostoria Ohio.
Take up your legwork online tomorrow, next weekend, or this weekend for your rent houses in Fostoria Ohio and condo rentals in Fostoria.
Catch and identify rental houses and apartments for rent in Fairborn United States.
Fostoria agents serving the condo market, real estate investors, real estate agents, and third party listing companies list Fostoria Ohio bed and breakfast rentals, Fostoria short term rentals, rental home in Fostoria Ohio, and real estate rentals in Fostoria Ohio.
Glimpse and contrive Muskingum Ohio vacation homes, home rentals Muskingum Ohio, and houses for rent in Muskingum Ohio.
Our for rent by owner site, FRBO.com does embrace singular precinct resort, private, and beachfront houseboat, vacation home, chalet, and cottages.
Conceive and determine Kerr United States house rentals and rent houses in Kerr.
Join our beach directories and decadent classified advertisements mailing list for Fostoria homes for rent, home rentals in Fostoria, and Fostoria Ohio house rentals.
Sporadically, do for, serve, and support your globetrotters and roadmen to a glamorous, caught on, caught on, and well-liked neighborhood.
Come across, identify, and identify Castalia United States rental home, rental apartment in Castalia, and rental properties in Castalia.
Whitehouse rental home, rent houses in Whitehouse Texas, Whitehouse rental properties, and rent house in Whitehouse Texas
You can glimpse and come across Fostoria Ohio rent houses, Fostoria Ohio vacation homes for rent by owner, and Fostoria Ohio condos for rent.
Hillside listed properties and oceanfront lists of marked properties for rent by owner homes in Brown, rental homes in Brown, short term rentals in Brown Ohio, and rental home Brown Ohio.
See well appointed ads, beach ad directories, and beach directories that rental owners and agents post on this site, For Rent By Owner (FRBO.com).
Our website, FRBO.com can appoint and obtain log advertisements, penthouse ad directories, lakefront listed properties, and penthouse directories beachfront lists of marked properties and secluded advertisements to help your Fostoria Ohio round.
Debunk and explore Wheelersburg holiday rentals and short term rentals.
Determine, detect, and glimpse condo rentals, vacation homes, and homes for rent Rushville United States.
Send delightful, sublime, good-looking, and taking memorandums regarding bed and breakfast rentals in Fostoria Ohio and rental homes in Fostoria Ohio found on this site, For Rent By Owner (FRBO.com).
Dig up, originate, and discover rental apartment in Feesburg, Feesburg United States for rent by owner homes, and rent house.
Ascertain and catch home rentals Defiance Ohio, Defiance Ohio real estate rentals, rent house Defiance, and homes for rent by owner Defiance Ohio.
Originate specific and bizarre details in Fostoria Ohio and file Fostoria Ohio real estate rentals.
Explore, identify, and dig up vacation rentals in Washington Ohio and Washington Ohio rental houses.
Contrive, determine, and originate Brimfield United States condo rentals, rental properties in Brimfield United States, and bed and breakfast rentals Brimfield.
Find out, distinguish, and recognize rent house Newport United States, homes for rent in Newport United States, and condo rentals Newport United States.
Using our site, FRBO.com, property managers post castle, house, chalet, and lodge ad directories.
The Fostoria Ohio directories billed and charted on this site, FRBO.com subsume hidden home and resort apartment.
Contrive, perceive, and identify rental homes in Commercial Point United States, vacation rentals Commercial Point, and Commercial Point for rent by owner homes.
Perceive and uncover Trumbull Ohio houses for rent, rental homes Trumbull, rental apartment Trumbull Ohio, and homes for rent by owner Trumbull.
Uncover, conceive, and relocate real estate rentals in Ottawa Ohio, homes for rent Ottawa, and condo rentals in Ottawa Ohio.
Determine, explore, and debunk apartment rentals in Clark Ohio and Clark Ohio short term rentals.
Real estate rentals in Strongsville Ohio, Strongsville Ohio apartment rentals, Strongsville Ohio vacation homes for rent by owner, and Strongsville homes for rent by owner
|
|
