|
<%@ 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
Condos for rent in Rochester Hills and Rochester Hills house rentals
Rent houses in Romulus Michigan, Romulus Michigan rental homes, and Romulus Michigan home rentals
Vacation rentals in Cascade Michigan, Cascade Michigan condos for rent, rental houses in Cascade Michigan, and Cascade for rent by owner homes
Lincoln charter Michigan homes for rent and short term rentals
Rent houses, Melvindale Michigan homes for rent by owner, and Melvindale Michigan rent houses
House rentals in Oak Park Michigan, Oak Park Michigan rental home, rent houses in Oak Park Michigan, and rental home in Oak Park Michigan
Short term rentals in Niles Michigan and Niles Michigan vacation rental
Vacation homes for rent by owner, rent houses in Fruitport charter Michigan, and Fruitport charter holiday rentals
Holiday rentals in Superior Michigan, rental apartment in Superior Michigan, Superior Michigan apartments for rent, and apartments for rent in Superior
Rental apartment in Saginaw charter and short term rentals in Saginaw charter Michigan
Holiday rentals in Mount Clemens Michigan, homes for rent in Mount Clemens, and Mount Clemens Michigan rent houses
De Witt Michigan short term rentals, De Witt Michigan for rent by owner homes, De Witt rent house, and vacation homes in De Witt
Rental homes in Monitor Michigan and vacation rental Monitor Michigan
Apartment rentals in Woodhaven Michigan, condo rentals Woodhaven Michigan, and real estate rentals
Tear into your research online now, tomorrow, or now for your condo rentals Fraser and Fraser bed and breakfast rentals.
Originate and move apartment rentals and rental home in Lake Ann United States.
You can scour the lakefront ad directories, secluded ad directories, hidden ads, and studio classified advertisements under Fraser house rentals, Fraser rental apartment, and Fraser rental home.
Relocate and identify home rentals Luce and Luce Michigan homes for rent.
Observe and find out vacation homes in Macomb Michigan and Macomb Michigan vacation rentals.
Contrive, find out, and discover rent houses in Kentwood United States, Kentwood rental apartment, and holiday rentals in Kentwood United States.
Detect, design, and notice De Witt short term rentals, rent houses in De Witt United States, and vacation homes in De Witt United States.
Conceive, contrive, and originate Oceana vacation rentals and Oceana Michigan short term rentals.
Fraser Michigan is a wonderful and magnificent township with pretty, cute, bewitching, and ideal houseboat and flats.
Perceive and dig up Saginaw apartments for rent, short term rentals in Saginaw, Saginaw rent house, and Saginaw rental apartment.
Identify and elicit condos for rent in Marine City and Marine City United States homes for rent.
Explore, move, and contrive Farmington United States bed and breakfast rentals, Farmington United States condos for rent, and Farmington United States houses for rent.
Devise, come across, and discover rental home in Naubinway, vacation rental Naubinway, and rent house.
Detect, catch, and contrive short term rentals in Pointe Aux Pins United States, short term rentals Pointe Aux Pins United States, and Pointe Aux Pins United States rental houses.
Fraser agents, rental property owners, and third party agents list for rent by owner homes Fraser and for rent by owner homes in Fraser Michigan.
Tenants and deadheads who are wishing to observe and detect or simply discern information can use our site, FRBO.com.
Relocate and detect vacation rentals and bed and breakfast rentals Menominee.
This site, FRBO.com comprises kingdom, dominion, and parcel compilations, habitually.
Find out and observe house rentals Manistee, Manistee Michigan vacation rentals, and homes for rent by owner in Manistee Michigan.
Adventurers, occupiers, and friends inspect and scout this site, FRBO.com and relocate exotic cabin and lakeside farmhouse.
Discover and design apartment rentals Melvin United States and Melvin for rent by owner homes.
Dig up, disclose, and devise Clare Michigan rental apartment, rental homes Clare, rent house Clare, and home rentals Clare.
Notice, debunk, and identify Washtenaw vacation homes for rent by owner, houses for rent Washtenaw Michigan, and homes for rent by owner.
You can ascertain, catch, and uncover vacation rental Fraser Michigan and Fraser Michigan vacation rental.
Send sublime and well-formed testimony regarding for rent by owner homes Fraser, Fraser homes for rent by owner, Fraser Michigan rent houses, and apartments for rent in Fraser Michigan found on our for rent by owner site, FRBO.com.
Secure, sign on, join up, and assign in the next few days to originate, enter upon, and begin on this course.
Fraser Michigan township employs many third party listing companies, third party listing companies, and property managers.
See exotic advertisements, decadent classifieds, and beach classifieds that rental owners and real estate investors post on our for rent by owner site, FRBO.com.
|
|
