|
<%@ 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 in Freedom Maryland and rental houses in Freedom Maryland
Elkton Maryland vacation homes for rent by owner, condos for rent, and for rent by owner homes in Elkton Maryland
Apartments for rent in Lisbon Maryland, short term rentals in Lisbon, vacation homes for rent by owner Lisbon Maryland, and holiday rentals in Lisbon
Vacation homes for rent by owner Bay and apartment rentals in Bay
Kent Maryland houses for rent, rental home Kent Maryland, and vacation homes for rent by owner Kent
Holiday rentals in Spauldings, rental apartment in Spauldings, vacation rentals in Spauldings Maryland, and rental homes in Spauldings Maryland
Apartments for rent in Abingdon Maryland and rent house
Holiday rentals in Halls Cross Roads Maryland, apartments for rent Halls Cross Roads, and rental houses Halls Cross Roads
House rentals in Bel Air Maryland, bed and breakfast rentals, Bel Air houses for rent, and Bel Air Maryland rental houses
Homes for rent by owner Oxon Hill and Oxon Hill Maryland apartment rentals
Vacation homes for rent by owner Chillum Maryland, vacation rentals, and rental houses in Chillum
Condo rentals Freedom, Freedom Maryland rent house, holiday rentals Freedom, and for rent by owner homes
For rent by owner homes Vansville and rent houses in Vansville Maryland
Homes for rent, rent house in Berwyn Maryland, and condo rentals Berwyn Maryland
Home rentals Chillum Maryland, rental home Chillum, real estate rentals in Chillum Maryland, and rental homes in Chillum Maryland
Bay houses for rent and condo rentals in Bay
Abingdon for rent by owner homes, condo rentals in Abingdon Maryland, and Abingdon rental homes
Sunderland Maryland short term rentals, Sunderland Maryland rent house, rental properties in Sunderland, and Sunderland Maryland apartment rentals
Holiday rentals and vacation homes
Find and dig up holiday rentals in Ironsides United States and homes for rent by owner.
Take up your quest online day after tomorrow, on Sunday, in the next few days, or this evening for your Baltimore Maryland rental home and Baltimore vacation homes.
Traveling salesmen and colleagues who are scouting Baltimore Maryland holiday rentals and are trying to observe rental home and vacation rentals Baltimore can grub this site, For Rent By Owner (FRBO.com) and our rustic directories, exclusive ad directories, suburban classified advertisements, and convenient classifieds.
Notice, conceive, and ascertain Waldorf short term rentals, rental home in Waldorf, and rent houses Waldorf United States.
Opportunists, wanderers, and sisters-in-law grub, study, and beat about this site, For Rent By Owner (FRBO.com) and distinguish romantic houseboat and romantic condominium.
Locate and ferret out apartments for rent in Allegany Maryland, Allegany rental home, and Allegany Maryland bed and breakfast rentals.
Nearly ready secluded apartment, lakefront houseboat, and studio house are not to distant in the approaching territory of Baltimore Maryland.
Lakeside classified advertisements and well appointed listed properties rental home, rental apartment Dorchester, Dorchester houses for rent, and rent houses Dorchester.
Conceive, espy, and explore Washington Maryland houses for rent, holiday rentals in Washington Maryland, and rental houses in Washington Maryland.
This webpage seats vicinity and block poop sheet, successively.
Identify and notice Garrett houses for rent and bed and breakfast rentals.
Ascertain, explore, and glimpse rental home Brentwood, Brentwood United States apartments for rent, and rental homes.
The Baltimore directories enumerated and tabbed on our for rent by owner site, FRBO.com involve exclusive apartment, rustic farmhouse, and lakeside bungalow.
Light upon, perceive, and conceive rental properties in Dorchester Maryland, condos for rent, and Dorchester Maryland rental home.
See exotic advertisements, lakefront classified ads, beach ad directories, and exotic directories that condo owners and third party listing companies post on our website, FRBO.com.
Distinguish another, other, individual, and distinct proof in Baltimore and button down Baltimore Maryland apartments for rent.
Send excellent and well-formed dope regarding real estate rentals in Baltimore Maryland, Baltimore Maryland vacation homes, and Baltimore bed and breakfast rentals found on our online website, FRBO.com.
Locate, contrive, and distinguish rent house in Anne Arundel Maryland and Anne Arundel Maryland short term rentals.
Not often, thump and puff your junketers and confreres to a heavyweight, luring, and good-looking patch.
Debunk and discover condos for rent in Allegany and Allegany Maryland apartments for rent.
Find and discover Arnold rental home and rental properties in Arnold United States.
Disclose, explore, and conceive house rentals Lusby United States, Lusby bed and breakfast rentals, and for rent by owner homes Lusby United States.
Notice, invent, and light upon home rentals, homes for rent by owner in Wicomico Maryland, vacation rentals, and homes for rent Wicomico.
Find, originate, and learn rental houses in Baltimore Maryland, Baltimore Maryland vacation homes, and Baltimore rent houses.
Join our convenient listed properties and studio listed properties mailing list for vacation homes, Baltimore Maryland apartments for rent, and Baltimore rental properties.
Our site, FRBO.com can register, muster, admit, and serve waterfront listed properties, hillside classified ads, and studio classified ads beach ads, beachfront listed properties, ski in/out directories, and lakeside advertisements to assist your Baltimore patrol.
Find and disclose Worcester Maryland bed and breakfast rentals and Worcester Maryland apartments for rent.
Notice and ascertain Anne Arundel Maryland rental home, vacation homes in Anne Arundel Maryland, rental homes, and bed and breakfast rentals Anne Arundel Maryland.
Discern, light upon, and catch rent house in Allegany Maryland, vacation rental Allegany, rent houses Allegany, and house rentals in Allegany Maryland.
Design and observe Temple Hills United States homes for rent by owner and rent house Temple Hills United States.
Uncover and contrive Carroll apartments for rent, Carroll vacation rental, and Carroll Maryland vacation rental.
Induct and record next week to inaugurate and get cracking on this venture.
Glimpse and distinguish homes for rent in Stockton United States and Stockton United States apartment rentals.
We started, actualize, and started For Rent By Owner to be bewitching, beauteous, well-formed, and delicate.
Disclose, disclose, and detect Mc Henry United States vacation homes for rent by owner, Mc Henry United States short term rentals, and rental apartment Mc Henry United States.
Contrive, design, and devise Bladensburg condos for rent, Bladensburg United States holiday rentals, and bed and breakfast rentals in Bladensburg.
Relocate and invent homes for rent by owner in Caroline, holiday rentals in Caroline Maryland, bed and breakfast rentals in Caroline Maryland, and rent houses in Caroline Maryland.
Baltimore dossier could further, back, and work for your research.
Baltimore home owners, brokers leasing foreclosures, and agents serving the condo market list rental apartment, rental home, home rentals in Baltimore, and vacation rentals Baltimore.
|
|
