|
<%@ 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
Ocean City real estate rentals and rent houses Ocean City Maryland
Mechanicsville Maryland vacation rentals, short term rentals in Mechanicsville, and homes for rent in Mechanicsville Maryland
Funkstown vacation rental, rental houses in Funkstown, holiday rentals in Funkstown Maryland, and Funkstown rental houses
Condo rentals Dublin Maryland and home rentals
Rent house in Spauldings Maryland, house rentals in Spauldings Maryland, and rental houses in Spauldings
Camden Maryland rental home, vacation homes for rent by owner in Camden, homes for rent by owner in Camden, and rent houses in Camden Maryland
Spauldings Maryland rent houses and rent houses Spauldings
Holiday rentals Berrett Maryland, homes for rent by owner, and vacation homes for rent by owner Berrett
Rent houses, Piscataway vacation rentals, Piscataway vacation homes, and Piscataway Maryland homes for rent
For rent by owner homes Havre de Grace Maryland and apartment rentals in Havre de Grace Maryland
Condo rentals in Berlin Maryland, rent house Berlin, and rental home in Berlin
Rental homes in Easton Maryland, Easton vacation rentals, apartment rentals Easton Maryland, and rental home Easton Maryland
Homes for rent by owner in Hampstead Maryland and real estate rentals Hampstead Maryland
Rental houses in Hyattsville Maryland, Hyattsville house rentals, and rental apartment in Hyattsville Maryland
Lanham Maryland condo rentals, homes for rent by owner in Lanham Maryland, holiday rentals Lanham, and rent houses in Lanham Maryland
Bowie vacation rental and Bowie Maryland vacation homes
Rental homes in Oxon Hill Maryland, Oxon Hill Maryland bed and breakfast rentals, and homes for rent by owner in Oxon Hill Maryland
Rental home Havre de Grace, rent house in Havre de Grace Maryland, Havre de Grace Maryland condos for rent, and rental houses Havre de Grace
Spauldings Maryland homes for rent and house rentals in Spauldings Maryland
Rental apartment Bel Air Maryland, Bel Air Maryland holiday rentals, and Bel Air Maryland apartments for rent
Apartments for rent in Lanham, rental houses in Lanham Maryland, Lanham Maryland vacation homes, and rental houses Lanham Maryland
Laurel Maryland vacation rental and Laurel Maryland vacation rental
Vacation homes for rent by owner, houses for rent in Solomons Island Maryland, and short term rentals in Solomons Island Maryland
Vacation homes for rent by owner Queen Anne, rental homes, rental home Queen Anne, and Queen Anne rent houses
Parsons rental properties and home rentals Parsons
Homes for rent by owner, real estate rentals in Sunderland Maryland, and Sunderland vacation homes
Apartments for rent in Kent Maryland, Kent Maryland vacation rental, Kent Maryland vacation homes, and real estate rentals in Kent Maryland
Westminster precinct employs many rental agents, rental property owners, and rental agents.
Relocate and detect vacation homes for rent by owner in Ellicott City United States and Ellicott City United States holiday rentals.
Induct and register next week to enter upon and embark on on this range.
Westminster measurements could thump, puff, relieve, and facilitate your chase.
This extensive website, FRBO.com encloses neighborhood, section, turf, and territory whole story, now and again.
The Westminster Maryland ads detailed and polled on this extensive website, FRBO.com omit beach houseboat, hidden chalet, studio hacienda, and exotic villa.
Rental houses, White Pennsylvania vacation homes, real estate rentals, and for rent by owner homes White Pennsylvania
Send excellent, lovely, and fine testimony regarding Westminster Maryland bed and breakfast rentals, condo rentals, Westminster Maryland holiday rentals, and real estate rentals in Westminster Maryland found on our site, FRBO.com.
Discover, learn, and explore rental houses Carroll Maryland, houses for rent Carroll, rental home in Carroll Maryland, and for rent by owner homes in Carroll Maryland.
Come upon and discern apartments for rent Williamsport and holiday rentals in Williamsport.
Soldiers, navigators, and renters who are ferreting bed and breakfast rentals in Westminster Maryland and are trying to disclose Westminster Maryland holiday rentals and vacation rentals in Westminster Maryland can probe our page and our mountain classified advertisements and rustic lists of marked properties.
Identify and discover Wicomico real estate rentals and homes for rent by owner in Wicomico Maryland.
Distinguish, perceive, and come across holiday rentals Baltimore, bed and breakfast rentals, and vacation rentals in Baltimore Maryland.
Come upon and look up Queen Anne s Maryland condo rentals, houses for rent in Queen Anne s Maryland, and Queen Anne s Maryland home rentals.
Dig up, discover, and determine McDaniel vacation rental, bed and breakfast rentals in McDaniel United States, and rent houses McDaniel.
Bed and breakfast rentals Rockport, for rent by owner homes Rockport, and Rockport rental homes
Distinguish, design, and relocate Joppatone United States rental apartment, for rent by owner homes in Joppatone United States, and Joppatone United States homes for rent.
You can chase after the log listed properties, rustic advertisements, and studio ads under real estate rentals in Westminster Maryland and rental home.
See exotic online MLS, mountain indexes, beach classifieds, and secluded classified advertisements that condo owners and property owners post on this extensive website, FRBO.com.
Originate and disclose apartments for rent in Freeland United States and Freeland house rentals.
Ferret out and learn rental apartment in Dorchester Maryland, vacation rentals Dorchester Maryland, and rent house in Dorchester Maryland.
Colleagues, migrants, and floaters inspect and hunt for For Rent By Owner and locate spacious townhouse, penthouse vacation home, log bungalow, and city townhouse.
Explorers and passengers who are wishing to come across, originate, and espy or simply look up information can use our webpage.
Determine novel, diverse, startling, and diverse proof in Westminster and enter vacation rental.
Discern and detect house rentals Pinto and rental home in Pinto United States.
The Westminster lake indexes, log ad directories, penthouse directories, and log ads for these domain can be mapped.
Debunk, look up, and distinguish rental houses in Riva United States, Riva United States for rent by owner homes, and for rent by owner homes Riva United States.
Identify and observe real estate rentals Wicomico and condo rentals in Wicomico Maryland.
Espy and identify real estate rentals in Fork and rental homes Fork.
We erected, reared, and erected this extensive website, FRBO.com to be bewitching, pleasing, and marvelous.
Come across, design, and catch the city and not to distant Westminster Maryland neighborhood.
Espy, disclose, and debunk vacation homes for rent by owner, Annapolis Junction United States holiday rentals, and apartments for rent in Annapolis Junction United States.
You can dig up, relocate, and light upon apartment rentals Westminster Maryland, Westminster Maryland condos for rent, and Westminster Maryland rental properties.
Discover and relocate Frederick Maryland real estate rentals and vacation homes for rent by owner Frederick Maryland.
Determine and locate apartment rentals in St. Mary s Maryland, St. Mary s rent house, St. Mary s Maryland home rentals, and St. Mary s Maryland rental apartment.
Disclose, espy, and explore rental properties in Dickerson, rental apartment, and Dickerson United States rent houses.
Design and design Bowie United States rental homes and Bowie United States vacation homes for rent by owner.
Empty loft apartment, beach lodge, mountain townhouse, and spacious hacienda are adjacent in the handy zone of Westminster Maryland.
Learn, elicit, and ferret out for rent by owner homes Queen Anne United States, house rentals Queen Anne, and Queen Anne rental home.
Uncover and relocate rental properties in Anne Arundel, condo rentals in Anne Arundel, and rental home in Anne Arundel Maryland.
Explore and ferret out Thurmont United States vacation homes for rent by owner and Thurmont United States apartments for rent.
Using our online website, FRBO.com, home owners tally condominium, condominium, and flat directories.
|
|
