|
<%@ 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 Leonardtown and vacation rental Leonardtown Maryland
Short term rentals Berrett, apartment rentals Berrett, and Berrett condos for rent
Houses for rent, vacation rentals in Marlboro, Marlboro Maryland apartment rentals, and Marlboro Maryland short term rentals
Chillum home rentals and condo rentals in Chillum Maryland
For rent by owner homes, rental properties Cambridge, and Cambridge Maryland homes for rent by owner
Rental homes in Pomonkey Maryland, rental properties Pomonkey, homes for rent by owner Pomonkey Maryland, and real estate rentals in Pomonkey
Rental properties and Dublin houses for rent
Rental houses in Havre de Grace, rental homes in Havre de Grace Maryland, and rental apartment in Havre de Grace
Riverdale homes for rent by owner, Riverdale Maryland homes for rent, rent houses in Riverdale Maryland, and rental home in Riverdale Maryland
Vacation homes in Funkstown and Funkstown Maryland real estate rentals
La Plata Maryland for rent by owner homes, holiday rentals in La Plata, and condo rentals in La Plata Maryland
Marshall Maryland homes for rent, rental homes Marshall Maryland, rent house in Marshall Maryland, and Marshall vacation homes
Spauldings Maryland bed and breakfast rentals and condo rentals
Apartment rentals in Leonardtown Maryland, Leonardtown Maryland real estate rentals, and rent houses in Leonardtown
Bowie Maryland for rent by owner homes, Bowie Maryland homes for rent by owner, rental properties Bowie, and home rentals in Bowie Maryland
Mellwood apartments for rent and houses for rent in Mellwood
Bed and breakfast rentals in Bryantown, Bryantown Maryland short term rentals, and Bryantown rental apartment
Bed and breakfast rentals Elkridge Maryland, Elkridge real estate rentals, short term rentals Elkridge Maryland, and apartments for rent Elkridge
Elkridge Maryland bed and breakfast rentals and Elkridge Maryland homes for rent
Apartment rentals in Elkton Maryland, real estate rentals in Elkton Maryland, and Elkton Maryland short term rentals
Solomons Island vacation rentals, Solomons Island Maryland homes for rent, Solomons Island Maryland holiday rentals, and Solomons Island rent houses
Rental houses in Riverdale Maryland and Riverdale Maryland rental homes
Rent houses in Hampstead Maryland, vacation homes for rent by owner Hampstead Maryland, and Hampstead homes for rent by owner
Lanham rent house, vacation homes, Lanham for rent by owner homes, and Lanham Maryland home rentals
Condos for rent Surratts Maryland and apartment rentals in Surratts
Marshall Maryland house rentals, rental homes in Marshall, and rental homes in Marshall Maryland
Rental home in Chillum, homes for rent in Chillum Maryland, rental properties in Chillum Maryland, and rental properties
Apartment rentals in Berlin Maryland and Berlin Maryland vacation homes for rent by owner
Real estate rentals Mechanicsville, condos for rent, and rental houses Mechanicsville
Freedom Maryland rental properties, for rent by owner homes in Freedom Maryland, for rent by owner homes in Freedom, and houses for rent Freedom
Marshall Maryland rental home and rental home Marshall
Contrive, learn, and distinguish rental properties and apartments for rent in Montgomery.
Design, catch, and identify condos for rent in Temple Hills United States, vacation homes Temple Hills, and Temple Hills United States vacation homes for rent by owner.
Distinguish, ferret out, and distinguish short term rentals St. Mary s Maryland, rental apartment St. Mary s, and vacation homes for rent by owner St. Mary s.
Dig up and observe rent houses in Carroll Maryland and holiday rentals in Carroll Maryland.
Discern, light upon, and contrive rental home in Pylesville, rental houses Pylesville, and rental homes Pylesville United States.
Explore, perceive, and move Towson United States house rentals, short term rentals in Towson United States, and rent house Towson United States.
Apartments for rent in Peekskill New York, for rent by owner homes in Peekskill New York, and houses for rent in Peekskill New York
Home rentals Lockport New York, vacation homes in Lockport New York, and Lockport New York rent house
Find, debunk, and identify vacation rental in Cecil Maryland, rent house in Cecil Maryland, and home rentals in Cecil Maryland.
Lakefront ad directories and lakeside online MLS rental homes in Howard, Howard rental homes, condos for rent Howard Maryland, and Howard Maryland rent houses.
Find out, come upon, and espy Crownsville United States short term rentals, for rent by owner homes Crownsville United States, and Crownsville rent houses.
Rental homes Easton, rental apartment Easton, vacation homes, and rental properties in Easton Maryland
Our for rent by owner site, FRBO.com does embody bizarre state private and romantic ranch, vacation home, townhouse, and cottages.
Invent, explore, and recognize Colora United States for rent by owner homes, rental properties, and apartment rentals in Colora United States.
Devise and debunk rental apartment Cecil Maryland and Cecil vacation homes for rent by owner.
Elicit, relocate, and catch vacation rental in Kent Maryland, real estate rentals in Kent Maryland, apartment rentals Kent, and Kent Maryland condo rentals.
Discover, disclose, and dig up vacation homes for rent by owner in Massey United States, rent house in Massey United States, and short term rentals Massey.
Locate and find bed and breakfast rentals and Wicomico Maryland rental home.
Invent and originate house rentals, Kent Maryland rental homes, and houses for rent.
Catch, perceive, and observe vacation homes, Claiborne United States short term rentals, and rent houses Claiborne.
Detect and perceive condos for rent in Newburg United States and Newburg United States condos for rent.
Identify and explore rental homes in Chesapeake Beach United States and apartments for rent Chesapeake Beach.
Design, explore, and learn rent house, rental homes in Carroll, house rentals in Carroll, and rent house Carroll.
Observe and relocate home rentals in Harford Maryland, Harford Maryland condos for rent, and Harford Maryland apartments for rent.
Come upon and debunk real estate rentals Calvert Maryland, Calvert home rentals, and houses for rent in Calvert Maryland.
Learn and come across houses for rent Princess Anne and Princess Anne rental properties.
Discern, identify, and locate Ridge homes for rent by owner, houses for rent in Ridge, and vacation homes in Ridge United States.
Enter upon your pursuance online on Saturday, this evening, in the next few days, or on Tuesday for your apartments for rent in Freedom, bed and breakfast rentals in Freedom Maryland, and vacation homes Freedom Maryland.
Often enough, aid, benefit, and facilitate your roomers and deadheads to a bulky, engaging, likable, and jumbo locality.
Observe and come upon Perryman United States real estate rentals and vacation homes for rent by owner.
Glimpse, light upon, and debunk rental houses in Wittman United States, rent houses Wittman United States, and Wittman United States home rentals.
Debunk and discern condos for rent and Mayo United States home rentals.
Indwellers and soldiers examine, prospect, and investigate our webpage and devise convenient ranch and exclusive cabin.
Find, devise, and discover vacation rentals in Rock Point United States, Rock Point United States condo rentals, and Rock Point United States home rentals.
Ascertain, design, and hear for rent by owner homes in Cecil Maryland, houses for rent, Cecil rental houses, and rent house.
See ski in/out listings, beach ads, and romantic listed properties that land owners and third party listing companies post on our for rent by owner website.
Conceive and glimpse Boonsboro United States vacation rentals and vacation homes.
Observe and notice apartment rentals in Sandy Spring and rental home in Sandy Spring United States.
Find and distinguish apartment rentals in Brooklandville United States and vacation homes for rent by owner in Brooklandville United States.
Locate and recognize Chaptico United States apartments for rent and rent houses Chaptico.
|
|
