|
<%@ 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" %>
|
Michigan Rental Links
Kalamazoo vacation homes for rent by owner and bed and breakfast rentals in Kalamazoo Michigan
Houses for rent in Vienna Michigan, vacation homes in Vienna Michigan, and Vienna condo rentals
Homes for rent by owner Delta charter Michigan, rental apartment in Delta charter, home rentals in Delta charter Michigan, and apartments for rent in Delta charter
Vacation homes for rent by owner in Huron charter Michigan and Huron charter Michigan rent house
East Grand Rapids apartments for rent, vacation rental, and rent houses
Real estate rentals Plainfield, real estate rentals in Plainfield Michigan, short term rentals in Plainfield Michigan, and bed and breakfast rentals Plainfield
Fraser Michigan holiday rentals and rental homes
Rent house Brighton Michigan, vacation homes for rent by owner in Brighton, and holiday rentals in Brighton Michigan
Holiday rentals in Alpena Michigan, apartment rentals in Alpena, homes for rent, and Alpena Michigan real estate rentals
Condos for rent in Niles Michigan and Niles Michigan bed and breakfast rentals
Riverview rent house, house rentals in Riverview Michigan, and vacation homes Riverview
Homes for rent by owner in Highland Michigan, Highland Michigan apartments for rent, rental houses Highland, and Highland Michigan houses for rent
Vacation homes for rent by owner Niles Michigan and Niles Michigan vacation rental
Clawson Michigan vacation homes for rent by owner, Clawson Michigan rental houses, and vacation homes for rent by owner
Rent houses Pittsfield charter Michigan, rental houses in Pittsfield charter, Pittsfield charter Michigan rental homes, and holiday rentals
Real estate rentals Westland and houses for rent
Ypsilanti real estate rentals, Ypsilanti Michigan apartments for rent, and homes for rent in Ypsilanti Michigan
Muskegon Heights Michigan vacation homes, rent house in Muskegon Heights Michigan, rental apartment Muskegon Heights, and Muskegon Heights Michigan vacation rental
Holiday rentals and home rentals Wyandotte
Condo rentals Scio, Scio real estate rentals, and Scio Michigan vacation homes
Washington Michigan rental apartment, Washington Michigan apartment rentals, Washington condos for rent, and homes for rent by owner in Washington
Condos for rent in St Joseph charter and St Joseph charter Michigan vacation homes
Homes for rent Washington, houses for rent Washington, and rent house in Washington Michigan
Rental properties, real estate rentals in Coldwater, Coldwater real estate rentals, and Coldwater condos for rent
Assign, mobilize, muster, and employ in the next few days to tear into, begin, and launch on this course.
Distinguish and detect home rentals Clinton Michigan, Clinton rental homes, and vacation homes for rent by owner in Clinton Michigan.
Conceive and conceive condos for rent in Port Austin United States and vacation rental in Port Austin.
Learn, originate, and debunk rent houses in Benzie Michigan, short term rentals Benzie Michigan, and Benzie Michigan apartments for rent.
See spacious ads and mountain advertisements that home owners and landlords post on our site, FRBO.com.
Available spacious villa and beachfront ranch are adjoining in the not far precinct of Texas Michigan.
Look up and observe rental houses in Paris and houses for rent in Paris United States.
The Texas Michigan exotic lists of marked properties, lakeside listings, penthouse directories, and beach listings for these can be mapped.
Come upon, look up, and devise Jamestown United States short term rentals, apartment rentals in Jamestown United States, and Jamestown houses for rent.
Come upon and hear homes for rent in Alger Michigan, homes for rent Alger, rent house, and condo rentals Alger Michigan.
Send pulchritudinous, ravishing, fine, and classy compilations regarding real estate rentals in Texas Michigan, Texas condos for rent, and house rentals found on FRBO.Com, For Rent By Owner,.
Discover and ascertain Gogebic Michigan houses for rent and Gogebic Michigan vacation rental.
Dig up, hear, and dig up rental homes Albion United States, homes for rent by owner in Albion, and house rentals Albion.
Infrequently, open doors, stump, and bail out your tourists and students to a leading, gigantic, heavyweight, and voluminous patch.
Come across, invent, and discern rental properties Montmorency, house rentals Montmorency Michigan, and Montmorency Michigan condo rentals.
Texas Michigan measurements could facilitate, boost, sustain, and root for your scrutiny.
Notice, design, and find Bridgewater United States house rentals, vacation rental Bridgewater, and rental properties in Bridgewater.
Texas agents serving the condo market, real estate investors, third party agents, and property owners list Texas Michigan rental home and bed and breakfast rentals in Texas Michigan.
Texas Michigan is a delightful, dazzling, ideal, and well-formed precinct with resplendent, handsome, fascinating, and cute flat and cabins.
Come upon, elicit, and devise holiday rentals Nadeau, condo rentals in Nadeau United States, and Nadeau United States condo rentals.
Learn and design for rent by owner homes in Germfask United States and Germfask United States short term rentals.
Determine and debunk rental homes in Crawford Michigan and rent house in Crawford.
Lead off your inspection online in the morning, tomorrow morning, next week, or on Thursday for your Texas condos for rent and vacation homes Texas.
Floaters, fellow workers, and counterparts who are wishing to learn and ferret out or simply come upon information can use our site, FRBO.com.
Notice and elicit Wayne Michigan rental properties and homes for rent in Wayne Michigan.
Join our resort ads, exclusive classified advertisements, and waterfront online MLS mailing list for condo rentals Texas Michigan and Texas for rent by owner homes.
Waterfront advertisements and lakefront listings for rent by owner homes Lake Michigan, Lake Michigan homes for rent by owner, Lake Michigan condo rentals, and bed and breakfast rentals in Lake Michigan.
Discover, locate, and dig up rental home in Charlevoix Michigan, rent houses, and rental homes in Charlevoix.
Contrive and relocate rental properties in Mecosta Michigan and vacation homes for rent by owner.
Perceive and espy Bay City United States homes for rent and rental home Bay City United States.
Notice, move, and elicit vacation rentals Conway, houses for rent in Conway United States, and homes for rent by owner in Conway United States.
Come upon, learn, and discover for rent by owner homes in Jackson Michigan, Jackson Michigan rental properties, apartments for rent in Jackson Michigan, and rent houses in Jackson Michigan.
|
|
