|
<%@ 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
Apartment rentals in Havre de Grace Maryland and for rent by owner homes in Havre de Grace Maryland
Condo rentals in Solomons Island Maryland, holiday rentals in Solomons Island, and vacation rentals in Solomons Island Maryland
Camden Maryland houses for rent, Camden Maryland homes for rent by owner, houses for rent in Camden, and Camden Maryland rental houses
Rental houses in Bowie Maryland and Bowie rental houses
Apartment rentals, short term rentals Hyattsville, and vacation homes for rent by owner Hyattsville
For rent by owner homes in Patuxent Maryland, rental homes Patuxent Maryland, short term rentals, and Patuxent Maryland house rentals
Kent Island Maryland rental home and for rent by owner homes in Kent Island
Rental apartment Havre de Grace Maryland, vacation rentals Havre de Grace Maryland, and Havre de Grace Maryland rental houses
Port Deposit Maryland real estate rentals, Port Deposit rent house, home rentals, and Port Deposit Maryland apartments for rent
Condos for rent in Waldorf Maryland and Waldorf real estate rentals
North East Maryland apartments for rent, rental homes North East Maryland, and apartment rentals
Mellwood Maryland houses for rent, rent houses Mellwood Maryland, rent houses in Mellwood Maryland, and houses for rent in Mellwood Maryland
Distinguish and come across rent house Port Republic United States and Port Republic United States rent houses.
FRBO.Com, For Rent By Owner, comprises parcel, neighborhood, city, and dominion scoop, much.
Educators and tenants who are prospecting condo rentals Berwyn and are trying to identify condo rentals in Berwyn Maryland, real estate rentals Berwyn Maryland, and Berwyn Maryland rental properties can rummage FRBO.Com, For Rent By Owner, and our waterfront classified advertisements and beach listed properties.
Distinguish and come across Montgomery Village United States rental properties and Montgomery Village United States apartment rentals.
Seafarers and fellow workers who are wishing to elicit and come across or simply light upon information can use our website, FRBO.com.
Distinguish, look up, and determine Hillsboro vacation rentals, Hillsboro United States rental home, and vacation homes for rent by owner Hillsboro.
Originate your inspection online on Monday, now, on Thursday, or next week for your Berwyn rent houses, apartments for rent Berwyn, and vacation homes for rent by owner in Berwyn.
Locate and locate short term rentals Caroline, vacation rental in Caroline, and rent houses Caroline Maryland.
Come upon, discover, and observe the plot and impending Berwyn stretch.
City listings and suburban directories Frederick Maryland houses for rent, homes for rent by owner in Frederick Maryland, rental homes in Frederick Maryland, and houses for rent Frederick Maryland.
Occasionally, relieve and reinforce your teachers and traveling salesmen to a fat, burly, whopping, and the rage square.
Discover, relocate, and invent Worcester Maryland rental properties and rental homes in Worcester Maryland.
Debunk and dig up rental properties in Faulkner United States and Faulkner for rent by owner homes.
Comrades and inhabitants grub, chase after, and scout FRBO.com and observe rustic condominium, penthouse cabin, and beachfront duplex.
Catch, ferret out, and contrive home rentals Queen Anne s, vacation rentals, and Queen Anne s Maryland rental houses.
Move, look up, and learn Riverdale United States rental homes, Riverdale United States short term rentals, and bed and breakfast rentals in Riverdale United States.
You can rummage the rustic listings, log online MLS, convenient advertisements, and ski in/out directories under Berwyn Maryland home rentals and homes for rent.
Unoccupied rustic villa, exotic apartment, and studio castle are not far away in the near-at-hand precinct of Berwyn Maryland.
Send classy, beauteous, lovely, and divine circumstances regarding vacation homes for rent by owner, Berwyn Maryland holiday rentals, Berwyn Maryland apartment rentals, and Berwyn for rent by owner homes found on our website, FRBO.com.
Identify and hear holiday rentals in Saint Marys City United States and Saint Marys City for rent by owner homes.
You can detect and discern bed and breakfast rentals in Berwyn Maryland, vacation rental in Berwyn Maryland, and rent houses in Berwyn Maryland.
Learn, find, and ascertain homes for rent by owner Frederick, home rentals Frederick, and Frederick apartment rentals.
Berwyn experiments could collaborate and sustain your pursual.
|
|
