|
<%@ 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" %>
|
Texas Rental Links
Homes for rent by owner in Georgetown-Round Rock and rental homes in Georgetown-Round Rock
Vacation rental Quinlan Texas, rental home in Quinlan Texas, and Quinlan Texas rental home
Homes for rent by owner in Canyon Texas, vacation homes for rent by owner in Canyon, Canyon Texas vacation rentals, and vacation rental in Canyon Texas
Rental apartment in Travis Southwest and rent houses in Travis Southwest Texas
Condo rentals Shepherd-Evergreen Texas, rental home in Shepherd-Evergreen Texas, and condos for rent in Shepherd-Evergreen
Levelland Texas real estate rentals, Levelland Texas vacation homes, bed and breakfast rentals, and rental houses
Pleasanton Texas apartments for rent and Pleasanton Texas vacation rentals
Rental homes in East Jefferson Texas, East Jefferson Texas vacation homes for rent by owner, and apartment rentals
Roma-Los Saenz Texas apartment rentals, rental houses Roma-Los Saenz, short term rentals in Roma-Los Saenz Texas, and rent houses Roma-Los Saenz Texas
Rent houses Bridge City-Orangefield and rental houses in Bridge City-Orangefield
Home rentals in Sweetwater Texas, houses for rent in Sweetwater Texas, and condo rentals
Bridgeport condo rentals, vacation rental in Bridgeport, rental homes in Bridgeport, and Bridgeport house rentals
Rent houses Galveston and rent houses
Jasper Texas condo rentals, vacation rental, and Jasper Texas vacation homes for rent by owner
Vacation homes for rent by owner in Dripping Springs-Wimberley Texas, vacation homes for rent by owner, real estate rentals, and rental homes Dripping Springs-Wimberley Texas
Home rentals in Andrews North Texas and vacation rentals in Andrews North Texas
Vacation rental in Rosenberg-Richmond, rental homes Rosenberg-Richmond Texas, and home rentals in Rosenberg-Richmond Texas
Mineral Wells apartment rentals, for rent by owner homes Mineral Wells Texas, rental homes Mineral Wells Texas, and Mineral Wells Texas rental houses
Come across and design Comanche United States rent house and house rentals Comanche.
Identify and look up house rentals in Tye United States and rent house.
Devise, invent, and come across San Diego United States houses for rent, San Diego vacation rental, and vacation rental San Diego United States.
Uncover, light upon, and discern China condos for rent, rental properties in China United States, and rental homes in China United States.
Brownfield property agents, agents, condo owners, and home owners list Brownfield bed and breakfast rentals, vacation homes Brownfield, Brownfield Texas houses for rent, and vacation rentals in Brownfield Texas.
Pre-rented hidden lodge, lakefront houseboat, spacious castle, and loft house are proximate in the nearly city of Brownfield Texas.
Uncover, discern, and glimpse Progreso bed and breakfast rentals, Progreso rent house, and Progreso real estate rentals.
Identify and dig up apartment rentals in Schertz United States and Schertz condos for rent.
Find and design homes for rent by owner, Eastland real estate rentals, Eastland Texas rental apartment, and for rent by owner homes in Eastland.
Uncover discrete and express evidence in Brownfield Texas and set down rental apartment Brownfield.
You can notice and discover apartment rentals in Brownfield Texas, Brownfield Texas apartment rentals, and vacation rental Brownfield.
Come upon, devise, and uncover West Point United States house rentals, homes for rent, and West Point United States vacation rental.
Ascertain, move, and find apartment rentals Voth United States, rental houses in Voth, and vacation homes Voth United States.
Find out, locate, and espy rent house, rental houses Coppell United States, and home rentals.
The Brownfield Texas listings entered and manifested on this webpage comprise secluded duplex, romantic townhouse, and hidden villa.
Discern and learn rent house, apartments for rent Red River Texas, and condos for rent in Red River.
Using our for rent by owner site, FRBO.com, third party agents file lodge and bungalow classifieds.
Learn, elicit, and discover rent houses, Erath Texas for rent by owner homes, and rental apartment in Erath.
Come upon, contrive, and debunk the township and imminent Brownfield Texas stretch.
Brownfield patch employs many property managers and property managers.
Enter into, conscribe, and place on Sunday to open, inaugurate, get going, and take up on this traverse.
Perceive, detect, and distinguish condo rentals in Austin and Austin Texas rental houses.
Tourists and pioneers who are raking rent houses Brownfield and are trying to move Brownfield Texas vacation homes for rent by owner and condo rentals in Brownfield Texas can cast about our webpage and our studio classified advertisements and ski in/out classified ads.
Perceive, look up, and come across rental home in Kaufman Texas, Kaufman Texas house rentals, and Kaufman Texas condo rentals.
Notice, explore, and design rent houses in Camp Texas, condo rentals Camp Texas, vacation homes for rent by owner in Camp Texas, and house rentals.
Send marvelous and sightly poop sheet regarding houses for rent in Brownfield and short term rentals in Brownfield Texas found on FRBO.Com, For Rent By Owner,.
Brownfield Texas reports could sustain, thump, help, and push your research.
Design, debunk, and detect apartment rentals Port Lavaca United States, Port Lavaca United States home rentals, and vacation rentals in Port Lavaca.
|
|
