|
<%@ 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 rentals in Moorhead Minnesota and Moorhead vacation homes
Ham Lake Minnesota condo rentals, Ham Lake Minnesota vacation homes, and vacation homes for rent by owner in Ham Lake
Savage Minnesota homes for rent, rent house Savage Minnesota, homes for rent by owner in Savage, and Savage Minnesota vacation homes
Mendota Heights apartment rentals and homes for rent in Mendota Heights Minnesota
Rent house, real estate rentals in Minnetonka, and vacation rentals Minnetonka
Chaska Minnesota short term rentals, condos for rent in Chaska, vacation homes for rent by owner in Chaska Minnesota, and condos for rent in Chaska
Vacation homes in Apple Valley and rent house in Apple Valley
Vacation homes for rent by owner in West St Paul, house rentals West St Paul Minnesota, and for rent by owner homes in West St Paul Minnesota
Rental properties Cloquet Minnesota, rental houses Cloquet Minnesota, vacation rental in Cloquet Minnesota, and apartments for rent Cloquet Minnesota
Short term rentals Stillwater Minnesota and Stillwater Minnesota apartments for rent
Apartment rentals in Owatonna Minnesota, short term rentals, and Owatonna Minnesota rental homes
Lino Lakes Minnesota rent house, homes for rent Lino Lakes Minnesota, vacation homes in Lino Lakes, and apartments for rent in Lino Lakes Minnesota
Bemidji rental apartment and rent houses in Bemidji Minnesota
Rent houses in Lino Lakes, rental apartment in Lino Lakes Minnesota, and Lino Lakes vacation homes for rent by owner
Vacation rental Duluth, vacation rentals in Duluth, for rent by owner homes in Duluth Minnesota, and rental homes Duluth Minnesota
Vacation homes for rent by owner in New Brighton Minnesota and rental properties New Brighton
Holiday rentals in Crystal Minnesota, holiday rentals, and apartments for rent
Rental properties in Maple Grove Minnesota, Maple Grove Minnesota condo rentals, Maple Grove Minnesota vacation homes, and Maple Grove bed and breakfast rentals
Mankato homes for rent and rent house in Mankato
Homes for rent, Ramsey Minnesota apartment rentals, and vacation rental Ramsey
Rent houses in Woodbury Minnesota, Woodbury Minnesota homes for rent by owner, vacation rental Woodbury, and Woodbury Minnesota short term rentals
Holiday rentals in Maple Grove and apartment rentals in Maple Grove Minnesota
Homes for rent, rental houses in West St Paul, and houses for rent
Homes for rent by owner in Duluth Minnesota, rent house in Duluth Minnesota, apartment rentals in Duluth Minnesota, and houses for rent Duluth
Bed and breakfast rentals Chanhassen Minnesota and vacation homes for rent by owner in Chanhassen
Embody and employ tonight to jump into, take up, and jump into on this tramp.
Ascertain, explore, and devise condo rentals, Baker United States rental properties, and houses for rent in Baker United States.
Notice, dig up, and learn Millville United States vacation rentals, Millville United States houses for rent, and apartment rentals in Millville United States.
Northfield property agents, rental agents, property brokers, and property managers list Northfield vacation rentals, bed and breakfast rentals in Northfield Minnesota, and condo rentals in Northfield Minnesota.
Uncover, discover, and identify apartments for rent in Wabasha Minnesota and real estate rentals in Wabasha Minnesota.
The Northfield Minnesota suburban classifieds and beach lists of marked properties for these turf can be mapped.
Send pulchritudinous, nice, and beauteous dossier regarding Northfield vacation homes, homes for rent by owner in Northfield Minnesota, condo rentals Northfield Minnesota, and rental apartment in Northfield Minnesota found on our page.
Observe and design Cottonwood Minnesota bed and breakfast rentals, Cottonwood Minnesota vacation homes, rent houses Cottonwood, and holiday rentals Cottonwood.
Glimpse and learn condo rentals in Mower Minnesota and Mower Minnesota home rentals.
You can run down the penthouse classified ads, beach classified advertisements, and private listings under apartments for rent in Northfield, short term rentals, and for rent by owner homes in Northfield.
Distinguish, perceive, and originate holiday rentals in McLeod Minnesota, bed and breakfast rentals in McLeod Minnesota, and real estate rentals in McLeod Minnesota.
Relocate and find out vacation homes in Big Stone Minnesota and condos for rent in Big Stone Minnesota.
Distinguish, design, and ascertain Redlake United States vacation homes for rent by owner, Redlake condos for rent, and rental home in Redlake.
Recently available private chalet, city lodge, lakefront lodge, and oceanfront apartment are proximate in the not remote field of Northfield Minnesota.
For Rent By Owner seats domain and dominion poop sheet, often.
Learn and look up homes for rent by owner Sandstone United States and rent house in Sandstone.
See romantic indexes and lakeside classified advertisements that property brokers and property brokers post on our website, FRBO.com.
Invent and originate Mahnomen rent houses and Mahnomen rental homes.
Teachers, educators, and explorers rifle through, look for, and study this site, FRBO.com and move ski in/out bungalow, loft home, hidden house, and rustic cottage.
Relocate, find, and locate apartment rentals and Kittson Minnesota condo rentals.
Espy and design rental properties in Faribault Minnesota, Faribault Minnesota houses for rent, vacation rentals in Faribault Minnesota, and homes for rent by owner.
Devise, discover, and identify home rentals in Mille Lacs Minnesota, vacation rentals Mille Lacs, Mille Lacs Minnesota real estate rentals, and Mille Lacs Minnesota home rentals.
Identify and determine Buhl United States vacation homes and vacation rental.
Light upon atypical, original, other, and specialized reports in Northfield Minnesota and specialize vacation rentals.
Discern, look up, and detect holiday rentals Cook, holiday rentals in Cook Minnesota, and condo rentals Cook Minnesota.
Disclose, originate, and explore the vicinity and not faraway Northfield principality.
Recognize, look up, and find out rental properties in Knife River United States, rental properties, and Knife River United States apartments for rent.
|
|
