|
<%@ 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 homes in Perrysburg Ohio and bed and breakfast rentals in Perrysburg
Cleveland Heights bed and breakfast rentals, rental apartment in Cleveland Heights Ohio, and Cleveland Heights Ohio rent houses
Rental home in Wickliffe, Wickliffe home rentals, Wickliffe houses for rent, and Wickliffe Ohio apartments for rent
Vacation rentals Trotwood Ohio and Trotwood Ohio rental home
Vacation homes Kent Ohio, Kent Ohio homes for rent, and rental home in Kent Ohio
Homes for rent in Green Ohio, Green Ohio condos for rent, Green bed and breakfast rentals, and real estate rentals in Green Ohio
Real estate rentals and vacation rentals
Holiday rentals in Sycamore Ohio, Sycamore house rentals, and Sycamore apartments for rent
Bed and breakfast rentals in Athens Ohio, house rentals Athens Ohio, Athens Ohio short term rentals, and Athens Ohio rent houses
Homes for rent by owner in Solon Ohio and homes for rent
Homes for rent in Seven Hills, rental homes Seven Hills, and real estate rentals in Seven Hills
Maple Heights Ohio vacation homes, homes for rent Maple Heights Ohio, vacation homes for rent by owner in Maple Heights, and Maple Heights Ohio homes for rent by owner
Delaware Ohio rental apartment and short term rentals in Delaware Ohio
For rent by owner homes, Marietta rental home, and bed and breakfast rentals Marietta Ohio
Short term rentals in Paris Ohio, Paris vacation homes, rent house, and Paris Ohio for rent by owner homes
Napoleon Ohio rental homes and homes for rent in Napoleon Ohio
For rent by owner homes in Norwalk, holiday rentals Norwalk Ohio, and Norwalk Ohio condos for rent
Rental properties in Scioto, house rentals in Scioto Ohio, rent house Scioto Ohio, and vacation rental in Scioto
Condo rentals Marietta Ohio and homes for rent by owner
Holiday rentals, Mayfield Heights houses for rent, and short term rentals
Huber Heights for rent by owner homes, rent houses in Huber Heights, Huber Heights rental apartment, and Huber Heights Ohio vacation rentals
Bay Village vacation rentals and vacation homes in Bay Village Ohio
Clear Creek Ohio apartment rentals, Clear Creek Ohio homes for rent, and Clear Creek Ohio houses for rent
Condo rentals Bexley, homes for rent by owner in Bexley, Bexley Ohio home rentals, and bed and breakfast rentals in Bexley Ohio
Vacation homes for rent by owner Seven Hills and homes for rent in Seven Hills Ohio
Condos for rent, house rentals in South Euclid, and rental properties
Vacation rental, home rentals in Caħaboncito, and Caħaboncito Puerto Rico real estate rentals
Debunk and identify condo rentals in Miami, house rentals in Miami Ohio, and homes for rent Miami.
Our website, FRBO.com can record, obtain, induct, and list studio online MLS, studio listings, private indexes, and log indexes waterfront advertisements, rustic classifieds, rustic lists of marked properties, and ski in/out online MLS to run interference your Clear Creek run.
Discover and find Morgan Ohio apartments for rent, houses for rent in Morgan Ohio, rental houses Morgan Ohio, and apartment rentals in Morgan Ohio.
Discover and come upon Allen homes for rent by owner and real estate rentals Allen.
Debunk and identify rental homes in Hillsboro United States and short term rentals in Hillsboro United States.
Disclose, dig up, and detect vacation rental in Leetonia, Leetonia real estate rentals, and Leetonia United States rent house.
Clear Creek Ohio testimony could expedite, aid, and open doors your inquest.
Clear Creek Ohio zone employs many condo owners, real estate investors, land owners, and town home owners.
Look up, ferret out, and disclose vacation rentals in New Madison United States, vacation homes for rent by owner in New Madison United States, and apartments for rent in New Madison United States.
Discover, espy, and discover Putnam Ohio vacation rentals and vacation homes for rent by owner Putnam.
Ascertain, originate, and discover for rent by owner homes in Cadiz United States, bed and breakfast rentals in Cadiz United States, and Cadiz bed and breakfast rentals.
Look up and glimpse houses for rent in Fort Recovery United States and house rentals in Fort Recovery.
Ascertain, locate, and find vacation homes Grelton, rent house in Grelton United States, and condos for rent in Grelton.
Recently available resort townhouse, exotic hacienda, and city chalet are handy in the imminent city of Clear Creek.
Glimpse and design rental properties Williams Ohio, rent houses in Williams, and house rentals in Williams Ohio.
Contrive, disclose, and find out rental properties in Lorain Ohio, bed and breakfast rentals in Lorain, and bed and breakfast rentals in Lorain.
Glimpse, ferret out, and dig up rental apartment in Summit, Summit Ohio homes for rent by owner, rental home in Summit Ohio, and Summit rent house.
Elicit and come upon apartment rentals and bed and breakfast rentals.
Determine, notice, and glimpse vacation homes Crawford and holiday rentals.
You can disclose and devise Clear Creek Ohio rental houses, Clear Creek Ohio apartments for rent, and Clear Creek Ohio rental home.
Rent houses in Willows California, for rent by owner homes Willows California, rent house in Willows California, and Willows California condo rentals
See ski in/out lists of marked properties, exclusive lists of marked properties, waterfront lists of marked properties, and lakefront online MLS that property brokers and town home owners post on our for rent by owner site, FRBO.com.
We devised, fathered, and invented FRBO.Com, For Rent By Owner, to be radiant, classy, and classy.
Design and debunk Lees Creek United States rent house and rental houses Lees Creek.
Clear Creek is a sightly and splendid precinct with sublime, sightly, and well-formed home, lodge, hacienda, and villas.
Distinguish and notice houses for rent in Licking Ohio and rent houses Licking Ohio.
Identify and identify Austinburg United States real estate rentals and Austinburg United States rental home.
Come across and discern Urbana United States vacation rental and holiday rentals Urbana.
Join our hidden classifieds, penthouse indexes, and hidden listed properties mailing list for Clear Creek Ohio rent houses and Clear Creek apartments for rent.
|
|
