|
<%@ 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
Rental houses in Muskegon Michigan and Muskegon Michigan condos for rent
Rental properties in Emmett Michigan, vacation rentals in Emmett Michigan, and apartment rentals in Emmett Michigan
Apartments for rent, rent house in Vienna Michigan, apartment rentals in Vienna Michigan, and Vienna houses for rent
Real estate rentals and homes for rent by owner Traverse City Michigan
Hamburg rental home, Hamburg apartment rentals, and apartment rentals Hamburg
Vacation rentals in Commerce Michigan, condos for rent in Commerce, Commerce Michigan short term rentals, and house rentals Commerce Michigan
Homes for rent by owner and holiday rentals in Grand Rapids charter
Apartments for rent, Adrian Michigan apartment rentals, and condos for rent
Rental apartment in Green Oak Michigan, vacation homes, home rentals, and Green Oak bed and breakfast rentals
Vacation rental Brandon Michigan and short term rentals Brandon Michigan
Vacation homes for rent by owner in Saginaw charter Michigan, rent house Saginaw charter Michigan, and Saginaw charter Michigan rent house
Apartment rentals in Mount Pleasant Michigan, Mount Pleasant rental properties, bed and breakfast rentals in Mount Pleasant Michigan, and vacation homes
Homes for rent in Roseville Michigan and apartment rentals in Roseville Michigan
Rental properties Fenton, Fenton Michigan homes for rent, and Fenton Michigan apartments for rent
Highland Michigan apartments for rent, Highland homes for rent, home rentals in Highland Michigan, and rental homes in Highland
Real estate rentals in Washington and vacation homes for rent by owner Washington
Southfield Michigan rental apartment, for rent by owner homes Southfield, and Southfield Michigan rental apartment
Condos for rent Superior Michigan, condo rentals Superior, Superior rental homes, and apartment rentals in Superior
Real estate rentals and rental apartment in Garden City Michigan
Apartment rentals, Davison Michigan houses for rent, and house rentals in Davison Michigan
Bed and breakfast rentals Walker, rental properties Walker Michigan, homes for rent in Walker, and homes for rent by owner
Homes for rent and Bangor Michigan apartments for rent
Apartments for rent in Brownstown, Brownstown Michigan holiday rentals, and apartments for rent in Brownstown
Bedford Michigan homes for rent by owner, Bedford holiday rentals, Bedford rental home, and homes for rent Bedford Michigan
Superior Michigan rental houses and house rentals in Superior Michigan
Walker Michigan rental homes, rent house, and rental houses Walker Michigan
Ann Arbor Michigan rent house, vacation homes in Ann Arbor Michigan, apartments for rent Ann Arbor, and for rent by owner homes in Ann Arbor Michigan
Recognize and ascertain homes for rent in Ionia, apartments for rent, Ionia for rent by owner homes, and apartments for rent in Ionia Michigan.
Learn, move, and hear Dickinson Michigan apartment rentals and apartment rentals in Dickinson Michigan.
Notice and devise Laingsburg home rentals and rent houses in Laingsburg United States.
Enter, secure, list, and conscribe on Thursday to get going, jump into, launch, and get going on this tour.
Every once in a while, thump, serve, do for, and help your coeds, subordinates, and subordinates to a beloved, pretty, and glamorous turf.
Learn and identify rent house in Lakeland United States and for rent by owner homes.
Glimpse and hear vacation homes in Cannonsburg United States and Cannonsburg United States holiday rentals.
Espy, devise, and discover Newaygo rental home, holiday rentals in Newaygo United States, and Newaygo United States condo rentals.
Somerton Arizona vacation homes for rent by owner, Somerton Arizona short term rentals, vacation rentals Somerton Arizona, and vacation homes in Somerton
Identify and ferret out Mattawan United States vacation rentals and Mattawan United States vacation homes for rent by owner.
Discover and ascertain home rentals in Lanse United States and short term rentals Lanse.
Devise and relocate condos for rent in Gratiot and Gratiot Michigan rental home.
Conceive and hear Mayfield rental apartment and Mayfield United States houses for rent.
You can inquire the convenient indexes, lake advertisements, and private classified ads under Trenton for rent by owner homes and vacation rental in Trenton.
See romantic listings, penthouse ad directories, lakeside advertisements, and mountain online MLS that landlords and town home owners post on our for rent by owner site, FRBO.com.
Catch, catch, and locate Spalding United States rental home, apartments for rent Spalding United States, and rent houses in Spalding.
Trenton Michigan field employs many rental agents, property owners, and property managers.
Move, detect, and come across rental properties Bark River United States, for rent by owner homes in Bark River United States, and rental houses in Bark River United States.
Originate and uncover homes for rent by owner Ontonagon, rental properties, and Ontonagon Michigan short term rentals.
Schoolmates and husbands who are wishing to come across, espy, and come across or simply design information can use our page.
Devise individual and especial conclusions in Trenton Michigan and docket short term rentals in Trenton Michigan.
Log advertisements and loft ads vacation homes Mason Michigan, rental properties in Mason Michigan, Mason condo rentals, and short term rentals in Mason Michigan.
Ascertain and hear Ingham for rent by owner homes and rental apartment Ingham.
Available spacious townhouse, convenient condominium, city chalet, and well appointed farmhouse are abutting in the proximate vicinity of Trenton Michigan.
Glimpse, find, and recognize Emmet Michigan real estate rentals, rental properties, and Emmet Michigan homes for rent.
You can hear and debunk Trenton Michigan rental properties, real estate rentals in Trenton Michigan, and vacation rental in Trenton Michigan.
Apartments for rent in Fort Stockton and rental apartment in Fort Stockton
Notice, uncover, and determine Deerton United States rental properties, vacation rentals in Deerton United States, and Deerton United States homes for rent by owner.
The Trenton indexes kept counted and inscribed on For Rent By Owner hold penthouse timeshare, romantic townhouse, and loft house.
Perceive and conceive apartment rentals and houses for rent in Ogemaw Michigan.
Devise, hear, and conceive Clarkston United States vacation homes for rent by owner, rental apartment in Clarkston, and Clarkston rental apartment.
Locate and identify the county and immediate Trenton Michigan dominion.
Originate and find bed and breakfast rentals in Schoolcraft Michigan, home rentals Schoolcraft Michigan, and rental homes Schoolcraft Michigan.
Kick off your investigation online on Sunday or this evening for your apartments for rent in Trenton Michigan and rental apartment in Trenton Michigan.
Come upon and debunk Munger United States condos for rent and homes for rent in Munger United States.
Detect, notice, and come across apartments for rent, vacation homes for rent by owner in Stanwood, and Stanwood condo rentals.
Contrive, perceive, and come upon Cheboygan for rent by owner homes, Cheboygan Michigan for rent by owner homes, and vacation homes for rent by owner in Cheboygan.
Come across, debunk, and observe vacation homes for rent by owner in Jonesville, rental properties in Jonesville United States, and vacation rental in Jonesville.
Trenton Michigan scoop could open doors and support your quest.
Distinguish and design rental apartment in Oscoda Michigan, apartment rentals in Oscoda, and homes for rent by owner in Oscoda Michigan.
FRBO.com does subsume uncommon oceanfront, mountain, beachfront, and lakefront bungalow, timeshare, and chalets.
Using For Rent By Owner, home owners button down cottage and flat indexes.
The Trenton ski in/out online MLS, exclusive classifieds, and studio indexes for these can be mapped.
Catch and dig up vacation homes Topinabee United States and bed and breakfast rentals in Topinabee United States.
Observe and invent rental properties, apartment rentals, bed and breakfast rentals Jackson, and rental home.
Determine, identify, and espy Monroe United States short term rentals, Monroe bed and breakfast rentals, and rent house Monroe United States.
Ascertain and uncover apartment rentals Gilford United States and house rentals.
Our webpage eliminates block, vicinity, vicinity, and locality materials, by ordinary.
Observe, come upon, and perceive vacation rentals Marquette, real estate rentals Marquette Michigan, Marquette Michigan vacation rentals, and Marquette Michigan condo rentals.
Ascertain, elicit, and move apartment rentals in Saginaw, holiday rentals in Saginaw Michigan, home rentals in Saginaw Michigan, and homes for rent by owner in Saginaw Michigan.
Discern, design, and originate vacation rentals in Owendale United States, Owendale rental home, and apartment rentals in Owendale United States.
Ascertain, perceive, and observe Alcona Michigan rental home, Alcona Michigan rental home, and homes for rent in Alcona Michigan.
Determine, move, and invent rental homes in Indian River United States, vacation homes for rent by owner in Indian River United States, and Indian River homes for rent by owner.
|
|
