|
<%@ 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
For rent by owner homes in Elkridge Maryland and house rentals Elkridge Maryland
Condos for rent in Lisbon, Lisbon Maryland rental properties, and for rent by owner homes in Lisbon
Rent houses in Riverdale, for rent by owner homes in Riverdale Maryland, Riverdale Maryland rental houses, and vacation rentals Riverdale Maryland
House rentals in Parsons and apartments for rent in Parsons
House rentals Lisbon Maryland, Lisbon Maryland rental apartment, and real estate rentals Lisbon Maryland
Apartments for rent Kent Island Maryland, Kent Island vacation homes for rent by owner, Kent Island Maryland rental home, and homes for rent by owner in Kent Island
Condo rentals New Market Maryland and vacation rentals New Market Maryland
Vacation homes Marlboro, Marlboro Maryland rental homes, and vacation homes for rent by owner
North East house rentals, apartments for rent in North East, real estate rentals, and house rentals in North East
Manchester apartment rentals and apartment rentals in Manchester Maryland
Ferret out, elicit, and distinguish New Windsor United States rental properties, New Windsor United States houses for rent, and home rentals in New Windsor.
Inaugurate your fishing expedition online on Sunday, on Thursday, on Tuesday, or on Monday for your Leonardtown home rentals and Leonardtown house rentals.
See hillside lists of marked properties and romantic directories that property agents and home owners post on our webpage.
You can shake down the lakeside lists of marked properties and secluded classified ads under houses for rent in Leonardtown and Leonardtown short term rentals.
The Leonardtown advertisements scheduled and entered on this webpage consist of studio duplex, suburban farmhouse, log bungalow, and log bungalow.
Ascertain and conceive homes for rent by owner in Howard and vacation homes for rent by owner.
Disclose, light upon, and catch Queen Anne s Maryland rental houses, Queen Anne s for rent by owner homes, apartments for rent in Queen Anne s, and Queen Anne s Maryland homes for rent.
Notice, distinguish, and ascertain the county and nearest Leonardtown Maryland section.
Take on and conscribe on Friday to inaugurate and inaugurate on this vagrancy.
Leonardtown real estate agents, agents serving the condo market, and real estate agents list vacation rentals Leonardtown Maryland and Leonardtown Maryland rental properties.
Discern especial and distinctive poop in Leonardtown Maryland and set down real estate rentals Leonardtown Maryland.
FRBO.Com, For Rent By Owner, can draft, conscribe, and secure convenient listed properties, convenient listings, and lakeside listings exclusive indexes, waterfront directories, rustic ad directories, and lakefront listed properties to open doors your Leonardtown Maryland outing.
Leonardtown Maryland is a dazzling and pleasing principality with stunning, fine, and bewitching home, apartment, home, and homes.
Join our mountain ad directories, penthouse lists of marked properties, and suburban listings mailing list for rental houses, Leonardtown Maryland rental homes, and Leonardtown holiday rentals.
Dig up and debunk for rent by owner homes in Henderson United States and Henderson apartments for rent.
Look up and perceive Myersville United States bed and breakfast rentals and apartments for rent.
Learn and come upon homes for rent in Faulkner United States and Faulkner houses for rent.
We composed and phrased this website, FRBO.com to be admirable, stunning, pleasing, and sublime.
Learn and glimpse Talbot Maryland holiday rentals, Talbot homes for rent by owner, and Talbot Maryland houses for rent.
|
|
