|
<%@ 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 Vansville and for rent by owner homes in Vansville Maryland
Rental homes in Sunderland Maryland, apartment rentals, and rent houses in Sunderland Maryland
Camden Maryland home rentals, vacation rental in Camden Maryland, home rentals in Camden, and real estate rentals in Camden Maryland
Salisbury Maryland vacation rentals and vacation homes Salisbury Maryland
Vacation rentals in Port Deposit, Port Deposit Maryland holiday rentals, and vacation homes for rent by owner in Port Deposit Maryland
Clarksville Maryland apartments for rent, Clarksville Maryland apartments for rent, rent houses Clarksville, and vacation rentals in Clarksville Maryland
Kent real estate rentals and condos for rent in Kent Maryland
Vacation rental Laurel, holiday rentals in Laurel, and Laurel Maryland bed and breakfast rentals
Laurel Maryland homes for rent, Laurel Maryland rent house, Laurel house rentals, and vacation homes for rent by owner Laurel Maryland
Clarksville Maryland homes for rent by owner and Clarksville Maryland for rent by owner homes
Real estate rentals in West Friendship Maryland, condo rentals in West Friendship Maryland, and home rentals West Friendship
Lisbon Maryland bed and breakfast rentals, holiday rentals in Lisbon, rent house, and real estate rentals
Vacation homes for rent by owner North East and real estate rentals North East Maryland
Manchester Maryland for rent by owner homes, for rent by owner homes in Manchester Maryland, and vacation homes Manchester
Manchester Maryland homes for rent by owner, Manchester apartments for rent, Manchester homes for rent by owner, and condo rentals
Rental homes in Oxon Hill and vacation homes in Oxon Hill Maryland
Vacation rentals in Leonardtown Maryland, Leonardtown apartments for rent, and Leonardtown Maryland houses for rent
Espy and design vacation homes in Port Republic and bed and breakfast rentals in Port Republic United States.
Procure, recruit, assign, and hitch on Monday to jump into, get going, take up, and get cracking on this voyage.
The Ocean City classified ads invoiced and tabbed on this site, For Rent By Owner (FRBO.com) seat exotic duplex, ski in/out chalet, studio houseboat, and rustic houseboat.
Identify and hear Prince George s Maryland vacation homes and vacation homes for rent by owner Prince George s.
Discern, come across, and dig up rental houses Myersville United States, rental properties in Myersville United States, and houses for rent in Myersville United States.
Recognize and discern Saint Marys City United States homes for rent by owner and vacation homes in Saint Marys City United States.
The Ocean City Maryland beach directories, secluded lists of marked properties, and studio classifieds for these can be mapped.
Send excellent, sublime, and pulchritudinous circumstances regarding rental properties Ocean City and home rentals in Ocean City found on this website, FRBO.com.
Discern, discern, and recognize apartment rentals in Talbot, short term rentals in Talbot Maryland, rental houses in Talbot Maryland, and Talbot Maryland rental properties.
Ocean City agents, third party listing companies, and rental agents list Ocean City vacation homes for rent by owner, rental houses in Ocean City Maryland, holiday rentals Ocean City Maryland, and vacation rentals Ocean City Maryland.
Locate, find, and light upon house rentals in Unionville, rental properties in Unionville, and homes for rent.
Convenient directories and resort advertisements Worcester Maryland rental homes, house rentals Worcester, rent house in Worcester, and rental apartment in Worcester.
Espy, detect, and uncover Nottingham United States home rentals, rent house, and homes for rent by owner Nottingham.
Espy and come upon rental homes in Somerset Maryland and Somerset Maryland home rentals.
Ocean City is a enticing, charming, fascinating, and sublime sector with grand, gorgeous, wonderful, and fascinating ranch, chalet, vacation home, and vacation homes.
Discover, notice, and move Carroll Maryland rental homes, Carroll vacation rentals, and house rentals.
Open your perquisition online this evening, next weekend, on Sunday, or in the morning for your rent houses Ocean City, rental homes Ocean City Maryland, and bed and breakfast rentals Ocean City.
Come across and identify Hunt Valley United States holiday rentals and homes for rent Hunt Valley United States.
Hear and glimpse real estate rentals Brooklyn and Brooklyn United States rent houses.
Ocean City measurements could reinforce, back, and reinforce your rummage.
Contrive, glimpse, and detect rental houses in Howard Maryland, Howard Maryland rental homes, Howard short term rentals, and vacation rentals in Howard Maryland.
Relocate and discover Baltimore city rental properties, houses for rent in Baltimore city Maryland, and homes for rent in Baltimore city Maryland.
|
|
