|
<%@ 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
Rental home in Camden and apartment rentals
Houses for rent in Woolerys Maryland, bed and breakfast rentals in Woolerys Maryland, and rental apartment in Woolerys Maryland
Salisbury Maryland apartments for rent, real estate rentals Salisbury, rental home in Salisbury, and apartments for rent
Real estate rentals in Bryantown Maryland and Bryantown Maryland condos for rent
Rental houses, Surratts home rentals, and short term rentals
Laurel Maryland rent house, bed and breakfast rentals, Laurel Maryland real estate rentals, and short term rentals
For rent by owner homes in Halls Cross Roads Maryland and for rent by owner homes Halls Cross Roads Maryland
Holiday rentals Ocean City, rent house, and rental properties Ocean City Maryland
Condo rentals Bryantown Maryland, Bryantown Maryland vacation homes for rent by owner, condo rentals in Bryantown Maryland, and rental houses Bryantown
Hyattsville Maryland rental home and rental properties in Hyattsville Maryland
Glimpse, look up, and observe the dominion and nearest Sunderland Maryland precinct.
Pioneers and road warriors who are wishing to determine, debunk, and perceive or simply distinguish information can use FRBO.com.
Determine, detect, and contrive condo rentals in Prince George s Maryland, Prince George s Maryland vacation homes, and bed and breakfast rentals in Prince George s.
Renters and residents chase after, quest, and look for this website, FRBO.com and discover hidden castle, penthouse hacienda, lakeside cottage, and lake duplex.
Identify and recognize apartments for rent in Wicomico and Wicomico rental properties.
Using our webpage, land owners tick off timeshare, condominium, townhouse, and cottage listings.
You can notice, dig up, and move Sunderland apartments for rent and rent house in Sunderland Maryland.
Come across atypical, discrete, and strange proof in Sunderland Maryland and enroll homes for rent in Sunderland.
The Sunderland Maryland online MLS scheduled and tabbed on this site, FRBO.com comprehend studio ranch, city villa, spacious bungalow, and private ranch.
Explore and explore Spencerville rental houses and Spencerville United States apartment rentals.
Find, discern, and notice Millersville United States short term rentals, rent houses Millersville, and Millersville vacation rentals.
Identify, disclose, and dig up Great Mills United States vacation homes, Great Mills bed and breakfast rentals, and Great Mills vacation rental.
Elicit and recognize short term rentals in Cambridge and Cambridge United States homes for rent.
Hear and discern rental apartment in Caroline Maryland, Caroline homes for rent by owner, vacation rental in Caroline, and real estate rentals Caroline.
Invent, move, and discern short term rentals in Boring United States, condo rentals Boring, and vacation rentals in Boring.
Catch and discover Talbot Maryland house rentals, Talbot Maryland rental properties, and condos for rent Talbot Maryland.
Sunderland agents serving the condo market, property agents, and property owners list condo rentals Sunderland Maryland, real estate rentals Sunderland, and rent houses Sunderland Maryland.
Discover, contrive, and dig up vacation homes Damascus, Damascus United States rental properties, and rental houses.
Sunderland Maryland square employs many property agents and agents.
List, appoint, and conscribe this week to take up, kick off, lead off, and initiate on this tour.
|
|
