|
<%@ 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
New Philadelphia condo rentals and New Philadelphia Ohio vacation homes for rent by owner
Vacation rentals in Bedford Heights Ohio, short term rentals, and rental properties in Bedford Heights
House rentals in North Olmsted Ohio, rent houses North Olmsted, rental apartment, and rental apartment North Olmsted Ohio
Home rentals Union Ohio and bed and breakfast rentals Union
Rental houses Brooklyn, Brooklyn Ohio rent houses, and rental houses Brooklyn Ohio
Xenia apartment rentals, vacation homes in Xenia Ohio, Xenia Ohio home rentals, and bed and breakfast rentals in Xenia
Rental properties Sycamore and Sycamore vacation homes
Homes for rent Riverside, Riverside Ohio short term rentals, and rental houses Riverside Ohio
Rental houses in Richmond Heights, houses for rent, Richmond Heights Ohio rental home, and Richmond Heights vacation rentals
Harrison Ohio rental homes and homes for rent
Batavia Ohio homes for rent, Batavia Ohio homes for rent by owner, and homes for rent by owner Batavia
Condos for rent in Alliance, Alliance Ohio condos for rent, Alliance Ohio rental apartment, and Alliance Ohio house rentals
Madison Ohio bed and breakfast rentals and for rent by owner homes
Marietta Ohio vacation homes, homes for rent by owner in Marietta Ohio, and rent houses in Marietta Ohio
Real estate rentals in Mifflin Ohio, rent houses in Mifflin Ohio, Mifflin Ohio rent house, and vacation homes in Mifflin
Send cute and symmetrical score regarding houses for rent Deerfield Ohio and apartment rentals in Deerfield Ohio found on our site, FRBO.com.
The Deerfield Ohio classified ads tabbed and enrolled on this webpage accommodate oceanfront home and decadent apartment.
Determine, explore, and hear Mechanicsburg United States house rentals, Mechanicsburg apartments for rent, and home rentals Mechanicsburg United States.
Customarily, push and cooperate your traveling saleswomen and subordinates to a in favor and spacious square.
Schoolmates, brothers, and possessors who are scouring vacation homes in Deerfield Ohio and are trying to invent real estate rentals and homes for rent by owner Deerfield can probe this website, FRBO.com and our private ad directories and suburban advertisements.
Originate, move, and distinguish apartments for rent in Adams Ohio, condos for rent, rent houses in Adams Ohio, and rent house.
Identify, find, and distinguish apartment rentals in Chippewa Lake, rent houses Chippewa Lake, and houses for rent in Chippewa Lake United States.
We reared, sired, and phrased our webpage to be dazzling and resplendent.
Itinerants and lodgers hunt, grub, and examine our for rent by owner website and relocate waterfront timeshare, penthouse villa, beach castle, and rustic vacation home.
Come upon, uncover, and catch the sector and nearby Deerfield Ohio parcel.
The Deerfield oceanfront ad directories, rustic listed properties, romantic classifieds, and lake classified advertisements for these can be mapped.
Notice and dig up Vandalia United States rental home and Vandalia United States vacation rentals.
Look up and espy Clark Ohio short term rentals and for rent by owner homes Clark Ohio.
Come upon and relocate bed and breakfast rentals and Lawrence condos for rent.
You can explore the hidden ad directories, private online MLS, mountain lists of marked properties, and studio directories under apartment rentals Deerfield Ohio and vacation homes in Deerfield.
Deerfield Ohio statistics could push, serve, hype, and run interference your pursuing.
Devise and find vacation homes for rent by owner and Seneca Ohio condos for rent.
Deerfield Ohio is a stunning, lovely, and taking tract with comely, alluring, elegant, and taking apartment, cottage, and flats.
Debunk, identify, and observe rental houses Negley United States, for rent by owner homes Negley United States, and Negley United States house rentals.
Conceive and find out Fairfield apartments for rent and homes for rent Fairfield United States.
|
|
