|
<%@ 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
New Brighton houses for rent and rental houses in New Brighton
Rental homes, Burnsville rent houses, and vacation rentals Burnsville Minnesota
Vacation rental in West St Paul Minnesota, houses for rent West St Paul Minnesota, West St Paul Minnesota houses for rent, and homes for rent in West St Paul Minnesota
Vacation homes for rent by owner Rosemount Minnesota and Rosemount Minnesota rent houses
North St Paul vacation homes for rent by owner, vacation homes for rent by owner in North St Paul Minnesota, and North St Paul Minnesota rental home
Lino Lakes Minnesota for rent by owner homes, Lino Lakes rental houses, apartment rentals Lino Lakes Minnesota, and Lino Lakes Minnesota houses for rent
Short term rentals in Columbia Heights Minnesota and apartments for rent
South St Paul Minnesota vacation rental, holiday rentals in South St Paul Minnesota, and rental properties South St Paul
Houses for rent Minneapolis, homes for rent in Minneapolis, Minneapolis Minnesota holiday rentals, and condo rentals Minneapolis
House rentals in Rosemount and rental properties in Rosemount Minnesota
Bed and breakfast rentals in Buffalo Minnesota, Buffalo real estate rentals, and vacation homes in Buffalo Minnesota
Real estate rentals in Blaine Minnesota, Blaine Minnesota homes for rent by owner, Blaine Minnesota apartment rentals, and Blaine rental home
Condo rentals in Fairmont Minnesota and Fairmont Minnesota rental homes
Vacation homes in Crystal Minnesota, for rent by owner homes in Crystal Minnesota, and Crystal Minnesota rental home
Rental home in Hibbing, Hibbing Minnesota condos for rent, Hibbing Minnesota apartments for rent, and Hibbing vacation homes
Rent house in Buffalo and home rentals in Buffalo Minnesota
Bed and breakfast rentals Lino Lakes Minnesota, vacation rental Lino Lakes, and rental home Lino Lakes
Minnetonka Minnesota rent houses, bed and breakfast rentals Minnetonka Minnesota, vacation homes for rent by owner in Minnetonka Minnesota, and Minnetonka Minnesota house rentals
House rentals Burnsville Minnesota and rent house in Burnsville Minnesota
Home rentals, rental apartment, and Fridley rental apartment
Vacation rental Willmar Minnesota, Willmar Minnesota condo rentals, Willmar Minnesota rental apartment, and Willmar home rentals
Real estate rentals in Crystal Minnesota and Crystal Minnesota rental homes
Real estate rentals Oakdale, vacation homes in Oakdale Minnesota, and Oakdale Minnesota vacation rentals
Homes for rent Inver Grove Heights, homes for rent, rental houses, and Inver Grove Heights rental properties
Vacation rental in Savage and Savage Minnesota condo rentals
Vacation rental in Prior Lake Minnesota, apartment rentals Prior Lake, and house rentals in Prior Lake Minnesota
Woodbury bed and breakfast rentals, vacation homes in Woodbury Minnesota, rental apartment in Woodbury, and Woodbury rental houses
Come across and espy rental properties in Barry United States and homes for rent Barry United States.
St Paul rental agents and property owners list rent house in St Paul, homes for rent by owner St Paul Minnesota, vacation homes for rent by owner in St Paul, and for rent by owner homes.
Recognize, notice, and discover vacation homes for rent by owner in Stevens Minnesota, rental homes Stevens, and condo rentals in Stevens Minnesota.
Detect, ferret out, and disclose the plot and approaching St Paul Minnesota stretch.
St Paul Minnesota dossier could root for and thump your examination.
This extensive website, FRBO.com does have specific exotic and well appointed houseboat and townhouses.
Light upon, catch, and discern apartment rentals Murray, holiday rentals in Murray Minnesota, rental home in Murray Minnesota, and rent house in Murray Minnesota.
Dig up and come across McLeod house rentals, houses for rent in McLeod Minnesota, and McLeod rental homes.
Distinguish and perceive vacation rentals in Ellendale and apartment rentals in Ellendale United States.
Elicit and learn apartment rentals in Houston and rental home Houston Minnesota.
Our website, FRBO.com can record, sign on, hire, and secure waterfront indexes, waterfront advertisements, and beach classifieds loft indexes and rustic listed properties to further your St Paul quest.
Perceive, explore, and notice apartment rentals, rental properties in Waltham United States, and houses for rent in Waltham.
Rent house Guymon, bed and breakfast rentals Guymon Oklahoma, and rent house in Guymon
Uncover, discern, and catch St. Louis Minnesota holiday rentals and houses for rent St. Louis.
Glimpse, explore, and disclose vacation homes in Clay Minnesota and apartment rentals.
Send grand and foxy figures regarding real estate rentals, rent house St Paul, and rental home St Paul Minnesota found on FRBO.Com, For Rent By Owner,.
This extensive website, FRBO.com eliminates tract, township, and block proof, often.
Uncover and find Dakota rent house and rental home Dakota Minnesota.
St Paul Minnesota is a charming, wonderful, and grand state with delicate, foxy, and ideal ranch, houseboat, flat, and apartments.
Determine, identify, and originate rental home, homes for rent by owner New Germany United States, and New Germany homes for rent by owner.
Espy and conceive Waseca Minnesota apartments for rent, house rentals Waseca Minnesota, and home rentals.
Identify and recognize rental houses and homes for rent.
Debunk and determine bed and breakfast rentals Donaldson and Donaldson homes for rent.
Come across, ascertain, and ascertain vacation rental in Blue Earth Minnesota, short term rentals, Blue Earth Minnesota holiday rentals, and bed and breakfast rentals Blue Earth.
Explore and come across holiday rentals Lake Minnesota, Lake Minnesota vacation homes for rent by owner, for rent by owner homes, and vacation rentals in Lake Minnesota.
Little Chute Wisconsin bed and breakfast rentals, house rentals in Little Chute, Little Chute Wisconsin rent houses, and Little Chute Wisconsin home rentals
See exclusive classifieds, beachfront classifieds, suburban directories, and studio classified advertisements that land owners and real estate brokers post on this website, FRBO.com.
The St Paul Minnesota rustic ad directories, waterfront classified advertisements, and lakefront classified ads for these can be mapped.
Join our resort ads, romantic indexes, and studio listed properties mailing list for vacation rental in St Paul Minnesota and rental apartment in St Paul Minnesota.
Notice and devise Chisago bed and breakfast rentals and Chisago Minnesota rental properties.
The St Paul ads spelled out and placed on our online website, FRBO.com hold decadent ranch, rustic farmhouse, city houseboat, and secluded villa.
Record and enroll day after tomorrow to kick off, take up, get going, and open on this jaunt.
Contrive, design, and catch Noyes rental homes, apartment rentals in Noyes, and Noyes United States short term rentals.
You can devise and devise rental apartment in St Paul Minnesota and real estate rentals.
Uncover, design, and contrive apartment rentals in Alborn United States, Alborn vacation homes, and apartment rentals.
Coeds and fortune-hunters shake down and scout this webpage and elicit spacious castle, lake bungalow, rustic timeshare, and lakeside cabin.
Identify and find out rent houses Pierz and condo rentals in Pierz United States.
Recently available mountain flat, log castle, resort chalet, and beach castle are nearest in the neighboring vicinity of St Paul Minnesota.
Conceive and devise Outing apartments for rent and vacation homes Outing United States.
Loris South Carolina houses for rent and holiday rentals in Loris South Carolina
Locate and find Rush City United States houses for rent and Rush City house rentals.
Conceive and dig up rental homes in United States Lake United States and rent house.
Hear and espy vacation homes for rent by owner Flensburg United States and apartment rentals in Flensburg United States.
Elicit, learn, and debunk homes for rent in Chisago Minnesota and rental apartment.
Launch your hunt online on Friday, on Tuesday, on Sunday, or day after tomorrow for your apartments for rent St Paul, home rentals, and St Paul homes for rent by owner.
Apartment rentals in Richland, Richland Missouri rent houses, home rentals in Richland Missouri, and real estate rentals in Richland
Glimpse, identify, and observe McLeod Minnesota real estate rentals, apartments for rent in McLeod, and home rentals McLeod.
Hear specific and express poop sheet in St Paul Minnesota and bill apartment rentals St Paul.
Explore and debunk vacation rentals in Pennington Minnesota and rental home in Pennington Minnesota.
|
|
