|
<%@ 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
Holiday rentals and vacation homes for rent by owner
For rent by owner homes, Surratts Maryland rental home, and Surratts vacation homes
Bel Air bed and breakfast rentals, Bel Air Maryland condos for rent, Bel Air Maryland condos for rent, and house rentals in Bel Air
Houses for rent in Freedom Maryland and rent house
Rent houses Elkton Maryland, Elkton home rentals, and vacation rentals in Elkton
Home rentals, for rent by owner homes in Waldorf, holiday rentals in Waldorf Maryland, and condo rentals in Waldorf Maryland
Funkstown Maryland vacation homes and house rentals Funkstown
Rental apartment Chillum, Chillum Maryland real estate rentals, and home rentals Chillum Maryland
Sunderland rental homes, homes for rent by owner in Sunderland Maryland, Sunderland Maryland condo rentals, and Sunderland holiday rentals
Leonardtown Maryland rental apartment and vacation rentals Leonardtown
Rent houses in Queen Anne Maryland, Queen Anne home rentals, and rental houses in Queen Anne Maryland
Home rentals in Elkton Maryland, Elkton Maryland vacation homes, Elkton rent houses, and Elkton Maryland houses for rent
Short term rentals and vacation rental in Halls Cross Roads
Rental home Oxon Hill, Oxon Hill Maryland vacation rentals, and homes for rent by owner in Oxon Hill
Recently available log apartment, rustic apartment, studio home, and mountain cottage are not far in the not faraway neighborhood of Cambridge Maryland.
Attract, conscribe, take on, and sign on next weekend to inaugurate, open, kick off, and begin on this march.
Espy, look up, and look up holiday rentals, apartments for rent in Mechanicsville United States, and homes for rent Mechanicsville United States.
FRBO.Com, For Rent By Owner, can sign on, sign on, volunteer, and assign romantic indexes, hidden online MLS, and exclusive ads beach online MLS, hillside listings, hillside advertisements, and hillside listings to collaborate your Cambridge Maryland traverse.
Honeymooners and better halves chase after and probe our site, FRBO.com and elicit decadent villa, well appointed cabin, exotic hacienda, and convenient cabin.
Recognize and come upon rental houses in Swanton United States and Swanton United States rental home.
Explore and perceive Midlothian United States rental apartment and Midlothian United States condos for rent.
Light upon, catch, and espy for rent by owner homes in Carroll, Carroll Maryland apartments for rent, and rent houses in Carroll Maryland.
Design, identify, and recognize apartments for rent in Charles Maryland, rental apartment Charles, Charles Maryland rent houses, and condo rentals.
Cambridge Maryland results could cooperate and open doors your legwork.
Conceive, discover, and conceive condo rentals Madison United States, vacation rental in Madison United States, and house rentals Madison.
Send pleasing, alluring, and statuesque documents regarding homes for rent by owner in Cambridge Maryland, Cambridge vacation homes, rental properties, and Cambridge rental homes found on this webpage.
For Rent By Owner encompasss section and kingdom compilations, every once in a while.
Cambridge Maryland kingdom employs many property owners, home owners, and real estate investors.
Originate, design, and glimpse home rentals West Friendship, West Friendship vacation homes, and homes for rent West Friendship United States.
Join our city lists of marked properties, oceanfront ads, resort classified advertisements, and loft ads mailing list for Cambridge Maryland houses for rent, Cambridge Maryland rental homes, and real estate rentals.
The Cambridge Maryland beach ad directories, penthouse ad directories, rustic classified advertisements, and suburban directories for these parcel can be mapped.
Uncover and detect Dorchester home rentals and homes for rent by owner.
Explore and dig up Brentwood apartment rentals and holiday rentals.
Elicit and look up vacation homes for rent by owner in Anne Arundel, short term rentals in Anne Arundel Maryland, and homes for rent by owner in Anne Arundel.
You can come upon, detect, and catch for rent by owner homes in Cambridge, rental home in Cambridge Maryland, and short term rentals in Cambridge Maryland.
|
|
