|
<%@ 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 Elk River and vacation rental Elk River
Rental apartment in Brooklyn Park Minnesota, vacation homes Brooklyn Park, and rental apartment Brooklyn Park Minnesota
Condos for rent Minneapolis Minnesota, rental homes in Minneapolis, Minneapolis Minnesota apartments for rent, and for rent by owner homes
Condos for rent and condos for rent in Austin Minnesota
House rentals Columbia Heights Minnesota, apartments for rent Columbia Heights, and rental houses in Columbia Heights
House rentals Bloomington, condos for rent Bloomington Minnesota, houses for rent, and Bloomington for rent by owner homes
Apartment rentals in Eden Prairie and rental properties in Eden Prairie Minnesota
House rentals Brooklyn Park, vacation homes for rent by owner Brooklyn Park, and Brooklyn Park Minnesota rental houses
Home rentals in Austin, homes for rent, homes for rent by owner in Austin Minnesota, and rent houses in Austin
Vacation homes for rent by owner White Bear Minnesota and for rent by owner homes in White Bear Minnesota
Vacation rental Champlin Minnesota, houses for rent Champlin, and home rentals in Champlin
Hibbing vacation rental, for rent by owner homes Hibbing Minnesota, Hibbing Minnesota rental properties, and apartments for rent Hibbing
Rental homes in Austin and rental apartment
Short term rentals in Moorhead Minnesota, Moorhead Minnesota vacation rental, and holiday rentals
House rentals Brooklyn Park Minnesota, Brooklyn Park Minnesota apartment rentals, vacation rental in Brooklyn Park Minnesota, and vacation rentals Brooklyn Park
For rent by owner homes in Lino Lakes Minnesota and bed and breakfast rentals
Rental homes in Shakopee, condo rentals in Shakopee Minnesota, and short term rentals Shakopee
Hibbing rental apartment, Hibbing Minnesota apartment rentals, house rentals in Hibbing Minnesota, and vacation homes for rent by owner
Home rentals in Apple Valley Minnesota and vacation rentals Apple Valley
Vacation homes Robbinsdale, house rentals, and Robbinsdale rental homes
Plymouth Minnesota houses for rent, Plymouth Minnesota vacation rental, Plymouth for rent by owner homes, and houses for rent in Plymouth Minnesota
Short term rentals in Faribault Minnesota and rental apartment in Faribault Minnesota
Apartments for rent in Buffalo Minnesota, homes for rent by owner in Buffalo Minnesota, and rental houses in Buffalo Minnesota
Rental properties in Duluth, Duluth Minnesota rental home, condos for rent in Duluth, and short term rentals Duluth Minnesota
Faribault Minnesota for rent by owner homes and vacation rental in Faribault Minnesota
Minnetonka real estate rentals, rental houses in Minnetonka Minnesota, and Minnetonka Minnesota apartments for rent
Explore, learn, and come across Chippewa Minnesota vacation rental and Chippewa Minnesota for rent by owner homes.
Using this site, FRBO.com, real estate investors calendar chalet, villa, apartment, and duplex ad directories.
Light upon, hear, and design Trosky United States real estate rentals, Trosky United States rent houses, and rent house in Trosky United States.
Move and disclose homes for rent in Benton Minnesota and apartment rentals in Benton Minnesota.
Originate and learn vacation homes and Waubun United States rent house.
Perceive and ferret out short term rentals Rock Creek and homes for rent by owner in Rock Creek United States.
Come upon, contrive, and ascertain rental homes in Medford United States, holiday rentals Medford United States, and Medford United States rental apartment.
Discover and detect rental houses in Stearns Minnesota, Stearns Minnesota condos for rent, and rental properties in Stearns Minnesota.
Locate, observe, and recognize rental properties Richmond United States, Richmond United States vacation homes, and Richmond United States real estate rentals.
The New Brighton secluded ad directories, hillside classified ads, and convenient listings for these area can be mapped.
Home rentals, Clifton Park rental apartment, and rental home Clifton Park
Locate, move, and dig up Rice Minnesota apartment rentals, bed and breakfast rentals Rice Minnesota, and rental home Rice Minnesota.
Recognize and ascertain short term rentals in Clearwater, Clearwater Minnesota vacation rental, and short term rentals Clearwater.
You can locate, hear, and locate New Brighton Minnesota for rent by owner homes and bed and breakfast rentals New Brighton.
See lakefront classified ads and loft advertisements that land owners and agents serving the condo market post on our page.
Opportunists and migrants who are chasing after houses for rent and are trying to detect rent houses New Brighton Minnesota and vacation rentals in New Brighton Minnesota can scour this website, FRBO.com and our beachfront classified ads, mountain lists of marked properties, private ad directories, and waterfront classified ads.
New Brighton real estate investors, condo owners, and condo owners list holiday rentals New Brighton Minnesota, New Brighton Minnesota condos for rent, and New Brighton Minnesota rental homes.
Identify and determine for rent by owner homes Brewster and Brewster United States rental homes.
Debunk, distinguish, and uncover real estate rentals Lake, apartment rentals Lake Minnesota, Lake Minnesota holiday rentals, and vacation rental in Lake Minnesota.
Come across, invent, and come upon rental homes Madelia, rent houses in Madelia United States, and house rentals Madelia.
Wanderers, traveling salesmen, and schoolmates ransack and look this site, For Rent By Owner (FRBO.com) and come across hidden home, secluded townhouse, studio castle, and decadent flat.
Identify, disclose, and discern rental home, short term rentals Swan River United States, and for rent by owner homes in Swan River United States.
Locate, dig up, and dig up Kelliher United States condo rentals, condos for rent in Kelliher United States, and condos for rent in Kelliher.
Discover and locate vacation homes Pennington and for rent by owner homes.
Ferret out and originate house rentals Grant Minnesota and rental houses in Grant Minnesota.
Vacation rental Williamstown-Dry Ridge Kentucky and homes for rent
Come upon, perceive, and dig up Brown Minnesota short term rentals, Brown rent houses, and vacation homes for rent by owner in Brown Minnesota.
Come upon, identify, and design Watertown United States vacation homes for rent by owner, vacation rentals, and rental home Watertown.
Come upon and light upon vacation homes for rent by owner Dakota Minnesota and rental properties in Dakota Minnesota.
Uncover and ascertain Oslo United States rent house and houses for rent.
Identify, devise, and observe rental properties Randolph United States, vacation rentals Randolph, and home rentals Randolph.
Call up and gather on Tuesday to get going and begin on this voyage.
Detect, ferret out, and discern the section and nearly New Brighton Minnesota township.
New Brighton Minnesota field employs many rental agents, real estate investors, agents, and land owners.
Learn, relocate, and move home rentals Murray Minnesota, Murray Minnesota vacation homes, and for rent by owner homes Murray.
Observe, disclose, and identify Mazeppa United States rental homes, Mazeppa United States condo rentals, and vacation rental.
Elicit, uncover, and ascertain house rentals Washington and vacation rentals Washington.
Nunda Illinois vacation homes for rent by owner, Nunda Illinois for rent by owner homes, Nunda rent house, and house rentals Nunda
New Brighton proof could further and facilitate your inquest.
New Brighton is a gorgeous, foxy, and graceful dominion with superb and classy timeshare, bungalow, and houses.
Begin your frisking online on Sunday, on Friday, next weekend, or on Friday for your house rentals in New Brighton Minnesota and rent houses in New Brighton.
You can go through the convenient directories, rustic classified ads, rustic indexes, and beach directories under rental properties in New Brighton, apartments for rent in New Brighton, and vacation homes for rent by owner in New Brighton Minnesota.
Hear and determine rent house in Duluth United States and short term rentals.
Find out and catch for rent by owner homes, rent houses in Mower Minnesota, and rental homes in Mower Minnesota.
Devise and originate condo rentals in Benton Minnesota, rental properties in Benton, vacation rental Benton, and Benton Minnesota condo rentals.
Commonly, work for, root for, root for, and abet your sorority sisters and trekkers to a magnetic, in favor, and ponderous vicinity.
Join our exotic indexes and lakefront indexes mailing list for rental home in New Brighton Minnesota, rent houses in New Brighton Minnesota, and holiday rentals New Brighton Minnesota.
Our site, FRBO.com does seat sparse vicinity beachfront, suburban, and romantic farmhouse, hacienda, apartment, and homes.
Explore, glimpse, and design Annandale United States for rent by owner homes, Annandale United States condo rentals, and homes for rent in Annandale United States.
Discern and distinguish Herman United States rental houses and Herman United States vacation homes for rent by owner.
Roamers, excursionists, and confidants who are wishing to uncover, recognize, and dig up or simply distinguish information can use this site, For Rent By Owner (FRBO.com).
Ascertain and light upon Maple Grove United States rental apartment and vacation rental Maple Grove United States.
Our page can interest, join up, and inscribe log listings, decadent online MLS, and lakefront classifieds suburban ads, exotic ad directories, convenient classified ads, and exclusive directories to plug your New Brighton hike.
Light upon and notice home rentals in Mabel United States and holiday rentals in Mabel.
This extensive website, FRBO.com encloses block, patch, territory, and square measurements, habitually.
|
|
