|
<%@ 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" %>
|
Maryland Rental Links
Homes for rent by owner in Prince Frederick and condos for rent in Prince Frederick Maryland
Bed and breakfast rentals Riverdale Maryland, Riverdale Maryland homes for rent, and Riverdale Maryland vacation rental
Condo rentals Lisbon, Lisbon apartment rentals, Lisbon Maryland rental homes, and homes for rent by owner in Lisbon Maryland
Condos for rent West Friendship Maryland and West Friendship Maryland home rentals
Cambridge Maryland vacation homes for rent by owner, bed and breakfast rentals in Cambridge Maryland, and apartment rentals Cambridge Maryland
Homes for rent in Seat Pleasant, bed and breakfast rentals in Seat Pleasant Maryland, home rentals, and rental homes
Rental houses in Bay Maryland and rent house in Bay Maryland
Rental properties in Pomonkey Maryland, homes for rent by owner in Pomonkey Maryland, and rent house in Pomonkey Maryland
Seat Pleasant Maryland homes for rent by owner, Seat Pleasant for rent by owner homes, condo rentals, and Seat Pleasant Maryland condos for rent
Piscataway Maryland vacation homes and rent house Piscataway
House rentals Lisbon, rental houses Lisbon, and for rent by owner homes in Lisbon Maryland
Dig up and come across rent house in Myersville United States and Myersville house rentals.
Hitch and muster on Wednesday to get going, originate, and launch on this promenade.
See exotic advertisements, secluded classified advertisements, and well appointed indexes that third party agents and land owners post on this extensive website, FRBO.com.
Recognize, espy, and espy apartment rentals Talbot Maryland and rental home Talbot.
Notice and perceive Caroline Maryland homes for rent and bed and breakfast rentals in Caroline Maryland.
Conceive and espy rental houses in Anne Arundel Maryland and vacation homes for rent by owner in Anne Arundel Maryland.
Ferret out, uncover, and recognize short term rentals Emmitsburg United States, rental properties in Emmitsburg United States, and Emmitsburg apartments for rent.
Ferret out, find, and ascertain Callaway United States apartment rentals, rent houses Callaway United States, and rental apartment in Callaway United States.
Dig up and debunk vacation homes Aberdeen United States and for rent by owner homes Aberdeen.
Invent and come across for rent by owner homes Elkton United States and Elkton rental homes.
Open your inquest online this week or on Wednesday for your for rent by owner homes in Woolerys Maryland and Woolerys Maryland holiday rentals.
Woolerys Maryland dossier could boost, work with, and puff your chase.
Find and find out for rent by owner homes Allen United States and rental properties in Allen United States.
The Woolerys convenient indexes, decadent online MLS, penthouse listed properties, and secluded listings for these field can be mapped.
|
|
