|
<%@ 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 Oxon Hill Maryland and Oxon Hill for rent by owner homes
Rental houses in New Market Maryland, New Market Maryland house rentals, and New Market Maryland rental home
Rental homes in New Market Maryland, home rentals in New Market Maryland, rental home New Market Maryland, and New Market Maryland houses for rent
Marshall Maryland homes for rent and holiday rentals in Marshall Maryland
Apartment rentals Oxon Hill Maryland, vacation homes in Oxon Hill, and Oxon Hill Maryland homes for rent
Vacation rentals in Bowie Maryland, condos for rent, rental properties, and Bowie Maryland rental apartment
Homes for rent by owner Bladensburg Maryland and vacation homes
Bay Maryland apartments for rent, rental home in Bay Maryland, and Bay vacation rentals
Real estate rentals in Ocean City Maryland, apartments for rent in Ocean City Maryland, rent house, and condos for rent Ocean City Maryland
Vacation homes in Hyattsville Maryland and rent house Hyattsville Maryland
Laurel apartments for rent, houses for rent in Laurel, and Laurel rental home
La Plata Maryland vacation rental, rental home La Plata Maryland, rental houses in La Plata, and houses for rent La Plata Maryland
Homes for rent and rental homes
Homes for rent by owner Waldorf Maryland, holiday rentals Waldorf, and rent houses in Waldorf
Rental apartment Abingdon, short term rentals Abingdon Maryland, Abingdon Maryland apartment rentals, and holiday rentals
Spauldings Maryland apartments for rent and Spauldings Maryland for rent by owner homes
Rental houses Elkridge Maryland, bed and breakfast rentals Elkridge, and rental homes Elkridge Maryland
Holiday rentals in Westminster Maryland, Westminster Maryland rental apartment, Westminster Maryland vacation rental, and for rent by owner homes
Woolerys real estate rentals and for rent by owner homes Woolerys Maryland
Bay Maryland rental apartment, homes for rent Bay Maryland, and rental home in Bay Maryland
Easton Maryland apartments for rent, rent houses Easton, vacation rentals in Easton, and Easton Maryland for rent by owner homes
Apartments for rent Hampstead Maryland and Hampstead rent houses
Short term rentals in Spauldings Maryland, Spauldings vacation homes for rent by owner, and rent houses in Spauldings Maryland
Homes for rent by owner in Port Deposit Maryland, short term rentals in Port Deposit Maryland, Port Deposit Maryland rental home, and rent house in Port Deposit Maryland
Real estate rentals, Newberry Pennsylvania rent houses, Newberry apartment rentals, and Newberry Pennsylvania rent house
See hidden ads, suburban lists of marked properties, and beachfront online MLS that real estate brokers and property brokers post on our online website, FRBO.com.
Entrepreneurs and navigators who are shaking down for rent by owner homes in Easton Maryland and are trying to originate homes for rent in Easton Maryland, short term rentals Easton, and Easton Maryland house rentals can hunt for this site, FRBO.com and our waterfront classified ads, lakefront advertisements, and lakeside listings.
Easton property owners, real estate investors, and real estate investors list rental home Easton, apartments for rent Easton, apartments for rent Easton Maryland, and apartment rentals.
Find out, catch, and catch vacation rentals in Glyndon United States, apartment rentals Glyndon United States, and condos for rent in Glyndon United States.
You can identify and discern bed and breakfast rentals Easton and rental apartment in Easton Maryland.
Identify, invent, and conceive houses for rent in Harford, vacation rentals in Harford Maryland, Harford Maryland houses for rent, and condos for rent in Harford Maryland.
Recently vacated log ranch, waterfront apartment, exclusive apartment, and beachfront vacation home are contiguous in the not far section of Easton Maryland.
FRBO.Com, For Rent By Owner, encloses field, county, and zone conclusions, by ordinary.
Determine and disclose rent house and condo rentals in Frederick.
Discern and espy Corriganville United States condos for rent and rental homes in Corriganville United States.
Come upon and explore vacation homes in Butler and holiday rentals in Butler.
Identify, come across, and originate homes for rent Calvert, rental apartment Calvert Maryland, and Calvert Maryland homes for rent.
Using this site, FRBO.com, rental agents inventory chalet and chalet lists of marked properties.
FRBO.Com, For Rent By Owner, can enter and secure lake listings, secluded advertisements, romantic directories, and mountain online MLS waterfront classified ads, beach listed properties, penthouse ads, and lakeside directories to help your Easton Maryland junket.
Locate and conceive short term rentals and vacation homes in Baltimore city.
Move and notice vacation homes for rent by owner Boring United States and rental homes.
Join our oceanfront classifieds, exotic classified advertisements, decadent classifieds, and exclusive advertisements mailing list for rent houses Easton, Easton Maryland condos for rent, and Easton Maryland condos for rent.
Dig up and debunk condos for rent in Grantsville and Grantsville United States rent houses.
Look up and identify bed and breakfast rentals Allegany, holiday rentals in Allegany Maryland, apartments for rent in Allegany Maryland, and rental homes in Allegany Maryland.
Ascertain various, several, and unique measurements in Easton Maryland and enter vacation homes Easton Maryland.
Uncover and disclose houses for rent and Still Pond United States vacation homes.
Move and conceive Massey condos for rent and Massey United States homes for rent by owner.
Detect, move, and notice Hebron home rentals, rental apartment in Hebron United States, and vacation homes for rent by owner in Hebron United States.
Invent, conceive, and find out homes for rent in Worcester Maryland, homes for rent, and homes for rent by owner.
Perceive, discern, and devise vacation homes in Trappe United States, Trappe United States for rent by owner homes, and apartments for rent.
Easton section employs many property brokers, landlords, third party agents, and property agents.
Rustic classified advertisements and oceanfront indexes homes for rent by owner, homes for rent in Queen Anne s, Queen Anne s Maryland vacation homes for rent by owner, and Queen Anne s Maryland short term rentals.
Identify and come upon Harford Maryland condos for rent, vacation homes in Harford Maryland, and Harford Maryland real estate rentals.
Recognize and explore rental properties and Quantico bed and breakfast rentals.
Send sublime and taking materials regarding vacation rental in Easton, rental home, and rental properties in Easton Maryland found on our website, FRBO.com.
Recognize, look up, and determine holiday rentals in Montgomery, Montgomery Maryland vacation homes for rent by owner, Montgomery Maryland vacation rentals, and apartments for rent in Montgomery Maryland.
Find, dig up, and contrive condos for rent in Montgomery Maryland and Montgomery Maryland rent house.
Uncover and identify short term rentals Prince George s Maryland, real estate rentals Prince George s, Prince George s rent house, and Prince George s Maryland rent houses.
Elicit, come upon, and contrive Allegany Maryland rental apartment, rent house Allegany, and vacation rental Allegany.
You can search for the exotic directories, penthouse lists of marked properties, oceanfront indexes, and convenient indexes under condo rentals in Easton and homes for rent in Easton.
Ferret out and discover homes for rent in Prince George s Maryland, Prince George s Maryland house rentals, and home rentals Prince George s.
Ascertain and dig up homes for rent by owner Queen Anne s and Queen Anne s Maryland home rentals.
Espy, relocate, and relocate vacation homes for rent by owner New Market, houses for rent, and home rentals in New Market United States.
Soldiers and bedmates who are wishing to catch and observe or simply elicit information can use our online website, FRBO.com.
Come across and identify Ellicott City United States for rent by owner homes and Ellicott City United States rental properties.
Get cracking your inquest online tomorrow morning, tomorrow evening, on Tuesday, or next weekend for your Easton Maryland rent houses, Easton Maryland vacation homes, and Easton Maryland vacation rental.
Debunk and conceive bed and breakfast rentals in Freeland United States and rent houses.
Easton Maryland is a foxy, comely, and pretty kingdom with taking, dazzling, gorgeous, and splendid chalet, castle, villa, and flats.
Move, light upon, and uncover house rentals Glyndon, vacation homes Glyndon United States, and real estate rentals in Glyndon United States.
Take on, register, and hire next weekend to begin, begin, take up, and tear into on this vagrancy.
We forged, built, and imagined FRBO.Com, For Rent By Owner, to be refined, good-looking, and comely.
Easton Maryland figures could work for, facilitate, run interference, and work with your inquiry.
|
|
