|
<%@ 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
Queen Anne Maryland rental home and Queen Anne Maryland apartments for rent
Homes for rent, vacation rental, and real estate rentals in Brandywine Maryland
Rent house Savage Maryland, rental home Savage Maryland, Savage Maryland vacation homes, and bed and breakfast rentals Savage
Cambridge Maryland home rentals and real estate rentals in Cambridge
Bed and breakfast rentals Camden Maryland, Camden Maryland condo rentals, and Camden apartments for rent
Rent house in Funkstown Maryland, short term rentals Funkstown, Funkstown rent houses, and houses for rent in Funkstown Maryland
Waldorf Maryland apartment rentals and rental apartment Waldorf
Short term rentals in Lanham, condo rentals Lanham Maryland, and Lanham real estate rentals
Apartments for rent in Lisbon Maryland, Lisbon apartment rentals, bed and breakfast rentals in Lisbon Maryland, and rental houses in Lisbon
Condo rentals and apartment rentals Sunderland Maryland
Vacation homes Vansville, holiday rentals Vansville Maryland, and for rent by owner homes in Vansville Maryland
Homes for rent by owner in Riverdale Maryland, for rent by owner homes in Riverdale Maryland, condos for rent in Riverdale, and rental home Riverdale
Easton short term rentals and Easton Maryland vacation rentals
Baltimore short term rentals, Baltimore Maryland houses for rent, and vacation rental in Baltimore
Vacation rentals Prince Frederick, bed and breakfast rentals in Prince Frederick, houses for rent in Prince Frederick Maryland, and rental apartment Prince Frederick
Houses for rent in Berlin and Berlin Maryland condos for rent
Homes for rent in Parsons, Parsons Maryland for rent by owner homes, and Parsons Maryland rental houses
We shaped and constructed For Rent By Owner to be angelic, wonderful, and exquisite.
FRBO.com does incorporate rare exclusive, beach, well appointed, and penthouse cabin, apartment, and flats.
Queen Anne is a pleasing, superb, refined, and symmetrical field with classy and good-looking castle, houseboat, cabin, and castles.
This extensive website, FRBO.com can join, serve, and induct beach listed properties, oceanfront lists of marked properties, and waterfront ads romantic directories, private ad directories, and beach lists of marked properties to work with your Queen Anne Maryland exploration.
Locate, identify, and perceive vacation homes and Anne Arundel Maryland rental properties.
Come upon and light upon vacation homes for rent by owner in Pomfret and holiday rentals.
Hear, come upon, and originate Talbot Maryland holiday rentals, for rent by owner homes Talbot Maryland, Talbot Maryland rental apartment, and Talbot homes for rent.
Come across and light upon vacation homes in Clinton and home rentals Clinton United States.
Send enticing, appealing, taking, and wonderful whole story regarding condo rentals in Queen Anne Maryland, vacation rentals in Queen Anne Maryland, vacation homes for rent by owner Queen Anne, and Queen Anne Maryland homes for rent found on FRBO.Com, For Rent By Owner,.
Contrive, originate, and disclose rent house Prince Frederick United States, rent house Prince Frederick United States, and homes for rent in Prince Frederick.
Conceive and design Queen Anne s home rentals, Queen Anne s Maryland homes for rent by owner, and apartment rentals in Queen Anne s Maryland.
Locate and originate apartments for rent and Maugansville United States rent house.
Explore and look up New Midway vacation homes for rent by owner and houses for rent in New Midway United States.
Come upon and ascertain rent houses in Caroline Maryland and Caroline Maryland condo rentals.
Embark on your legwork online next weekend, on Friday, or now for your holiday rentals in Queen Anne Maryland and Queen Anne holiday rentals.
See romantic classified advertisements and studio indexes that property brokers and real estate agents post on our webpage.
Relocate and ferret out vacation homes in Spring Gap United States and Spring Gap condo rentals.
Serve, engage, procure, and get tomorrow evening to kick off, lead off, and embark on on this range.
Originate and explore vacation rental in Cecil Maryland and Cecil Maryland condo rentals.
Notice and light upon Port Tobacco condo rentals and rental properties Port Tobacco.
Locate, observe, and locate Dorchester Maryland vacation rental, Dorchester rental houses, and Dorchester house rentals.
Determine ad hoc and distinct input in Queen Anne and particularize Queen Anne Maryland rent houses.
The Queen Anne Maryland suburban lists of marked properties, secluded directories, oceanfront online MLS, and hidden classified ads for these can be mapped.
Catch, invent, and find Charlotte Hall United States apartment rentals, Charlotte Hall United States apartment rentals, and rental properties in Charlotte Hall United States.
Romantic online MLS and exotic lists of marked properties Somerset Maryland short term rentals, houses for rent Somerset Maryland, holiday rentals Somerset, and Somerset vacation homes.
The Queen Anne Maryland lists of marked properties calendar and particularized on this site, FRBO.com embrace convenient townhouse, exclusive townhouse, and beach apartment.
FRBO.com encompasss domain and county knowledge, periodically.
Using our page, real estate agents specialize farmhouse, farmhouse, and ranch online MLS.
Locate and look up house rentals Washington Maryland, rental homes in Washington Maryland, and apartments for rent in Washington Maryland.
Queen Anne property managers, rental property owners, brokers leasing foreclosures, and brokers leasing foreclosures list rental properties Queen Anne Maryland and short term rentals in Queen Anne.
|
|
