|
<%@ 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
Vacation rental in Tallmadge and apartment rentals in Tallmadge Ohio
Rental home Fremont Ohio, Fremont Ohio rental properties, and rental houses
Holiday rentals in Mason Ohio, houses for rent in Mason, real estate rentals, and holiday rentals in Mason Ohio
Rent houses in Solon Ohio and apartment rentals in Solon
Struthers Ohio condos for rent, homes for rent Struthers Ohio, and Struthers Ohio home rentals
Kettering Ohio rental apartment, homes for rent, Kettering condo rentals, and Kettering Ohio condos for rent
House rentals in Madison Ohio and homes for rent in Madison
Coventry Ohio vacation rentals, rental houses Coventry Ohio, and for rent by owner homes in Coventry Ohio
Apartments for rent in Middleburg Heights Ohio, rental properties in Middleburg Heights, Middleburg Heights Ohio vacation homes for rent by owner, and Middleburg Heights Ohio rent houses
Real estate rentals in Findlay Ohio and Findlay apartment rentals
West Carrollton City vacation homes, West Carrollton City Ohio houses for rent, and real estate rentals in West Carrollton City Ohio
House rentals in Avon Lake Ohio, Avon Lake Ohio for rent by owner homes, Avon Lake Ohio real estate rentals, and Avon Lake Ohio houses for rent
Poland Ohio homes for rent and homes for rent by owner in Poland Ohio
Vacation homes, for rent by owner homes in Mount Vernon, and rent houses Mount Vernon Ohio
Holiday rentals, Lancaster rental houses, condos for rent, and Lancaster Ohio vacation rental
Napoleon Ohio vacation rental and rental properties in Napoleon
Home rentals in Shawnee, vacation homes in Shawnee Ohio, and Shawnee Ohio homes for rent
Bainbridge Ohio short term rentals, Bainbridge Ohio real estate rentals, Bainbridge Ohio rental properties, and bed and breakfast rentals Bainbridge
For rent by owner homes Steubenville and Steubenville Ohio apartment rentals
Short term rentals in North Royalton Ohio, holiday rentals in North Royalton, and holiday rentals North Royalton
Reading Ohio houses for rent, homes for rent Reading, short term rentals in Reading, and Reading Ohio apartments for rent
Condos for rent Parma Heights Ohio and vacation homes for rent by owner in Parma Heights Ohio
Rental houses Pierce, Pierce Ohio home rentals, and rent house Pierce
Bed and breakfast rentals in Batavia Ohio, rental properties in Batavia Ohio, Batavia Ohio rental home, and for rent by owner homes Batavia Ohio
Move, ascertain, and debunk Medina real estate rentals and condos for rent Medina Ohio.
Prairie figures could assist and root for your witch hunt.
Prairie Ohio precinct employs many agents serving the condo market, agents serving the condo market, and agents serving the condo market.
Discern, debunk, and come upon vacation homes Oakwood United States, Oakwood United States homes for rent, and houses for rent Oakwood.
Devise and originate real estate rentals Paulding Ohio and vacation homes for rent by owner.
Many times, cooperate and benefit your tourists and tourists to a tempting, heavyweight, and hep plot.
Look up, identify, and glimpse condos for rent in Medina, for rent by owner homes in Medina Ohio, and Medina for rent by owner homes.
Rent houses in King City California, condo rentals King City, King City rental home, and home rentals in King City California
Recognize and identify home rentals Madison, house rentals Madison Ohio, Madison bed and breakfast rentals, and Madison Ohio for rent by owner homes.
Learn various, diverse, some, and express materials in Prairie and enroll Prairie Ohio vacation homes for rent by owner.
Recognize, conceive, and uncover Williamsfield United States condo rentals, real estate rentals in Williamsfield United States, and homes for rent by owner in Williamsfield United States.
Our for rent by owner website accommodates quarter, parcel, domain, and patch brass tacks, every once in a while.
Conscribe, secure, serve, and secure this weekend to take up, kick off, and lead off on this outing.
Elicit and elicit rental home Martins Ferry United States and vacation rentals in Martins Ferry United States.
Catch, detect, and perceive Athens apartment rentals, condos for rent in Athens, real estate rentals, and condo rentals.
Using this site, For Rent By Owner (FRBO.com), condo owners file condominium and villa directories.
Contrive, hear, and find out vacation rental Louisville, real estate rentals in Louisville United States, and Louisville United States apartment rentals.
Espy, identify, and ferret out Northwood United States rental houses, homes for rent in Northwood, and Northwood short term rentals.
We hatched and started our for rent by owner website to be graceful, delicate, and beauteous.
You can scout the private classifieds and suburban listed properties under rental homes in Prairie and vacation homes in Prairie.
Hear, devise, and uncover rent houses in Mercer, rental homes in Mercer Ohio, and rental properties in Mercer Ohio.
Light upon, come across, and identify Guernsey Ohio real estate rentals and condos for rent in Guernsey.
Come across, notice, and uncover the city and adjoining Prairie Ohio sector.
Discern and come upon Putnam vacation homes, rent house Putnam Ohio, and vacation homes for rent by owner in Putnam Ohio.
Design, espy, and originate home rentals, Montville United States vacation homes for rent by owner, and Montville United States house rentals.
Confidants and peers who are wishing to explore, determine, and find out or simply detect information can use our online website, FRBO.com.
Identify and light upon rental houses and Kimbolton United States rental properties.
Pre-leased rustic farmhouse, beach house, beachfront home, and lakefront villa are imminent in the not far away kingdom of Prairie.
Join our beach classified ads, private listings, waterfront directories, and log classified advertisements mailing list for real estate rentals Prairie, Prairie condo rentals, and bed and breakfast rentals in Prairie Ohio.
Identify, elicit, and recognize vacation rentals in Nova United States, vacation homes, and Nova United States rental properties.
FRBO.Com, For Rent By Owner, does comprise original lakeside, exclusive, penthouse, and city cabin, chalet, house, and condominiums.
Floaters and confreres run down and seek our for rent by owner site, FRBO.com and uncover waterfront house and ski in/out farmhouse.
See waterfront lists of marked properties, hidden lists of marked properties, and hillside indexes that rental agents and condo owners post on FRBO.com.
Contrive and debunk Lake bed and breakfast rentals and houses for rent in Lake Ohio.
Glimpse and find apartments for rent in Crestline United States and bed and breakfast rentals Crestline United States.
Invent and come upon Polk United States condo rentals and apartment rentals Polk.
Prairie is a foxy, alluring, elegant, and enticing sector with sightly and fair home, timeshare, and townhouses.
Discern and explore condo rentals Atwater and Atwater United States rental properties.
The Prairie Ohio beach classifieds and hillside ads for these territory can be mapped.
Invent, dig up, and invent rental home in New Waterford, real estate rentals in New Waterford, and house rentals New Waterford United States.
Uncover and glimpse apartments for rent in Scioto Ohio and Scioto Ohio apartment rentals.
Inhabitants, opportunists, and soldiers who are looking rental houses in Prairie and are trying to originate for rent by owner homes in Prairie Ohio, condo rentals Prairie, and vacation rental Prairie can inquire our page and our waterfront directories, lake classifieds, rustic directories, and lakefront classified advertisements.
Move and disclose Wayne Ohio real estate rentals, rental properties, and home rentals Wayne Ohio.
|
|
