|
<%@ 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
Homes for rent by owner in Baltimore Maryland and rental properties
Manchester condos for rent, short term rentals, and rental homes Manchester
Rental apartment in Brandywine, condo rentals in Brandywine Maryland, home rentals in Brandywine Maryland, and Brandywine Maryland for rent by owner homes
Vacation rental in Port Deposit Maryland and rental properties Port Deposit
Savage Maryland home rentals, rental home Savage, and rent houses in Savage
Real estate rentals in Bowie Maryland, holiday rentals in Bowie, Bowie Maryland for rent by owner homes, and Bowie rent house
Bay vacation rental and real estate rentals in Bay Maryland
Frederick Maryland holiday rentals, Frederick house rentals, and home rentals
Holiday rentals Vansville, rent houses in Vansville, rental apartment Vansville Maryland, and Vansville Maryland rent houses
Rental homes in Chillum and Chillum Maryland vacation rental
Rent houses Elkton, Elkton Maryland houses for rent, and houses for rent
Condo rentals, Prince Frederick Maryland vacation rentals, Prince Frederick Maryland rental apartment, and rental apartment in Prince Frederick
Homes for rent by owner in Bowie Maryland and Bowie condos for rent
Frederick Maryland apartment rentals, vacation rentals in Frederick Maryland, and real estate rentals in Frederick Maryland
Holiday rentals in Piscataway Maryland, Piscataway real estate rentals, vacation homes for rent by owner, and home rentals in Piscataway
Vacation homes in Chillum and rental home Chillum
North East rental houses, North East houses for rent, and vacation rentals in North East
Rent houses in Havre de Grace, Havre de Grace home rentals, real estate rentals in Havre de Grace Maryland, and Havre de Grace condo rentals
Homes for rent by owner in Chillum Maryland and condo rentals in Chillum Maryland
Vacation homes in West Friendship Maryland, West Friendship Maryland rent houses, and condos for rent in West Friendship
Apartments for rent in Prince Frederick Maryland, vacation homes for rent by owner in Prince Frederick Maryland, houses for rent, and apartment rentals Prince Frederick Maryland
Elkton Maryland holiday rentals and Elkton Maryland house rentals
Brandywine Maryland rental homes, Brandywine Maryland homes for rent by owner, and holiday rentals in Brandywine Maryland
Vacation rental in Parsons Maryland, Parsons Maryland home rentals, Parsons Maryland vacation rental, and real estate rentals in Parsons
Short term rentals in Prince Frederick Maryland and vacation rentals Prince Frederick Maryland
Originate, look up, and glimpse rental home Benedict United States, vacation rentals in Benedict United States, and vacation homes for rent by owner in Benedict United States.
Contrive, catch, and glimpse Mardela Springs United States rental apartment, Mardela Springs rental apartment, and real estate rentals Mardela Springs.
Bay condo owners and rental owners list home rentals in Bay, vacation homes Bay, and homes for rent by owner Bay Maryland.
Notice, recognize, and uncover Brooklyn United States holiday rentals, Brooklyn United States vacation rental, and Brooklyn United States vacation homes.
Glimpse, detect, and invent bed and breakfast rentals Carroll Maryland and for rent by owner homes in Carroll Maryland.
Ferret out, discern, and explore homes for rent in Mardela Springs, rent house, and house rentals in Mardela Springs.
You can hear, discover, and explore rental properties in Bay Maryland, homes for rent in Bay Maryland, and apartments for rent in Bay.
Design, find out, and invent Eden United States apartments for rent, rental apartment Eden, and rental houses.
You can frisk the ski in/out directories, mountain listed properties, mountain listed properties, and beach classifieds under rent house and rental homes.
The Bay Maryland decadent online MLS, well appointed classified ads, loft ad directories, and resort classified ads for these field can be mapped.
Disclose and recognize rental apartment Prince George s Maryland, rental properties in Prince George s, and holiday rentals in Prince George s Maryland.
Move and come upon Greenbelt apartments for rent and condo rentals Greenbelt.
Join our ski in/out classified advertisements, hidden ad directories, exotic online MLS, and studio advertisements mailing list for Bay Maryland vacation rental and Bay Maryland short term rentals.
Jump into your pursual online now, on Thursday, this week, or in the next few days for your Bay houses for rent, home rentals in Bay Maryland, and Bay Maryland short term rentals.
Come upon and elicit Talbot Maryland rental homes and condo rentals Talbot.
Debunk, find, and catch vacation homes for rent by owner in Cascade United States, vacation rentals Cascade, and homes for rent.
Glimpse and espy vacation homes Faulkner United States and house rentals.
Entrepreneurs and commuters who are wishing to originate and catch or simply observe information can use this site, FRBO.com.
Ferret out and discover vacation rentals Glyndon United States and rental properties.
Rental apartment in Poland Ohio, Poland Ohio house rentals, apartments for rent in Poland Ohio, and Poland Ohio condos for rent
Discover and look up rental homes in Caroline and Caroline vacation rentals.
Bay Maryland sector employs many condo owners, agents, and property managers.
Disclose and discover Park Hall house rentals and Park Hall vacation homes for rent by owner.
Our website, FRBO.com does involve distinct patch penthouse, log, studio, and romantic vacation home, cottage, and duplexs.
Dig up, catch, and detect Somerset Maryland bed and breakfast rentals, bed and breakfast rentals Somerset Maryland, vacation rental in Somerset Maryland, and for rent by owner homes Somerset Maryland.
Determine and learn short term rentals Monkton United States and Monkton United States rental homes.
|
|
