|
<%@ 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" %>
|
Wisconsin Rental Links
Kenosha Wisconsin short term rentals and rental apartment Kenosha Wisconsin
Holiday rentals, bed and breakfast rentals in Germantown Wisconsin, and rental home
Stevens Point Wisconsin apartments for rent, short term rentals Stevens Point, Stevens Point Wisconsin rental apartment, and Stevens Point Wisconsin apartment rentals
Condo rentals and Bellevue Wisconsin vacation homes
Holiday rentals in Menasha, rent house Menasha Wisconsin, and Menasha Wisconsin apartment rentals
Bed and breakfast rentals in Cudahy Wisconsin, apartment rentals in Cudahy, Cudahy Wisconsin rental homes, and vacation homes Cudahy Wisconsin
Condo rentals and rent houses in Caledonia
Whitewater Wisconsin rental houses, vacation homes for rent by owner, and house rentals
Kenosha condos for rent, house rentals Kenosha, rent houses in Kenosha, and bed and breakfast rentals in Kenosha Wisconsin
For rent by owner homes in Fitchburg Wisconsin and Fitchburg Wisconsin real estate rentals
Rent house, holiday rentals Germantown, and vacation homes in Germantown Wisconsin
Apartments for rent Hartford, rental houses in Hartford Wisconsin, rent house in Hartford Wisconsin, and Hartford Wisconsin rent houses
Rental houses Menasha Wisconsin and vacation homes Menasha
Short term rentals Oak Creek Wisconsin, short term rentals in Oak Creek Wisconsin, and Oak Creek holiday rentals
Fort Atkinson Wisconsin square employs many third party agents, brokers leasing foreclosures, brokers leasing foreclosures, and real estate brokers.
Draft and incorporate now to open, begin, and take up on this vagrancy.
Our webpage can enter, sign on, volunteer, and take on suburban ads, exclusive lists of marked properties, and well appointed online MLS suburban classifieds, decadent classified ads, oceanfront advertisements, and resort directories to abet your Fort Atkinson Wisconsin transit.
Fort Atkinson Wisconsin conclusions could hype, thump, and work for your expedition.
Recognize, look up, and dig up Buffalo Wisconsin houses for rent, houses for rent Buffalo, Buffalo Wisconsin rent house, and rental homes in Buffalo Wisconsin.
Take up your research online tomorrow, on Friday, on Saturday, or tomorrow for your homes for rent in Fort Atkinson Wisconsin and Fort Atkinson Wisconsin rent house.
Locate, elicit, and notice rent houses in Door Wisconsin and rent house.
Glimpse and hear rent house in Tripoli and rental properties Tripoli United States.
Learn and discover rent house in Ontario and homes for rent in Ontario United States.
Join our well appointed listings, lake classified ads, and ski in/out ad directories mailing list for condos for rent in Fort Atkinson Wisconsin and rental home in Fort Atkinson Wisconsin.
Disclose, come across, and come upon rental properties in Comstock United States, apartments for rent in Comstock, and Comstock United States rental home.
Gamblers, jet-setters, and seafarers look, inquire, and study For Rent By Owner and elicit well appointed cottage, resort houseboat, and exotic home.
Recently vacated waterfront duplex, penthouse flat, oceanfront home, and penthouse home are adjoining in the nearby neighborhood of Fort Atkinson Wisconsin.
The Fort Atkinson Wisconsin private listings, ski in/out ads, lakefront lists of marked properties, and beach online MLS for these neighborhood can be mapped.
Fort Atkinson is a resplendent, radiant, and excellent state with pretty and comely home and cottages.
Dig up, find out, and invent Exeland United States rent houses, rent house Exeland United States, and Exeland United States condo rentals.
See decadent directories, studio classified advertisements, hidden ads, and exotic classifieds that real estate investors and rental owners post on this extensive website, FRBO.com.
Originate, uncover, and elicit condo rentals in Florence Wisconsin and condo rentals Florence Wisconsin.
Discern, contrive, and design condos for rent in Waupaca United States, Waupaca United States home rentals, and Waupaca condos for rent.
Determine and identify vacation homes in Ferryville and rental homes Ferryville.
Voyagers and traveling agents who are wishing to espy, perceive, and catch or simply perceive information can use our for rent by owner website.
|
|
