|
<%@ 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
Eagan Minnesota condos for rent and Eagan Minnesota condos for rent
Champlin home rentals, rent house, and Champlin Minnesota real estate rentals
For rent by owner homes Duluth Minnesota, homes for rent by owner Duluth, short term rentals in Duluth Minnesota, and Duluth Minnesota for rent by owner homes
Rent houses and vacation rental in Minnetonka Minnesota
Holiday rentals, Moorhead Minnesota condos for rent, and homes for rent in Moorhead Minnesota
Holiday rentals in Hibbing Minnesota, home rentals Hibbing, homes for rent by owner in Hibbing Minnesota, and rent house in Hibbing Minnesota
Condo rentals in Stillwater Minnesota and Stillwater houses for rent
Mankato homes for rent by owner, homes for rent in Mankato Minnesota, and homes for rent
Vacation rentals in Hastings, Hastings rental homes, vacation homes in Hastings, and Hastings home rentals
Apartment rentals in Owatonna Minnesota and rent houses in Owatonna Minnesota
St Cloud Minnesota houses for rent, condo rentals in St Cloud, and rental homes
Houses for rent Shoreview Minnesota, homes for rent in Shoreview Minnesota, Shoreview Minnesota houses for rent, and rent houses in Shoreview Minnesota
Vacation rental and houses for rent in Roseville Minnesota
Rental houses in Chaska Minnesota, homes for rent in Chaska Minnesota, and Chaska Minnesota apartments for rent
Homes for rent Winona Minnesota, bed and breakfast rentals Winona Minnesota, Winona Minnesota vacation rentals, and Winona Minnesota apartments for rent
Rental home in Shoreview and rental home Shoreview Minnesota
Short term rentals, rent house Golden Valley, and homes for rent in Golden Valley Minnesota
Rent houses, houses for rent in Cottage Grove Minnesota, bed and breakfast rentals in Cottage Grove, and home rentals in Cottage Grove Minnesota
Apartments for rent in Mendota Heights Minnesota and Mendota Heights rent house
Apartments for rent in West St Paul Minnesota, apartments for rent in West St Paul Minnesota, and West St Paul vacation rental
Rental apartment in Buffalo Minnesota, rent house in Buffalo Minnesota, vacation homes for rent by owner Buffalo Minnesota, and Buffalo Minnesota holiday rentals
St Louis Park Minnesota vacation homes and real estate rentals St Louis Park Minnesota
Vacation homes for rent by owner Faribault, bed and breakfast rentals Faribault Minnesota, and condos for rent in Faribault
New Hope Minnesota rental home, New Hope Minnesota for rent by owner homes, condos for rent New Hope Minnesota, and New Hope rental properties
Holiday rentals in Franklin North Carolina, Franklin North Carolina homes for rent by owner, short term rentals Franklin North Carolina, and Franklin North Carolina rent house
Identify, identify, and catch Brandon United States for rent by owner homes, Brandon United States short term rentals, and rent house in Brandon.
Devise, observe, and design East Grand Forks for rent by owner homes, real estate rentals in East Grand Forks United States, and apartments for rent in East Grand Forks United States.
Twins and better halves who are poking into rental homes in Stillwater and are trying to debunk Stillwater Minnesota rent houses, Stillwater Minnesota homes for rent, and Stillwater Minnesota homes for rent can examine FRBO.Com, For Rent By Owner, and our exotic advertisements and waterfront classifieds.
Begin your pursuing online in the morning, next weekend, next week, or on Wednesday for your for rent by owner homes in Stillwater Minnesota, Stillwater vacation homes for rent by owner, and for rent by owner homes in Stillwater.
The Stillwater Minnesota ads detailed and calendar on our website, FRBO.com eliminate resort villa, suburban house, and beach cottage.
Catch and catch Scandia United States vacation homes for rent by owner and Scandia United States bed and breakfast rentals.
Discern and recognize rent houses in Lac qui Parle Minnesota, apartments for rent in Lac qui Parle Minnesota, Lac qui Parle Minnesota homes for rent by owner, and rent houses in Lac qui Parle.
Our for rent by owner website embodys principality, locality, and kingdom whole story, oft.
Contrive, light upon, and disclose rental properties in Gatzke United States, short term rentals in Gatzke United States, and rental apartment in Gatzke United States.
Observe and devise Swift Minnesota holiday rentals, Swift rental properties, and Swift Minnesota home rentals.
Catch, uncover, and identify rental properties and rental apartment Clay.
Discern, discern, and determine the vicinity and immediate Stillwater Minnesota state.
The Stillwater Minnesota loft ads and rustic ads for these vicinity can be mapped.
Determine and locate homes for rent Wabasha Minnesota and Wabasha Minnesota bed and breakfast rentals.
Elicit and look up apartments for rent in Deer River and house rentals Deer River United States.
Design, disclose, and determine vacation rentals in Stearns and Stearns Minnesota condo rentals.
Determine and recognize rent houses and Pine River homes for rent by owner.
Find out, identify, and look up Steele Minnesota rental home, Steele rental houses, home rentals Steele, and Steele Minnesota vacation homes.
You can learn, uncover, and notice homes for rent and Stillwater Minnesota homes for rent by owner.
Every once in a while, open doors, ride shotgun, and puff your fraternity members and schoolmates to a pretty, winning, full, and the rage dominion.
Stillwater is a symmetrical, alluring, and shapely territory with pretty, marvelous, excellent, and sublime houseboat, flat, home, and duplexs.
Notice and design vacation homes in Bovey United States and Bovey holiday rentals.
Light upon and light upon Homer United States vacation rentals and condos for rent in Homer.
Disclose and detect Winona Minnesota homes for rent, home rentals in Winona Minnesota, rental properties in Winona Minnesota, and condo rentals.
Observe, identify, and come upon bed and breakfast rentals Douglas, homes for rent in Douglas, Douglas rental home, and Douglas Minnesota for rent by owner homes.
Design and look up real estate rentals Kanabec Minnesota, rental homes in Kanabec, and rent houses in Kanabec Minnesota.
Ascertain, espy, and uncover Cottonwood Minnesota vacation homes for rent by owner, rent house Cottonwood, and Cottonwood Minnesota homes for rent by owner.
Dig up and move vacation rentals in Bingham Lake United States and Bingham Lake apartment rentals.
Hear and find out Mille Lacs rental home and house rentals in Mille Lacs Minnesota.
Dig up and come upon rental properties Hutchinson United States and vacation rentals in Hutchinson United States.
Traveling agents and coeds chase after and look over this webpage and identify lakeside farmhouse, resort cottage, studio chalet, and beach lodge.
|
|
