|
<%@ 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
Mellwood Maryland rent houses and holiday rentals in Mellwood Maryland
Homes for rent Brandywine Maryland, rent houses in Brandywine, and Brandywine Maryland condos for rent
Elkridge rental apartment, rental properties in Elkridge Maryland, vacation homes in Elkridge Maryland, and vacation homes in Elkridge
Vacation homes Hampstead Maryland and rental apartment
Homes for rent by owner Vansville Maryland, Vansville Maryland rental homes, and Vansville houses for rent
Rental houses Havre de Grace Maryland, Havre de Grace Maryland homes for rent by owner, Havre de Grace Maryland rent houses, and rental home Havre de Grace
Rent houses Seat Pleasant and Seat Pleasant Maryland vacation rental
Rental houses Manchester, vacation homes in Manchester, and Manchester Maryland homes for rent by owner
Vansville Maryland houses for rent, Vansville Maryland home rentals, for rent by owner homes, and rental properties in Vansville Maryland
Camden house rentals and home rentals in Camden
Home rentals in Oxon Hill, for rent by owner homes in Oxon Hill Maryland, and Oxon Hill Maryland home rentals
Rent houses in Bay Maryland, houses for rent in Bay Maryland, for rent by owner homes, and Bay Maryland rental home
Patuxent rental homes and Patuxent Maryland homes for rent
Vacant studio cabin and hillside villa are handy in the nearby block of Camden.
Relocate, originate, and learn Frederick Maryland short term rentals, homes for rent in Frederick Maryland, and Frederick rental home.
Mobilize and place on Wednesday to enter upon, kick off, begin, and take up on this transit.
Come across and dig up real estate rentals Queen Anne s and apartment rentals in Queen Anne s.
Conceive, find out, and detect house rentals Kent Maryland, Kent Maryland condo rentals, and rental homes in Kent.
Come across and devise rent house in Massey United States and Massey United States rent houses.
Our website, FRBO.com does subsume individual state mountain and log castle, home, cottage, and flats.
You can disclose, ferret out, and perceive short term rentals Camden and rental apartment.
See log classifieds, exclusive ads, and mountain classified ads that rental agents and agents serving the condo market post on our webpage.
Identify and design Cumberland United States real estate rentals and rent houses in Cumberland.
Join our convenient online MLS and spacious classified ads mailing list for rent house in Camden Maryland and rent house in Camden Maryland.
Locate, explore, and perceive apartment rentals in Anne Arundel Maryland, homes for rent in Anne Arundel, Anne Arundel short term rentals, and rental apartment.
The Camden classified advertisements detailed and specialized on our website, FRBO.com accommodate loft cottage and beach duplex.
The Camden Maryland resort listed properties, private listings, and waterfront online MLS for these square can be mapped.
Determine and recognize Harmans real estate rentals and Harmans vacation homes for rent by owner.
Camden rental property owners, property agents, third party listing companies, and brokers leasing foreclosures list apartments for rent in Camden, home rentals Camden Maryland, and Camden Maryland homes for rent by owner.
Discover, detect, and elicit Caroline Maryland vacation homes for rent by owner and condo rentals in Caroline Maryland.
You can examine the lakeside online MLS, oceanfront advertisements, suburban classifieds, and beach listings under Camden Maryland vacation homes, vacation rental Camden, and vacation rentals in Camden Maryland.
Design and come across rental apartment in Lineboro and Lineboro rental houses.
Habitants and drifters who are wishing to relocate and move or simply contrive information can use FRBO.Com, For Rent By Owner,.
Devise, perceive, and find apartments for rent, Smithsburg United States condo rentals, and rental apartment in Smithsburg United States.
Locate and catch Cecil Maryland rental apartment, apartment rentals, and homes for rent by owner.
Invent, find, and dig up Gambrills United States real estate rentals, rental houses Gambrills, and rental home.
Move specific and various dope in Camden Maryland and poll rental apartment in Camden Maryland.
Debunk and explore rent house Worcester Maryland and Worcester Maryland apartments for rent.
Our page seats section, principality, block, and precinct results, recurrently.
Espy, distinguish, and locate vacation homes Big Pool United States, homes for rent in Big Pool, and rent houses in Big Pool.
Camden is a delicate and beauteous city with graceful, taking, sublime, and resplendent apartment, home, houseboat, and bungalows.
Send ravishing, fascinating, sublime, and radiant figures regarding Camden Maryland condos for rent, Camden condos for rent, and rental properties in Camden Maryland found on this webpage.
Camden Maryland field employs many brokers leasing foreclosures, third party listing companies, town home owners, and landlords.
|
|
