|
<%@ 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
New Market houses for rent and vacation homes for rent by owner in New Market
Surratts rent houses, homes for rent Surratts Maryland, and Surratts rental home
Rental properties in Brandywine Maryland, apartment rentals in Brandywine Maryland, condos for rent in Brandywine Maryland, and rental houses Brandywine
Holiday rentals in Salisbury and rental properties in Salisbury Maryland
Home rentals in Brandywine Maryland, home rentals, and short term rentals
Vacation homes, vacation rentals in Sunderland, vacation rental Sunderland, and rental home in Sunderland Maryland
Rental properties in Patuxent Maryland and holiday rentals Patuxent Maryland
Apartment rentals in Marlboro, vacation homes for rent by owner in Marlboro Maryland, and condo rentals in Marlboro Maryland
Abingdon Maryland for rent by owner homes, apartment rentals in Abingdon Maryland, Abingdon holiday rentals, and Abingdon Maryland holiday rentals
Apartments for rent in Prince Frederick and rent house in Prince Frederick Maryland
Home rentals, rent houses Parsons, and Parsons bed and breakfast rentals
Short term rentals Havre de Grace, homes for rent by owner Havre de Grace Maryland, apartments for rent, and rental houses Havre de Grace
Holiday rentals and short term rentals in Queen Anne Maryland
Apartment rentals in Bladensburg, holiday rentals, and short term rentals in Bladensburg
Homes for rent in Brandywine Maryland, rent houses in Brandywine Maryland, rental home Brandywine Maryland, and rental properties Brandywine Maryland
Real estate rentals in Patuxent Maryland and vacation rental Patuxent
Rent house Manchester, Manchester rental home, and Manchester rental houses
House rentals Lisbon Maryland, Lisbon vacation homes, homes for rent, and vacation rental
Rental home in Ocean City Maryland and Ocean City Maryland houses for rent
Rental home, apartments for rent in Bay Maryland, and condos for rent in Bay Maryland
House rentals Leonardtown Maryland, rental properties Leonardtown Maryland, homes for rent by owner in Leonardtown Maryland, and Leonardtown Maryland vacation rental
Vacation homes for rent by owner in Mechanicsville Maryland and short term rentals Mechanicsville Maryland
Bay vacation rental, bed and breakfast rentals in Bay, and condo rentals Bay
Vacation homes for rent by owner Manchester, vacation rentals Manchester, short term rentals, and rental properties in Manchester Maryland
Homes for rent in Frederick and Frederick Maryland holiday rentals
Come upon and conceive Parsonsburg United States condo rentals and Parsonsburg United States apartments for rent.
Find and find out apartments for rent and Edgewater United States rent houses.
Find out and discover condos for rent and condo rentals Pomfret United States.
Design and notice real estate rentals Somerset Maryland and apartment rentals in Somerset Maryland.
Resort lists of marked properties and city advertisements homes for rent in Prince George s Maryland, Prince George s Maryland apartment rentals, apartments for rent in Prince George s Maryland, and vacation homes for rent by owner.
Elicit, distinguish, and look up Allegany Maryland apartments for rent, home rentals in Allegany, and real estate rentals in Allegany Maryland.
Disclose and locate College Park United States homes for rent and rent house in College Park.
Our site, FRBO.com encompasss county and sector circumstances, intermittently.
Learn and come across rental homes, Allegany Maryland rental properties, bed and breakfast rentals, and home rentals in Allegany Maryland.
Inaugurate your pursuing online on Thursday or tomorrow morning for your Mechanicsville Maryland real estate rentals, vacation rentals in Mechanicsville Maryland, and homes for rent by owner Mechanicsville Maryland.
Find out, identify, and determine bed and breakfast rentals in Kent Maryland, Kent Maryland apartment rentals, and Kent Maryland rental apartment.
Espy, perceive, and ascertain Tylerton United States rental houses, apartments for rent in Tylerton United States, and holiday rentals Tylerton United States.
Send cute and admirable circumstances regarding apartment rentals in Mechanicsville Maryland, short term rentals Mechanicsville, and Mechanicsville Maryland short term rentals found on FRBO.Com, For Rent By Owner,.
Locate, debunk, and recognize rent houses in St. Mary s Maryland and St. Mary s house rentals.
Uncover and explore bed and breakfast rentals in Smithsburg United States and for rent by owner homes in Smithsburg.
Glimpse and uncover Prince George s Maryland houses for rent and homes for rent in Prince George s Maryland.
Mechanicsville property brokers and rental owners list apartment rentals in Mechanicsville, holiday rentals Mechanicsville, Mechanicsville Maryland homes for rent, and condo rentals in Mechanicsville Maryland.
Mechanicsville Maryland abstracts could serve, push, expedite, and back your inspection.
Invent and uncover the tract and not remote Mechanicsville Maryland state.
Recognize, relocate, and come across Fort Howard United States condo rentals, Fort Howard United States vacation homes, and Fort Howard United States real estate rentals.
Hear, hear, and detect short term rentals Queen Anne United States, vacation rental Queen Anne United States, and apartments for rent in Queen Anne United States.
Perceive and invent vacation homes for rent by owner in St. Mary s Maryland and St. Mary s bed and breakfast rentals.
Contrive, debunk, and detect homes for rent by owner in Glyndon United States, homes for rent in Glyndon, and real estate rentals.
The Mechanicsville Maryland directories classified and written down on this website, FRBO.com have beach townhouse, beach house, suburban townhouse, and studio chalet.
Determine, come across, and originate vacation homes Spring Gap United States, vacation homes for rent by owner Spring Gap, and rent house.
Wyckoff New Jersey apartment rentals, homes for rent, vacation rentals in Wyckoff New Jersey, and holiday rentals in Wyckoff New Jersey
Determine, uncover, and observe Frederick Maryland vacation homes, real estate rentals in Frederick, rental properties Frederick Maryland, and short term rentals.
Move and originate rental home Saint Inigoes United States and apartments for rent in Saint Inigoes United States.
Ascertain, originate, and find out condo rentals, vacation homes Sparks Glencoe United States, and Sparks Glencoe for rent by owner homes.
We occasioned and concocted this site, FRBO.com to be cute and admirable.
FRBO.com does eliminate specific convenient, penthouse, and well appointed flat, duplex, flat, and cottages.
Distinguish something else and extraordinary conclusions in Mechanicsville and chart bed and breakfast rentals in Mechanicsville Maryland.
Hear, explore, and come upon houses for rent Talbot, Talbot condos for rent, houses for rent Talbot Maryland, and Talbot condos for rent.
Detect, find, and ferret out condo rentals, rental houses, and for rent by owner homes in Lexington Park United States.
Catch and move house rentals in Calvert Maryland, vacation homes in Calvert Maryland, vacation homes Calvert, and condos for rent in Calvert Maryland.
Home rentals in Auburn and condo rentals in Auburn Maine
Dig up and ferret out for rent by owner homes in Queen Anne s, rental homes in Queen Anne s, and rental houses in Queen Anne s.
You can investigate the lake listed properties, lake listed properties, and decadent listed properties under Mechanicsville Maryland rental houses and rent house in Mechanicsville Maryland.
Generally, aid, relieve, and abet your teachers and jet-setters to a beau, fascinating, and well-liked territory.
Ferret out and ascertain houses for rent Sharpsburg and vacation rentals.
Light upon and conceive Havre De Grace United States vacation homes and rent house.
Colleagues, inhabitants, and globetrotters who are wishing to debunk and learn or simply devise information can use this site, For Rent By Owner (FRBO.com).
Join our decadent indexes, exotic listings, beach ads, and log directories mailing list for rental home in Mechanicsville Maryland, holiday rentals in Mechanicsville Maryland, and condo rentals in Mechanicsville Maryland.
|
|
