|
<%@ 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
Abingdon homes for rent and holiday rentals Abingdon Maryland
Homes for rent Baltimore, real estate rentals in Baltimore, and Baltimore Maryland rent houses
Home rentals in Havre de Grace, homes for rent by owner in Havre de Grace, vacation rental in Havre de Grace Maryland, and Havre de Grace rent house
Spauldings Maryland short term rentals and homes for rent by owner
Savage Maryland real estate rentals, Savage Maryland house rentals, and rental apartment in Savage Maryland
Frederick Maryland apartment rentals, Frederick rental properties, vacation rental in Frederick, and homes for rent by owner in Frederick
Apartments for rent Port Deposit and real estate rentals
Rental houses in Freedom Maryland, Freedom homes for rent by owner, and vacation rentals Freedom Maryland
Prince Frederick Maryland vacation homes for rent by owner, Prince Frederick Maryland rent house, Prince Frederick Maryland rental home, and home rentals Prince Frederick Maryland
Short term rentals in North East and home rentals in North East Maryland
Apartment rentals, Ellicott City Maryland vacation rentals, and Ellicott City Maryland holiday rentals
City ad directories and decadent ad directories bed and breakfast rentals in Allegany Maryland, Allegany Maryland rental houses, Allegany Maryland rental apartment, and rental properties.
Observe and espy rental apartment in Saint Michaels and Saint Michaels United States vacation rentals.
You can quest the beachfront lists of marked properties and lakefront advertisements under Bowie Maryland rent houses, short term rentals, and for rent by owner homes in Bowie.
Detect, espy, and find out Denton United States condos for rent, Denton rent houses, and house rentals in Denton United States.
This site, FRBO.com can list and join mountain ads, hidden classified ads, and rustic listings secluded lists of marked properties, rustic ads, ski in/out indexes, and lake listed properties to boost your Bowie Maryland crossing.
Detect, discover, and dig up apartment rentals in Prince George s and homes for rent by owner in Prince George s Maryland.
Bowie Maryland is a well-formed and nice block with splendid, good-looking, and splendid lodge and lodges.
Join our secluded directories and romantic classified ads mailing list for Bowie rent houses and vacation homes for rent by owner in Bowie.
Send nice, splendid, and ideal knowledge regarding vacation rentals Bowie Maryland, house rentals, and vacation homes in Bowie found on our page.
Hear and dig up St. Mary s Maryland vacation rental and condo rentals in St. Mary s Maryland.
Identify and find the field and not to distant Bowie Maryland neighborhood.
Contrive and move rental homes in Butler United States and Butler United States holiday rentals.
Bowie rental agents, land owners, rental agents, and agents list Bowie Maryland real estate rentals, holiday rentals in Bowie Maryland, and homes for rent by owner in Bowie.
You can originate and dig up vacation rentals in Bowie Maryland and rent house in Bowie Maryland.
Move, catch, and distinguish Ironsides bed and breakfast rentals, Ironsides vacation rentals, and Ironsides rental properties.
Troupers and wanderers who are prospecting rental homes Bowie Maryland and are trying to come upon Bowie Maryland apartments for rent, rent houses in Bowie Maryland, and Bowie for rent by owner homes can comb FRBO.com and our log indexes, suburban indexes, waterfront ad directories, and ski in/out listings.
This extensive website, FRBO.com does consist of discrete tract beachfront, hillside, and lake bungalow, bungalow, condominium, and duplexs.
Bowie Maryland abstracts could support, puff, and benefit your inquiry.
Natives, traveling men, and transmigrants who are wishing to devise and determine or simply glimpse information can use our page.
Discover and uncover Rock Point homes for rent and Rock Point United States rent house.
Oblige, mobilize, and record in the next few days to embark on, tear into, lead off, and get cracking on this odyssey.
Uncover and uncover rental properties in Barton United States and vacation rental in Barton.
Come across, elicit, and hear homes for rent by owner Washington Maryland, condo rentals Washington Maryland, rental properties Washington, and holiday rentals in Washington Maryland.
|
|
