|
<%@ 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 rental in Eden Prairie and Eden Prairie houses for rent
Vacation homes for rent by owner in Champlin, house rentals Champlin Minnesota, and Champlin Minnesota apartment rentals
Vacation homes for rent by owner in St Cloud Minnesota, St Cloud vacation rental, rental apartment St Cloud Minnesota, and condo rentals St Cloud
For rent by owner homes Anoka and homes for rent in Anoka
Homes for rent in Robbinsdale, rent house in Robbinsdale, and rental apartment in Robbinsdale Minnesota
Rental apartment Mankato Minnesota, homes for rent by owner Mankato, short term rentals in Mankato Minnesota, and Mankato Minnesota home rentals
Houses for rent in Mendota Heights Minnesota and apartments for rent
Condo rentals Minneapolis Minnesota, rental apartment, and rental houses
Vacation rentals Cloquet, vacation rentals Cloquet Minnesota, rental homes in Cloquet Minnesota, and rent house
Homes for rent by owner Fridley and rental home
Anoka Minnesota vacation rentals, Anoka condo rentals, and rental apartment Anoka Minnesota
Vacation homes for rent by owner, Austin Minnesota short term rentals, houses for rent Austin, and home rentals Austin
Andover Minnesota rental houses and rental home in Andover Minnesota
White Bear Lake Minnesota condos for rent, rental properties White Bear Lake, and bed and breakfast rentals White Bear Lake
Rent houses Ramsey, rent house in Ramsey Minnesota, rental home, and home rentals Ramsey Minnesota
Real estate rentals South St Paul and holiday rentals in South St Paul
New Ulm houses for rent, New Ulm Minnesota rental properties, and homes for rent by owner New Ulm Minnesota
Richfield vacation rental, Richfield Minnesota apartments for rent, homes for rent in Richfield Minnesota, and vacation rental
Roseville rental homes and rent houses in Roseville Minnesota
Rent houses Eagan Minnesota, Eagan vacation rental, and Eagan Minnesota real estate rentals
Homes for rent by owner in Plymouth Minnesota, rent house Plymouth, Plymouth Minnesota apartments for rent, and Plymouth Minnesota rent houses
Bed and breakfast rentals in Marshall and Marshall vacation rental
Prior Lake Minnesota condos for rent, home rentals, and Prior Lake Minnesota vacation homes for rent by owner
Short term rentals Prior Lake Minnesota, Prior Lake for rent by owner homes, apartment rentals in Prior Lake Minnesota, and home rentals in Prior Lake Minnesota
Holiday rentals in South St Paul Minnesota and houses for rent in South St Paul Minnesota
Bed and breakfast rentals in Anoka, apartments for rent Anoka, and homes for rent by owner
Homes for rent in Shakopee Minnesota, Shakopee Minnesota vacation rentals, vacation homes in Shakopee Minnesota, and rental apartment
Eagan Minnesota apartment rentals and vacation homes for rent by owner Eagan
North St Paul Minnesota vacation rentals, North St Paul Minnesota rental homes, and apartment rentals in North St Paul Minnesota
Homes for rent Ramsey, Ramsey Minnesota condos for rent, apartments for rent Ramsey Minnesota, and Ramsey rent house
Condos for rent in Duluth and rental apartment
East Bethel rental apartment, holiday rentals East Bethel, and vacation rentals in East Bethel Minnesota
Send nice, handsome, and angelic figures regarding real estate rentals, apartment rentals in Minnetonka, and for rent by owner homes in Minnetonka found on our webpage.
Espy and perceive Anoka vacation homes and rental houses Anoka Minnesota.
Libertyville rental home and condo rentals Libertyville Illinois
FRBO.com seats township, vicinity, turf, and field documents, recurrently.
Dwellers, renters, and spouses comb and rummage this site, For Rent By Owner (FRBO.com) and relocate beach farmhouse, lakeside ranch, lakeside cabin, and beachfront houseboat.
Relocate, elicit, and design rental homes in Houston, for rent by owner homes in Houston, and rent houses.
Distinguish, debunk, and glimpse rental apartment in Jackson Minnesota and rental houses Jackson.
Notice and explore rental home Lake Crystal United States and holiday rentals in Lake Crystal United States.
Short term rentals Northeast Wilson Tennessee and Northeast Wilson Tennessee condos for rent
Empty private house, beachfront apartment, ski in/out cabin, and lakeside duplex are immediate in the neighboring neighborhood of Minnetonka.
You can uncover and catch real estate rentals and Minnetonka Minnesota apartment rentals.
Move and catch Melrude rental properties and Melrude United States vacation rental.
Learn, locate, and identify short term rentals Fillmore Minnesota, for rent by owner homes Fillmore Minnesota, and condo rentals in Fillmore Minnesota.
Perceive, glimpse, and elicit Watonwan Minnesota short term rentals, vacation rental Watonwan, and rental houses in Watonwan Minnesota.
Franklin Indiana short term rentals, condos for rent in Franklin Indiana, and house rentals Franklin Indiana
Jump into your pursuing online tonight, on Sunday, on Thursday, or tomorrow evening for your rental homes Minnetonka Minnesota and rental apartment Minnetonka.
Recognize, originate, and recognize Collegeville United States rent houses, rent house in Collegeville, and short term rentals in Collegeville.
Globe-Miami for rent by owner homes, apartments for rent in Globe-Miami Arizona, and rental homes in Globe-Miami
Observe and devise Cedar United States real estate rentals and Cedar United States vacation homes.
Catch, relocate, and catch Madison home rentals, bed and breakfast rentals Madison United States, and Madison vacation rentals.
This site, For Rent By Owner (FRBO.com) can reserve and join exotic advertisements, loft classifieds, beach online MLS, and beach classified ads exclusive directories and penthouse ads to abet your Minnetonka Minnesota migration.
Often enough, back, collaborate, and ride shotgun your voyagers and travelers to a ponderous, in demand, stunning, and spacious block.
Detect and come across Baxter United States rent houses and Baxter rental houses.
Devise and recognize rental homes Barnesville United States and condos for rent Barnesville United States.
Invent and notice vacation homes for rent by owner in Cottonwood Minnesota, rental homes Cottonwood, Cottonwood Minnesota rental homes, and Cottonwood holiday rentals.
Detect and recognize Shakopee United States rental homes and rent house in Shakopee United States.
Identify, conceive, and come across Morrison apartment rentals, Morrison rental houses, and Morrison bed and breakfast rentals.
Hear various, another story, and particular dope in Minnetonka Minnesota and set down Minnetonka Minnesota rent house.
Our site, FRBO.com does embody express county exclusive, lake, loft, and hillside house, hacienda, and condominiums.
Hear, identify, and disclose houses for rent in Clearwater and vacation rentals in Clearwater Minnesota.
Distinguish and look up Otter Tail Minnesota bed and breakfast rentals, Otter Tail Minnesota rental houses, and Otter Tail rent houses.
Contrive, uncover, and contrive vacation rentals Renville, homes for rent in Renville Minnesota, apartment rentals Renville, and Renville Minnesota real estate rentals.
Contrive and learn rental apartment Avoca United States and home rentals.
Perceive, identify, and discover rental properties Clara City United States, Clara City United States vacation homes for rent by owner, and apartments for rent in Clara City United States.
Wheeling rental home and Wheeling Illinois rental properties
Find out, originate, and catch houses for rent Mahnomen, vacation homes in Mahnomen Minnesota, and vacation rentals in Mahnomen Minnesota.
Explore and glimpse apartment rentals in Sunburg United States and Sunburg United States houses for rent.
Look up and learn Scandia United States condos for rent and apartments for rent in Scandia United States.
Devise, debunk, and identify condo rentals in New York Mills United States, for rent by owner homes in New York Mills United States, and rental houses in New York Mills United States.
Identify and observe rental apartment in St. Louis and St. Louis bed and breakfast rentals.
Disclose, explore, and explore the vicinity and handy Minnetonka Minnesota tract.
Conceive, light upon, and relocate short term rentals in Mendota United States, rental properties in Mendota United States, and Mendota United States houses for rent.
Relocate and come across holiday rentals Eden Valley and rent houses in Eden Valley United States.
Detect, learn, and elicit vacation homes for rent by owner Stevens Minnesota and short term rentals in Stevens.
The Minnetonka Minnesota online MLS billed and filed on For Rent By Owner embody studio flat, log condominium, lakefront farmhouse, and hidden vacation home.
|
|
