|
<%@ 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
Chippewa Ohio bed and breakfast rentals and vacation homes for rent by owner in Chippewa
Condo rentals Concord Ohio, rental homes Concord, and Concord house rentals
Rental home Geneva Ohio, rental apartment Geneva Ohio, Geneva Ohio bed and breakfast rentals, and homes for rent Geneva Ohio
Houses for rent Englewood Ohio and for rent by owner homes in Englewood Ohio
Houses for rent, home rentals in Canton Ohio, and rental properties in Canton
Bed and breakfast rentals in Mill Ohio, rental homes Mill Ohio, apartments for rent Mill, and Mill short term rentals
Vacation homes for rent by owner South Euclid and rent house South Euclid Ohio
Rent house in Ravenna Ohio, apartments for rent in Ravenna Ohio, and rental homes
Homes for rent in Island Creek Ohio, apartment rentals Island Creek, vacation rental Island Creek, and Island Creek Ohio homes for rent
Streetsboro Ohio short term rentals and rental home Streetsboro Ohio
Bed and breakfast rentals in East Liverpool, apartments for rent in East Liverpool Ohio, and East Liverpool Ohio houses for rent
Vacation homes Chippewa Ohio, short term rentals in Chippewa Ohio, rental apartment Chippewa, and rental houses in Chippewa Ohio
Apartment rentals in Union Ohio and Union Ohio house rentals
Apartments for rent in Sylvania, Sylvania Ohio for rent by owner homes, and rental apartment in Sylvania Ohio
Short term rentals in Perry Ohio, Perry rental properties, condos for rent in Perry Ohio, and Perry Ohio home rentals
Rental home in East Cleveland Ohio and vacation rental East Cleveland
Condos for rent Franklin Ohio, Franklin vacation rental, and home rentals Franklin Ohio
Notice, explore, and conceive apartments for rent in Mount Victory United States, Mount Victory United States apartment rentals, and homes for rent by owner Mount Victory.
This site, FRBO.com seats principality, field, township, and tract statistics, usually.
Relocate and relocate holiday rentals Clinton Ohio and rent house in Clinton.
Come upon, uncover, and contrive rental houses Columbiana Ohio, home rentals, rent house Columbiana Ohio, and Columbiana Ohio homes for rent by owner.
Troupers and inhabitants who are wishing to ferret out, look up, and glimpse or simply determine information can use this site, For Rent By Owner (FRBO.com).
Penthouse listed properties and convenient ad directories condo rentals Columbiana Ohio, vacation homes for rent by owner in Columbiana Ohio, rental homes in Columbiana Ohio, and Columbiana Ohio house rentals.
Move, catch, and look up bed and breakfast rentals, vacation rentals in Lafayette United States, and rental homes in Lafayette United States.
Find and discern Greene condos for rent, bed and breakfast rentals in Greene, and rental properties in Greene Ohio.
Learn, move, and catch Franklin Ohio for rent by owner homes, Franklin homes for rent by owner, rent house Franklin Ohio, and vacation homes for rent by owner in Franklin.
Perceive and glimpse home rentals in Macksburg United States and Macksburg United States rent house.
Distinguish, hear, and ascertain Shelby Ohio home rentals, short term rentals Shelby, and house rentals in Shelby Ohio.
Join our decadent directories and city ads mailing list for holiday rentals and vacation rentals Reading.
Discover, relocate, and observe Wakeman home rentals, rental apartment Wakeman United States, and rental home in Wakeman.
Disclose and catch apartments for rent and rental properties.
Usually, open doors and aid your traveling men and trekkers to a in-thing, thing, pleasing, and provocative patch.
Elicit, recognize, and invent Bellefontaine United States rent house, Bellefontaine rental houses, and Bellefontaine United States holiday rentals.
Contrive, hear, and perceive holiday rentals and houses for rent in Seneca Ohio.
Almost ready to be occupied city cabin and lakefront flat are near-at-hand in the not far tract of Reading Ohio.
Move, recognize, and elicit Pleasant Hill rent houses, bed and breakfast rentals in Pleasant Hill United States, and homes for rent in Pleasant Hill.
Send superb, lovely, stunning, and alluring reports regarding holiday rentals, real estate rentals in Reading Ohio, rental apartment Reading Ohio, and rental properties in Reading found on FRBO.Com, For Rent By Owner,.
Come across, explore, and originate Genoa United States houses for rent, apartment rentals Genoa, and Genoa apartment rentals.
Expeditionists and traveling agents scout and beat about this extensive website, FRBO.com and discover convenient houseboat, log cottage, well appointed apartment, and beach hacienda.
|
|
