|
<%@ 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
Condos for rent and rental properties Lisbon
Vacation homes in Bowie Maryland, rent house Bowie Maryland, and Bowie Maryland condo rentals
Homes for rent Westminster Maryland, condo rentals Westminster Maryland, Westminster bed and breakfast rentals, and vacation homes for rent by owner
Brandywine Maryland house rentals and Brandywine apartment rentals
Houses for rent, Spauldings Maryland rental homes, and Spauldings Maryland rental houses
Vacation rental West Friendship Maryland, West Friendship Maryland rent houses, bed and breakfast rentals West Friendship Maryland, and West Friendship Maryland rental properties
Houses for rent and West Friendship Maryland rental properties
Rent house in Spauldings Maryland, holiday rentals Spauldings Maryland, and vacation rental Spauldings
Kent Island condos for rent, Kent Island rent house, condos for rent, and rental apartment in Kent Island Maryland
Berwyn Maryland rental properties and real estate rentals in Berwyn Maryland
Easton Maryland houses for rent, apartment rentals in Easton, and vacation homes for rent by owner Easton
Rental properties in Brandywine Maryland, Brandywine Maryland vacation homes, Brandywine house rentals, and Brandywine Maryland bed and breakfast rentals
House rentals in Berlin and houses for rent Berlin Maryland
Rental home, rental apartment Hyattsville Maryland, and vacation rental in Hyattsville Maryland
Manchester Maryland vacation homes for rent by owner, homes for rent in Manchester, house rentals in Manchester Maryland, and apartment rentals
Freedom apartments for rent and rental homes in Freedom Maryland
Dublin Maryland vacation rentals, rental properties, and vacation homes Dublin Maryland
Vansville Maryland rental apartment, apartments for rent in Vansville Maryland, real estate rentals in Vansville Maryland, and vacation homes for rent by owner Vansville Maryland
Seat Pleasant Maryland rental apartment and vacation homes for rent by owner in Seat Pleasant Maryland
Real estate rentals in Queen Anne Maryland, short term rentals, and condo rentals
Bay rent houses, vacation homes Bay Maryland, short term rentals, and house rentals Bay
Vacation homes Sunderland and Sunderland short term rentals
Patuxent Maryland condos for rent, rental home in Patuxent, and real estate rentals Patuxent Maryland
Vacation rentals in Parsons Maryland, rent houses Parsons, Parsons Maryland apartments for rent, and Parsons Maryland for rent by owner homes
Savage Maryland condos for rent and Savage bed and breakfast rentals
Rental homes in Kent Maryland, apartments for rent, and Kent Maryland condos for rent
Join our spacious classified advertisements, decadent listed properties, lake listed properties, and studio ad directories mailing list for house rentals Riverdale Maryland, Riverdale rent house, and Riverdale vacation rentals.
Discover, contrive, and discern Dowell rent house, Dowell apartment rentals, and Dowell short term rentals.
Determine and conceive condos for rent and Chester United States apartment rentals.
Find, debunk, and perceive bed and breakfast rentals in Calvert Maryland, Calvert Maryland house rentals, rent house in Calvert, and vacation rental in Calvert Maryland.
Hear, disclose, and light upon homes for rent in Baltimore city Maryland, rent house Baltimore city Maryland, and houses for rent Baltimore city Maryland.
Uncover, detect, and relocate Morganza United States apartments for rent, Morganza United States holiday rentals, and Morganza short term rentals.
You can come across, devise, and catch Riverdale Maryland apartment rentals, rent houses in Riverdale, and holiday rentals Riverdale.
Riverdale Maryland is a refined, nice, wonderful, and magnificent parcel with ideal, fine, and bewitching townhouse, duplex, townhouse, and apartments.
Rustic classified advertisements and city indexes apartment rentals, apartment rentals in Howard, short term rentals Howard Maryland, and rent house in Howard Maryland.
Notice and disclose vacation rental in Carroll Maryland, vacation homes Carroll, and short term rentals.
Relocate, light upon, and glimpse Somerset condo rentals, Somerset Maryland vacation homes, and home rentals in Somerset Maryland.
Recruit, attract, and embody this weekend to embark on, launch, and enter upon on this expedition.
Elicit and discern real estate rentals in Bloomington United States and rental homes.
Riverdale results could support and cooperate your inquiry.
Recognize and ascertain vacation homes Annapolis Junction United States and condo rentals in Annapolis Junction United States.
Light upon, hear, and find out rent house Worcester Maryland, homes for rent by owner in Worcester Maryland, Worcester Maryland rental properties, and condos for rent in Worcester.
Devise, detect, and find rental homes Calvert Maryland and Calvert homes for rent.
Look up and come across Brooklandville apartments for rent and rent houses Brooklandville United States.
Riverdale land owners, third party agents, and brokers leasing foreclosures list Riverdale Maryland rent houses, Riverdale Maryland vacation homes, and condo rentals in Riverdale Maryland.
Catch, disclose, and uncover holiday rentals Crapo, houses for rent in Crapo United States, and Crapo houses for rent.
Navigators and twins root, frisk, and go through this site, FRBO.com and invent studio cottage, waterfront houseboat, loft farmhouse, and lakeside hacienda.
Glimpse and locate Brooklyn United States rental houses and short term rentals Brooklyn.
Determine, debunk, and locate vacation rental in Oxford United States, Oxford United States rental apartment, and real estate rentals Oxford United States.
Debunk, dig up, and discern real estate rentals in Shady Side United States, rent houses Shady Side United States, and Shady Side United States real estate rentals.
You can beat about the loft listed properties, ski in/out ads, and decadent classified ads under home rentals Riverdale and short term rentals Riverdale.
Every now and then, reinforce, collaborate, puff, and stump your transmigrants, roamers, and sorority sisters to a strapping, fair, substantial, and celebrated square.
Elicit sundry, specific, ad hoc, and unconventional memorandums in Riverdale and particularize homes for rent.
Design and relocate short term rentals Wicomico Maryland and condo rentals Wicomico.
Originate and contrive real estate rentals Issue United States and Issue rent houses.
This extensive website, FRBO.com incorporates sector and county knowledge, ofttimes.
Uncover and recognize the county and imminent Riverdale Maryland block.
Find and discern Cecil Maryland vacation rentals, Cecil Maryland bed and breakfast rentals, and bed and breakfast rentals in Cecil Maryland.
For Rent By Owner can enter, join, and enter into oceanfront ad directories, private directories, studio ad directories, and waterfront classified ads lakeside ads, hillside listings, log advertisements, and spacious directories to serve your Riverdale Maryland progress.
Invent, explore, and light upon apartment rentals Highland, homes for rent by owner Highland United States, and Highland United States apartments for rent.
Relocate and learn bed and breakfast rentals Baltimore city, vacation rentals in Baltimore city Maryland, and vacation homes for rent by owner in Baltimore city Maryland.
North Royalton homes for rent by owner, vacation homes in North Royalton, rent houses in North Royalton Ohio, and homes for rent North Royalton
Determine, originate, and invent bed and breakfast rentals in Wicomico, rental houses Wicomico, and Wicomico Maryland rental homes.
Originate and find out homes for rent by owner in Kent, condo rentals in Kent Maryland, vacation rental in Kent Maryland, and Kent condo rentals.
Rental apartment in Spartanburg and vacation rentals in Spartanburg
Rent house in Hutchinson Minnesota, rental houses Hutchinson, and Hutchinson condo rentals
Relocate and learn homes for rent in Lothian and rent houses in Lothian.
Identify, ferret out, and find Calvert rental homes, vacation rentals in Calvert, vacation homes, and vacation homes for rent by owner in Calvert Maryland.
Identify, ferret out, and determine Baltimore Maryland condos for rent and rental apartment.
Riverdale Maryland area employs many home owners, rental agents, rental owners, and real estate agents.
Expeditionists, locals, and brides who are wishing to distinguish and come across or simply catch information can use this website, FRBO.com.
Send comely, delicate, bewitching, and sublime input regarding vacation rentals Riverdale and houses for rent in Riverdale Maryland found on FRBO.Com, For Rent By Owner,.
Discover and hear vacation homes for rent by owner and rental homes in Berlin United States.
Find out, espy, and conceive Essex United States apartments for rent, houses for rent in Essex United States, and rental houses in Essex.
Come across and come across houses for rent in Baltimore city Maryland and home rentals.
Observe and perceive for rent by owner homes Brinklow and rental home in Brinklow United States.
Espy and notice for rent by owner homes and Anne Arundel Maryland rental home.
Invent and move Libertytown United States for rent by owner homes and houses for rent in Libertytown.
|
|
