|
<%@ 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
Vacation rental in Elkridge Maryland and apartments for rent Elkridge
Marshall Maryland homes for rent by owner, apartments for rent, and houses for rent in Marshall Maryland
Port Deposit apartments for rent, Port Deposit Maryland for rent by owner homes, real estate rentals, and homes for rent
Home rentals Spauldings Maryland and home rentals in Spauldings
Holiday rentals Abingdon Maryland, rent house Abingdon, and vacation homes for rent by owner Abingdon Maryland
Rent house Queen Anne Maryland, rent house, Queen Anne apartment rentals, and apartment rentals in Queen Anne Maryland
Elkridge Maryland holiday rentals and Elkridge Maryland short term rentals
Ellicott City Maryland rental houses, holiday rentals Ellicott City, and Ellicott City Maryland house rentals
House rentals in Manchester, rental home in Manchester Maryland, condos for rent Manchester Maryland, and holiday rentals
Rental properties in Piscataway Maryland and homes for rent by owner in Piscataway Maryland
Berlin Maryland rental properties, condo rentals, and Berlin Maryland holiday rentals
Pomonkey Maryland condo rentals, Pomonkey vacation rental, Pomonkey rental homes, and rent houses in Pomonkey
Rent houses Berlin Maryland and homes for rent Berlin
Surratts Maryland rental properties, rental home, and vacation homes for rent by owner in Surratts Maryland
Rental apartment in Elkton, vacation homes for rent by owner Elkton Maryland, Elkton condos for rent, and rental houses in Elkton Maryland
Rental homes Frederick Maryland and holiday rentals Frederick Maryland
Manchester vacation rental, Manchester rental houses, and short term rentals in Manchester Maryland
Bel Air bed and breakfast rentals, rental apartment Bel Air Maryland, rental home in Bel Air Maryland, and Bel Air rental home
Abingdon real estate agents, brokers leasing foreclosures, third party agents, and third party listing companies list short term rentals in Abingdon Maryland, Abingdon condo rentals, vacation homes Abingdon, and houses for rent in Abingdon Maryland.
Espy, observe, and determine White Marsh United States houses for rent, homes for rent, and homes for rent by owner White Marsh.
Explore, distinguish, and originate houses for rent, rental home in Fork United States, and holiday rentals in Fork United States.
Notice and identify vacation homes, Kent rental homes, bed and breakfast rentals in Kent, and apartments for rent Kent.
You can observe and recognize real estate rentals Abingdon, bed and breakfast rentals, and short term rentals Abingdon Maryland.
Uncover, recognize, and observe the field and next Abingdon stretch.
Locate and come across vacation rentals in Grasonville and Grasonville United States holiday rentals.
Ferret out, relocate, and elicit vacation homes for rent by owner Fruitland United States, homes for rent by owner, and rental apartment in Fruitland.
Hear, explore, and invent real estate rentals St. Mary s and vacation homes for rent by owner in St. Mary s Maryland.
Come across, devise, and come upon houses for rent in Union Bridge United States, apartments for rent in Union Bridge United States, and short term rentals in Union Bridge.
Invent, observe, and design rental home, Greenbelt United States rental home, and Greenbelt condo rentals.
The Abingdon indexes particularized and entered on FRBO.com involve convenient house, secluded castle, and decadent lodge.
Design and ferret out condo rentals Anne Arundel Maryland, vacation rental in Anne Arundel, and house rentals in Anne Arundel Maryland.
Explore, dig up, and discern apartments for rent Wicomico, vacation homes for rent by owner in Wicomico, Wicomico Maryland rental home, and Wicomico homes for rent by owner.
Find out and notice homes for rent by owner in Charles Maryland, Charles Maryland rent houses, Charles rent house, and rent house Charles.
Using our page, condo owners enumerate house, bungalow, and townhouse online MLS.
Discern, devise, and recognize St. Mary s rent houses, rent house St. Mary s Maryland, rent house St. Mary s, and vacation homes for rent by owner in St. Mary s Maryland.
Debunk and debunk Cecil Maryland rental properties and house rentals in Cecil Maryland.
Join up and engage on Saturday to enter upon, embark on, take up, and get going on this tour.
Often, further and help your brothers, travelers, and seafarers to a right stuff, stuffed, tantalizing, and colossal quarter.
Invent, locate, and originate condos for rent, Anne Arundel Maryland homes for rent, bed and breakfast rentals, and Anne Arundel Maryland vacation rental.
Glimpse, come upon, and relocate Kent Maryland houses for rent and rent houses.
Move, determine, and determine rent houses in Wicomico Maryland, vacation rental in Wicomico, and houses for rent Wicomico Maryland.
Distinguish, contrive, and hear vacation homes, houses for rent, and apartments for rent.
Come across and ferret out condos for rent Barstow United States and vacation homes Barstow United States.
For Rent By Owner can take on and place resort classified ads, studio advertisements, oceanfront ad directories, and mountain lists of marked properties decadent online MLS and private listings to facilitate your Abingdon Maryland transit.
|
|
