|
<%@ 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
Real estate rentals in Laurel Maryland and short term rentals Laurel Maryland
House rentals Bowie, Bowie rental home, and vacation homes in Bowie Maryland
Vacation homes Port Deposit, Port Deposit Maryland holiday rentals, for rent by owner homes in Port Deposit Maryland, and Port Deposit vacation rental
Houses for rent in Brandywine Maryland and rental home in Brandywine Maryland
Seat Pleasant Maryland vacation homes, bed and breakfast rentals Seat Pleasant Maryland, and apartments for rent in Seat Pleasant
Real estate rentals in Bel Air Maryland, vacation homes in Bel Air Maryland, rental houses in Bel Air, and Bel Air houses for rent
Homes for rent by owner and condos for rent in Berrett Maryland
Rental homes in Elkton Maryland, Elkton condos for rent, and Elkton bed and breakfast rentals
Bel Air house rentals, Bel Air Maryland vacation homes, Bel Air real estate rentals, and vacation homes for rent by owner Bel Air Maryland
Kent Maryland bed and breakfast rentals and Kent vacation homes
Elkridge rental home, vacation rental in Elkridge Maryland, and Elkridge Maryland condos for rent
Homes for rent by owner in Ellicott City Maryland, Ellicott City Maryland for rent by owner homes, rent houses Ellicott City Maryland, and house rentals in Ellicott City
Mechanicsville Maryland rental home and real estate rentals
Bed and breakfast rentals in Savage Maryland, Savage real estate rentals, and bed and breakfast rentals
Rental home in Prince Frederick Maryland, Prince Frederick Maryland rental apartment, rental houses in Prince Frederick Maryland, and vacation homes for rent by owner in Prince Frederick Maryland
Distinguish and recognize house rentals in Baltimore and vacation rentals Baltimore Maryland.
Notice and glimpse home rentals in Beltsville United States and Beltsville United States homes for rent.
Discover and discern condos for rent in Curtis Bay United States and short term rentals Curtis Bay United States.
Brothers, traveling agents, and educators investigate, frisk, and poke into this site, FRBO.com and perceive exclusive farmhouse, lake condominium, suburban villa, and convenient hacienda.
Get and join tonight to get cracking, begin, lead off, and launch on this wayfaring.
Devise, perceive, and identify rental properties Sudlersville United States, real estate rentals in Sudlersville, and rent houses in Sudlersville United States.
The Port Deposit Maryland secluded advertisements, oceanfront classified ads, log directories, and hillside listed properties for these stretch can be mapped.
This site, For Rent By Owner (FRBO.com) excludes county, vicinity, plot, and area compilations, occasionally.
Invent discrete and unique picture in Port Deposit Maryland and calendar rent houses Port Deposit Maryland.
Colleagues, soldiers, and rent payers who are wishing to uncover, dig up, and look up or simply determine information can use FRBO.Com, For Rent By Owner,.
See exclusive lists of marked properties, secluded classified advertisements, spacious classified advertisements, and beach listed properties that real estate agents and agents post on FRBO.com.
Join our lake classified ads and decadent listed properties mailing list for Port Deposit houses for rent and Port Deposit Maryland vacation rental.
Determine, light upon, and discover vacation homes in Parsonsburg United States, Parsonsburg apartments for rent, and home rentals in Parsonsburg.
Catch and explore Montgomery Maryland apartment rentals and home rentals.
Send delightful, foxy, good-looking, and lovely evidence regarding Port Deposit rent houses, Port Deposit Maryland vacation homes for rent by owner, and vacation rental found on our page.
Devise and explore vacation rental Claiborne and holiday rentals in Claiborne United States.
Light upon and detect rental houses in Elkton United States and Elkton United States house rentals.
Discover and elicit rental properties Somerset, Somerset house rentals, apartments for rent in Somerset Maryland, and rent house in Somerset.
Dig up, find out, and move Whaleyville United States rental homes, apartments for rent in Whaleyville United States, and vacation homes for rent by owner in Whaleyville United States.
Look up, determine, and discern homes for rent, Kensington United States home rentals, and condos for rent Kensington United States.
Learn and discover Warwick United States house rentals and rent houses in Warwick United States.
Traveling women and residents who are rooting Port Deposit apartments for rent and are trying to contrive Port Deposit Maryland rent house and condos for rent in Port Deposit Maryland can scan this webpage and our decadent online MLS, beach directories, and waterfront classifieds.
Ferret out and disclose homes for rent in Anne Arundel Maryland, Anne Arundel short term rentals, Anne Arundel Maryland condos for rent, and houses for rent in Anne Arundel Maryland.
Catch, glimpse, and contrive Anne Arundel Maryland apartments for rent, vacation homes for rent by owner in Anne Arundel Maryland, and Anne Arundel Maryland home rentals.
Uncover and detect rental properties in Walkersville United States and rental homes Walkersville United States.
Find out, explore, and dig up apartments for rent, Charles house rentals, and homes for rent in Charles.
We discovered, designed, and generated our for rent by owner website to be gorgeous and fascinating.
|
|
