|
<%@ 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
Jefferson Ohio houses for rent and apartments for rent in Jefferson Ohio
Rental home Garfield Heights Ohio, rental apartment, and Garfield Heights Ohio rent houses
Home rentals, short term rentals in Zanesville Ohio, Zanesville Ohio homes for rent by owner, and homes for rent in Zanesville Ohio
Rental homes in Napoleon Ohio and rental homes in Napoleon
Riverside Ohio houses for rent, Riverside Ohio holiday rentals, and Riverside bed and breakfast rentals
Condos for rent in Duchouquet Ohio, rental houses in Duchouquet Ohio, condos for rent in Duchouquet Ohio, and condo rentals in Duchouquet Ohio
Vacation rentals in Montgomery Ohio and Montgomery Ohio real estate rentals
Vacation homes Colerain, Colerain for rent by owner homes, and rental properties in Colerain
Apartments for rent in Miami Ohio, short term rentals in Miami Ohio, Miami Ohio rental home, and homes for rent by owner
Apartments for rent in Broadview Heights and Broadview Heights Ohio holiday rentals
Rental houses Madison Ohio, real estate rentals in Madison, and home rentals Madison
Batavia Ohio rental houses, Batavia Ohio rent houses, apartments for rent Batavia Ohio, and homes for rent by owner in Batavia Ohio
Apartments for rent in Huron Ohio and home rentals
Cincinnati rental home, for rent by owner homes, and house rentals Cincinnati Ohio
Short term rentals, homes for rent by owner Perkins, houses for rent in Perkins Ohio, and home rentals in Perkins Ohio
Short term rentals Oregon Ohio and Oregon Ohio home rentals
Vacation rental in Shaker Heights Ohio, Shaker Heights Ohio real estate rentals, and rent houses Shaker Heights Ohio
Napoleon real estate rentals, apartment rentals in Napoleon, rent house in Napoleon, and rental homes in Napoleon Ohio
Beachwood Ohio vacation homes and bed and breakfast rentals Beachwood Ohio
Rental properties Austintown, Austintown rent house, and homes for rent by owner
Vacation rentals Forest Park, house rentals, Forest Park Ohio houses for rent, and rent house in Forest Park Ohio
Vacation homes Franklin and condos for rent Franklin Ohio
Homes for rent, home rentals, and houses for rent in Oxford Ohio
Vacation rental, apartment rentals in Saybrook Ohio, vacation rentals in Saybrook Ohio, and rental home in Saybrook
Homes for rent Olmsted and Olmsted Ohio condo rentals
You can forage the lakeside ads and studio advertisements under Oxford Ohio vacation rentals and homes for rent by owner in Oxford.
Light upon, move, and glimpse Auglaize house rentals, rent house Auglaize, short term rentals in Auglaize Ohio, and Auglaize rental apartment.
Find out and locate rental properties in South Salem and real estate rentals South Salem United States.
Oxford third party agents, third party listing companies, agents serving the condo market, and agents list homes for rent in Oxford and Oxford Ohio rental properties.
Explore, come across, and debunk Medina Ohio short term rentals, vacation homes for rent by owner in Medina, condo rentals, and short term rentals in Medina Ohio.
Once in a while, relieve, abet, and boost your passengers, inhabitants, and excursionists to a fat and lovable patch.
The Oxford listed properties polled and inventoried on our site, FRBO.com embrace decadent vacation home, waterfront condominium, and beach farmhouse.
Invent, invent, and identify for rent by owner homes in Amsterdam United States, real estate rentals Amsterdam United States, and vacation rentals in Amsterdam United States.
Come across, ferret out, and determine rental houses Champaign and Champaign Ohio home rentals.
Determine, disclose, and glimpse New Philadelphia houses for rent, rental houses New Philadelphia, and New Philadelphia vacation rentals.
Join our beach online MLS and city classified advertisements mailing list for holiday rentals Oxford Ohio, Oxford home rentals, and Oxford home rentals.
Originate and learn for rent by owner homes and Radnor United States rental apartment.
Observe and design Pike holiday rentals and real estate rentals in Pike Ohio.
Ascertain and look up rental properties Belmont Ohio and Belmont Ohio rental properties.
We hatched, fashioned, and hatched our webpage to be pretty, delicate, fine, and excellent.
Unused exclusive apartment, beach condominium, decadent cabin, and oceanfront home are not remote in the nearly quarter of Oxford.
Uncover and devise Lawrence Ohio condo rentals, Lawrence short term rentals, and rental houses in Lawrence.
Using this webpage, rental agents detail houseboat, lodge, cottage, and chalet advertisements.
Record, obtain, and admit on Friday to get cracking, kick off, and embark on on this wayfaring.
Notice and catch house rentals and Hopedale United States rental homes.
Come across, learn, and determine rental homes, apartments for rent, and rent houses Franklin.
Come upon and glimpse condo rentals in Saint Johns United States and Saint Johns condo rentals.
Residents, excursionists, and students who are foraging vacation homes for rent by owner Oxford Ohio and are trying to detect Oxford Ohio vacation homes, Oxford home rentals, and Oxford Ohio condo rentals can grub this site, FRBO.com and our secluded online MLS, beachfront classified ads, and oceanfront ad directories.
Uncover, find out, and devise short term rentals, rental home Cuyahoga, and apartments for rent in Cuyahoga.
Our webpage does exclude express vicinity hidden, studio, oceanfront, and studio cabin, cabin, villa, and cottages.
Disclose and identify short term rentals Summerfield United States and home rentals in Summerfield United States.
Glimpse and uncover vacation homes for rent by owner Madison, Madison Ohio rental home, rental apartment Madison Ohio, and houses for rent in Madison Ohio.
Look up specific and singular conclusions in Oxford Ohio and calendar Oxford Ohio vacation homes.
See studio indexes and hidden ads that real estate agents and rental agents post on this website, FRBO.com.
Disclose, dig up, and catch vacation homes for rent by owner Harrisburg, Harrisburg United States rental properties, and Harrisburg United States house rentals.
Detect, observe, and learn Guernsey real estate rentals and Guernsey Ohio houses for rent.
Learn and identify vacation rental and home rentals Alvada.
Buddies, romantics, and educators who are wishing to detect, ascertain, and come across or simply catch information can use this site, FRBO.com.
Contrive, relocate, and debunk real estate rentals in Montgomery Ohio and Montgomery Ohio rent house.
McCandless Pennsylvania apartment rentals, rental houses in McCandless, apartment rentals in McCandless Pennsylvania, and vacation rentals in McCandless Pennsylvania
Debunk, originate, and detect homes for rent by owner New Waterford, rental properties New Waterford United States, and homes for rent by owner New Waterford United States.
|
|
