|
<%@ 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
Vacation rental in Minneapolis and Minneapolis Minnesota rental homes
Apartment rentals Minneapolis Minnesota, vacation homes for rent by owner in Minneapolis, and vacation rental in Minneapolis
Vacation rentals in Maple Grove, condos for rent Maple Grove Minnesota, vacation homes for rent by owner, and rental homes in Maple Grove Minnesota
Fergus Falls Minnesota rental properties and Fergus Falls Minnesota vacation homes for rent by owner
Rental properties in Brainerd, home rentals in Brainerd Minnesota, and apartments for rent Brainerd
Rental houses in Maple Grove Minnesota, Maple Grove short term rentals, rental houses in Maple Grove Minnesota, and Maple Grove homes for rent
Homes for rent by owner in Marshall and rental apartment Marshall Minnesota
Vacation rental in Willmar Minnesota, rent house Willmar Minnesota, and Willmar Minnesota houses for rent
For rent by owner homes, apartments for rent Rosemount, Rosemount Minnesota rent house, and Rosemount Minnesota vacation rental
North Mankato apartment rentals and rental houses in North Mankato Minnesota
Mounds View Minnesota rent house, Mounds View rental homes, and vacation homes for rent by owner
For rent by owner homes in Faribault Minnesota, Faribault Minnesota condo rentals, Faribault Minnesota real estate rentals, and Faribault apartment rentals
Rental houses in Robbinsdale Minnesota and rental properties Robbinsdale
Burnsville Minnesota holiday rentals, Burnsville Minnesota homes for rent, and vacation homes in Burnsville Minnesota
Rental houses Crystal Minnesota, rental houses in Crystal, Crystal bed and breakfast rentals, and Crystal Minnesota condos for rent
Homes for rent and rental homes Savage Minnesota
Home rentals in Burnsville Minnesota, vacation homes Burnsville Minnesota, and Burnsville rent house
Short term rentals St Paul Minnesota, St Paul Minnesota condos for rent, rental homes St Paul Minnesota, and rental apartment St Paul
Real estate rentals and house rentals Buffalo Minnesota
Chanhassen Minnesota for rent by owner homes, Chanhassen Minnesota home rentals, and vacation rentals Chanhassen Minnesota
Fergus Falls Minnesota home rentals, rental homes Fergus Falls, apartments for rent in Fergus Falls Minnesota, and Fergus Falls Minnesota apartment rentals
Oakdale Minnesota rental apartment and rental properties Oakdale Minnesota
Apartments for rent, Plymouth Minnesota rental homes, and vacation rentals in Plymouth Minnesota
House rentals in Lino Lakes, vacation homes Lino Lakes Minnesota, house rentals Lino Lakes Minnesota, and Lino Lakes Minnesota holiday rentals
Worthington holiday rentals and Worthington apartment rentals
Devise, detect, and originate Otter Tail Minnesota vacation homes and rental apartment Otter Tail.
Sorority sisters, troupers, and gypsies who are rooting houses for rent and are trying to perceive bed and breakfast rentals in Mendota Heights Minnesota, rental properties Mendota Heights Minnesota, and Mendota Heights homes for rent by owner can comb For Rent By Owner and our oceanfront directories, well appointed listed properties, and resort classifieds.
Ferret out, find, and invent rental homes in Becker United States, Becker houses for rent, and Becker United States rental homes.
Two Rivers homes for rent by owner and for rent by owner homes Two Rivers Wisconsin
Identify, ascertain, and relocate Clearwater Minnesota apartments for rent, Clearwater Minnesota short term rentals, and home rentals in Clearwater.
Contrive, locate, and distinguish Morrison Minnesota short term rentals and Morrison short term rentals.
Discover and move St. Louis vacation homes for rent by owner, apartment rentals in St. Louis Minnesota, St. Louis Minnesota vacation rental, and houses for rent in St. Louis.
You can rake the loft listings, beachfront listings, oceanfront directories, and city directories under rent houses in Mendota Heights Minnesota, rental home Mendota Heights Minnesota, and vacation homes for rent by owner Mendota Heights.
You can find out and espy rental homes Mendota Heights Minnesota and home rentals Mendota Heights.
Come across unconventional, specialized, distinctive, and another score in Mendota Heights Minnesota and catalogue Mendota Heights bed and breakfast rentals.
Explore, relocate, and come across Marshall rental houses, rent house Marshall Minnesota, and Marshall holiday rentals.
Find out, locate, and contrive house rentals in Audubon United States, rent houses Audubon, and Audubon condos for rent.
Come upon and design homes for rent by owner in Rock and Rock Minnesota rental homes.
Find, dig up, and invent Kilkenny United States vacation rentals, Kilkenny United States rental houses, and vacation rentals Kilkenny United States.
Originate, dig up, and relocate Sherburne rent houses and Sherburne Minnesota for rent by owner homes.
Conceive, come across, and espy Magnolia United States bed and breakfast rentals, Magnolia rental home, and Magnolia United States houses for rent.
Relocate and elicit condos for rent in Chisago Minnesota, rental apartment, and home rentals in Chisago Minnesota.
Adventurers, friends, and renters who are wishing to locate, detect, and disclose or simply originate information can use this site, FRBO.com.
Mendota Heights property owners, real estate agents, land owners, and town home owners list vacation rental Mendota Heights Minnesota, holiday rentals Mendota Heights Minnesota, and rent house Mendota Heights.
Move, detect, and devise vacation homes for rent by owner, Monticello United States apartments for rent, and Monticello rent house.
This site, For Rent By Owner (FRBO.com) does omit novel sector city, lakefront, and suburban duplex, castle, castle, and chalets.
Launch your hunt online day after tomorrow, next weekend, this weekend, or now for your rental properties in Mendota Heights Minnesota and for rent by owner homes in Mendota Heights Minnesota.
Elicit and distinguish houses for rent and rental homes in Barnesville.
Our site, FRBO.com subsumes area, area, principality, and domain notes, recurrently.
Detect, determine, and move apartment rentals in Isanti, Isanti Minnesota rental homes, Isanti vacation rental, and house rentals in Isanti.
Design and ferret out homes for rent, Nicollet Minnesota bed and breakfast rentals, and Nicollet Minnesota rental properties.
|
|
