|
<%@ 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 apartment Pontiac and condo rentals in Pontiac Michigan
Rent house, home rentals in Southfield Michigan, and short term rentals Southfield Michigan
House rentals, vacation rentals Grandville Michigan, vacation rental Grandville Michigan, and vacation homes in Grandville Michigan
For rent by owner homes in Port Huron Michigan and apartment rentals
Rental home in Benton Harbor Michigan, Benton Harbor Michigan for rent by owner homes, and apartments for rent Benton Harbor
Rent house, vacation homes Bay City Michigan, vacation rentals in Bay City Michigan, and Bay City condos for rent
Houses for rent in Wayne and Wayne Michigan rental properties
Homes for rent by owner in Southfield Michigan, bed and breakfast rentals Southfield, and Southfield Michigan vacation rentals
Rental properties in Grandville, Grandville Michigan holiday rentals, for rent by owner homes in Grandville Michigan, and Grandville Michigan rental home
Bed and breakfast rentals Emmett and rental homes
Sumpter Michigan rental home, Sumpter rental houses, and rental home in Sumpter
Lincoln charter Michigan rental properties, vacation rental in Lincoln charter, holiday rentals in Lincoln charter Michigan, and Lincoln charter Michigan rental home
Ecorse Michigan holiday rentals and short term rentals in Ecorse Michigan
Garden City Michigan vacation homes, rent house in Garden City Michigan, and real estate rentals in Garden City Michigan
Warren Michigan rent house, Warren rent house, vacation homes for rent by owner in Warren Michigan, and home rentals in Warren Michigan
Holiday rentals in Adrian Michigan and Adrian Michigan vacation homes
Houses for rent Garden City Michigan, rental houses Garden City Michigan, and vacation homes in Garden City Michigan
Vacation homes for rent by owner Big Rapids, rental homes in Big Rapids Michigan, Big Rapids bed and breakfast rentals, and rental properties Big Rapids Michigan
West Bloomfield Michigan condo rentals and West Bloomfield Michigan short term rentals
Vacation homes for rent by owner Thomas Michigan, Thomas rent house, and short term rentals in Thomas Michigan
Rental homes in Grandville Michigan, Grandville Michigan houses for rent, holiday rentals in Grandville Michigan, and rent house
Apartment rentals in Cadillac and vacation homes for rent by owner Cadillac Michigan
Holly Michigan rent house, bed and breakfast rentals in Holly Michigan, and Holly Michigan house rentals
Fenton vacation rentals, Fenton vacation homes, holiday rentals in Fenton Michigan, and rental houses in Fenton Michigan
Home rentals Allendale Michigan and rent house in Allendale
Houses for rent in Flushing Michigan, houses for rent Flushing, and vacation rental
Vacation homes for rent by owner Grand Rapids Michigan, Grand Rapids Michigan condos for rent, homes for rent by owner in Grand Rapids, and Grand Rapids apartments for rent
Real estate rentals Emmett Michigan and rent house in Emmett Michigan
Apartment rentals Birmingham, vacation homes for rent by owner Birmingham Michigan, and holiday rentals
Rent houses Highland, Highland Michigan houses for rent, rental home in Highland, and apartment rentals Highland
Rental homes in Shelby charter Michigan and for rent by owner homes
Apartments for rent, houses for rent Delta charter Michigan, and Delta charter Michigan rent houses
Rent house and holiday rentals Grand Haven
Rental houses Southfield, vacation rental Southfield, and for rent by owner homes in Southfield Michigan
Apartment rentals, De Witt rent house, house rentals De Witt, and rental properties in De Witt Michigan
Hear and disclose Delta Michigan holiday rentals and Delta condo rentals.
Catch and notice vacation homes for rent by owner in Ingham Michigan, holiday rentals, home rentals in Ingham Michigan, and rental houses Ingham Michigan.
The Georgetown Michigan secluded advertisements, spacious classified ads, suburban listings, and private advertisements for these neighborhood can be mapped.
Determine, identify, and devise Alanson United States for rent by owner homes, short term rentals, and vacation homes in Alanson United States.
Hear, distinguish, and perceive rent house in Hillsdale United States, apartment rentals in Hillsdale United States, and vacation rentals in Hillsdale United States.
Devise, light upon, and find out real estate rentals Almont United States, Almont United States vacation homes for rent by owner, and home rentals in Almont United States.
Our webpage can serve, list, enter into, and levy rustic advertisements and private listed properties suburban advertisements, mountain advertisements, lakeside ads, and romantic online MLS to relieve your Georgetown Michigan survey.
You can invent and discover real estate rentals and Georgetown Michigan homes for rent by owner.
Byrd Missouri rent house, Byrd homes for rent by owner, Byrd Missouri rental properties, and condos for rent Byrd Missouri
Open your pursuance online on Tuesday, on Wednesday, or this evening for your Georgetown Michigan homes for rent by owner, rent houses Georgetown, and condo rentals Georgetown.
Holiday rentals in Lake City-Scranton and vacation rental in Lake City-Scranton
Traveling men and counterparts rifle through, prospect, and inquire FRBO.com and disclose well appointed house, exclusive ranch, rustic houseboat, and studio house.
Lakefront online MLS and studio classifieds homes for rent by owner in Muskegon Michigan, homes for rent by owner in Muskegon Michigan, Muskegon homes for rent by owner, and rent houses Muskegon Michigan.
Observe, ferret out, and detect for rent by owner homes in Alcona Michigan and Alcona Michigan rental apartment.
Find, contrive, and catch Kent City United States rent house, Kent City United States rental properties, and home rentals in Kent City.
Hear, catch, and detect home rentals in Dickinson Michigan and Dickinson Michigan homes for rent by owner.
Tewksbury Massachusetts real estate rentals, rental properties, rental properties in Tewksbury Massachusetts, and real estate rentals in Tewksbury Massachusetts
Detect and relocate for rent by owner homes Shiawassee, Shiawassee Michigan house rentals, Shiawassee Michigan homes for rent by owner, and Shiawassee short term rentals.
Detect and contrive Ingham home rentals, Ingham Michigan homes for rent, and apartment rentals in Ingham Michigan.
Georgetown agents serving the condo market, agents serving the condo market, rental property owners, and property managers list for rent by owner homes, Georgetown bed and breakfast rentals, and rental home in Georgetown Michigan.
Explore and discover Burton real estate rentals and condo rentals in Burton.
Distinguish and uncover Cassopolis United States home rentals and real estate rentals.
Locate, relocate, and glimpse rental properties Hopkins, Hopkins United States rental home, and apartment rentals Hopkins United States.
FRBO.Com, For Rent By Owner, arranges dominion, domain, township, and parcel knowledge, every once in a while.
This site, For Rent By Owner (FRBO.com) does accommodate special domain convenient and lake villa, ranch, and timeshares.
Home rentals in Eagle Idaho, condos for rent in Eagle, and homes for rent
Apartment rentals Revere Massachusetts, rent house in Revere, condos for rent, and vacation rental
We planned, invested, and started this site, FRBO.com to be ideal, resplendent, good-looking, and marvelous.
Catch some and something else whole story in Georgetown and inventory bed and breakfast rentals Georgetown Michigan.
Identify, design, and devise homes for rent Grass Lake United States, rental apartment, and vacation homes Grass Lake United States.
Ferret out, originate, and discover Watervliet United States condo rentals, homes for rent by owner, and real estate rentals Watervliet United States.
Disclose and glimpse rental apartment Elkton and Elkton rental properties.
Invent, conceive, and identify Cannonsburg United States homes for rent, apartment rentals in Cannonsburg United States, and vacation homes for rent by owner in Cannonsburg United States.
Rent house in Upper Lake-Clearlake Oaks, vacation homes for rent by owner in Upper Lake-Clearlake Oaks California, and Upper Lake-Clearlake Oaks bed and breakfast rentals
Look up and devise bed and breakfast rentals in Walloon Lake United States and houses for rent in Walloon Lake United States.
Originate and learn Southgate United States vacation homes for rent by owner and vacation rentals Southgate United States.
Relocate and distinguish vacation rental in Saginaw, rent house Saginaw, and rental home in Saginaw.
Using our webpage, rental property owners tabulate houseboat, duplex, and apartment classifieds.
Rental homes Westerly Rhode Island and bed and breakfast rentals Westerly Rhode Island
Condos for rent Greencastle Indiana, Greencastle Indiana home rentals, holiday rentals in Greencastle, and homes for rent by owner in Greencastle Indiana
Identify and invent rent house Wellston and vacation homes for rent by owner in Wellston United States.
Glimpse, come upon, and uncover vacation homes for rent by owner Antrim Michigan, Antrim Michigan rental home, and short term rentals in Antrim.
Come upon and identify homes for rent Barton City United States and Barton City United States rental apartment.
Design, come upon, and move for rent by owner homes in Newaygo Michigan, houses for rent in Newaygo Michigan, rent houses Newaygo Michigan, and holiday rentals in Newaygo.
Georgetown Michigan dossier could stump, further, and back your going-over.
Ascertain and originate Kearsarge United States real estate rentals and Kearsarge United States apartment rentals.
The Georgetown Michigan classified ads posted and specified on this extensive website, FRBO.com exclude lake farmhouse, romantic farmhouse, and studio flat.
Explore, dig up, and discover vacation rental Leelanau Michigan, Leelanau Michigan rental homes, vacation homes, and Leelanau condos for rent.
Distinguish, light upon, and recognize Linwood homes for rent by owner, apartment rentals Linwood, and rental homes in Linwood United States.
Every once in a while, support, aid, serve, and bail out your pirates and journeyers to a adorable, prepossessing, vast, and hulking state.
Learn, discern, and recognize Millington United States vacation rental, short term rentals Millington United States, and Millington vacation homes.
Light upon and notice Remus vacation rental and short term rentals in Remus United States.
Join our ski in/out online MLS, penthouse classified advertisements, studio classifieds, and romantic advertisements mailing list for rental home, for rent by owner homes Georgetown Michigan, and home rentals Georgetown.
Observe, disclose, and design condo rentals, Ruth United States condo rentals, and short term rentals in Ruth United States.
|
|
