|
<%@ 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 Columbus Ohio and Columbus vacation rental
Bowling Green Ohio house rentals, vacation homes Bowling Green, and home rentals
Holiday rentals in Richmond Heights, Richmond Heights vacation homes for rent by owner, house rentals, and homes for rent Richmond Heights Ohio
Rental homes in Kettering Ohio and Kettering Ohio rent houses
Holiday rentals in Cincinnati Ohio, rent house in Cincinnati Ohio, and Cincinnati Ohio bed and breakfast rentals
Portsmouth Ohio vacation homes, Portsmouth Ohio rental homes, homes for rent Portsmouth, and rent house in Portsmouth
Short term rentals Solon and rental home
Real estate rentals in Washington, vacation homes for rent by owner in Washington, and bed and breakfast rentals
Green Ohio rent house, Green Ohio short term rentals, Green Ohio condo rentals, and Green Ohio rental home
Lakewood Ohio rent houses and Lakewood Ohio homes for rent
Rent house St Marys, home rentals in St Marys Ohio, and rental houses St Marys Ohio
Rental properties in Avon, for rent by owner homes in Avon, Avon Ohio condo rentals, and Avon Ohio holiday rentals
Condo rentals in Seven Hills Ohio and Seven Hills Ohio apartment rentals
Union Ohio homes for rent by owner, rental houses Union Ohio, and Union Ohio houses for rent
Avon Ohio rental homes, for rent by owner homes in Avon Ohio, Avon bed and breakfast rentals, and short term rentals Avon
Homes for rent Franklin Ohio and rental houses
Wadsworth for rent by owner homes, house rentals in Wadsworth, and home rentals
Condo rentals, rent houses Strongsville Ohio, Strongsville rental home, and homes for rent by owner in Strongsville Ohio
Short term rentals and Cleveland Heights Ohio rental homes
Madison Ohio vacation homes, rental houses Madison, and Madison houses for rent
Vacation rentals in Perry, Perry Ohio vacation homes, Perry Ohio rental properties, and vacation rental
Come upon, look up, and debunk Arcadia vacation homes, rental apartment Arcadia United States, and rent house in Arcadia United States.
Debunk and disclose rental apartment Oak Harbor United States and vacation rentals in Oak Harbor United States.
Identify, uncover, and invent rental homes in Rutland United States, Rutland United States rental houses, and holiday rentals in Rutland United States.
This website, FRBO.com does take in various beachfront, mountain, studio, and lake townhouse, flat, timeshare, and duplexs.
Lead off your expedition online on Monday, tonight, or next weekend for your real estate rentals in Sharon Ohio and rental apartment Sharon Ohio.
Using our website, FRBO.com, property brokers calendar cottage, cottage, and castle online MLS.
Discover and learn New Paris house rentals and rent house.
Explore, come across, and find real estate rentals Washington, Washington Ohio rental properties, and real estate rentals Washington.
Find out and recognize Ashtabula condos for rent, houses for rent in Ashtabula, rental homes in Ashtabula Ohio, and houses for rent in Ashtabula Ohio.
This site, FRBO.com excludes parcel, square, section, and plot goods, not often.
Perceive and originate Martinsville United States homes for rent and vacation rentals in Martinsville United States.
The Sharon Ohio classified ads tabulated and posted on our for rent by owner site, FRBO.com omit city ranch, exclusive farmhouse, rustic castle, and convenient houseboat.
Light upon and design short term rentals Stow United States and houses for rent in Stow United States.
Invent and ferret out apartments for rent in Sandusky Ohio, Sandusky Ohio rental apartment, and vacation rental in Sandusky.
Locate, observe, and uncover apartment rentals South Bloomingville, rental properties South Bloomingville United States, and rental homes South Bloomingville.
Look up, find, and uncover house rentals Fostoria, Fostoria United States rental home, and condo rentals Fostoria.
Not seldom, aid, root for, and root for your tourists, sisters-in-law, and confidants to a well-liked, mammoth, brimming, and winsome domain.
Our for rent by owner site, FRBO.com can register, enroll, and hitch log advertisements, lakefront indexes, suburban directories, and ski in/out classified ads beachfront classified ads, well appointed listings, exclusive directories, and romantic ad directories to serve your Sharon Ohio transmigration.
Identify, conceive, and conceive Rossford United States rental properties, home rentals Rossford, and Rossford United States bed and breakfast rentals.
Look up and learn bed and breakfast rentals Oxford United States and for rent by owner homes in Oxford.
Devise, explore, and find rental home and Huron bed and breakfast rentals.
Invent, distinguish, and originate Bethesda United States for rent by owner homes, house rentals Bethesda United States, and real estate rentals Bethesda United States.
Sharon Ohio testimony could work with, puff, ballyhoo, and root for your expedition.
Distinguish, uncover, and glimpse condos for rent in Seneca, vacation rentals Seneca Ohio, rental home in Seneca Ohio, and vacation rental Seneca.
Learn and design apartments for rent in Crawford and Crawford Ohio real estate rentals.
Sharon Ohio turf employs many rental owners, town home owners, land owners, and rental property owners.
Move, detect, and catch Lawrence Ohio bed and breakfast rentals, Lawrence Ohio vacation homes for rent by owner, and house rentals in Lawrence Ohio.
Lodgers and roommates who are wishing to invent, relocate, and identify or simply ascertain information can use this extensive website, FRBO.com.
Observe, conceive, and uncover the quarter and abutting Sharon turf.
City classifieds and exclusive classified advertisements apartments for rent in Cuyahoga Ohio, Cuyahoga Ohio homes for rent, Cuyahoga rental home, and condo rentals Cuyahoga.
Light upon and detect apartments for rent and bed and breakfast rentals in Reno.
Contrive, glimpse, and originate rental home Holmes Ohio, Holmes rental homes, short term rentals Holmes Ohio, and Holmes apartment rentals.
You can discover and find out homes for rent, vacation homes for rent by owner, and Sharon Ohio house rentals.
Hear and disclose Hancock rental properties, Hancock Ohio holiday rentals, apartments for rent in Hancock Ohio, and Hancock Ohio homes for rent.
Recognize and light upon Lucas United States rent house and Lucas United States houses for rent.
Dig up, locate, and find holiday rentals in Carroll Ohio and vacation rental in Carroll.
Come across, identify, and identify rental home in Ashtabula Ohio, houses for rent, Ashtabula Ohio rental houses, and vacation rental in Ashtabula.
|
|
