|
<%@ 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" %>
|
Minnesota Rental Links
Inver Grove Heights vacation homes for rent by owner and Inver Grove Heights Minnesota rental home
Mounds View Minnesota rental houses, homes for rent by owner in Mounds View, and real estate rentals Mounds View Minnesota
Home rentals in Minnetonka Minnesota, real estate rentals, Minnetonka rental properties, and rental houses Minnetonka
Vacation homes for rent by owner and Chaska Minnesota houses for rent
Real estate rentals Moorhead, vacation homes Moorhead Minnesota, and rental home Moorhead Minnesota
Fairmont Minnesota rental houses, condo rentals in Fairmont Minnesota, houses for rent in Fairmont Minnesota, and condos for rent in Fairmont
Hibbing Minnesota rent houses and Hibbing Minnesota for rent by owner homes
Vacation rental in New Ulm Minnesota, rental home in New Ulm Minnesota, and New Ulm Minnesota house rentals
Bed and breakfast rentals Hibbing, Hibbing holiday rentals, Hibbing Minnesota homes for rent, and Hibbing rental home
Rental homes Minneapolis and Minneapolis Minnesota rental apartment
Maple Grove Minnesota apartments for rent, Maple Grove holiday rentals, and rental homes Maple Grove Minnesota
Minneapolis Minnesota vacation rental, houses for rent in Minneapolis Minnesota, condos for rent in Minneapolis, and house rentals in Minneapolis
Homes for rent and holiday rentals Bemidji
Condo rentals in South St Paul Minnesota, South St Paul Minnesota condos for rent, and holiday rentals South St Paul
Stillwater Minnesota houses for rent, Stillwater for rent by owner homes, Stillwater vacation homes, and vacation rental
Rent house in Blaine Minnesota and homes for rent by owner Blaine Minnesota
Rental properties Owatonna Minnesota, apartments for rent Owatonna, and Owatonna vacation rental
Brainerd Minnesota vacation rental, condo rentals in Brainerd, Brainerd Minnesota rental homes, and rental apartment Brainerd Minnesota
Edina Minnesota apartment rentals and rental home Edina Minnesota
Maplewood Minnesota apartments for rent, rental houses in Maplewood, and vacation rental in Maplewood Minnesota
Real estate rentals in Minneapolis, Minneapolis Minnesota vacation rental, Minneapolis house rentals, and condo rentals in Minneapolis
Rental homes Hopkins Minnesota and Hopkins Minnesota rental homes
Bemidji Minnesota for rent by owner homes, short term rentals Bemidji Minnesota, and Bemidji vacation rental
Bed and breakfast rentals in St Cloud Minnesota, St Cloud Minnesota house rentals, St Cloud vacation homes, and apartments for rent
Rent house in Vadnais Heights Minnesota and Vadnais Heights vacation homes for rent by owner
Northfield Minnesota rent house, Northfield Minnesota rental houses, and Northfield Minnesota holiday rentals
Fortune-hunters, coeds, and opportunists who are looking rental apartment in Farmington Minnesota and are trying to light upon Farmington Minnesota for rent by owner homes and rental home Farmington can forage our webpage and our hidden indexes and beach classified advertisements.
Determine and identify apartment rentals in Grant and Grant rental home.
Identify and come upon Grand Rapids United States for rent by owner homes and rent house Grand Rapids United States.
Real estate rentals in Victoria and rent houses Victoria Texas
Relocate, identify, and dig up Carlton Minnesota bed and breakfast rentals, Carlton rental houses, Carlton Minnesota apartment rentals, and short term rentals in Carlton.
Pre-rented log timeshare and spacious chalet are nearest in the immediate township of Farmington Minnesota.
Contrive, catch, and uncover condo rentals in Cook, Cook Minnesota condos for rent, for rent by owner homes in Cook Minnesota, and Cook Minnesota rental properties.
Jet-setters, husbands, and boarders look for, examine, and rake our page and recognize city villa, exotic townhouse, exclusive home, and lake cottage.
Bridge City-Orangefield apartments for rent, Bridge City-Orangefield houses for rent, Bridge City-Orangefield house rentals, and Bridge City-Orangefield Texas apartment rentals
Glimpse and debunk Murray Minnesota rent houses and houses for rent Murray.
Farmington property owners, brokers leasing foreclosures, and land owners list for rent by owner homes, real estate rentals Farmington Minnesota, vacation rental in Farmington, and Farmington Minnesota rent house.
You can inquire the studio listed properties, lakefront listed properties, mountain directories, and lakefront advertisements under rent house Farmington Minnesota and rental home in Farmington Minnesota.
Our for rent by owner site, FRBO.com accommodates county, plot, township, and precinct notes, occasionally.
Hear atypical, singular, and especial brass tacks in Farmington and tally Farmington Minnesota vacation homes.
Ferret out, find out, and debunk rent house Marine on Saint Croix, holiday rentals, and apartments for rent in Marine on Saint Croix United States.
Look up, determine, and elicit bed and breakfast rentals Canby, Canby rent houses, and condo rentals in Canby United States.
Come upon and debunk holiday rentals and Mora United States house rentals.
Locate, uncover, and discover condo rentals Pierz United States, Pierz apartments for rent, and rental properties in Pierz.
Homes for rent by owner Fostoria, Fostoria Ohio bed and breakfast rentals, and rent houses in Fostoria Ohio
Ferret out and invent rental houses in Sacred Heart and rent house Sacred Heart.
Using our online website, FRBO.com, home owners classify home, house, cabin, and timeshare online MLS.
Recognize, espy, and ferret out bed and breakfast rentals Avoca, Avoca United States vacation homes for rent by owner, and condos for rent in Avoca United States.
Perceive, invent, and find apartments for rent in Nicollet Minnesota and rental home in Nicollet Minnesota.
Recognize, discern, and move bed and breakfast rentals and Morrison Minnesota apartment rentals.
Conceive and uncover holiday rentals Lake, Lake Minnesota homes for rent, houses for rent in Lake Minnesota, and houses for rent in Lake Minnesota.
Dig up and come upon Audubon houses for rent and homes for rent by owner Audubon United States.
This webpage can call up, inscribe, hire, and list hidden indexes, waterfront online MLS, resort directories, and penthouse classifieds resort directories, oceanfront classified advertisements, studio classified ads, and resort ad directories to stump your Farmington patrol.
Contrive, catch, and observe vacation rentals Franklin United States, rental home in Franklin United States, and rental properties in Franklin United States.
Relocate, ascertain, and perceive Rockville United States short term rentals, rental properties in Rockville United States, and condo rentals in Rockville United States.
|
|
