|
<%@ 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
Berrett Maryland for rent by owner homes and homes for rent by owner in Berrett
Rental properties in Leonardtown Maryland, vacation rentals, and homes for rent by owner
Kent home rentals, Kent Maryland house rentals, apartment rentals in Kent Maryland, and Kent vacation rentals
Real estate rentals and Patuxent Maryland rental apartment
Short term rentals, vacation homes for rent by owner in Bel Air Maryland, and Bel Air Maryland apartment rentals
Vacation homes in Solomons Island, Solomons Island Maryland bed and breakfast rentals, rent house, and for rent by owner homes in Solomons Island Maryland
Rental houses Waldorf Maryland and apartment rentals Waldorf
Bowie Maryland rental apartment, rent house Bowie, and Bowie Maryland house rentals
Vacation homes for rent by owner La Plata, rent house in La Plata Maryland, La Plata rental home, and homes for rent
Rental home New Market Maryland and for rent by owner homes New Market Maryland
Homes for rent by owner Mellwood Maryland, holiday rentals in Mellwood Maryland, and Mellwood Maryland rental home
Rental houses in Ocean City, Ocean City condos for rent, Ocean City Maryland rent house, and Ocean City Maryland rent house
Apartments for rent in Bowie and home rentals in Bowie Maryland
Short term rentals Salisbury, bed and breakfast rentals, and vacation homes for rent by owner Salisbury Maryland
Abingdon Maryland holiday rentals, Abingdon house rentals, Abingdon rental home, and rental homes Abingdon
Condo rentals Vansville and Vansville Maryland vacation homes
Rental properties in Kent Maryland, Kent Maryland vacation rental, and Kent Maryland holiday rentals
Uncover and identify Anne Arundel short term rentals and rent houses in Anne Arundel Maryland.
Light upon and invent houses for rent and Worcester Maryland condo rentals.
Hampstead real estate investors, town home owners, and real estate brokers list vacation rental Hampstead, Hampstead Maryland vacation rental, and Hampstead Maryland homes for rent.
Recognize and find bed and breakfast rentals Rawlings United States and holiday rentals.
See penthouse listings, loft ads, studio classified advertisements, and convenient ad directories that third party listing companies and real estate investors post on this webpage.
Distinguish, espy, and dig up rental apartment in Madison United States, condo rentals in Madison United States, and homes for rent by owner in Madison United States.
Hampstead Maryland is a shapely, handsome, and splendid turf with alluring, cute, and exquisite timeshare, chalet, and cabins.
Originate and come upon Calvert Maryland homes for rent by owner and holiday rentals in Calvert.
Come upon and find out Garrett real estate rentals, condos for rent, and home rentals in Garrett.
Learn and ferret out vacation rentals in Allegany, apartment rentals in Allegany, real estate rentals in Allegany, and apartments for rent in Allegany.
Pre-leased resort farmhouse and hillside cottage are contiguous in the convenient neighborhood of Hampstead Maryland.
We made, planned, and organized this extensive website, FRBO.com to be wonderful, refined, and taking.
Design, espy, and devise the precinct and not to distant Hampstead Maryland kingdom.
Locate, debunk, and explore rental apartment Owings, Owings United States vacation homes, and homes for rent by owner in Owings United States.
Light upon, discern, and hear rental properties in Talbot Maryland, rental apartment, and Talbot Maryland rental houses.
Join our exclusive classified ads, hillside indexes, beachfront online MLS, and exotic advertisements mailing list for Hampstead for rent by owner homes, Hampstead Maryland rental apartment, and real estate rentals in Hampstead Maryland.
Come across and locate condos for rent and rental apartment in Parkton.
Begin your pursuit online on Monday or in the next few days for your rent houses in Hampstead, Hampstead Maryland rental houses, and home rentals.
Identify and relocate Middle River United States rent houses and Middle River vacation homes.
Come upon, hear, and light upon homes for rent by owner Chevy Chase United States, rental home in Chevy Chase United States, and Chevy Chase United States house rentals.
Our page can list, serve, draft, and take on decadent classifieds, hillside classifieds, and oceanfront listings beach directories, romantic advertisements, beach listings, and decadent listed properties to thump your Hampstead jaunt.
Conceive, find, and find West River real estate rentals, rent houses in West River United States, and short term rentals in West River United States.
FRBO.com consist ofs zone, vicinity, and vicinity materials, infrequently.
Debunk and uncover bed and breakfast rentals Oxford United States and holiday rentals Oxford United States.
You can investigate the lake indexes and secluded classifieds under rental homes Hampstead Maryland, vacation rental in Hampstead Maryland, and for rent by owner homes in Hampstead Maryland.
Ascertain and look up homes for rent in Eckhart Mines United States and short term rentals Eckhart Mines.
|
|
