|
<%@ 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
Vacation homes for rent by owner Hampstead and vacation homes in Hampstead Maryland
Rent houses Lisbon, rent house Lisbon Maryland, and rent house in Lisbon Maryland
Vacation rental in Cambridge Maryland, Cambridge rental apartment, rent house in Cambridge Maryland, and rental home Cambridge
Vacation rentals Chillum and real estate rentals
Houses for rent Easton, short term rentals Easton Maryland, and Easton house rentals
Vacation rental in Halls Cross Roads Maryland, home rentals Halls Cross Roads Maryland, homes for rent by owner in Halls Cross Roads Maryland, and apartment rentals
Easton vacation rentals and house rentals in Easton
House rentals Queen Anne Maryland, rental houses Queen Anne Maryland, and Queen Anne vacation rentals
Baltimore Maryland vacation rentals, Baltimore rent house, Baltimore Maryland short term rentals, and rent house in Baltimore Maryland
Oxon Hill Maryland rent houses and rental houses
Locate, discover, and find houses for rent in Pomfret United States, rent houses, and Pomfret holiday rentals.
Find out and explore houses for rent Caroline Maryland, Caroline Maryland rent houses, and rental apartment.
Invent, ferret out, and devise rent houses Still Pond United States, short term rentals in Still Pond, and apartment rentals.
The Chillum Maryland online MLS tallied and posted on FRBO.com comprehend lakefront timeshare and city townhouse.
Relocate and come across rental apartment in Cecil Maryland and real estate rentals in Cecil Maryland.
Chillum turf employs many agents, rental owners, and third party agents.
You can find out, come upon, and locate Chillum rental apartment and Chillum Maryland homes for rent by owner.
Our website, FRBO.com can obtain, recruit, and join up exotic listings, oceanfront lists of marked properties, and suburban lists of marked properties spacious directories, beach classifieds, spacious listed properties, and secluded listed properties to support your Chillum progress.
Using our page, agents calendar villa and townhouse ads.
Travelers and itinerants who are running down condo rentals in Chillum Maryland and are trying to contrive short term rentals Chillum Maryland and holiday rentals Chillum can look for our webpage and our studio ad directories, resort directories, secluded ad directories, and studio online MLS.
Ascertain and conceive rental apartment in Chaptico and vacation rental in Chaptico United States.
Send lovely and appealing proof regarding Chillum Maryland rent houses, for rent by owner homes in Chillum, and rent houses found on this site, FRBO.com.
Chillum real estate investors, rental owners, and property managers list rental properties in Chillum Maryland, Chillum home rentals, and real estate rentals Chillum Maryland.
|
|
