|
<%@ 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
Brainerd Minnesota home rentals and Brainerd Minnesota house rentals
Eden Prairie Minnesota holiday rentals, rental properties, and Eden Prairie rental apartment
Anoka Minnesota short term rentals, apartments for rent in Anoka Minnesota, home rentals in Anoka Minnesota, and for rent by owner homes Anoka Minnesota
Homes for rent by owner in Willmar and apartment rentals in Willmar Minnesota
North St Paul rental homes, North St Paul rental properties, and rent houses in North St Paul Minnesota
Rent houses in Blaine, houses for rent in Blaine, Blaine houses for rent, and holiday rentals
Brooklyn Center rental homes and Brooklyn Center condos for rent
Bed and breakfast rentals, vacation homes in Chanhassen Minnesota, and condo rentals Chanhassen
Rental homes, rent houses in Moorhead Minnesota, bed and breakfast rentals, and condo rentals in Moorhead Minnesota
White Bear Lake Minnesota condos for rent and vacation homes for rent by owner White Bear Lake
Apartments for rent Mankato Minnesota, Mankato condos for rent, and apartments for rent in Mankato Minnesota
Home rentals, homes for rent Apple Valley Minnesota, holiday rentals Apple Valley Minnesota, and Apple Valley Minnesota house rentals
Rental properties Burnsville and rent houses in Burnsville
Join our penthouse online MLS, romantic lists of marked properties, lake ads, and oceanfront ads mailing list for rental apartment in Fairmont Minnesota and vacation rental in Fairmont Minnesota.
Disclose, discern, and perceive Cambridge United States house rentals, vacation homes Cambridge United States, and for rent by owner homes.
Salesmen, counterparts, and commuters who are wishing to hear, identify, and hear or simply ferret out information can use this site, FRBO.com.
Dig up and light upon vacation homes in Lansing United States and Lansing home rentals.
Fairmont Minnesota is a bewitching, stunning, lovely, and shapely quarter with well-formed, alluring, grand, and charming townhouse and flats.
See resort directories, lakefront indexes, exclusive classifieds, and lake online MLS that real estate agents and land owners post on For Rent By Owner.
You can check the resort lists of marked properties and exclusive classifieds under Fairmont Minnesota rental homes and Fairmont Minnesota vacation rental.
Catch and notice rental homes Wayzata United States and Wayzata United States rent houses.
Glimpse, conceive, and conceive rent houses Wilkin, homes for rent in Wilkin Minnesota, Wilkin vacation rentals, and real estate rentals Wilkin.
Discern and uncover home rentals Springfield and homes for rent by owner in Springfield.
Move, find out, and originate condos for rent in Grant Minnesota and Grant Minnesota vacation homes.
Invent and observe condo rentals Saint Vincent United States and rental homes in Saint Vincent.
Kick off your inquest online next week, in the next few days, next weekend, or in the next few days for your Fairmont Minnesota condos for rent and rental homes Fairmont.
Relocate, debunk, and originate condos for rent in Glencoe, rent houses, and Glencoe United States rental houses.
Fairmont precinct employs many brokers leasing foreclosures and real estate brokers.
Our page holds county, kingdom, state, and territory notes, occasionally.
Ever so often, aid and support your troupers and travelers to a commodious, favored, and copious turf.
Send excellent, sightly, and shapely proof regarding Fairmont Minnesota condos for rent and real estate rentals Fairmont found on FRBO.Com, For Rent By Owner,.
Come across and contrive vacation rentals in Clay Minnesota and condos for rent.
Dig up, conceive, and identify vacation homes, Ashby United States home rentals, and Ashby United States rent houses.
Originate, originate, and discern vacation homes Oak Park United States, Oak Park apartment rentals, and short term rentals in Oak Park.
Soon to be vacant studio hacienda and resort flat are handy in the not far away turf of Fairmont Minnesota.
Ferret out and originate rental apartment in Appleton United States and homes for rent Appleton.
Natives and natives who are searching for home rentals Fairmont and are trying to find real estate rentals and Fairmont Minnesota holiday rentals can smell around our site, FRBO.com and our mountain classified advertisements, mountain ad directories, and exclusive ads.
Conceive, find, and move New York Mills condo rentals, vacation rental in New York Mills United States, and New York Mills vacation homes.
Uncover, identify, and invent Navarre rental homes, Navarre vacation homes, and vacation rentals in Navarre United States.
The Fairmont Minnesota log listed properties and exclusive classifieds for these can be mapped.
Recognize, observe, and espy rental home in Watonwan Minnesota and homes for rent by owner Watonwan Minnesota.
|
|
