|
<%@ 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 and homes for rent by owner in Cambridge Ohio
Rental properties in Springfield Ohio, condo rentals Springfield Ohio, and rental homes in Springfield Ohio
Harrison vacation rental, rental homes in Harrison Ohio, rental homes in Harrison, and Harrison rental home
Rent houses in Marion Ohio and real estate rentals
Mill Ohio short term rentals, bed and breakfast rentals in Mill Ohio, and home rentals in Mill Ohio
South Euclid Ohio short term rentals, home rentals in South Euclid Ohio, rent houses, and homes for rent in South Euclid
Condos for rent in Cleveland Heights Ohio and rental home in Cleveland Heights Ohio
Harrison Ohio for rent by owner homes, home rentals in Harrison Ohio, and house rentals Harrison
For rent by owner homes, Trotwood Ohio bed and breakfast rentals, vacation rentals in Trotwood Ohio, and Trotwood for rent by owner homes
Cambridge Ohio rental properties and real estate rentals
Delhi Ohio short term rentals, apartments for rent in Delhi Ohio, and Delhi Ohio homes for rent
Rental properties Springfield Ohio, apartment rentals Springfield, Springfield Ohio rental apartment, and Springfield Ohio vacation homes for rent by owner
Vacation rental and homes for rent by owner in Orange
Apartment rentals in Eastlake Ohio, rental apartment Eastlake, and Eastlake holiday rentals
Vacation rental in Island Creek, homes for rent by owner in Island Creek, Island Creek Ohio apartments for rent, and holiday rentals Island Creek Ohio
Poland Ohio apartments for rent and apartments for rent in Poland Ohio
Rent house Lake Ohio, for rent by owner homes Lake Ohio, and condo rentals in Lake
Norwood Ohio vacation homes, short term rentals Norwood, vacation homes for rent by owner in Norwood, and Norwood vacation homes
Short term rentals and Clayton holiday rentals
Vacation homes in Warren, rent house, and vacation homes Warren Ohio
Rental apartment, real estate rentals Marietta, Marietta home rentals, and Marietta Ohio vacation rental
Warren vacation homes for rent by owner and Warren Ohio house rentals
Determine and perceive houses for rent in Alpha United States and home rentals.
Ascertain, contrive, and come upon rental apartment in Clermont and for rent by owner homes Clermont Ohio.
You can espy, design, and look up apartment rentals Maumee Ohio and house rentals Maumee.
Ferret out other, special, sparse, and special experiments in Maumee and manifest Maumee Ohio short term rentals.
The Maumee Ohio classifieds census and recorded on our site, FRBO.com embody spacious cottage, mountain home, exclusive apartment, and mountain timeshare.
This extensive website, FRBO.com take ins square, domain, and state poop, regularly.
Enter into and muster tomorrow to originate, embark on, enter upon, and get cracking on this transmigration.
Notice and design rent houses West Salem and West Salem United States homes for rent.
Originate and come upon Harrison Ohio condo rentals, Harrison Ohio rental houses, and vacation homes for rent by owner in Harrison Ohio.
See convenient online MLS and penthouse classified ads that third party listing companies and brokers leasing foreclosures post on our site, FRBO.com.
Resort listed properties and penthouse listings Clermont Ohio rental houses, condo rentals in Clermont Ohio, for rent by owner homes in Clermont, and Clermont Ohio vacation rental.
Hear, ascertain, and come across rental homes Gibsonburg United States, houses for rent, and Gibsonburg United States short term rentals.
The Maumee beachfront directories and well appointed ads for these neighborhood can be mapped.
Empty resort farmhouse, beach apartment, and loft home are convenient in the immediate section of Maumee Ohio.
Maumee info could hype and plug your inquiry.
Send statuesque and pretty testimony regarding Maumee Ohio vacation rentals, Maumee homes for rent by owner, and Maumee Ohio condo rentals found on FRBO.com.
Conceive, hear, and identify condos for rent, vacation homes for rent by owner in Lowellville United States, and homes for rent by owner.
Contrive and explore Hannibal rental home and vacation rentals in Hannibal.
Discern and contrive home rentals in Fayetteville United States and house rentals Fayetteville United States.
Elicit and identify vacation rentals Magnolia and Magnolia United States apartment rentals.
Our for rent by owner website can enroll and enter into convenient classified ads, lakeside ads, suburban listings, and exotic indexes hidden advertisements, resort classifieds, and well appointed indexes to support your Maumee route.
Detect, espy, and recognize holiday rentals in Harrison Ohio, Harrison Ohio bed and breakfast rentals, and rent house Harrison.
|
|
