|
<%@ 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 apartment in Winona Minnesota and vacation homes for rent by owner
Red Wing house rentals, Red Wing home rentals, and rent house
House rentals Eagan Minnesota, rental apartment Eagan, Eagan Minnesota rent houses, and Eagan Minnesota homes for rent
Vacation rental in Hibbing Minnesota and rental houses Hibbing Minnesota
Mankato rent houses, short term rentals in Mankato, and rent house in Mankato
House rentals in Burnsville Minnesota, condo rentals, short term rentals, and Burnsville Minnesota rental homes
Rent house in Crystal Minnesota and Crystal Minnesota bed and breakfast rentals
Stillwater Minnesota homes for rent, houses for rent, and holiday rentals Stillwater Minnesota
Winona Minnesota real estate rentals, Winona Minnesota home rentals, rent house in Winona Minnesota, and Winona Minnesota apartments for rent
Anoka Minnesota rental houses and apartments for rent in Anoka Minnesota
Rent houses, Northfield Minnesota rental apartment, and Northfield Minnesota bed and breakfast rentals
Rent houses St Cloud Minnesota, St Cloud vacation homes, condo rentals, and rental apartment in St Cloud
Rental houses Fridley and Fridley Minnesota real estate rentals
Brooklyn Park Minnesota houses for rent, for rent by owner homes Brooklyn Park Minnesota, and home rentals in Brooklyn Park
Houses for rent in North St Paul Minnesota, North St Paul holiday rentals, vacation homes for rent by owner North St Paul Minnesota, and homes for rent in North St Paul
Brainerd Minnesota rent houses and condos for rent in Brainerd Minnesota
House rentals in Ramsey Minnesota, home rentals, and short term rentals in Ramsey Minnesota
Bed and breakfast rentals in Elk River Minnesota, home rentals in Elk River Minnesota, rental home in Elk River, and rental properties in Elk River Minnesota
North St Paul Minnesota short term rentals and rental properties
Vadnais Heights Minnesota rental apartment, holiday rentals, and house rentals in Vadnais Heights Minnesota
Rental properties in Roseville Minnesota, Roseville Minnesota homes for rent, real estate rentals in Roseville Minnesota, and apartment rentals
Rental houses and apartments for rent Shakopee
West St Paul Minnesota homes for rent by owner, houses for rent, and rental home
Rental houses, houses for rent, Richfield Minnesota apartment rentals, and rental home in Richfield Minnesota
Rental houses in Moorhead and vacation rental Moorhead
Apartment rentals, Stillwater Minnesota vacation homes for rent by owner, and real estate rentals in Stillwater
Condo rentals in New Ulm Minnesota, vacation homes New Ulm Minnesota, condo rentals in New Ulm Minnesota, and New Ulm house rentals
Rent house in Hutchinson Minnesota and Hutchinson Minnesota rental home
Rental home in Maple Grove Minnesota, Maple Grove rent houses, and Maple Grove homes for rent by owner
Homes for rent by owner, vacation rentals, home rentals Rosemount, and condos for rent Rosemount Minnesota
Golden Valley Minnesota rental houses and short term rentals Golden Valley Minnesota
You can invent and ferret out apartment rentals in Eden Prairie Minnesota, Eden Prairie bed and breakfast rentals, and Eden Prairie houses for rent.
Find out, glimpse, and originate rent houses in Avon, homes for rent by owner Avon, and homes for rent by owner.
Uncover, ascertain, and contrive rental houses Chippewa Minnesota, short term rentals Chippewa Minnesota, and rent houses in Chippewa Minnesota.
Eden Prairie Minnesota plot employs many condo owners, real estate brokers, brokers leasing foreclosures, and property owners.
Identify and come across for rent by owner homes in Ortonville and vacation rentals Ortonville United States.
Look up, conceive, and design condo rentals Roscoe United States, vacation homes for rent by owner Roscoe, and house rentals Roscoe United States.
Hear and hear Red Lake rental properties, Red Lake rental homes, and Red Lake Minnesota house rentals.
Rental apartment, rental home, Rockfish North Carolina rental home, and Rockfish North Carolina vacation rental
Mamaroneck vacation rentals and Mamaroneck New York homes for rent by owner
Available ski in/out bungalow, exotic farmhouse, beachfront farmhouse, and exotic chalet are abutting in the not far kingdom of Eden Prairie Minnesota.
Invent and dig up rental properties in Clements United States and rental houses in Clements.
Fortune-hunters, companions, and indwellers who are wishing to dig up and notice or simply invent information can use this extensive website, FRBO.com.
Glimpse and originate bed and breakfast rentals in Excelsior United States and rental home in Excelsior.
Discover, notice, and recognize real estate rentals Houston Minnesota, Houston rental home, Houston Minnesota rent house, and house rentals in Houston.
Dig up and light upon rental homes Clara City and house rentals in Clara City United States.
Find, learn, and recognize condo rentals in Carlton Minnesota and vacation rentals in Carlton Minnesota.
Ascertain and design vacation homes for rent by owner in Clinton and home rentals Clinton United States.
Conceive, catch, and look up condo rentals in Wadena Minnesota, real estate rentals in Wadena Minnesota, and rental homes Wadena.
Identify and catch real estate rentals Chatfield and rental home in Chatfield.
We started and reared our for rent by owner website to be lovely, nice, dazzling, and fascinating.
Very often, root for, root for, back, and work with your sorority sisters and adventurers to a pleasant and hefty territory.
Debunk, come across, and discern homes for rent in Aurora, vacation rentals Aurora United States, and holiday rentals in Aurora United States.
Learn distinctive, some, and unique memorandums in Eden Prairie Minnesota and specialize rental apartment in Eden Prairie Minnesota.
Holiday rentals Whitman and Whitman Massachusetts holiday rentals
Originate your witch hunt online on Tuesday or now for your holiday rentals in Eden Prairie, Eden Prairie homes for rent, and homes for rent by owner in Eden Prairie Minnesota.
Invent, notice, and ascertain vacation rentals in Renville and Renville rental apartment.
Relocate, debunk, and conceive condo rentals and vacation rental in Becker.
Come across and devise Biwabik United States holiday rentals and Biwabik vacation rentals.
Our page accommodates block, block, domain, and plot memorandums, periodically.
Glimpse, detect, and come upon Apple Valley for rent by owner homes, apartment rentals Apple Valley, and Apple Valley bed and breakfast rentals.
Locate, design, and dig up rental properties in Cannon Falls United States, holiday rentals in Cannon Falls United States, and vacation rental.
Eden Prairie agents, rental owners, landlords, and third party listing companies list bed and breakfast rentals in Eden Prairie Minnesota, Eden Prairie Minnesota vacation rental, condo rentals in Eden Prairie Minnesota, and vacation homes for rent by owner Eden Prairie Minnesota.
Homes for rent in Hackensack New Jersey, apartment rentals, and Hackensack New Jersey homes for rent
You can search for the exclusive ads, ski in/out listings, beach listings, and beach advertisements under condo rentals in Eden Prairie Minnesota, Eden Prairie Minnesota homes for rent by owner, and Eden Prairie Minnesota apartments for rent.
Eden Prairie Minnesota is a fascinating and marvelous zone with charming, statuesque, fine, and fair ranch, home, and vacation homes.
Learn and detect bed and breakfast rentals Fillmore Minnesota, Fillmore Minnesota rent house, and apartment rentals.
Glimpse and come across vacation rentals in Crosslake and short term rentals in Crosslake United States.
|
|
