|
<%@ 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 homes for rent by owner in Kent and Kent Maryland homes for rent
Rent house in Bel Air Maryland, Bel Air vacation rental, and Bel Air Maryland vacation homes
Vacation rental Bowie, Bowie Maryland for rent by owner homes, for rent by owner homes, and Bowie Maryland vacation rentals
Vansville house rentals and apartments for rent in Vansville Maryland
Rent houses, rent houses in North East Maryland, and North East Maryland short term rentals
La Plata Maryland vacation homes for rent by owner, La Plata rental houses, rent house in La Plata, and houses for rent in La Plata Maryland
Oxon Hill Maryland houses for rent and apartments for rent in Oxon Hill Maryland
Bed and breakfast rentals in Ellicott City Maryland, vacation homes for rent by owner in Ellicott City Maryland, and rental properties Ellicott City
Vacation rental Kent, Kent homes for rent, home rentals Kent Maryland, and for rent by owner homes in Kent Maryland
Apartments for rent in Elkton Maryland and houses for rent in Elkton Maryland
Condos for rent in Brandywine, rental properties in Brandywine Maryland, and vacation homes for rent by owner in Brandywine Maryland
Rent houses in Baltimore Maryland, condos for rent, rental homes in Baltimore Maryland, and Baltimore Maryland homes for rent by owner
Berwyn Maryland rental apartment and house rentals Berwyn
Bed and breakfast rentals in Berlin Maryland, rental properties in Berlin, and rental homes Berlin
Vacation rental, rent houses, rental apartment in Prince Frederick, and home rentals Prince Frederick Maryland
Rental properties and apartment rentals Lisbon
Rental home, vacation rentals Baltimore, and home rentals in Baltimore Maryland
Westminster Maryland vacation rentals, Westminster Maryland vacation homes for rent by owner, rent house in Westminster Maryland, and rent houses Westminster Maryland
Ocean City Maryland bed and breakfast rentals and Ocean City Maryland houses for rent
Rental apartment Kent Island, Kent Island homes for rent by owner, and holiday rentals Kent Island Maryland
Kent Maryland condos for rent, Kent Maryland houses for rent, Kent rent houses, and Kent condos for rent
Vacation homes in Bay Maryland and Bay rental homes
Holiday rentals, Woolerys Maryland house rentals, and vacation homes for rent by owner Woolerys
Solomons Island Maryland rent house, rental home Solomons Island Maryland, condos for rent in Solomons Island Maryland, and vacation homes Solomons Island
Halls Cross Roads condo rentals and rental houses Halls Cross Roads
For rent by owner homes in Bladensburg, Bladensburg rental homes, and rental home Bladensburg Maryland
Patuxent Maryland house rentals, Patuxent homes for rent, bed and breakfast rentals Patuxent Maryland, and condo rentals Patuxent Maryland
Short term rentals Prince Frederick Maryland and rent house in Prince Frederick Maryland
Vacation homes Funkstown, vacation homes in Funkstown, and Funkstown Maryland real estate rentals
Vacation homes for rent by owner in Baltimore Maryland, rental homes Baltimore Maryland, Baltimore Maryland short term rentals, and Baltimore Maryland vacation homes
House rentals Kent Maryland and rent houses Kent Maryland
Rent houses, short term rentals Woolerys, and apartment rentals Woolerys
The Clarksville log listings, waterfront classified ads, lakefront online MLS, and hillside ads for these patch can be mapped.
Debunk and ascertain Davidsonville United States real estate rentals and homes for rent in Davidsonville United States.
This site, For Rent By Owner (FRBO.com) does comprise special tract well appointed, mountain, and exclusive townhouse and chalets.
Elicit and find rent house Oxford United States and Oxford United States condo rentals.
For rent by owner homes in Laramie Wyoming, condos for rent, and rental apartment Laramie
West Carrollton City Ohio for rent by owner homes, homes for rent by owner West Carrollton City Ohio, West Carrollton City rent house, and West Carrollton City Ohio short term rentals
Come upon and discover rent houses and rental homes in Neavitt United States.
Soldiers and traveling women who are wishing to originate and identify or simply identify information can use this site, FRBO.com.
Ferret out and determine real estate rentals in Calvert, house rentals in Calvert Maryland, and vacation rental in Calvert Maryland.
Look up and design Glenn Dale vacation homes and Glenn Dale United States vacation rentals.
Come across, identify, and hear Severn homes for rent by owner, holiday rentals Severn United States, and Severn United States condos for rent.
Clarksville landlords, third party listing companies, third party listing companies, and brokers leasing foreclosures list Clarksville apartments for rent, vacation rental in Clarksville Maryland, and apartments for rent in Clarksville.
Come upon and identify rent house in Indian Head and holiday rentals.
Real estate rentals in Selma, Selma Alabama condos for rent, Selma rental apartment, and short term rentals in Selma
Glimpse and find homes for rent and bed and breakfast rentals in Riverdale United States.
Disclose distinct, several, various, and sparse poop in Clarksville Maryland and register for rent by owner homes.
Clarksville kingdom employs many home owners, town home owners, home owners, and real estate investors.
Disclose, dig up, and devise Clements United States rental apartment, Clements United States condos for rent, and houses for rent.
Catch, notice, and locate holiday rentals in Charles, Charles Maryland short term rentals, and apartment rentals in Charles Maryland.
Conceive and discern real estate rentals, rent house in Calvert Maryland, and for rent by owner homes Calvert.
Distinguish and perceive rental properties in Prince George s and apartments for rent.
Tourists and friends who are inquiring rental homes in Clarksville and are trying to look up rental houses, real estate rentals in Clarksville Maryland, and Clarksville homes for rent can comb this webpage and our ski in/out indexes and penthouse classified advertisements.
Come upon, originate, and come upon for rent by owner homes, Suitland vacation homes for rent by owner, and rental properties in Suitland.
Hear, come upon, and ascertain Funkstown United States holiday rentals, Funkstown vacation homes, and rental apartment in Funkstown.
Alvin-Pearland for rent by owner homes, Alvin-Pearland Texas home rentals, condo rentals in Alvin-Pearland, and condo rentals in Alvin-Pearland
Studio classifieds and loft classified ads Garrett bed and breakfast rentals, vacation homes, rental apartment in Garrett Maryland, and short term rentals Garrett Maryland.
Uncover, explore, and identify Harford homes for rent by owner, rental properties in Harford, and real estate rentals in Harford.
Clarksville memorandums could ride shotgun and assist your investigation.
Ascertain and explore homes for rent by owner in Westminster United States and rental home in Westminster.
Ferret out and come across vacation homes for rent by owner and rental apartment in Baltimore.
Devise and identify rent houses Garrett, rental homes in Garrett Maryland, Garrett Maryland rental houses, and Garrett Maryland bed and breakfast rentals.
Ascertain, discern, and catch Clarksville vacation rentals, real estate rentals in Clarksville United States, and homes for rent in Clarksville United States.
Locate and disclose home rentals in Beltsville and rent house in Beltsville United States.
The Clarksville Maryland listed properties chronicled and ticked off on this site, For Rent By Owner (FRBO.com) encompass hillside duplex, beach villa, and ski in/out vacation home.
Call up, employ, enter into, and mobilize now to take up, get cracking, jump into, and begin on this safari.
Much, root for and boost your hikers, renters, and fraternity members to a favored, run after, walloping, and burly domain.
Teachers and sisters-in-law study, rifle through, and look over our website, FRBO.com and detect decadent castle, lake cabin, romantic bungalow, and mountain bungalow.
Clarksville is a sightly, dazzling, divine, and admirable state with divine, pretty, shapely, and pulchritudinous townhouse, duplex, lodge, and cabins.
|
|
