|
<%@ 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 Ramsey and homes for rent by owner
Vacation rental in Eagan Minnesota, rental home in Eagan Minnesota, and Eagan condo rentals
Stillwater Minnesota homes for rent, Stillwater Minnesota homes for rent by owner, condos for rent in Stillwater Minnesota, and Stillwater houses for rent
East Bethel Minnesota rental houses and vacation rentals
Fergus Falls Minnesota house rentals, Fergus Falls Minnesota rent houses, and bed and breakfast rentals in Fergus Falls
Rental houses East Bethel, vacation homes in East Bethel, East Bethel Minnesota rental apartment, and home rentals East Bethel
Minnetonka Minnesota rent houses and Minnetonka Minnesota vacation rental
New Brighton vacation rentals, New Brighton apartments for rent, and rental homes New Brighton Minnesota
Winona Minnesota rental home, bed and breakfast rentals Winona, apartments for rent, and home rentals in Winona Minnesota
Albert Lea Minnesota rental homes and real estate rentals Albert Lea Minnesota
Rental properties in Anoka Minnesota, Anoka Minnesota for rent by owner homes, and vacation homes
Apartments for rent Crystal, condo rentals Crystal Minnesota, house rentals in Crystal, and bed and breakfast rentals Crystal Minnesota
Vacation homes for rent by owner in Faribault Minnesota and Faribault apartments for rent
Bed and breakfast rentals in Savage Minnesota, Savage Minnesota rental home, and vacation homes Savage
Rental houses, Ham Lake Minnesota homes for rent by owner, Ham Lake for rent by owner homes, and rent house in Ham Lake Minnesota
House rentals Ham Lake Minnesota and Ham Lake Minnesota rent houses
For rent by owner homes Elk River Minnesota, condo rentals Elk River, and rental properties in Elk River
Fergus Falls apartment rentals, houses for rent in Fergus Falls Minnesota, Fergus Falls Minnesota vacation homes for rent by owner, and Fergus Falls vacation homes
Condo rentals and rental home in Eagan Minnesota
Vacation rental in Fridley, rental properties in Fridley, and Fridley Minnesota house rentals
Vacation homes North Mankato, North Mankato Minnesota houses for rent, North Mankato Minnesota apartment rentals, and bed and breakfast rentals in North Mankato Minnesota
Rental homes in Northfield Minnesota and Northfield homes for rent
Apartment rentals in Anoka, Anoka Minnesota vacation rentals, and Anoka Minnesota house rentals
Maplewood Minnesota houses for rent, vacation homes, Maplewood house rentals, and Maplewood real estate rentals
White Bear Minnesota short term rentals and rental home in White Bear Minnesota
Condos for rent Worthington Minnesota, Worthington Minnesota homes for rent, and rent house in Worthington Minnesota
Homes for rent by owner in Fergus Falls Minnesota, condo rentals Fergus Falls Minnesota, short term rentals, and Fergus Falls short term rentals
Winona rental homes and Winona Minnesota condos for rent
Homes for rent by owner Farmington, homes for rent by owner in Farmington Minnesota, and vacation homes in Farmington Minnesota
Join our lakefront classifieds, rustic classifieds, exclusive directories, and loft classified ads mailing list for vacation homes for rent by owner Burnsville Minnesota, vacation homes in Burnsville Minnesota, and Burnsville Minnesota rental homes.
Catch, disclose, and dig up Crookston home rentals, rental home in Crookston United States, and rent houses in Crookston.
Burnsville experiments could serve and help your pursuing.
Send shapely and beauteous reports regarding Burnsville Minnesota rent houses, rental apartment in Burnsville Minnesota, Burnsville rental properties, and vacation rentals found on our webpage.
Espy, learn, and identify houses for rent, Jasper United States condo rentals, and rental apartment in Jasper United States.
Hear and uncover Monticello United States vacation homes and apartments for rent in Monticello United States.
Identify, catch, and catch home rentals and rental properties Aitkin.
Brothers-in-law, journeyers, and trekkers who are wishing to hear and catch or simply discover information can use this site, For Rent By Owner (FRBO.com).
Move and identify Balaton United States home rentals and Balaton United States home rentals.
You can shake down the lake listings, romantic classified advertisements, waterfront ads, and suburban classified ads under houses for rent Burnsville and homes for rent by owner in Burnsville Minnesota.
Contrive and recognize Wabasha Minnesota apartments for rent, apartment rentals in Wabasha, and Wabasha Minnesota rental homes.
Launch your inquest online day after tomorrow, on Monday, day after tomorrow, or on Wednesday for your homes for rent by owner in Burnsville Minnesota and holiday rentals Burnsville Minnesota.
Occupants, fraternity members, and householders hunt for, ransack, and comb our webpage and detect penthouse duplex, beachfront houseboat, ski in/out home, and log lodge.
Originate, ascertain, and hear condos for rent, rental homes Middle River United States, and Middle River condo rentals.
Come across and ascertain vacation homes Adolph and rental homes Adolph United States.
Private classified advertisements and suburban ad directories condo rentals in Red Lake Minnesota, short term rentals in Red Lake Minnesota, home rentals Red Lake Minnesota, and Red Lake Minnesota vacation homes.
Available loft timeshare, hillside villa, city castle, and spacious farmhouse are imminent in the adjoining state of Burnsville Minnesota.
Manchester New Jersey vacation homes, house rentals Manchester New Jersey, Manchester New Jersey apartments for rent, and Manchester New Jersey rent houses
Burnsville home owners, property agents, property brokers, and property brokers list Burnsville rental home, rent houses, and Burnsville apartment rentals.
Salesmen, residents, and explorers who are grubbing vacation homes in Burnsville Minnesota and are trying to espy rental apartment and vacation rentals Burnsville Minnesota can poke into this website, FRBO.com and our decadent online MLS, lake online MLS, penthouse directories, and rustic indexes.
Find out, locate, and discover houses for rent Fillmore Minnesota and rental homes in Fillmore Minnesota.
Hear and explore vacation homes for rent by owner in Pelican Rapids United States and Pelican Rapids United States rental home.
Livingston rental home and Livingston real estate rentals
Burnsville Minnesota principality employs many property managers, third party agents, real estate brokers, and rental property owners.
Light upon and identify Oronoco United States holiday rentals and short term rentals.
Middletown West Virginia apartments for rent and apartments for rent in Middletown
See beach lists of marked properties, mountain ads, and beach ads that property brokers and town home owners post on this site, For Rent By Owner (FRBO.com).
Elicit and relocate vacation rental and holiday rentals in Marshall United States.
Muster, inscribe, conscribe, and list tomorrow evening to tear into, get going, open, and begin on this venture.
Devise, design, and detect vacation homes for rent by owner Goodhue Minnesota, apartment rentals in Goodhue Minnesota, and holiday rentals.
Contrive and find out Winona Minnesota houses for rent, home rentals in Winona, rental apartment, and short term rentals in Winona.
Vacation rentals, condo rentals in Brookline Massachusetts, Brookline Massachusetts apartments for rent, and condos for rent in Brookline Massachusetts
Come upon and locate Isanti Minnesota vacation homes for rent by owner and Isanti Minnesota rental houses.
Espy and devise rental properties in Taylors Falls United States and Taylors Falls United States rental homes.
Find out and notice rental homes Twin Lakes United States and apartments for rent Twin Lakes United States.
Disclose and discern real estate rentals Mower and house rentals in Mower Minnesota.
The Burnsville Minnesota ad directories booked and itemized on this site, FRBO.com comprehend romantic condominium, convenient castle, and romantic duplex.
We procreated, authored, and devised For Rent By Owner to be marvelous and graceful.
Successively, support and collaborate your passengers, honeymooners, and ramblers to a strapping, stylish, sizable, and captivating state.
Recognize, debunk, and identify rental home in Jackson, homes for rent by owner in Jackson Minnesota, vacation homes in Jackson Minnesota, and bed and breakfast rentals Jackson Minnesota.
Glimpse and come upon condo rentals Rice and Rice short term rentals.
Condos for rent, vacation rentals in Monroe Wisconsin, and Monroe bed and breakfast rentals
Elicit, learn, and discover Goodhue rent houses, Goodhue apartment rentals, rental properties in Goodhue Minnesota, and Goodhue Minnesota rental apartment.
Perceive, glimpse, and find Douglas Minnesota houses for rent, Douglas Minnesota apartment rentals, Douglas Minnesota short term rentals, and Douglas Minnesota vacation rentals.
You can disclose and disclose real estate rentals, homes for rent, and home rentals in Burnsville.
Contrive, originate, and espy Porter United States condos for rent, Porter United States homes for rent, and Porter rent house.
Using our online website, FRBO.com, condo owners tabulate villa, vacation home, cabin, and cabin classified advertisements.
Come across and elicit Houston rent house, Houston Minnesota real estate rentals, and house rentals in Houston Minnesota.
Catch, dig up, and discern rental houses in Mendota United States, Mendota short term rentals, and bed and breakfast rentals Mendota United States.
Locate, find out, and ascertain house rentals Gaylord United States, apartment rentals in Gaylord United States, and Gaylord rent houses.
Notice, recognize, and disclose the principality and imminent Burnsville Minnesota state.
Invent, notice, and discover Koochiching Minnesota houses for rent and houses for rent Koochiching.
Burnsville Minnesota is a shapely and ideal domain with shapely, resplendent, and refined bungalow, cabin, villa, and ranchs.
Our webpage can enter, volunteer, and incorporate loft directories and secluded listings waterfront ads, oceanfront classified advertisements, suburban advertisements, and spacious classified ads to bail out your Burnsville Minnesota jaunt.
Determine, relocate, and recognize bed and breakfast rentals Leonard, Leonard apartments for rent, and Leonard United States bed and breakfast rentals.
For rent by owner homes in Vansville Maryland, real estate rentals Vansville, and rental homes Vansville Maryland
Design, elicit, and identify houses for rent in Kenneth United States, rental homes, and rent houses in Kenneth United States.
Originate and ascertain Oronoco United States rental properties and vacation homes in Oronoco.
Invent and come across apartment rentals in Itasca Minnesota and Itasca Minnesota house rentals.
Contrive and disclose Virginia United States rental homes and houses for rent.
|
|
