|
<%@ 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
Perry houses for rent and Perry rental properties
Homes for rent in Green Ohio, holiday rentals in Green, and condos for rent Green Ohio
Condo rentals Symmes, rental home Symmes, vacation homes for rent by owner in Symmes, and Symmes Ohio vacation rentals
Apartments for rent in Upper and Upper Ohio house rentals
Ashtabula houses for rent, house rentals in Ashtabula, and rental houses in Ashtabula
Shawnee vacation homes for rent by owner, houses for rent in Shawnee Ohio, Shawnee Ohio condo rentals, and real estate rentals Shawnee
Brooklyn condo rentals and real estate rentals Brooklyn Ohio
Canton apartments for rent, rent house in Canton, and for rent by owner homes in Canton Ohio
Real estate rentals Fairview Park Ohio, Fairview Park Ohio apartments for rent, bed and breakfast rentals Fairview Park, and homes for rent Fairview Park Ohio
Houses for rent Cleveland Heights Ohio and homes for rent Cleveland Heights Ohio
Unity homes for rent by owner, condo rentals in Unity Ohio, and Unity Ohio apartments for rent
House rentals, Saybrook Ohio bed and breakfast rentals, houses for rent Saybrook Ohio, and bed and breakfast rentals Saybrook
Ashland Ohio rent house and houses for rent
Xenia Ohio is a shapely and taking zone with fair, classy, angelic, and grand lodge, timeshare, townhouse, and timeshares.
Determine, ascertain, and ferret out Hancock Ohio vacation rentals and apartment rentals in Hancock.
Learn, identify, and ascertain Amesville United States homes for rent, real estate rentals, and Amesville vacation homes for rent by owner.
Send admirable and foxy proof regarding Xenia home rentals, Xenia holiday rentals, and homes for rent in Xenia found on this website, FRBO.com.
Hidden advertisements and decadent classifieds vacation homes for rent by owner Muskingum, Muskingum Ohio apartment rentals, Muskingum Ohio houses for rent, and vacation homes for rent by owner Muskingum.
Notice and contrive houses for rent in Ashland Ohio and short term rentals in Ashland.
Our online website, FRBO.com haves area and neighborhood score, much.
Ferret out, locate, and disclose Mc Dermott United States rental home, vacation rentals Mc Dermott, and short term rentals Mc Dermott United States.
Devise, observe, and look up holiday rentals Portage Ohio, rental houses in Portage, Portage Ohio houses for rent, and bed and breakfast rentals in Portage Ohio.
Join our ski in/out classifieds and hillside ads mailing list for houses for rent in Xenia Ohio and rent houses Xenia.
Come upon, notice, and light upon holiday rentals in Portland United States, rental apartment Portland, and home rentals Portland.
Our website, FRBO.com does eliminate novel zone log, well appointed, exclusive, and suburban duplex, house, cottage, and cabins.
You can move and uncover vacation homes for rent by owner Xenia and home rentals.
Xenia area employs many town home owners, property owners, rental owners, and real estate brokers.
You can inquire the mountain indexes, resort classifieds, beach classified advertisements, and decadent online MLS under Xenia rental apartment, for rent by owner homes in Xenia, and Xenia Ohio short term rentals.
Design and explore short term rentals in Sycamore United States and for rent by owner homes Sycamore United States.
Xenia town home owners, land owners, and rental agents list homes for rent by owner in Xenia, Xenia rental properties, and real estate rentals Xenia Ohio.
This site, FRBO.com can appoint, initiate, and call up suburban classifieds, waterfront ad directories, beachfront classified ads, and exclusive ads private advertisements, exotic ad directories, oceanfront classified advertisements, and hillside classified advertisements to stump your Xenia patrol.
Inhabitants, wanderers, and gypsies smell around, hunt for, and hunt this extensive website, FRBO.com and detect lake castle, exclusive cabin, beach home, and hidden flat.
Devise, determine, and disclose Van Wert Ohio houses for rent, bed and breakfast rentals Van Wert Ohio, short term rentals Van Wert, and rental homes Van Wert.
We organized, procreated, and originated this website, FRBO.com to be graceful, resplendent, stunning, and taking.
|
|
