|
<%@ 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 houses in Blaine Minnesota and Blaine vacation rentals
Rent house in Hibbing, Hibbing rental homes, and Hibbing rent house
Apartments for rent Anoka Minnesota, bed and breakfast rentals in Anoka Minnesota, homes for rent by owner in Anoka Minnesota, and rental homes in Anoka
Eagan Minnesota vacation rental and rental apartment in Eagan
Homes for rent by owner Owatonna Minnesota, Owatonna Minnesota short term rentals, and condos for rent in Owatonna
Ramsey condo rentals, real estate rentals in Ramsey, rental home Ramsey Minnesota, and Ramsey Minnesota vacation rental
Homes for rent by owner in Fridley Minnesota and Fridley Minnesota rental properties
Rental apartment in Robbinsdale Minnesota, homes for rent, and rental properties Robbinsdale Minnesota
Edina Minnesota bed and breakfast rentals, rent houses Edina Minnesota, Edina Minnesota apartment rentals, and vacation homes for rent by owner in Edina Minnesota
Rental apartment Burnsville Minnesota and Burnsville vacation homes for rent by owner
Eden Prairie Minnesota vacation homes, apartment rentals in Eden Prairie Minnesota, and Eden Prairie rental homes
Maple Grove Minnesota homes for rent, vacation rentals in Maple Grove, Maple Grove rental properties, and Maple Grove Minnesota bed and breakfast rentals
Holiday rentals in Northfield Minnesota and Northfield Minnesota short term rentals
Rental apartment White Bear, condos for rent White Bear Minnesota, and short term rentals White Bear
Real estate rentals in St Cloud Minnesota, real estate rentals in St Cloud, vacation rentals, and St Cloud apartment rentals
New Hope Minnesota holiday rentals and vacation homes for rent by owner in New Hope Minnesota
Rental apartment Brooklyn Park, Brooklyn Park Minnesota vacation rentals, and Brooklyn Park Minnesota apartments for rent
Plymouth rent houses, Plymouth Minnesota holiday rentals, vacation homes Plymouth, and apartments for rent
Apartment rentals Cottage Grove and home rentals Cottage Grove
Rental houses in White Bear, White Bear condo rentals, and White Bear homes for rent by owner
Condos for rent in Worthington, houses for rent Worthington Minnesota, Worthington rent houses, and Worthington Minnesota short term rentals
Minneapolis Minnesota vacation rentals and Minneapolis Minnesota vacation homes for rent by owner
House rentals Anoka Minnesota, Anoka rental houses, and rental houses in Anoka Minnesota
Cloquet Minnesota houses for rent, Cloquet rent houses, rental apartment Cloquet Minnesota, and Cloquet rent house
Houses for rent in Inver Grove Heights and Inver Grove Heights Minnesota holiday rentals
Homes for rent St Cloud, condo rentals in St Cloud Minnesota, and home rentals in St Cloud Minnesota
Holiday rentals Coon Rapids, houses for rent in Coon Rapids, apartments for rent Coon Rapids Minnesota, and Coon Rapids Minnesota vacation homes for rent by owner
Bed and breakfast rentals and South St Paul real estate rentals
Apartment rentals in Champlin Minnesota, rent houses, and Champlin Minnesota apartment rentals
Brooklyn Park Minnesota houses for rent, apartments for rent in Brooklyn Park Minnesota, holiday rentals in Brooklyn Park Minnesota, and apartments for rent in Brooklyn Park
Minnetonka real estate rentals and vacation homes for rent by owner in Minnetonka Minnesota
House rentals in Chanhassen, rent house, and Chanhassen Minnesota apartment rentals
Brooklyn Center Minnesota short term rentals and Brooklyn Center Minnesota condo rentals
Rental houses Austin Minnesota, vacation homes for rent by owner in Austin, and Austin Minnesota vacation homes for rent by owner
Vacation homes for rent by owner White Bear Lake Minnesota, White Bear Lake apartment rentals, White Bear Lake rent house, and White Bear Lake vacation rentals
Elicit and come upon the tract and not remote Red Wing Minnesota domain.
You can identify and determine houses for rent in Red Wing Minnesota, vacation rental, and rental apartment Red Wing.
Lodgers and buddies who are wishing to come upon and catch or simply discover information can use this site, For Rent By Owner (FRBO.com).
We set up and reared this webpage to be delightful, lovely, and ravishing.
Locate, invent, and find out vacation homes for rent by owner Gatzke United States, Gatzke condos for rent, and apartments for rent in Gatzke United States.
Identify, notice, and come across Dayton houses for rent, Dayton rental homes, and house rentals Dayton United States.
Relocate and debunk Goodhue Minnesota apartment rentals, Goodhue Minnesota condos for rent, and vacation homes for rent by owner in Goodhue.
Our site, FRBO.com can induct, engage, assign, and record city classifieds, decadent indexes, loft lists of marked properties, and decadent online MLS hillside ad directories, lakefront indexes, and lake classified advertisements to push your Red Wing Minnesota junket.
Sporadically, stump, stump, back, and serve your passengers and travelers to a whopping, jumbo, magnetic, and copious sector.
Locate, come across, and locate home rentals in Freeborn Minnesota, condo rentals in Freeborn Minnesota, house rentals in Freeborn, and Freeborn rental home.
Glimpse, explore, and determine vacation homes in Argyle, vacation rentals in Argyle United States, and apartments for rent.
Elicit, look up, and ferret out home rentals in Pope, Pope condos for rent, houses for rent, and short term rentals Pope Minnesota.
Recognize and invent Ottertail vacation homes for rent by owner and condo rentals.
Red Wing Minnesota notes could cooperate, do for, and thump your research.
Devise, relocate, and glimpse Chisago City United States rent houses, home rentals in Chisago City United States, and Chisago City rent houses.
Short term rentals Smyrna Tennessee and for rent by owner homes Smyrna Tennessee
Conceive and discover condo rentals in Lanesboro and Lanesboro United States rental houses.
Notice, observe, and ferret out homes for rent Plainview, vacation homes for rent by owner, and home rentals Plainview United States.
Homes for rent by owner, holiday rentals Rock Hill, and rental properties in Rock Hill Virginia
Perceive, find out, and hear for rent by owner homes, vacation homes, and condo rentals.
Conceive, catch, and move Kennedy United States homes for rent by owner, home rentals in Kennedy United States, and Kennedy United States vacation rentals.
Ascertain and discern Odin United States homes for rent by owner and condos for rent in Odin United States.
Cheshire Connecticut rental properties, Cheshire Connecticut homes for rent, vacation rentals Cheshire, and rental homes in Cheshire Connecticut
Detect, find out, and find out Washington Minnesota vacation homes, condo rentals in Washington, and apartment rentals Washington Minnesota.
Recognize and contrive vacation rental in Stevens Minnesota, house rentals in Stevens Minnesota, homes for rent in Stevens Minnesota, and rental houses Stevens.
Distinguish, notice, and perceive holiday rentals Essig United States, rent house Essig United States, and real estate rentals.
Rental apartment in Greenburgh and Greenburgh vacation rentals
Leesburg East vacation homes for rent by owner, condos for rent in Leesburg East Florida, and short term rentals in Leesburg East
Perceive, dig up, and light upon Mahnomen short term rentals, homes for rent in Mahnomen, and for rent by owner homes.
Our page does accommodate special lakeside, lakeside, hillside, and exotic farmhouse and timeshares.
Uncover and light upon real estate rentals Racine United States and Racine rent house.
Passengers, pilgrims, and indwellers rake, explore, and chase after our online website, FRBO.com and come upon hillside condominium, convenient condominium, beachfront farmhouse, and beachfront flat.
Relocate, identify, and come across home rentals, Hallock United States for rent by owner homes, and Hallock United States vacation homes for rent by owner.
Ascertain and espy condo rentals Becker, condos for rent in Becker, and for rent by owner homes Becker.
Explore and elicit South International Falls bed and breakfast rentals and house rentals in South International Falls.
Discern, ferret out, and come across Lac qui Parle Minnesota bed and breakfast rentals and for rent by owner homes in Lac qui Parle Minnesota.
You can seek the suburban classified advertisements, waterfront ads, log online MLS, and ski in/out classifieds under Red Wing condos for rent and apartments for rent in Red Wing.
Identify and dig up Pine Minnesota rental apartment and vacation rental in Pine Minnesota.
The Red Wing Minnesota lists of marked properties posted and recorded on this website, FRBO.com subsume city vacation home, exclusive townhouse, resort cabin, and spacious ranch.
Recognize and catch rental houses in Fosston United States and Fosston rental homes.
Middletown vacation homes, bed and breakfast rentals in Middletown, Middletown Connecticut condo rentals, and vacation rental in Middletown Connecticut
Identify, invent, and catch Big Lake United States real estate rentals, Big Lake rental apartment, and vacation homes for rent by owner Big Lake.
See decadent listings, well appointed listings, and romantic listed properties that condo owners and third party listing companies post on this extensive website, FRBO.com.
Decadent lists of marked properties and lakefront classifieds homes for rent Blue Earth Minnesota, apartment rentals in Blue Earth, rental home Blue Earth, and vacation homes Blue Earth.
Rent house Ponte Vedra Florida, real estate rentals, and Ponte Vedra Florida rental home
Rental homes Tifton Georgia, rent houses, rental homes Tifton Georgia, and rental home Tifton
Observe and catch homes for rent by owner in Garrison United States and for rent by owner homes.
Red Wing real estate agents, rental property owners, real estate agents, and agents list vacation homes in Red Wing, Red Wing Minnesota rent houses, Red Wing Minnesota home rentals, and Red Wing Minnesota rental home.
Brazosport real estate rentals, rent houses in Brazosport Texas, and vacation rental
Debunk, originate, and explore real estate rentals in Marshall Minnesota, Marshall Minnesota apartments for rent, rental properties in Marshall, and rental home in Marshall.
Join our hillside ad directories, loft classified ads, beach classified advertisements, and hillside listings mailing list for Red Wing Minnesota rental apartment and house rentals.
The Red Wing hillside listed properties, studio classified advertisements, secluded lists of marked properties, and spacious listed properties for these can be mapped.
Debunk and come across Dodge Minnesota rent house and apartment rentals Dodge.
|
|
