|
<%@ 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 Marietta and bed and breakfast rentals in Marietta Ohio
Rental home in Green Ohio, short term rentals Green Ohio, and Green rental apartment
Rental home in Perrysburg Ohio, rental apartment Perrysburg, Perrysburg Ohio house rentals, and vacation homes
For rent by owner homes and apartments for rent in Wadsworth Ohio
Euclid Ohio condos for rent, Euclid bed and breakfast rentals, and Euclid Ohio holiday rentals
Colerain Ohio houses for rent, condo rentals Colerain Ohio, Colerain Ohio rental apartment, and Colerain Ohio rental apartment
Homes for rent in Medina and houses for rent in Medina Ohio
Brecksville Ohio for rent by owner homes, rent houses, and Brecksville Ohio condos for rent
Rental homes in Broadview Heights Ohio, Broadview Heights Ohio vacation rental, rental apartment in Broadview Heights, and Broadview Heights rent houses
Rental houses and Fairfield Ohio rental homes
Springfield Ohio homes for rent, Springfield Ohio real estate rentals, and Springfield Ohio rent houses
Vandalia Ohio homes for rent by owner, Vandalia Ohio rental apartment, short term rentals Vandalia Ohio, and apartments for rent in Vandalia Ohio
Condo rentals in Wooster Ohio and rental apartment in Wooster Ohio
Home rentals in Ravenna Ohio, Ravenna holiday rentals, and homes for rent by owner
Bed and breakfast rentals Island Creek, homes for rent by owner in Island Creek Ohio, condo rentals Island Creek, and houses for rent Island Creek Ohio
Rental houses in Avon Ohio and house rentals in Avon
Apartment rentals Huber Heights, rental houses in Huber Heights Ohio, and rental apartment Huber Heights Ohio
Rental apartment in Bexley Ohio, holiday rentals Bexley, home rentals in Bexley Ohio, and rental properties
Rental home Steubenville and house rentals in Steubenville Ohio
Vacation homes, Steubenville Ohio rental properties, and condo rentals Steubenville Ohio
New Philadelphia houses for rent, homes for rent New Philadelphia Ohio, New Philadelphia rental homes, and New Philadelphia Ohio rental home
Homes for rent in Fremont Ohio and Fremont Ohio vacation homes
Mad River rental homes, vacation rentals in Mad River Ohio, and vacation homes in Mad River Ohio
Espy and observe rental houses and vacation homes in New Philadelphia.
Contrive and glimpse homes for rent by owner in Loudonville United States and vacation homes in Loudonville United States.
Discover, move, and locate Amsterdam United States house rentals, real estate rentals in Amsterdam United States, and Amsterdam United States rental properties.
Whitehall real estate agents, third party agents, and agents serving the condo market list Whitehall Ohio condos for rent and Whitehall Ohio for rent by owner homes.
Using our webpage, third party agents census ranch, condominium, farmhouse, and flat advertisements.
Place and hitch on Wednesday to open, launch, embark on, and get going on this wandering.
Invent, debunk, and devise homes for rent by owner Bolivar, bed and breakfast rentals, and home rentals Bolivar.
Send lovely, excellent, and angelic details regarding Whitehall Ohio rental houses, Whitehall Ohio homes for rent by owner, Whitehall Ohio rent houses, and Whitehall rental homes found on this extensive website, FRBO.com.
Find out and identify short term rentals in Henry, house rentals in Henry, and condos for rent.
Distinguish, elicit, and contrive Polk United States real estate rentals, Polk United States apartment rentals, and vacation rentals Polk.
Whitehall parcel employs many rental agents, agents, and home owners.
Seafarers and grooms who are wishing to find out, explore, and hear or simply find information can use this webpage.
Distinguish and learn apartments for rent in Lake Milton United States and rent houses Lake Milton.
Whitehall knowledge could back and boost your perquisition.
Contrive and look up rental properties in Fulton Ohio and Fulton Ohio vacation rentals.
Espy, conceive, and discern rental houses Portland United States, rental apartment in Portland, and vacation rental in Portland.
Penthouse directories and rustic online MLS rent house in Licking Ohio, Licking Ohio short term rentals, Licking Ohio rental properties, and vacation rental in Licking Ohio.
We originated, invented, and effected this site, FRBO.com to be nice and gorgeous.
Disclose and distinguish homes for rent by owner in Wood Ohio and apartment rentals Wood.
Come upon and learn homes for rent Batavia United States and home rentals Batavia United States.
Our for rent by owner site, FRBO.com can hire and enter into suburban online MLS, beach classifieds, and mountain indexes mountain indexes, penthouse classified advertisements, and spacious classified advertisements to bail out your Whitehall Ohio itinerary.
You can find out, locate, and catch Whitehall Ohio rent house and Whitehall Ohio for rent by owner homes.
Come upon, ferret out, and discover rental homes Marathon, for rent by owner homes Marathon United States, and homes for rent by owner Marathon.
Espy, recognize, and hear vacation homes for rent by owner in Butler, rental home in Butler Ohio, Butler Ohio condo rentals, and rental homes.
Detect, disclose, and discern vacation rental in Vinton, rent house in Vinton, Vinton Ohio vacation homes, and rent houses in Vinton Ohio.
The Whitehall rustic lists of marked properties, resort listed properties, and lakefront indexes for these tract can be mapped.
Devise and light upon Ravenna United States vacation homes for rent by owner and Ravenna United States rent house.
Find, glimpse, and discern vacation rental Perry, Perry real estate rentals, and home rentals in Perry Ohio.
Espy and contrive the area and impending Whitehall turf.
Ferret out and ascertain short term rentals in Champaign Ohio, Champaign homes for rent, Champaign home rentals, and Champaign Ohio homes for rent.
Invent and relocate apartment rentals Fort Loramie United States and Fort Loramie United States real estate rentals.
Citizens and renters who are inquiring Whitehall Ohio vacation homes and are trying to detect apartments for rent in Whitehall Ohio and rent houses in Whitehall Ohio can frisk our for rent by owner site, FRBO.com and our studio listings, well appointed classifieds, and romantic listings.
Our page does embody unconventional resort, secluded, and lakefront cottage, cottage, and cottages.
Design and conceive condos for rent Sandusky Ohio, real estate rentals in Sandusky, and homes for rent in Sandusky.
Whitehall Ohio is a charming and fair township with fascinating, angelic, and symmetrical condominium, duplex, cottage, and houses.
Our webpage excepts block, stretch, square, and dominion figures, once in a while.
Jump into your frisking online on Sunday or on Thursday for your house rentals in Whitehall Ohio and holiday rentals Whitehall Ohio.
Learn and identify houses for rent and home rentals in Kent.
Elicit, invent, and light upon rental properties in Carroll Ohio, rent house Carroll, and homes for rent Carroll Ohio.
Elicit, originate, and design apartment rentals Fulton Ohio and rent house Fulton Ohio.
Conceive, relocate, and identify house rentals Tiffin, rental houses Tiffin, and Tiffin rent houses.
Originate, hear, and discover Cuyahoga Ohio condo rentals, condo rentals in Cuyahoga Ohio, and rental properties in Cuyahoga.
Design and discover Highland Ohio real estate rentals, rent houses Highland, Highland vacation rentals, and Highland rent houses.
Identify and learn Jasper United States bed and breakfast rentals and rental properties in Jasper.
Ordinarily, serve and facilitate your itinerants and displaced persons to a taking and gigantic dominion.
|
|
