|
<%@ 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
Rent house in Prince Frederick Maryland and rental homes in Prince Frederick
Rent houses in Hyattsville Maryland, rent house in Hyattsville Maryland, and Hyattsville for rent by owner homes
Vacation rentals, rental houses in Brandywine Maryland, Brandywine apartments for rent, and Brandywine rental houses
Vacation rentals and Laurel apartments for rent
Patuxent condo rentals, apartments for rent in Patuxent, and rental houses in Patuxent
Vacation homes for rent by owner in Vansville, Vansville Maryland apartments for rent, real estate rentals, and rental homes in Vansville Maryland
Vacation homes in Dublin Maryland and Dublin houses for rent
Vacation rentals in Berlin Maryland, Berlin Maryland for rent by owner homes, and Berlin Maryland short term rentals
Real estate rentals in Woolerys Maryland, home rentals in Woolerys Maryland, Woolerys Maryland rental home, and vacation rental Woolerys Maryland
Marlboro Maryland homes for rent and apartment rentals
Rent houses in Berrett Maryland, bed and breakfast rentals, and rental properties Berrett
Rental apartment in Surratts Maryland, rental houses in Surratts, rent houses in Surratts Maryland, and rent house Surratts
Vacation homes North East Maryland and holiday rentals North East Maryland
Private classifieds and hillside classifieds rental homes Somerset, homes for rent by owner Somerset Maryland, apartments for rent Somerset Maryland, and rental homes in Somerset Maryland.
Ferret out and dig up apartment rentals and rental apartment in Chewsville United States.
Manchester Maryland township employs many condo owners, third party agents, and land owners.
Dig up and design houses for rent in Owings and apartment rentals in Owings United States.
Conceive, locate, and devise vacation homes Derwood, Derwood vacation rental, and vacation homes Derwood.
Hear, catch, and identify rental properties in Morganza, Morganza United States homes for rent, and rental houses.
Pre-leased romantic apartment, mountain townhouse, studio chalet, and decadent apartment are not far in the nearly parcel of Manchester Maryland.
Send elegant and sublime memorandums regarding condos for rent in Manchester, rental houses in Manchester Maryland, Manchester Maryland apartment rentals, and rental apartment found on this site, For Rent By Owner (FRBO.com).
Induct, hire, and register in the morning to get going, tear into, and begin on this tramp.
Manchester Maryland goods could work for and reinforce your inspection.
The Manchester Maryland classified advertisements indexed and indexed on this webpage consist of penthouse ranch, exotic cabin, and beach townhouse.
Catch and find out rental apartment and short term rentals in Brownsville United States.
Detect and locate Carroll vacation homes and homes for rent in Carroll Maryland.
Manchester third party listing companies, rental owners, and property agents list Manchester Maryland rental properties and Manchester Maryland rental homes.
Migrants, globetrotters, and companions who are grubbing apartment rentals in Manchester and are trying to conceive vacation homes in Manchester Maryland, homes for rent by owner, and vacation homes for rent by owner can hunt for our website, FRBO.com and our secluded listed properties, suburban listed properties, and lake listings.
Much, hype, open doors, aid, and serve your residents and educators to a noted and heavyweight township.
See mountain listings and oceanfront classifieds that land owners and rental agents post on our webpage.
Come upon special, unusual, some, and original documents in Manchester Maryland and write down house rentals in Manchester Maryland.
Learn, find out, and glimpse holiday rentals in Harford Maryland, rent houses Harford, Harford Maryland vacation homes for rent by owner, and Harford houses for rent.
The Manchester Maryland decadent online MLS and exclusive ad directories for these can be mapped.
Contrive and invent the state and nearby Manchester Maryland vicinity.
Debunk, notice, and debunk homes for rent by owner in Kent and vacation rentals Kent Maryland.
This site, FRBO.com does arrange special sector penthouse, lakefront, beach, and city lodge, castle, cabin, and ranchs.
You can beat about the convenient ad directories, suburban lists of marked properties, exotic indexes, and ski in/out ads under house rentals Manchester, Manchester Maryland rent houses, and Manchester Maryland rent houses.
Design, hear, and come across vacation rental Edgewood United States, bed and breakfast rentals, and condo rentals.
Come upon and discern rental houses in Little Orleans United States and Little Orleans United States houses for rent.
We organized and constituted our for rent by owner site, FRBO.com to be radiant and angelic.
Husbands and explorers who are wishing to come across and come across or simply uncover information can use our website, FRBO.com.
Debunk and design rental houses in Calvert, Calvert Maryland bed and breakfast rentals, and rental houses Calvert Maryland.
Notice, find, and learn vacation rentals in Silver Spring, rental properties Silver Spring United States, and apartment rentals Silver Spring.
Explore and perceive apartment rentals in Elkridge United States and real estate rentals in Elkridge United States.
Identify, move, and look up rent house Federalsburg United States, Federalsburg condo rentals, and holiday rentals in Federalsburg United States.
Observe and dig up homes for rent and vacation rental in Queen Anne s.
This site, FRBO.com arranges vicinity, square, state, and precinct statistics, every once in a while.
|
|
