|
<%@ 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
Lisbon Maryland vacation homes and vacation rentals in Lisbon
Lisbon Maryland rent house, rent houses in Lisbon Maryland, and vacation homes in Lisbon Maryland
Bel Air vacation rentals, homes for rent Bel Air Maryland, Bel Air Maryland homes for rent, and rental houses in Bel Air Maryland
Rental houses in Waldorf Maryland and Waldorf Maryland vacation rental
Rent house in Oxon Hill Maryland, Oxon Hill Maryland condo rentals, and Oxon Hill Maryland rental houses
Vacation rentals Lisbon Maryland, vacation homes for rent by owner Lisbon Maryland, for rent by owner homes Lisbon, and rent house
Spauldings Maryland homes for rent by owner and Spauldings Maryland rental homes
Apartment rentals Freedom Maryland, houses for rent in Freedom Maryland, and rental homes in Freedom Maryland
Spauldings homes for rent by owner, Spauldings Maryland bed and breakfast rentals, vacation rentals in Spauldings, and rent houses
Rent house Vansville Maryland and for rent by owner homes in Vansville Maryland
Disclose and distinguish Bozman for rent by owner homes and condos for rent in Bozman.
Almost ready to be occupied waterfront chalet and mountain bungalow are adjoining in the not far away quarter of Hyattsville Maryland.
Traveling salesmen and schoolmates prospect and scour our website, FRBO.com and identify ski in/out townhouse, exclusive farmhouse, mountain villa, and hidden ranch.
Find out, identify, and come across Dorchester Maryland vacation rentals, Dorchester Maryland condos for rent, and Dorchester Maryland rental houses.
Beachfront online MLS and beach listings real estate rentals Howard, condo rentals in Howard Maryland, bed and breakfast rentals Howard Maryland, and vacation rental.
Hyattsville area employs many town home owners, property managers, property brokers, and third party agents.
Dig up, find, and explore home rentals in Howard and Howard Maryland apartments for rent.
FRBO.Com, For Rent By Owner, does embrace sparse state romantic, log, spacious, and exotic lodge, house, vacation home, and apartments.
Uncover, glimpse, and ferret out real estate rentals in Lisbon, for rent by owner homes in Lisbon United States, and Lisbon United States homes for rent by owner.
Our online website, FRBO.com can incorporate, place, recruit, and obtain beachfront classified advertisements, lake listed properties, and resort classified advertisements beach listed properties and loft advertisements to help your Hyattsville Maryland round.
Discover, espy, and determine real estate rentals Worcester Maryland and houses for rent in Worcester Maryland.
Disclose and elicit rental houses Wicomico Maryland, homes for rent in Wicomico, homes for rent in Wicomico Maryland, and Wicomico Maryland apartments for rent.
Observe and invent rental properties in Mount Victoria and homes for rent by owner Mount Victoria.
Globetrotters and comrades who are hunting for Hyattsville Maryland rent house and are trying to discern Hyattsville holiday rentals, Hyattsville Maryland vacation homes for rent by owner, and Hyattsville Maryland vacation rentals can ransack For Rent By Owner and our oceanfront ad directories, exotic advertisements, and exotic indexes.
|
|
