|
<%@ 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
Carthage rental properties and Carthage houses for rent
Rental apartment in McAllen-Pharr Texas, bed and breakfast rentals McAllen-Pharr Texas, and McAllen-Pharr Texas real estate rentals
Vacation homes for rent by owner Waxahachie, home rentals Waxahachie, rental properties in Waxahachie, and Waxahachie bed and breakfast rentals
Bruni-Mirando Texas condos for rent and condo rentals in Bruni-Mirando
Homes for rent in Amarillo Texas, vacation homes Amarillo Texas, and holiday rentals in Amarillo
Weatherford Texas rental houses, rental houses in Weatherford Texas, short term rentals Weatherford Texas, and Weatherford Texas apartment rentals
Rent houses Sulphur Springs Texas and houses for rent in Sulphur Springs Texas
Condo rentals, Mission homes for rent by owner, and Mission Texas bed and breakfast rentals
La Marque-Hitchcock Texas home rentals, La Marque-Hitchcock rent houses, houses for rent in La Marque-Hitchcock, and La Marque-Hitchcock Texas rent houses
Vacation rental Hereford East and Hereford East home rentals
Holiday rentals in Levelland Texas, rental properties in Levelland, and Levelland Texas rental properties
Rent houses in Borger Texas, Borger Texas apartment rentals, Borger Texas vacation homes, and rental houses in Borger Texas
Vacation homes in Uvalde Texas and vacation rental Uvalde Texas
Stafford-Missouri City house rentals, condo rentals in Stafford-Missouri City Texas, and rental homes Stafford-Missouri City
Sullivan City Texas houses for rent, short term rentals Sullivan City Texas, vacation homes for rent by owner in Sullivan City Texas, and Sullivan City Texas rental home
Vacation homes for rent by owner Terrell and apartment rentals in Terrell Texas
Holiday rentals in Huntington, Huntington Texas vacation homes, and rental home Huntington
Rental properties in Hallsville, apartment rentals in Hallsville Texas, Hallsville houses for rent, and holiday rentals Hallsville Texas
Vacation homes Montgomery Texas and Montgomery Texas rental houses
Home rentals in Alvin-Pearland Texas, Alvin-Pearland bed and breakfast rentals, and rental houses Alvin-Pearland Texas
Fort Stockton Texas apartments for rent, vacation rentals in Fort Stockton Texas, house rentals in Fort Stockton Texas, and vacation rental Fort Stockton Texas
Guadalupe Southwest Texas short term rentals and real estate rentals Guadalupe Southwest
Contrive, move, and recognize homes for rent Waskom United States, apartments for rent in Waskom United States, and vacation homes for rent by owner Waskom.
Notice and move Fort Worth United States rent house and Fort Worth United States holiday rentals.
Debunk, locate, and look up homes for rent, rental houses Stonewall Texas, and rental apartment in Stonewall Texas.
Discern, originate, and invent Addison United States rental home, condos for rent in Addison, and condos for rent Addison United States.
City online MLS and exclusive ad directories for rent by owner homes in Comal Texas, Comal rent house, Comal Texas rental properties, and Comal Texas vacation rental.
This extensive website, FRBO.com does incorporate discrete stretch resort, lakeside, studio, and lakefront houseboat, cabin, condominium, and ranchs.
Journeyers and itinerants run down and rifle through this site, For Rent By Owner (FRBO.com) and explore hillside castle, loft houseboat, and log cabin.
Contrive and locate Kaufman Texas rental apartment, rental home, and vacation homes for rent by owner Kaufman Texas.
Detect, ferret out, and come upon houses for rent Banquete, Banquete United States houses for rent, and apartment rentals in Banquete.
Teachers and possessors who are rummaging holiday rentals West Tom Green and are trying to recognize vacation homes for rent by owner in West Tom Green Texas and condos for rent West Tom Green Texas can examine this site, For Rent By Owner (FRBO.com) and our oceanfront online MLS and romantic ads.
Soon to be vacant loft vacation home, rustic houseboat, secluded vacation home, and beachfront cabin are near-at-hand in the convenient state of West Tom Green Texas.
Determine, ferret out, and uncover Brown rental houses, rental properties in Brown, vacation rental in Brown Texas, and Brown Texas home rentals.
West Tom Green third party listing companies, real estate agents, and town home owners list rental properties in West Tom Green Texas, holiday rentals, short term rentals in West Tom Green Texas, and West Tom Green Texas rent house.
Originate, come upon, and find out Louise United States vacation homes for rent by owner, Louise United States homes for rent, and house rentals Louise.
Find out, conceive, and glimpse Karnes City United States condo rentals, rent houses in Karnes City United States, and bed and breakfast rentals Karnes City.
Find out and ferret out vacation rental Rice and bed and breakfast rentals in Rice.
Uncover and disclose Victoria Texas rent house and houses for rent Victoria.
Come upon, discern, and identify home rentals in Titus and vacation homes in Titus Texas.
Hear, come across, and discover vacation rentals Wichita, Wichita houses for rent, and Wichita Texas holiday rentals.
Relocate and perceive for rent by owner homes, bed and breakfast rentals Taylor Texas, rental properties Taylor, and vacation homes in Taylor.
Learn, identify, and discern Aransas rent houses, Aransas Texas condo rentals, and short term rentals in Aransas.
This extensive website, FRBO.com can sign on, enroll, and attract spacious online MLS, suburban advertisements, exotic listed properties, and suburban ad directories city classifieds and beach lists of marked properties to help your West Tom Green Texas traverse.
Hear, find, and recognize Hill rent house and Hill Texas short term rentals.
Using our site, FRBO.com, land owners poll castle, bungalow, duplex, and home classifieds.
Come across, contrive, and find real estate rentals Haskell, condos for rent in Haskell Texas, condo rentals Haskell, and homes for rent by owner Haskell.
Learn and devise apartment rentals and house rentals Armstrong Texas.
|
|
