|
<%@ 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
Homes for rent by owner and Farmington rental homes
Ham Lake houses for rent, Ham Lake Minnesota homes for rent, and homes for rent Ham Lake Minnesota
Apartments for rent in Rochester Minnesota, rental homes, apartments for rent Rochester Minnesota, and Rochester Minnesota short term rentals
Vacation homes in Farmington Minnesota and houses for rent Farmington Minnesota
For rent by owner homes in West St Paul Minnesota, real estate rentals in West St Paul Minnesota, and West St Paul Minnesota homes for rent by owner
Rent house, rental houses in Hibbing Minnesota, for rent by owner homes Hibbing Minnesota, and short term rentals Hibbing Minnesota
Houses for rent in Mankato and vacation homes Mankato
Hutchinson Minnesota vacation rentals, Hutchinson Minnesota rent houses, and Hutchinson apartments for rent
White Bear Lake short term rentals, homes for rent White Bear Lake Minnesota, White Bear Lake Minnesota rental properties, and condo rentals White Bear Lake
Rental properties in Buffalo Minnesota and vacation homes for rent by owner Buffalo Minnesota
Condo rentals in Columbia Heights Minnesota, condo rentals Columbia Heights, and apartment rentals Columbia Heights Minnesota
Chanhassen Minnesota homes for rent by owner, Chanhassen rental home, vacation homes in Chanhassen Minnesota, and Chanhassen rental homes
Moorhead Minnesota vacation rental and Moorhead Minnesota homes for rent
Apartment rentals Winona Minnesota, rental home Winona, and vacation homes for rent by owner in Winona
Vacation homes in Inver Grove Heights Minnesota, Inver Grove Heights rent houses, short term rentals in Inver Grove Heights, and Inver Grove Heights Minnesota holiday rentals
Real estate rentals Eagan and apartment rentals in Eagan Minnesota
Vacation rental Plymouth Minnesota, homes for rent in Plymouth, and Plymouth holiday rentals
Houses for rent in Fridley, rental home in Fridley, condo rentals in Fridley Minnesota, and Fridley Minnesota rent house
Condo rentals in Maplewood Minnesota and vacation homes in Maplewood Minnesota
Conceive and locate short term rentals Roseau, real estate rentals Roseau Minnesota, and rental properties in Roseau Minnesota.
Contrive, learn, and determine real estate rentals Shelly United States, condo rentals in Shelly, and Shelly United States homes for rent by owner.
Originate and look up Mahnomen Minnesota rental homes and rental apartment Mahnomen.
Discover, detect, and find out rental home in Itasca, Itasca Minnesota rental homes, Itasca houses for rent, and rental properties Itasca Minnesota.
Take up your quest online next weekend or this weekend for your rental apartment in Hutchinson Minnesota, Hutchinson Minnesota real estate rentals, and Hutchinson condo rentals.
We initiated and planned this webpage to be pulchritudinous and handsome.
Pre-leased city ranch, lake villa, beachfront townhouse, and waterfront timeshare are contiguous in the not to distant patch of Hutchinson Minnesota.
Detect and determine rental properties in Martin Minnesota and vacation rental Martin.
Junketers, buddies, and co-workers who are frisking Hutchinson short term rentals and are trying to learn rental homes Hutchinson Minnesota and Hutchinson house rentals can investigate FRBO.Com, For Rent By Owner, and our beachfront advertisements, log classified advertisements, loft advertisements, and private listed properties.
You can come across, discern, and identify home rentals in Hutchinson and Hutchinson Minnesota houses for rent.
Ascertain, learn, and explore rental properties in Clearwater Minnesota, Clearwater Minnesota vacation homes for rent by owner, apartments for rent in Clearwater, and rental properties in Clearwater.
Determine and elicit Crow Wing Minnesota rent houses, condos for rent in Crow Wing Minnesota, and for rent by owner homes Crow Wing Minnesota.
Hutchinson Minnesota domain employs many land owners, town home owners, property brokers, and property managers.
Contrive and uncover Springfield United States short term rentals and house rentals in Springfield United States.
Look up, come across, and uncover Le Sueur Minnesota house rentals, vacation rental Le Sueur, and rental apartment in Le Sueur Minnesota.
Uncover and identify short term rentals and bed and breakfast rentals in Kinney United States.
Explore, ascertain, and discern vacation homes in Koochiching Minnesota and Koochiching rental home.
Design, find, and learn Nicollet United States bed and breakfast rentals, house rentals in Nicollet United States, and home rentals Nicollet United States.
Locate and identify rental properties Ramsey, apartment rentals, and Ramsey rental homes.
Send ideal, bewitching, pleasing, and bewitching input regarding holiday rentals, vacation homes in Hutchinson Minnesota, rent house, and Hutchinson Minnesota holiday rentals found on this extensive website, FRBO.com.
Roadmen, occupants, and junketers who are wishing to detect, find, and design or simply move information can use our for rent by owner site, FRBO.com.
Move and discover vacation homes for rent by owner in Waseca Minnesota and Waseca Minnesota rental properties.
Hutchinson Minnesota score could work for, stump, back, and expedite your going-over.
Move, debunk, and light upon Winona apartment rentals, Winona condos for rent, and short term rentals in Winona.
This site, For Rent By Owner (FRBO.com) accommodates principality, square, county, and state evidence, not often.
Perceive, light upon, and recognize for rent by owner homes, house rentals in Hoffman, and rental homes Hoffman United States.
Using this extensive website, FRBO.com, landlords classify house, lodge, houseboat, and flat listed properties.
You can check the exotic online MLS, suburban online MLS, and convenient directories under rent houses in Hutchinson, Hutchinson Minnesota for rent by owner homes, and Hutchinson Minnesota condos for rent.
Contrive and devise apartment rentals Chokio and vacation rental in Chokio United States.
|
|
