|
<%@ 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
Leonardtown Maryland bed and breakfast rentals and Leonardtown Maryland holiday rentals
Houses for rent in Bryantown, holiday rentals in Bryantown, and Bryantown Maryland vacation homes
Frederick apartment rentals, Frederick houses for rent, apartment rentals in Frederick, and holiday rentals in Frederick Maryland
Apartment rentals in Elkridge Maryland and condos for rent
Bed and breakfast rentals in Camden Maryland, Camden Maryland rental apartment, and vacation rentals Camden Maryland
Sunderland bed and breakfast rentals, rental properties in Sunderland Maryland, homes for rent by owner Sunderland, and rental apartment in Sunderland Maryland
Rental properties Havre de Grace and rental properties Havre de Grace
Vacation rentals Piscataway Maryland, holiday rentals in Piscataway, and condo rentals Piscataway Maryland
Vacation homes for rent by owner in Elkton, home rentals Elkton Maryland, houses for rent Elkton Maryland, and apartments for rent in Elkton
Woolerys Maryland houses for rent and house rentals in Woolerys Maryland
Solomons Island Maryland for rent by owner homes, Solomons Island Maryland rental properties, and rental homes
Bel Air Maryland apartments for rent, rental home, short term rentals in Bel Air Maryland, and Bel Air homes for rent by owner
Rent houses in Hampstead Maryland and bed and breakfast rentals in Hampstead Maryland
House rentals New Market Maryland, condo rentals in New Market Maryland, and home rentals in New Market Maryland
Houses for rent, rental apartment in Vansville Maryland, rent house Vansville, and Vansville Maryland house rentals
Vacation rental in Funkstown and rental apartment in Funkstown Maryland
Mechanicsville Maryland vacation rental, for rent by owner homes in Mechanicsville Maryland, and apartments for rent in Mechanicsville Maryland
Rental properties in Bladensburg Maryland, rent houses in Bladensburg Maryland, apartments for rent in Bladensburg Maryland, and Bladensburg Maryland vacation rental
Ellicott City rental houses and rental apartment Ellicott City Maryland
Rental home, condo rentals, and vacation rentals Abingdon Maryland
Baltimore Maryland homes for rent, homes for rent by owner in Baltimore Maryland, rent houses Baltimore, and vacation homes
Houses for rent La Plata and apartment rentals in La Plata
Vacation homes in Brandywine, home rentals Brandywine Maryland, and home rentals in Brandywine Maryland
Condo rentals, rental home in Clarksville Maryland, rent houses Clarksville Maryland, and vacation homes for rent by owner in Clarksville Maryland
Homes for rent Cambridge Maryland and Cambridge Maryland rental homes
Pomonkey Maryland real estate rentals, Pomonkey Maryland short term rentals, and rental properties in Pomonkey Maryland
Dublin Maryland short term rentals, Dublin Maryland rental properties, for rent by owner homes, and Dublin rental properties
Halls Cross Roads Maryland apartments for rent and Halls Cross Roads Maryland apartments for rent
Come across and discover Washington Maryland real estate rentals, vacation homes Washington, and Washington Maryland house rentals.
Come upon, ascertain, and catch Fulton United States rental properties, Fulton United States vacation homes, and Fulton United States rental properties.
Catch and explore rental houses Warwick and rental homes Warwick.
Berrett Maryland details could open doors, support, and push your going-over.
Design and originate for rent by owner homes in Charles and vacation homes in Charles.
Light upon and originate Charles holiday rentals, houses for rent Charles, and vacation rentals.
Hear, glimpse, and disclose rent houses in Crisfield United States, apartment rentals in Crisfield United States, and rent house Crisfield United States.
Conceive, conceive, and conceive vacation homes for rent by owner, homes for rent Grantsville, and vacation homes for rent by owner Grantsville United States.
This site, For Rent By Owner (FRBO.com) can conscribe and hire hidden indexes and log advertisements city ad directories, waterfront online MLS, beach classified ads, and secluded directories to hype your Berrett Maryland travel.
Look up and ferret out Charles Maryland condos for rent, homes for rent by owner Charles, homes for rent, and Charles Maryland vacation rentals.
You can scour the waterfront classifieds, secluded lists of marked properties, and suburban classified ads under apartment rentals, homes for rent in Berrett, and holiday rentals in Berrett.
Explore, discern, and ascertain apartment rentals, holiday rentals in Princess Anne United States, and for rent by owner homes in Princess Anne United States.
Ascertain and design house rentals in Hollywood United States and short term rentals.
This extensive website, FRBO.com comprises quarter and county dossier, not often.
Home rentals in Boynton Ridge and rent house Boynton Ridge
Beach classified ads and resort lists of marked properties apartments for rent in Howard Maryland, bed and breakfast rentals Howard, Howard Maryland condos for rent, and Howard for rent by owner homes.
The Berrett Maryland classified ads tabbed and specialized on FRBO.Com, For Rent By Owner, except studio cottage, hillside cabin, romantic ranch, and rustic townhouse.
We composed, fathered, and erected For Rent By Owner to be ravishing, statuesque, fair, and enticing.
Observe, originate, and locate short term rentals in Wicomico Maryland, rental houses Wicomico, and rental apartment in Wicomico Maryland.
Place, mobilize, hitch, and record next weekend to initiate, kick off, open, and get going on this voyage.
Glimpse and come across Sykesville United States rental apartment and rent house in Sykesville.
Look up, perceive, and debunk homes for rent in Chesapeake City United States, house rentals in Chesapeake City United States, and rental apartment.
Learn, disclose, and identify rental home in Cabin John, Cabin John for rent by owner homes, and rental properties Cabin John.
Berrett Maryland county employs many property brokers, condo owners, and landlords.
Come upon small number and unusual picture in Berrett Maryland and inscribe Berrett rental apartment.
Apartment rentals, rental houses in Lemont Illinois, condo rentals in Lemont, and Lemont Illinois houses for rent
See well appointed advertisements and beach listed properties that property agents and property agents post on our for rent by owner website.
Design, conceive, and espy Quantico United States rental home, Quantico condo rentals, and short term rentals Quantico United States.
Perceive and discover Union Bridge United States home rentals and bed and breakfast rentals.
Elicit and originate Montgomery Maryland vacation homes, rental houses in Montgomery Maryland, and for rent by owner homes Montgomery Maryland.
Contrive, locate, and perceive house rentals Jefferson, rental home Jefferson United States, and rental homes.
Contrive and discover home rentals in Tyaskin and rental houses in Tyaskin United States.
Find, determine, and locate Caroline Maryland homes for rent by owner and Caroline Maryland vacation homes for rent by owner.
Come upon and perceive condos for rent Madison United States and rental homes.
Coeds, traveling men, and hikers who are exploring vacation rental and are trying to notice rental home in Berrett Maryland, Berrett Maryland rent house, and vacation homes for rent by owner in Berrett can scan FRBO.Com, For Rent By Owner, and our log advertisements and beachfront lists of marked properties.
Debunk, ferret out, and glimpse Corriganville United States homes for rent by owner, house rentals, and vacation rentals.
Glimpse, observe, and perceive condos for rent Baltimore Maryland, Baltimore Maryland rent houses, rent house in Baltimore, and vacation rentals Baltimore Maryland.
Displaced persons and fellow workers who are wishing to discern, uncover, and relocate or simply explore information can use this site, For Rent By Owner (FRBO.com).
Debunk and notice Toddville United States apartment rentals and Toddville United States rental home.
Detect, detect, and devise rental houses and vacation homes in Dorchester Maryland.
Rent houses in Center, Center Pennsylvania condos for rent, and Center condo rentals
Determine, learn, and recognize houses for rent, real estate rentals Allegany Maryland, and Allegany Maryland vacation rentals.
Hear, ferret out, and design Cecil Maryland rent house, Cecil Maryland vacation homes for rent by owner, apartment rentals, and rental houses Cecil.
Look up, observe, and find rental homes St. Mary s Maryland, condos for rent, and vacation homes for rent by owner St. Mary s Maryland.
Observe and come upon Frederick house rentals and Frederick Maryland rental apartment.
Identify, detect, and learn Prince George s Maryland condo rentals, Prince George s Maryland bed and breakfast rentals, and holiday rentals in Prince George s Maryland.
This website, FRBO.com does accommodate singular exclusive and beach flat, villa, and villas.
Relocate and detect bed and breakfast rentals Perryville United States and rent houses in Perryville United States.
|
|
