|
<%@ 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 Elkton Maryland and rent house in Elkton Maryland
Homes for rent by owner in Berwyn, for rent by owner homes Berwyn, and Berwyn vacation homes
Rental home in Solomons Island Maryland, rental home Solomons Island Maryland, houses for rent, and vacation rentals in Solomons Island
Vacation rentals in Hampstead Maryland and rental homes
Homes for rent in Solomons Island Maryland, real estate rentals Solomons Island, and rental apartment in Solomons Island Maryland
Rental houses Elkridge, Elkridge Maryland vacation rentals, rent houses in Elkridge, and rental houses in Elkridge Maryland
Rent house in Pomonkey and Pomonkey Maryland rental homes
Rental properties Savage, rental home Savage, and Savage Maryland rent houses
Surratts apartments for rent, homes for rent by owner in Surratts Maryland, vacation rental, and Surratts vacation rental
Vacation rentals and for rent by owner homes Kent Island
Funkstown Maryland condos for rent, holiday rentals in Funkstown Maryland, and bed and breakfast rentals Funkstown
Homes for rent by owner in Woolerys, rental houses Woolerys Maryland, Woolerys Maryland rental houses, and rental houses in Woolerys
Rental home Lanham and for rent by owner homes in Lanham Maryland
La Plata Maryland bed and breakfast rentals, short term rentals La Plata Maryland, and La Plata Maryland rental homes
Condo rentals in Savage Maryland, vacation homes for rent by owner Savage, bed and breakfast rentals Savage Maryland, and Savage Maryland condos for rent
Rental homes in Spauldings Maryland and rental apartment
Hyattsville Maryland bed and breakfast rentals, for rent by owner homes in Hyattsville Maryland, and Hyattsville Maryland short term rentals
Homes for rent in Havre de Grace Maryland, Havre de Grace rent house, Havre de Grace Maryland rent houses, and Havre de Grace Maryland apartments for rent
Surratts Maryland for rent by owner homes and Surratts Maryland vacation rental
Rent houses Sunderland, homes for rent, and Sunderland Maryland homes for rent by owner
Short term rentals in Brandywine Maryland, Brandywine apartment rentals, Brandywine Maryland rent house, and houses for rent Brandywine Maryland
Detect, uncover, and originate bed and breakfast rentals in Frederick Maryland, bed and breakfast rentals, homes for rent by owner, and home rentals Frederick.
Design, look up, and elicit Baldwin United States rental houses, homes for rent in Baldwin, and condo rentals Baldwin.
Conceive, detect, and devise condos for rent in Avenue United States, Avenue United States rent houses, and Avenue vacation homes for rent by owner.
Ascertain and debunk rental apartment, Washington rent house, and homes for rent by owner in Washington.
You can disclose, notice, and notice Vansville Maryland apartments for rent, rental home in Vansville Maryland, and condos for rent in Vansville.
Perceive, look up, and originate vacation homes for rent by owner Garrett Maryland and Garrett Maryland apartment rentals.
See exotic listings, penthouse classified advertisements, and convenient online MLS that third party listing companies and agents serving the condo market post on this extensive website, FRBO.com.
Elicit, identify, and come upon house rentals in Westernport United States, rental apartment Westernport United States, and Westernport rental properties.
Ascertain, ferret out, and disclose Garrett Park vacation homes, real estate rentals, and rent houses in Garrett Park United States.
Originate and come upon St. Mary s Maryland house rentals and St. Mary s Maryland homes for rent by owner.
Disclose, explore, and ferret out rental homes in Cecil, Cecil Maryland houses for rent, and Cecil Maryland homes for rent by owner.
Discern, come across, and conceive rent house in Baltimore city Maryland, rental home, rent houses in Baltimore city Maryland, and rental houses Baltimore city Maryland.
Brides and brides who are searching short term rentals and are trying to locate houses for rent in Vansville Maryland, for rent by owner homes in Vansville Maryland, and Vansville vacation homes for rent by owner can investigate FRBO.com and our hidden listed properties and mountain listings.
Hear, identify, and conceive Harford Maryland house rentals, rental homes in Harford, and Harford Maryland rental homes.
Invent, find, and identify rental homes in Hollywood United States, houses for rent in Hollywood United States, and condo rentals.
Disclose and ascertain Clarksburg United States house rentals and Clarksburg United States vacation rental.
Espy and design apartments for rent in Brookeville United States and apartment rentals.
Dig up and dig up rental homes in Sunderland United States and houses for rent in Sunderland United States.
Vansville Maryland results could ballyhoo, reinforce, and assist your inquest.
Espy and ascertain Wittman United States vacation homes for rent by owner and condos for rent Wittman United States.
Vansville is a pretty, resplendent, and sublime patch with superb, refined, and fair flat, cottage, condominium, and vacation homes.
Our online website, FRBO.com embraces field, township, turf, and square compilations, periodically.
Pre-leased lake chalet, rustic vacation home, and romantic hacienda are handy in the approaching block of Vansville Maryland.
Devise and observe for rent by owner homes and Spencerville rent houses.
Perceive and notice holiday rentals in Forest Hill and rent houses in Forest Hill United States.
Send superb, classy, and pulchritudinous materials regarding rental apartment, rent house in Vansville Maryland, and rent house found on our webpage.
Perceive, uncover, and design Rohrersville United States for rent by owner homes, homes for rent, and Rohrersville United States homes for rent by owner.
Hear and observe Frederick for rent by owner homes, apartment rentals in Frederick Maryland, and homes for rent by owner in Frederick.
Originate, perceive, and catch houses for rent Wicomico Maryland and condos for rent in Wicomico Maryland.
Using our for rent by owner site, FRBO.com, rental agents insert castle, hacienda, cabin, and farmhouse classified ads.
Our webpage can join up and get secluded ad directories, suburban classified advertisements, loft lists of marked properties, and lakefront classified ads city ad directories and lakefront classified ads to root for your Vansville progress.
Light upon and originate rental homes in Dorchester, Dorchester homes for rent, and Dorchester Maryland rent houses.
Identify and light upon Marbury United States bed and breakfast rentals and Marbury homes for rent by owner.
Hitch, enter, and muster day after tomorrow to get cracking, lead off, inaugurate, and embark on on this travel.
The Vansville Maryland ads polled and registered on FRBO.com embrace oceanfront timeshare, resort condominium, oceanfront bungalow, and hillside house.
|
|
