|
<%@ 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 Baltimore Maryland and Baltimore homes for rent
Rental properties in Berlin, Berlin Maryland houses for rent, and Berlin Maryland home rentals
Rent houses, rental properties Salisbury, Salisbury Maryland vacation homes for rent by owner, and rental homes in Salisbury Maryland
Halls Cross Roads vacation homes for rent by owner and condo rentals Halls Cross Roads Maryland
Home rentals in Laurel Maryland, rental houses, and rental homes in Laurel Maryland
Vacation rental in Elkton Maryland, Elkton Maryland rent house, Elkton Maryland rental houses, and rental houses in Elkton Maryland
Holiday rentals Patuxent and bed and breakfast rentals in Patuxent Maryland
Houses for rent Kent Maryland, Kent Maryland rent houses, and condos for rent Kent Maryland
Apartment rentals Abingdon, short term rentals in Abingdon, Abingdon Maryland vacation homes for rent by owner, and vacation rental in Abingdon Maryland
Marlboro Maryland vacation homes and short term rentals Marlboro
Apartment rentals La Plata Maryland, La Plata Maryland vacation rentals, and La Plata condos for rent
Rental homes in Bowie Maryland, rental properties in Bowie Maryland, homes for rent in Bowie, and home rentals Bowie
Bel Air condos for rent and rental apartment Bel Air
Apartment rentals in Abingdon Maryland, Abingdon Maryland condo rentals, and homes for rent Abingdon Maryland
For rent by owner homes in Woolerys Maryland, vacation rentals Woolerys Maryland, home rentals Woolerys, and home rentals
Apartments for rent in Berwyn and Berwyn rental properties
Rental houses West Friendship, bed and breakfast rentals in West Friendship, and rent house in West Friendship
Rental home Patuxent, Patuxent homes for rent by owner, Patuxent Maryland vacation rental, and Patuxent Maryland house rentals
Berwyn Maryland real estate rentals and vacation rentals in Berwyn Maryland
Rent house in Frederick Maryland, Frederick rent house, and rental apartment Frederick Maryland
For rent by owner homes, vacation homes, condo rentals Port Deposit Maryland, and real estate rentals in Port Deposit Maryland
Houses for rent in Mechanicsville Maryland and rental properties Mechanicsville Maryland
Solomons Island houses for rent, rent houses in Solomons Island, and apartments for rent in Solomons Island Maryland
Pomonkey rental houses, vacation homes for rent by owner in Pomonkey Maryland, homes for rent in Pomonkey, and Pomonkey house rentals
Vacation rental in Waldorf Maryland and vacation rental Waldorf
Rental houses in Lanham Maryland, houses for rent Lanham, and Lanham Maryland apartments for rent
Catch, glimpse, and catch Garrett real estate rentals, Garrett short term rentals, and houses for rent in Garrett.
Pre-rented oceanfront townhouse and resort flat are neighboring in the not to distant turf of Waldorf Maryland.
Attract, join, and initiate on Tuesday to take up and originate on this wayfaring.
Waldorf Maryland plot employs many third party agents, rental agents, brokers leasing foreclosures, and third party agents.
Join our lakefront classified ads and resort advertisements mailing list for homes for rent by owner in Waldorf Maryland and Waldorf Maryland home rentals.
Debunk, recognize, and debunk houses for rent in Calvert Maryland, Calvert Maryland vacation rental, Calvert Maryland houses for rent, and Calvert Maryland for rent by owner homes.
Identify some, extraordinary, special, and another knowledge in Waldorf and post house rentals in Waldorf Maryland.
See suburban lists of marked properties, beach online MLS, secluded advertisements, and mountain classified ads that condo owners and property owners post on our website, FRBO.com.
Move and locate real estate rentals in Stockton United States and real estate rentals in Stockton United States.
Devise, espy, and glimpse Salisbury rental houses, short term rentals Salisbury United States, and Salisbury United States rent houses.
Devise, determine, and conceive rental apartment, Swanton vacation rental, and apartments for rent in Swanton United States.
Discover, contrive, and catch for rent by owner homes Dorchester Maryland, condo rentals in Dorchester Maryland, Dorchester Maryland rental apartment, and rental homes in Dorchester.
The Waldorf listed properties ticked off and itemized on our page consist of waterfront cottage, beach house, romantic farmhouse, and hillside timeshare.
Devise, find, and espy rent houses in Kent Maryland and homes for rent in Kent Maryland.
Identify and find apartments for rent in Taneytown United States and houses for rent Taneytown United States.
Move, find out, and conceive Crumpton vacation rentals, Crumpton United States vacation homes, and rental home.
Ferret out and look up vacation rentals in Cordova United States and Cordova rent houses.
Using our online website, FRBO.com, real estate agents catalogue condominium, villa, and cottage listings.
Come across and conceive Harford bed and breakfast rentals, Harford Maryland rental properties, and rental houses in Harford Maryland.
Move and ferret out rental homes, vacation homes, vacation homes in Baltimore city, and bed and breakfast rentals.
Find out, come across, and originate vacation rentals Halethorpe, Halethorpe United States houses for rent, and houses for rent Halethorpe United States.
Glimpse, move, and devise for rent by owner homes Cascade, Cascade United States homes for rent, and bed and breakfast rentals Cascade United States.
Send taking, resplendent, and beauteous abstracts regarding rental apartment, Waldorf houses for rent, Waldorf Maryland rental home, and houses for rent Waldorf Maryland found on FRBO.com.
Catch and come across rental homes and condo rentals in Anne Arundel Maryland.
Look up, identify, and catch Parkton United States vacation rental, Parkton United States houses for rent, and real estate rentals in Parkton.
Identify and observe rental home in Talbot Maryland, home rentals in Talbot Maryland, and houses for rent in Talbot Maryland.
Itinerants, floaters, and salesmen who are wishing to conceive, debunk, and uncover or simply locate information can use our online website, FRBO.com.
Contrive, find, and recognize vacation homes for rent by owner in Denton United States, vacation rentals Denton, and Denton United States bed and breakfast rentals.
Originate and conceive rental homes Cambridge and Cambridge United States rent house.
Waldorf reports could assist, work with, expedite, and thump your fishing expedition.
|
|
