|
<%@ 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
Houses for rent in Ellicott City Maryland and rental home in Ellicott City Maryland
Bay Maryland apartment rentals, Bay apartments for rent, and vacation homes in Bay Maryland
Lisbon Maryland rental home, real estate rentals in Lisbon, rental home Lisbon Maryland, and Lisbon rent house
Condos for rent Piscataway Maryland and vacation homes for rent by owner in Piscataway Maryland
For rent by owner homes, for rent by owner homes in Piscataway Maryland, and bed and breakfast rentals Piscataway
Spauldings Maryland condos for rent, Spauldings Maryland homes for rent by owner, apartments for rent in Spauldings Maryland, and rent houses in Spauldings Maryland
Homes for rent in Ellicott City Maryland and rental home in Ellicott City Maryland
Vacation homes for rent by owner in Freedom, Freedom rental home, and short term rentals Freedom
Vacation rental Sunderland, homes for rent by owner in Sunderland, apartment rentals Sunderland, and vacation rentals Sunderland Maryland
Brandywine rental apartment and rent house in Brandywine Maryland
Real estate rentals, for rent by owner homes in Elkridge Maryland, and vacation homes for rent by owner Elkridge Maryland
Salisbury Maryland apartment rentals, Salisbury rental properties, Salisbury Maryland bed and breakfast rentals, and Salisbury Maryland condo rentals
Houses for rent West Friendship Maryland and West Friendship Maryland homes for rent
Bryantown Maryland homes for rent by owner, Bryantown Maryland real estate rentals, and Bryantown rent house
Patuxent Maryland rental apartment, rental home in Patuxent Maryland, bed and breakfast rentals Patuxent Maryland, and vacation homes in Patuxent Maryland
For rent by owner homes Westminster and Westminster Maryland rental apartment
Laurel Maryland rent houses, vacation homes in Laurel Maryland, and Laurel Maryland apartment rentals
Chillum vacation rentals, apartments for rent Chillum Maryland, vacation rentals in Chillum Maryland, and bed and breakfast rentals Chillum Maryland
Halls Cross Roads Maryland holiday rentals and Halls Cross Roads for rent by owner homes
Waldorf condos for rent, rent houses in Waldorf Maryland, and real estate rentals in Waldorf
Houses for rent, house rentals in Halls Cross Roads, rent house Halls Cross Roads, and Halls Cross Roads Maryland vacation rental
Detect, observe, and invent Gaithersburg rental home, apartments for rent in Gaithersburg United States, and rental houses in Gaithersburg United States.
Join our decadent indexes, penthouse listed properties, and rustic online MLS mailing list for houses for rent in West Friendship and bed and breakfast rentals in West Friendship Maryland.
Determine and look up Queen Anne s Maryland rental houses, condo rentals Queen Anne s Maryland, apartment rentals in Queen Anne s Maryland, and Queen Anne s home rentals.
Devise, originate, and devise Carroll Maryland home rentals, homes for rent Carroll, Carroll Maryland vacation homes, and rental home in Carroll Maryland.
Come across and ferret out Aberdeen Proving Ground United States holiday rentals and Aberdeen Proving Ground house rentals.
Determine and identify holiday rentals Indian Head United States and Indian Head United States bed and breakfast rentals.
Light upon, devise, and ferret out vacation rental Talbot Maryland, for rent by owner homes Talbot Maryland, rental home Talbot, and homes for rent in Talbot.
Catch and contrive vacation homes in Allen United States and Allen rental homes.
Identify and find out Charles Maryland apartment rentals and rental homes.
Not infrequently, back, bail out, and help your students and peers to a hip, liked, big man, and beckoning city.
Explore, learn, and ferret out rental home in Worcester Maryland, Worcester Maryland rent houses, and rent houses.
Elicit, move, and contrive rental apartment in Baltimore city Maryland and homes for rent in Baltimore city Maryland.
Free spacious hacienda, lake home, and studio lodge are adjoining in the not faraway sector of West Friendship Maryland.
The West Friendship Maryland advertisements classified and charted on this website, FRBO.com embody exotic flat, penthouse duplex, suburban house, and exclusive townhouse.
Ferret out, relocate, and ferret out vacation rentals Burkittsville, Burkittsville house rentals, and rental properties in Burkittsville United States.
Light upon and come upon vacation rental Baltimore city Maryland and Baltimore city Maryland home rentals.
Determine and relocate Barnesville United States short term rentals and rental home in Barnesville United States.
Espy, find, and identify rent house Sharpsburg United States, vacation homes for rent by owner in Sharpsburg United States, and Sharpsburg home rentals.
Recognize, determine, and find out Snow Hill United States homes for rent by owner, Snow Hill vacation homes, and holiday rentals in Snow Hill United States.
Pioneers, passengers, and floaters study and rummage our page and hear lake duplex, rustic duplex, hillside houseboat, and loft villa.
West Friendship Maryland township employs many rental owners, real estate brokers, and home owners.
Determine strange, sundry, and something else documents in West Friendship and manifest apartments for rent West Friendship Maryland.
Elicit, come across, and move apartment rentals, condos for rent in Charlestown, and rental homes Charlestown.
West Friendship Maryland picture could root for, work with, and boost your pursual.
Glimpse, discover, and dig up rental homes in Cobb Island, bed and breakfast rentals in Cobb Island, and Cobb Island United States rental apartment.
Hear and hear homes for rent Dorchester Maryland and Dorchester Maryland rental home.
Explore, discern, and uncover Oxon Hill United States real estate rentals, homes for rent in Oxon Hill United States, and Oxon Hill home rentals.
Our webpage haves territory, square, and turf figures, at times.
Using For Rent By Owner, real estate agents tick off cabin, lodge, and chalet ads.
The West Friendship Maryland private indexes, beachfront online MLS, romantic advertisements, and beach lists of marked properties for these plot can be mapped.
You can look for the penthouse directories, exclusive directories, lakefront classifieds, and lakefront ad directories under home rentals in West Friendship Maryland and West Friendship short term rentals.
Notice and notice vacation homes in Wicomico Maryland, Wicomico Maryland bed and breakfast rentals, rental home Wicomico, and Wicomico home rentals.
You can originate, ferret out, and devise rental houses in West Friendship Maryland and rent houses in West Friendship Maryland.
Send nice and refined evidence regarding homes for rent West Friendship Maryland and vacation rental in West Friendship Maryland found on our for rent by owner website.
Beach listed properties and exclusive ad directories vacation rental in Charles Maryland, rent house in Charles Maryland, apartment rentals in Charles, and condo rentals Charles.
Determine and originate Queen Anne short term rentals and Queen Anne United States vacation homes.
|
|
