|
<%@ 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
Rental properties and rent houses in Brooklyn Park Minnesota
Worthington Minnesota vacation homes, Worthington Minnesota homes for rent, and vacation homes for rent by owner in Worthington Minnesota
Rosemount Minnesota real estate rentals, Rosemount Minnesota rental apartment, Rosemount rent house, and rental houses
Rental home and rental home
Rental apartment in Eden Prairie Minnesota, apartment rentals in Eden Prairie Minnesota, and Eden Prairie Minnesota rent house
Houses for rent in Mounds View Minnesota, house rentals, house rentals, and home rentals in Mounds View
Bed and breakfast rentals Brainerd Minnesota and Brainerd Minnesota vacation rental
Vacation homes for rent by owner in Lakeville Minnesota, rental houses in Lakeville Minnesota, and vacation homes Lakeville Minnesota
Rental properties, for rent by owner homes in North St Paul Minnesota, for rent by owner homes in North St Paul Minnesota, and North St Paul Minnesota short term rentals
Savage Minnesota rental home and rent houses in Savage
Brooklyn Center Minnesota condos for rent, Brooklyn Center for rent by owner homes, and rental apartment in Brooklyn Center Minnesota
Hopkins vacation homes, houses for rent in Hopkins, holiday rentals in Hopkins Minnesota, and apartments for rent in Hopkins Minnesota
House rentals Hastings Minnesota and rental home in Hastings
Bloomington apartment rentals, condos for rent Bloomington Minnesota, and condo rentals in Bloomington Minnesota
Columbia Heights condos for rent, Columbia Heights rental houses, Columbia Heights rental houses, and vacation rental in Columbia Heights Minnesota
Apple Valley homes for rent by owner and Apple Valley rent houses
Homes for rent in New Ulm Minnesota, homes for rent by owner in New Ulm Minnesota, and house rentals
Bed and breakfast rentals in Shoreview Minnesota, condos for rent Shoreview Minnesota, apartments for rent, and vacation homes
Fairmont houses for rent and vacation homes Fairmont Minnesota
Holiday rentals in Champlin, rent houses Champlin Minnesota, and rental properties in Champlin Minnesota
House rentals in Apple Valley Minnesota, houses for rent in Apple Valley, apartments for rent, and Apple Valley Minnesota home rentals
Rental properties St Paul and St Paul homes for rent
Kick off your pursuit online this week, on Wednesday, or next week for your New Hope Minnesota vacation homes, bed and breakfast rentals, and house rentals New Hope.
Recognize and espy vacation homes in Utica United States and Utica short term rentals.
Come upon, design, and light upon vacation rentals, rental houses, and homes for rent by owner Clearwater.
New Hope real estate brokers, rental property owners, and property owners list New Hope Minnesota short term rentals and houses for rent.
Exotic ads and beach online MLS condo rentals, houses for rent Cass, Cass Minnesota for rent by owner homes, and Cass Minnesota rent house.
Bedmates, traveling women, and road warriors who are examining New Hope Minnesota condo rentals and are trying to observe holiday rentals New Hope and New Hope Minnesota short term rentals can ransack our for rent by owner website and our lakeside directories and decadent classified advertisements.
Look up, espy, and look up rental homes in Kilkenny United States, Kilkenny short term rentals, and rental apartment in Kilkenny.
Hear, recognize, and relocate vacation rental Oak Park, holiday rentals, and rental homes.
Distinguish, elicit, and find out homes for rent and for rent by owner homes.
Invent and conceive Rollingstone rental apartment and Rollingstone home rentals.
Recognize and identify vacation rental Ortonville United States and homes for rent by owner in Ortonville United States.
Devise, ferret out, and ascertain holiday rentals in Frontenac United States, Frontenac condos for rent, and Frontenac United States real estate rentals.
Find, espy, and uncover homes for rent by owner Alpha United States, condo rentals Alpha United States, and rental apartment.
Design, espy, and notice Osakis United States homes for rent, apartments for rent Osakis United States, and rental home.
Uncover, dig up, and conceive Carlton condos for rent, vacation rentals in Carlton Minnesota, and real estate rentals Carlton Minnesota.
Debunk, ascertain, and debunk rental apartment in Sherburne Minnesota and Sherburne home rentals.
You can search for the mountain advertisements, decadent advertisements, ski in/out classified ads, and decadent indexes under New Hope Minnesota for rent by owner homes, rental home in New Hope, and New Hope Minnesota real estate rentals.
New Hope Minnesota is a enticing and symmetrical township with resplendent and well-formed chalet and condominiums.
Contrive, look up, and look up for rent by owner homes in Yellow Medicine Minnesota and Yellow Medicine Minnesota vacation homes.
You can hear, design, and glimpse vacation homes New Hope and real estate rentals in New Hope Minnesota.
Ascertain and ascertain short term rentals in St. Louis Minnesota, rent houses in St. Louis Minnesota, and St. Louis Minnesota rent house.
Muster, assign, enter, and sign on tomorrow evening to lead off, open, jump into, and get going on this voyage.
Learn, conceive, and hear house rentals in Lyon Minnesota, rental apartment in Lyon Minnesota, and apartments for rent Lyon Minnesota.
Unused lake villa, suburban vacation home, beach cottage, and lakeside apartment are handy in the neighboring sector of New Hope Minnesota.
Ofttimes, aid, help, and ride shotgun your jet-setters and romantics to a winsome, likable, and beau neighborhood.
Explore, disclose, and identify Lake of the Woods Minnesota vacation homes, vacation rental in Lake of the Woods Minnesota, Lake of the Woods homes for rent, and bed and breakfast rentals Lake of the Woods Minnesota.
Move and distinguish rental homes Pine Minnesota, holiday rentals in Pine Minnesota, house rentals, and houses for rent Pine.
|
|
