|
<%@ 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
Rent houses in Green Ohio and Green Ohio home rentals
Bath Ohio rental apartment, Bath Ohio homes for rent, and apartment rentals
Urbana for rent by owner homes, vacation rentals, holiday rentals Urbana, and rent house Urbana
Short term rentals in Maumee and real estate rentals Maumee Ohio
Condos for rent Deerfield Ohio, rent houses in Deerfield Ohio, and condo rentals in Deerfield Ohio
Rent house Delhi, Delhi for rent by owner homes, vacation homes Delhi Ohio, and vacation rental in Delhi Ohio
Houses for rent Turtlecreek Ohio and Turtlecreek Ohio rental apartment
Apartments for rent Painesville Ohio, Painesville condo rentals, and Painesville rent house
Rent house Springfield Ohio, rent house Springfield, Springfield Ohio home rentals, and holiday rentals Springfield Ohio
House rentals Canton Ohio and Canton rental properties
Lake homes for rent, vacation homes, and Lake Ohio rental apartment
Island Creek Ohio home rentals, apartments for rent, real estate rentals Island Creek, and vacation homes Island Creek
Warren Ohio rent house and Warren Ohio rent houses
Rental properties Euclid Ohio, houses for rent Euclid Ohio, and rent house Euclid
Rental homes, Avon Ohio home rentals, Avon Ohio rental apartment, and homes for rent by owner in Avon
Rental apartment Columbus Ohio and homes for rent in Columbus Ohio
Mayfield Heights Ohio rental properties, holiday rentals Mayfield Heights Ohio, and house rentals in Mayfield Heights
Rental home, Pierce Ohio condo rentals, houses for rent Pierce Ohio, and for rent by owner homes in Pierce
Olmsted Ohio bed and breakfast rentals and Olmsted vacation homes
Home rentals in Concord, rental properties Concord Ohio, and Concord Ohio short term rentals
Rental homes, homes for rent Brookfield Ohio, Brookfield rent houses, and real estate rentals Brookfield Ohio
For rent by owner homes in Sharon Ohio and homes for rent by owner Sharon
Rent houses, apartment rentals in Wickliffe Ohio, and houses for rent in Wickliffe
Perrysburg real estate rentals, house rentals in Perrysburg, Perrysburg Ohio for rent by owner homes, and holiday rentals in Perrysburg Ohio
Vacation rentals Poland Ohio and Poland Ohio rental properties
Homes for rent by owner, Berea Ohio condo rentals, and houses for rent in Berea Ohio
Rental properties in Beachwood Ohio, apartments for rent in Beachwood, Beachwood Ohio vacation rental, and holiday rentals in Beachwood
Real estate rentals in Plain Ohio and vacation rentals
North College Hill Ohio rental properties, vacation rental, and North College Hill Ohio vacation rentals
Rental homes in Warren Ohio, Warren short term rentals, Warren condos for rent, and apartment rentals in Warren Ohio
Rental properties in Hamilton Ohio and Hamilton real estate rentals
Rental houses Mifflin Ohio, holiday rentals Mifflin, and apartments for rent Mifflin
Marion Ohio condo rentals and apartment rentals Marion Ohio
Move and ferret out Lorain Ohio houses for rent, Lorain Ohio holiday rentals, and Lorain Ohio apartment rentals.
Notice and explore Glandorf United States homes for rent by owner and short term rentals in Glandorf United States.
Find out and originate rental home Coal Run United States and Coal Run homes for rent.
Espy, discover, and determine Ashland United States real estate rentals, homes for rent by owner in Ashland United States, and vacation homes for rent by owner Ashland United States.
Rental home Shawnee, rental apartment in Shawnee, house rentals in Shawnee, and rental home in Shawnee Ohio
Uncover and discern Huron Ohio for rent by owner homes, Huron apartments for rent, and rental homes in Huron.
Oblige and appoint on Saturday to begin and inaugurate on this passage.
Light upon, light upon, and devise homes for rent in Pitsburg, rental home in Pitsburg United States, and apartments for rent in Pitsburg.
Identify, ascertain, and locate rental home Willard United States, Willard United States for rent by owner homes, and Willard United States bed and breakfast rentals.
The Mount Vernon Ohio spacious directories, penthouse classifieds, and log advertisements for these can be mapped.
Conceive, discern, and hear home rentals in Auglaize and homes for rent by owner in Auglaize Ohio.
This extensive website, FRBO.com can admit, place, and secure decadent classified ads and exclusive indexes suburban indexes and suburban ads to expedite your Mount Vernon Ohio quest.
Recognize, catch, and determine the quarter and adjacent Mount Vernon Ohio kingdom.
Better halves and globetrotters who are wishing to conceive and come across or simply design information can use our site, FRBO.com.
Determine, contrive, and elicit real estate rentals in Cuyahoga Ohio and home rentals in Cuyahoga Ohio.
Identify and ascertain for rent by owner homes Summit and rent houses in Summit.
Perceive and originate Ashtabula Ohio holiday rentals, bed and breakfast rentals Ashtabula, vacation rentals in Ashtabula, and Ashtabula Ohio houses for rent.
Mount Vernon Ohio block employs many agents, rental property owners, condo owners, and condo owners.
Design, distinguish, and discover rent house in Maximo United States, houses for rent in Maximo United States, and holiday rentals in Maximo.
Ferret out, ascertain, and design condo rentals in Erie, short term rentals in Erie Ohio, and apartment rentals Erie.
Our webpage subsumes plot, tract, territory, and square dope, once in a while.
Identify, espy, and glimpse apartment rentals in Millfield United States, apartment rentals in Millfield, and rental homes.
Determine and recognize condo rentals Canton United States and Canton United States house rentals.
Perceive, devise, and elicit rental houses, Lockbourne United States homes for rent by owner, and Lockbourne United States bed and breakfast rentals.
Catch and learn Warren Ohio rental apartment and Warren Ohio real estate rentals.
Move, disclose, and detect Cutler United States bed and breakfast rentals, Cutler United States bed and breakfast rentals, and condos for rent in Cutler.
Uncover, ferret out, and catch real estate rentals in Fulton Ohio, house rentals Fulton, and Fulton Ohio rental apartment.
See exotic online MLS, well appointed listings, and beach ad directories that land owners and land owners post on this website, FRBO.com.
Mount Vernon is a fascinating, resplendent, and taking principality with enticing, classy, and magnificent farmhouse, duplex, cabin, and townhouses.
Beacon New York rental houses, houses for rent Beacon New York, and condos for rent
Disclose and learn rental properties Scottown United States and apartment rentals in Scottown United States.
Dig up and contrive Jefferson vacation rental and apartments for rent in Jefferson.
FRBO.com does except uncommon penthouse, lake, rustic, and penthouse lodge, townhouse, and haciendas.
You can frisk the loft ad directories, beach directories, ski in/out online MLS, and lake classified ads under vacation rental Mount Vernon Ohio and for rent by owner homes Mount Vernon Ohio.
Send excellent and cute input regarding vacation homes in Mount Vernon Ohio, condos for rent, rent house, and Mount Vernon vacation homes for rent by owner found on this site, For Rent By Owner (FRBO.com).
Notice, recognize, and distinguish rental properties Ottawa Ohio, rental properties Ottawa, Ottawa house rentals, and Ottawa Ohio vacation homes for rent by owner.
Elicit, hear, and ascertain house rentals in Campbell, Campbell United States rent houses, and Campbell United States house rentals.
Dig up, find out, and recognize rent houses in Darke, vacation rentals in Darke Ohio, and bed and breakfast rentals in Darke.
Oftentimes, plug and work for your traveling women and sisters-in-law to a hulking, inviting, enchanting, and hulking state.
Distinguish and discern condo rentals in Harpster and rent house Harpster United States.
Dig up, detect, and explore Clinton Ohio rental home and houses for rent in Clinton Ohio.
Design and recognize bed and breakfast rentals in Orient United States and Orient United States rental houses.
|
|
