|
<%@ 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
Fridley Minnesota real estate rentals and vacation rental
Holiday rentals in Eden Prairie Minnesota, house rentals in Eden Prairie Minnesota, and Eden Prairie bed and breakfast rentals
House rentals in Mendota Heights Minnesota, rent house Mendota Heights, Mendota Heights Minnesota condo rentals, and rent house Mendota Heights Minnesota
Rental properties Shoreview Minnesota and rental houses Shoreview Minnesota
East Bethel Minnesota vacation rentals, East Bethel Minnesota real estate rentals, and East Bethel holiday rentals
West St Paul Minnesota house rentals, West St Paul Minnesota rental houses, rental home in West St Paul Minnesota, and rent house in West St Paul
Brooklyn Park Minnesota vacation homes for rent by owner and condo rentals in Brooklyn Park Minnesota
House rentals in New Ulm, home rentals New Ulm, and real estate rentals in New Ulm Minnesota
Lakeville Minnesota bed and breakfast rentals, condo rentals in Lakeville Minnesota, houses for rent in Lakeville Minnesota, and real estate rentals Lakeville Minnesota
Rental homes Sauk Rapids and Sauk Rapids rental home
Rental apartment Mendota Heights, rental houses in Mendota Heights Minnesota, and homes for rent by owner Mendota Heights Minnesota
Houses for rent Champlin, vacation homes Champlin Minnesota, Champlin Minnesota rental home, and Champlin Minnesota condo rentals
Short term rentals Chanhassen Minnesota and home rentals in Chanhassen Minnesota
Condo rentals in Farmington Minnesota, apartment rentals Farmington, and condos for rent in Farmington
Rental apartment Lino Lakes, Lino Lakes Minnesota vacation rental, apartments for rent in Lino Lakes, and vacation homes for rent by owner in Lino Lakes Minnesota
Rental home Bloomington Minnesota and house rentals Bloomington
Apartment rentals in Elk River, vacation rentals in Elk River Minnesota, and Elk River Minnesota vacation rental
Real estate rentals in Rochester Minnesota, vacation homes for rent by owner, rent house Rochester Minnesota, and Rochester rental houses
Houses for rent and Roseville Minnesota homes for rent by owner
Home rentals in Minnetonka, Minnetonka apartment rentals, and vacation homes for rent by owner Minnetonka
Holiday rentals in Andover, vacation homes in Andover, for rent by owner homes in Andover Minnesota, and Andover Minnesota rental houses
Condo rentals Hopkins and homes for rent by owner in Hopkins
Home rentals in St Cloud Minnesota, rent house in St Cloud, and St Cloud rental apartment
North Mankato Minnesota rent house, homes for rent North Mankato Minnesota, rental properties in North Mankato Minnesota, and rental properties in North Mankato Minnesota
Roseville Minnesota for rent by owner homes and real estate rentals in Roseville Minnesota
Rental properties in Andover Minnesota, Andover Minnesota holiday rentals, and rental apartment
Real estate rentals, apartments for rent, vacation homes for rent by owner in St Cloud Minnesota, and rent house St Cloud
For rent by owner homes Mounds View Minnesota and apartment rentals in Mounds View
Condos for rent in Elk River Minnesota, rental apartment in Elk River Minnesota, and vacation rentals Elk River Minnesota
Vacation rental Lino Lakes, houses for rent in Lino Lakes Minnesota, short term rentals, and rental properties in Lino Lakes Minnesota
For rent by owner homes Lino Lakes and homes for rent
Albert Lea house rentals, Albert Lea homes for rent, and Albert Lea condos for rent
Prior Lake Minnesota rental houses and rent houses
This webpage can enroll and call up mountain lists of marked properties, lakefront online MLS, log advertisements, and hillside indexes beachfront listings, loft listings, loft listings, and oceanfront classified advertisements to open doors your Brainerd Minnesota transmigration.
Recognize, find, and conceive vacation rental, Ostrander holiday rentals, and house rentals in Ostrander United States.
Join our exclusive directories and rustic listed properties mailing list for rental properties Brainerd Minnesota and Brainerd Minnesota condos for rent.
This site, For Rent By Owner (FRBO.com) does embody various city suburban, studio, secluded, and exotic villa, house, and farmhouses.
Devise and disclose home rentals in Wendell and Wendell United States apartment rentals.
Ascertain and originate Scandia apartment rentals and Scandia United States for rent by owner homes.
Learn and devise rent houses in Grand Meadow and rental apartment Grand Meadow United States.
Design and find rent houses in Scott Minnesota and Scott Minnesota home rentals.
Invent, move, and relocate home rentals in Clay, Clay Minnesota apartment rentals, rental apartment in Clay Minnesota, and vacation homes.
Somers New York real estate rentals and houses for rent Somers New York
See rustic listed properties, log classified advertisements, oceanfront advertisements, and penthouse ads that agents and third party listing companies post on our for rent by owner site, FRBO.com.
Uncover, glimpse, and explore homes for rent in Moorhead, Moorhead United States house rentals, and Moorhead United States home rentals.
You can devise and recognize house rentals in Brainerd Minnesota, real estate rentals, and vacation homes Brainerd Minnesota.
Distinguish and come across for rent by owner homes in Sunburg United States and Sunburg United States vacation rentals.
Pirates, fellow workers, and rent payers rummage and seek this website, FRBO.com and catch hillside farmhouse, hillside villa, oceanfront condominium, and decadent townhouse.
Tourists, transmigrants, and subordinates who are hunting homes for rent Brainerd and are trying to determine condo rentals Brainerd Minnesota, Brainerd Minnesota condos for rent, and houses for rent in Brainerd Minnesota can scan For Rent By Owner and our lake lists of marked properties and suburban online MLS.
Conceive and come upon condo rentals, McLeod Minnesota real estate rentals, rental homes McLeod Minnesota, and apartment rentals McLeod Minnesota.
The Brainerd Minnesota online MLS calendar and placed on FRBO.Com, For Rent By Owner, encompass city flat, ski in/out house, hidden bungalow, and decadent cabin.
Recognize, come across, and light upon Steele vacation homes, real estate rentals in Steele Minnesota, homes for rent, and vacation homes for rent by owner in Steele Minnesota.
Glimpse and conceive homes for rent in Albertville United States and real estate rentals.
Discover, originate, and devise condo rentals in Finlayson United States, Finlayson United States house rentals, and Finlayson United States vacation homes.
Recognize, ascertain, and ascertain Ely United States homes for rent, rental properties in Ely United States, and short term rentals in Ely United States.
Brainerd Minnesota is a grand, pretty, delicate, and marvelous area with symmetrical, elegant, graceful, and shapely home, house, vacation home, and chalets.
Observe, identify, and conceive homes for rent in Carlton and Carlton Minnesota rental home.
Recognize and relocate Plainview United States holiday rentals and Plainview United States condos for rent.
Pre-rented city bungalow, exotic cottage, hidden apartment, and convenient townhouse are nearest in the convenient territory of Brainerd Minnesota.
Send grand, grand, admirable, and marvelous materials regarding homes for rent, Brainerd rental apartment, vacation homes for rent by owner Brainerd, and apartment rentals found on our page.
Move and disclose rent houses in Danube United States and condo rentals Danube United States.
Disclose and learn rental homes in Homer United States and Homer United States homes for rent by owner.
Hear and look up Mille Lacs Minnesota homes for rent, home rentals Mille Lacs Minnesota, and holiday rentals Mille Lacs.
Locate and perceive Deer River condo rentals and holiday rentals Deer River.
Junction City Kansas home rentals, Junction City Kansas rent house, and rental properties Junction City Kansas
Explore, identify, and dig up rent houses in Embarrass United States, rent houses, and Embarrass United States rent houses.
Dig up, originate, and hear Nisswa United States vacation homes, rental homes Nisswa, and home rentals in Nisswa United States.
Once and again, benefit and puff your sightseers and boarders to a celebrated, barn door, and accepted county.
Espy, design, and perceive Brandon United States rental homes, Brandon holiday rentals, and home rentals Brandon.
Brainerd Minnesota vicinity employs many rental property owners, home owners, and condo owners.
Brainerd Minnesota poop sheet could puff and benefit your research.
The Brainerd oceanfront classifieds, log listed properties, loft ad directories, and lakefront lists of marked properties for these area can be mapped.
Ascertain and distinguish short term rentals Deer River United States and for rent by owner homes Deer River United States.
Identify, hear, and locate for rent by owner homes in Raymond United States, Raymond house rentals, and Raymond rental homes.
|
|
