Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '45324625' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471078' ,`Longitude` = '-95.510416' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '724572.00' ,`Status` = 'Active' ,`StreetName` = 'Camille Park' ,`StreetNumber` = '1918' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 45324625 - Built by Toll Brothers, Inc. - September completion! ~ The popular 1.5 story Turner plan is filled with amazing features. The covered entry leads into a dramatic foyer with two-story ceiling. Glass doors and sloped ceiling in the office give an elegant yet private feel and is large enough for two work spaces. Your guests will appreciate the bedroom suite with full bath and walk-in closet just off the great room. Enjoy entertaining on movie night in the media room or relaxing in the upstairs flex/game room. The great room features 12-foot ceilings and is open to a desirable kitchen with large island, an abundance of cabinets, butler\'s pantry and walk-in pantry. The casual dining area is conveniently located off the kitchen with views to the backyard. A secluded and relaxing primary bedroom includes a tray ceiling and en-suite with a luxurious freestanding tub, ultra shower and spacious walk-in closet. Located in acclaimed Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9511' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Sienna - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113642' WHERE `Matrix_Unique_ID` = '199716300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '41662212' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150899' ,`Longitude` = '-95.584323' ,`PhotoCount` = '26' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '921861.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge' ,`StreetNumber` = '8538' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 41662212 - Built by Toll Brothers, Inc. - December completion! ~ Located on a corner home site with no rear neighbors, the Adalyn Italian Villa boasts a clean stucco finish that makes an impressive statement. This beautiful two-story home features soaring ceilings, private study, and formal dining room with views to the curved staircase. Open the multi-slide doors in the great room and expand your entertaining and living space to the covered porch. Additional highlights are a first-floor guest suite with full bath. The primary suite offers a tray ceiling and resort-style bath and spacious closet. Host game and movie nights in the flex/game space or media room. Outdoor toys will be covered in the huge 4-car tandem garage. This is the epitome of luxury living in a resort-style community!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 9 Blk 3' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '11718' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113642' WHERE `Matrix_Unique_ID` = '200571208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '48467908' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.524641' ,`Longitude` = '-95.409677' ,`PhotoCount` = '15' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '955895.00' ,`Status` = 'Active' ,`StreetName` = 'Elm Manor' ,`StreetNumber` = '2208' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 48467908 - Built by Toll Brothers, Inc. - Ready Now! ~ The Valen Modern Farmhouse plan is an entertainers dream home. Starting with the stone and stucco exterior that exudes curb appeal, you will be welcomed into a foyer with tray ceiling flanked by a two-story office with sloped ceiling. A wall of windows that surround the central courtyard lead into a spacious great room with fireplace. The well-appointed kitchen features a casual dining area and large island, perfect for gathering. Expand the entertaining space by opening the multi-slide doors leading to the covered patio. The relaxing primary bedroom has views to the backyard and en-suite that includes dual sinks, separate shower, tub and two walk-in closets. Other highlights include a private guest suite with full bath and walk-in closet, a large flex/game room, private media room and two large secondary bedrooms. Quality and craftsmanship as you would expect with all the entertaining space you need.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 15 (A0563 HT&BRR) BLK 1 LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '10401' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1164' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '' ,`TaxRate` = '3.72' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113643' WHERE `Matrix_Unique_ID` = '201263377' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '27972860' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472116' ,`Longitude` = '-95.510829' ,`PhotoCount` = '16' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '699061.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Oak' ,`StreetNumber` = '10515' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 27972860 - Built by Toll Brothers, Inc. - Ready Now! ~ The Watson High Plains plan is a single-story plan with room to grow. The stucco and stone exterior provides curb appeal and welcomes you home. The covered entry opens to the foyer with tray ceiling. Two spacious secondary bedrooms and shared hall bath are split from the activity of the main living space. A secluded office with double-door entry provides an excellent remote working space. The gourmet kitchen features a casual dining room, and large center island with view to the great room. A breathtaking sloped ceiling in the great room extends onto the covered patio that can be accessed by 15-foot sliding glass doors that expand entertaining space to outdoor living space. Host game night in the game room just off the main living area. Guest will appreciate the bedroom suite with full bath. The primary bedroom offers privacy and includes an expanded shower and oversized walk-in closet. Dreams can come true!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9483' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna Select' ,`TaxAmount` = '' ,`TaxRate` = '3.72' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113643' WHERE `Matrix_Unique_ID` = '202874347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '76432475' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468092' ,`Longitude` = '-95.525340' ,`PhotoCount` = '17' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '549672.00' ,`Status` = 'Active' ,`StreetName` = 'Rustling Creek' ,`StreetNumber` = '1715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76432475 - Built by Toll Brothers, Inc. - September completion! ~ The Waller Mission boast curb appeal with the stylish stucco exterior with shutters and covered entry. The impressive two-story foyer with tray ceiling flows into the secluded office with double doors. A spacious great room offers a multi-slide door that opens to an expanded back patio. The grand and private back yard has plenty of room for a future pool and outdoor recreational activities. The gourmet kitchen features a casual dining room, walk-in pantry and island that overlooks the great room. The first-floor primary bedroom includes dramatic sloped ceilings and ensuite bath with dual vanities, free standing tub with separate shower and walk-in closet with convenient access to the utility room. Additional highlights are three spacious bedrooms, one with private bath, shared hall bath and a loft overlooking the great room!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Blk 2' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '8693' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna - Villa Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113643' WHERE `Matrix_Unique_ID` = '202961781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '60947278' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472147' ,`Longitude` = '-95.510670' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '724855.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Oak' ,`StreetNumber` = '10519' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 60947278 - Built by Toll Brothers, Inc. - September completion! ~ The stunning Langdon Transitional is a two-story home that offers a spacious open concept. This home features a spacious guest bedroom on the main floor and a luxurious primary bedroom with sloped ceiling and en-suite with dual sinks, freestanding tub, and roomy walk-in closet. A generous office space makes for a great place for remote work or study. The generous cabinet and counter top space in the kitchen, is what makes this home perfect for any sized party. Atop the curved staircase, you will enjoy a large game/flex room and private media room with two secondary bedrooms and full bath. Filled with craftsmanship and quality you expect, with the luxury and premium finishes you deserve!!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 11 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113643' WHERE `Matrix_Unique_ID` = '202968197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '39102668' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099473' ,`Longitude` = '-95.347974' ,`PhotoCount` = '26' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '799786.00' ,`Status` = 'Active' ,`StreetName` = 'Woodley' ,`StreetNumber` = '28261' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39102668 - Built by Toll Brothers, Inc. - Ready Now! ~ LIMITED AVAILABILITY! The Quinton plan opens to a welcoming foyer with tray ceiling and a clear view of an expansive great room. Multi-slide doors lead to a generous covered patio with cathedral ceiling perfect for entertaining. Adjacent to an inviting front covered porch is a formal dining area that has pass through access to a well-appointed kitchen with a large center island. The primary bedroom is enhanced with a majestic cathedral ceiling, enormous walk-in closet with ultra shower and large soaking tub and dual-sink vanities. This home includes generous secondary bedrooms, two with Jack and Jill bath and one with full hall bath access. Additional highlights include a game room, versatile study off the great room and a useful resource center off the kitchen. Luxury and craftsmanship all in a single-story home.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Blk 1' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '11030' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Woodson\'s Reserve' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113643' WHERE `Matrix_Unique_ID` = '203319030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '31786152' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150766' ,`Longitude` = '-95.585521' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '1039979.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge' ,`StreetNumber` = '8522' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 31786152 - Built by Toll Brothers, Inc. - January completion! ~ The Venetian Calais plan offers luxurious style and design. The impressive exterior featuring a porte cochere with motor court, 3-car split garage, and covered front porch and patio, makes for great curb appeal. The foyer provides elegance with it\'s curved staircase, two-story ceilings, and views into the formal dining room. A private office and bedroom suite off the foyer provide convenience of remote working and solitude for guests. Entertaining is easy in the open concept kitchen and great room. The primary suite includes a tray ceiling, and luxurious bath with freestanding tub, large vanity with double sinks, separate shower and huge walk-in closet. Upstairs, you will find a spacious flex-game room and media room, along with three generous bedrooms with full baths!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Blk 3' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '12850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113643' WHERE `Matrix_Unique_ID` = '205387513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '32167895' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979811' ,`Longitude` = '-95.746001' ,`PhotoCount` = '12' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '734522.00' ,`Status` = 'Active' ,`StreetName` = 'Via Santa Caterina' ,`StreetNumber` = '20719' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 32167895 - Built by Toll Brothers, Inc. - September completion! ~ New Plan! The Indio Transitional plan offers single-level living at it\'s finest. A split plan with two generous secondary bedrooms and hall bath at the front of the home. A private office with dramatic sloped ceiling and double door entry is perfect for remote work. A sizable guest suite with full bath and walk-in closet is ideal for overnight guests or multi-generational living. Entertaining is easy in the private media room with easy access to the butler\'s pantry for snacks. An open concept great room is overlooked by a chef inspired kitchen and casual dining space. Expand your living space outdoors by opening the multi-slide doors from the great room onto the expanded covered patio. End the day soaking in the freestanding tub in the primary bath!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Blk 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9417' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113644' WHERE `Matrix_Unique_ID` = '206621752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '95066896' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978895' ,`Longitude` = '-95.746621' ,`PhotoCount` = '15' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '749462.00' ,`Status` = 'Active' ,`StreetName` = 'Via Del Obispo' ,`StreetNumber` = '20719' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 95066896 - Built by Toll Brothers, Inc. - Ready Now! ~ Now open! Our popular Belmore High Plains plan offers single-story living with room for everyone. This amazing home features 4 spacious bedrooms, private media room and additional flex space that could be used for a home office, gym, playroom and beyond. The open concept kitchen comes complete with center island, stainless steel appliances and walk-in pantry. The great room boasts a 17-foot sloped ceiling with electric fireplace and 12-foot multi-slide door the opens to the covered patio, expanding entertaining space. A relaxing primary bedroom includes a spacious walk-in closet and en-suite with freestanding tub, separate shower, double sinks and linen closet. This impressive house is ready for you to call it home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Blk 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9254' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113644' WHERE `Matrix_Unique_ID` = '206622040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '76306361' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644255' ,`Longitude` = '-95.027607' ,`PhotoCount` = '30' ,`PostalCode` = '77571' ,`RoomCount` = '10' ,`ListPrice` = '379487.00' ,`Status` = 'Active' ,`StreetName` = 'Lucky Manor' ,`StreetNumber` = '167' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76306361 - Built by HistoryMaker Homes - Ready Now! ~ This 5 bedroom, 3 full bathroom, two-story home boasts 9\' ceilings throughout the 1st floor. Luxury vinyl plank can be found in the common areas and all baths. The chef-inspired kitchen offers 42-inch white cabinetry with crown molding, ceramic tile backsplash, granite countertops, a corner walk-in pantry, and stainless-steel appliances that make entertaining easy. Settle into the spacious primary bedroom located on first floor and bathroom with dual sink vanity and oversized shower with separate soaking tub. This home comes with full sod, full irrigation, and covered back patio!!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113644' WHERE `Matrix_Unique_ID` = '206646612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '82574053' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979918' ,`Longitude` = '-95.746848' ,`PhotoCount` = '14' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '744263.00' ,`Status` = 'Active' ,`StreetName` = 'Via Santa Caterina' ,`StreetNumber` = '20735' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 82574053 - Built by Toll Brothers, Inc. - September completion! ~ NEW PLAN! The Fenton High Plains plan offers an abundance of space and function in a single-story home made for long term living. Situated on a 60-foot wide home site, this amazing home features a 12-foot ceiling in the office just off the foyer. A private secondary bedroom with full bath is perfect for overnight guests. The open concept kitchen comes complete with center island, stainless appliances and walk-in pantry. The great room boasts high ceilings and a 60 linear electric fireplace. 15-foot multi-slide glass doors open to the expanded covered patio allowing the outdoor\'s in and opening entertaining space. A relaxing primary bedroom includes a walk-in closet, oversized shower with drying area and separate vanities. Additional highlights include an additional multi-purpose flex room and spacious secondary bedrooms.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34 Blk 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9264' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113644' WHERE `Matrix_Unique_ID` = '207316292' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '15235168' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841495' ,`Longitude` = '-95.861174' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '319295.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Green' ,`StreetNumber` = '817' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 15235168 - Built by HistoryMaker Homes - Ready Now! ~ Spacious and light one-story home with large primary suite. Large open kitchen and dining area with window nook in breakfast area. Tray ceilings in family room and primary suite. Neutral color palette compliments this spacious and functional floor plan!!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S800008 SUNTERRA SECTION 8 BLK 1 LOT 105' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5664' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113644' WHERE `Matrix_Unique_ID` = '207435686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '34161678' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194748' ,`Longitude` = '-95.419044' ,`PhotoCount` = '48' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '404048.00' ,`Status` = 'Active' ,`StreetName` = 'Chinese Violet' ,`StreetNumber` = '10726' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1942' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 34161678 - Built by HistoryMaker Homes - Ready Now! ~ he exclusive, gated, Harper’s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from The Woodlands world class dining, shopping, and entertainment. This charming Cypress 4 bedroom and 2 bath floor plan boasts exceptional curb appeal with its Brick accented covered entry, 10\' ceilings throughout, an extended covered patio (the perfect spot for outdoor dining and your grill), and a box out window in the dining area. The home-chef will love the stainless-steel appliances, quartz counter tops, large island, 42 inch white cabinetry w/crown molding, and walk-in pantry. The primary bedroom suite offers dual vanities, a garden tub, separate shower, and large walk-in closet.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 24 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113644' WHERE `Matrix_Unique_ID` = '207462024' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '81309648' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194862' ,`Longitude` = '-95.419662' ,`PhotoCount` = '41' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '449794.00' ,`Status` = 'Active' ,`StreetName` = 'Chinese Violet' ,`StreetNumber` = '10714' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2422' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 81309648 - Built by HistoryMaker Homes - Ready Now! ~ Welcome to HistoryMaker Homes in Harper’s Preserve. The exclusive, gated, Harper’s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from world class dining, shopping, and entertainment. This home has 10 ft Ceilings with 8 ft doors on 1st Floor, an extended covered patio just waiting for your grill or smoker, three bedrooms on the 1st Floor with a bedroom and large game room upstairs. The primary bedroom suite boasts a garden tub, separate shower, dual sinks, and vanities, and not just one but TWO walk-in closets! The chef-inspired kitchen features quartz counter tops, 42 cabinetry w/crown molding, and stainless-steel Whirlpool appliances.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113644' WHERE `Matrix_Unique_ID` = '207611111' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '87028097' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836150' ,`Longitude` = '-95.863745' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '347750.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol Bay' ,`StreetNumber` = '900' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 87028097 - Built by HistoryMaker Homes - Ready Now! ~ Light, bright, and open one-story with lots of energy-efficient windows and spacious, functional, combined kitchen/dining space. Large primary bedroom with spacious bath and large walk-in closet' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5715' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113645' WHERE `Matrix_Unique_ID` = '207612305' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '6176399' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841157' ,`Longitude` = '-95.861611' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '365250.00' ,`Status` = 'Active' ,`StreetName` = 'Laguna Green' ,`StreetNumber` = '812' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1917' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 6176399 - Built by HistoryMaker Homes - Ready Now! ~ COME BE A PART OF THE LAGOON LIFE @ STUNTERRA!! SOMERVILLE U 1917 sq ft / 3 BEDS / 2 BATHS / 1 PWDR 2 GARAGE / 2STORY 9\' Ceilings Throughout First Floor Luxury Vinyl Tile Flooring in Entry, Family Room, Kitchen, Nook & Utility 42 inch White Kitchen Cabinets with Crown Moulding and Kitchen Island Quartz Countertops with Ceramic Tile Backsplash Stainless Steel Whirlpool Kitchen Appliances including Microwave Box Window in Nook Master Suite with 60 inch Shower and Double Vanity with Second Sink Full Yard Sod with Irrigation Covered Patio UNDER CONSTRUCTION!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S800008 SUNTERRA SECTION 8 BLK 1 LOT 89' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5528' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113645' WHERE `Matrix_Unique_ID` = '207871150' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '64669583' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194725' ,`Longitude` = '-95.418953' ,`PhotoCount` = '28' ,`PostalCode` = '77385' ,`RoomCount` = '10' ,`ListPrice` = '464405.00' ,`Status` = 'Active' ,`StreetName` = 'Chinese Violet' ,`StreetNumber` = '10730' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 64669583 - Built by HistoryMaker Homes - Ready Now! ~ Welcome to HistoryMaker Homes in Harper’s Preserve. The exclusive, gated, Harper\'s Preserve offers exemplary schools, resort-style amenities and is located just minutes away from world class dining, shopping, and entertainment. This stunning Sequoia plan features10\' Ceilings Throughout First Floor, Luxury Vinyl Plank Flooring in Entry, Kitchen, Nook, Family Room & Utility Room, 42 White Kitchen Cabinets with Crown Molding and Kitchen Island, Granite Countertops with Ceramic Tile Backsplash, Stainless Steel Whirlpool Kitchen Appliances including Microwave, Box Window in Nook, Master Suite with Garden Tub & Separate Shower with Double Vanity & Second Sink, Full Yard Sod with Full Irrigation with Rotary Heads, Extended Covered Patio and more. Schedule your appointment today.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S572731 - Harper\'s Preserve 31, BLOCK 1, Lot 23' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1127' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harper\'s Preserve' ,`TaxAmount` = '' ,`TaxRate` = '3.01' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113645' WHERE `Matrix_Unique_ID` = '207897161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '52510054' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841604' ,`Longitude` = '-95.858595' ,`PhotoCount` = '27' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '411650.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol Bay' ,`StreetNumber` = '896' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 52510054 - Built by HistoryMaker Homes - November completion! ~ Light, bright, open, spacious two-story with oversized primary suite upstairs combined with aPrimary closet to match! Three-car-tandem garage solves any parking problems and/or provides some extra storage/workout/shop space. Privacy with nice green-space behind the home. House faces South/East. This one is a must see!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 46 Block: 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5714' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.67' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113645' WHERE `Matrix_Unique_ID` = '208143816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '81415413' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979741' ,`Longitude` = '-95.747571' ,`PhotoCount` = '12' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '799885.00' ,`Status` = 'Active' ,`StreetName` = 'Garibaldi' ,`StreetNumber` = '14219' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 81415413 - Built by Toll Brothers, Inc. - September completion! ~ The Hardy Transitional has a sleek stucco exterior and filled with architectural details inside. The two-story foyer with curved staircase is flanked by a private office with double-door entry. A secluded bedroom with full bath and walk-in closet provides space for multigenerational living or overnight guests. The great room allows you to enjoy warm fires with the electric fireplace or open the multi-slide doors to the covered patio to expand entertaining space. The gourmet kitchen features an expansive island, walk-in pantry, stainless appliances and casual dining room. The upper level is host to two spacious bedrooms and two full baths, enormous loft and media room!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 17 blk 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8905' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113645' WHERE `Matrix_Unique_ID` = '208241881' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','208264940','1664113645','208264940','2022-09-24T23:36:05.660','23422786','Jared Turner','LennarVillageBldr-JaredTurner','','','30.163005','-95.202827','8','77357','8','295000.00','Active','Via Nizza','19220','Lane','New Caney','2','1','4','2211','Single-Family','NEW Gulf Coast Series \'\'Aransas II\" Elevation-A by Lennar in Gorgeous Tavola. This is a Wonderful Two Story 4 Bedroom, 2.5 Bath home. All Bedrooms Up! Features a Fantastic Kitchen with adjoining Breakfast Nook, Breakfast Bar, Designer Cabinets, Sparkling Countertops & Great Appliance Pkg! Open Concept w/ Generous Family Room and Dining Area! Master Suite w/ Tub, Separate Shower & Dual Walk-in Closets! Lovely Wood-look Hard Surface Floors and Carpet; Fully Sodded Yards; Energy Efficient 16 SEER HVAC System & More!','','40','Lennar Homes','','','','Mud,Other Disclosures','1','','','Porter/New Caney East','Central Gas','1','SEC 0034 BLK 003 LOT 022','Subdivision Lot','','','','800','1','To Be Built/Under Construction','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Tavola','','3.5826','Public Sewer,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:21:16.583' ,`MLSNumber` = '15831886' ,`ListAgentFullName` = 'Dan Chen' ,`ListOfficeName` = 'KingFay Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772508' ,`Longitude` = '-95.564434' ,`PhotoCount` = '31' ,`PostalCode` = '77079' ,`RoomCount` = '8' ,`ListPrice` = '589999.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial' ,`StreetNumber` = '12919' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lot value only. 3-4 bedrooms. A bonus room can be media room or play room. Per seller , the bonus room is not included in 1988 SF which means the actual SF is more than 1988. Upgraded home sit in huge 12,300 SF lot in memorial area zoned to Memorial middle/high school. Iron front gate for privacy. Community pool & tennis courts within walking distance. Conveniently located within walking distance to memorial city , city center and park. Per seller, never flooded. They seller will need 2 weeks lease back after closing. 2 hour notice for the appointment. Showing allow after/on 4 pm during week day or Any time during weekend.' ,`Acres` = '0.2824' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 MEMORIAL BEND SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '12300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Bend' ,`TaxAmount` = '11670' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664113645' WHERE `Matrix_Unique_ID` = '208381686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:20:11.497' ,`MLSNumber` = '83674937' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085477' ,`Longitude` = '-95.182803' ,`PhotoCount` = '6' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Clearwater Bluff' ,`StreetNumber` = '9431' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The inviting single story \"Honeysuckle II B\" plan, from the Wildflower Collection by Lennar in gorgeous Royal Brook at Kingwood, features 3 bedrooms, 2 baths, a 2 car garage, and an an open-concept layout that’s ideal for modern family living. A spacious kitchen overlooks the family room and attached covered patio, ready for indoor-outdoor entertaining. Two bedrooms are privately situated near the family room, while the owner’s suite boasts an en-suite bathroom and walk-in closet at the end of the home. Amazing appliances; utility room; 16 SEER HVAC system; landscape pkg; fully sodded yards & more.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0022 BLK 001 LOT 008' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Royal Brook' ,`TaxAmount` = '' ,`TaxRate` = '2.65' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113646' WHERE `Matrix_Unique_ID` = '208475967' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '79517619' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099434' ,`Longitude` = '-95.349580' ,`PhotoCount` = '15' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '774258.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Peak' ,`StreetNumber` = '28224' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3789' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 79517619 - Built by Toll Brothers, Inc. - November completion! ~ Entertainers dream home now available! This luxurious Warner High Plains home features impeccable finishes and inspiring spaces throughout. High 19-foot ceilings start in the foyer and lead into a two-story great room making the home feel open and bright. A 60\' linear fireplace keeps you warm on cool nights and 12-foot multi-slide doors open to the covered patio and expand your entertaining space to the outdoors. A formal dining room is easily accessed from the chef-inspired kitchen via the butlers pantry. The comfortable and relaxing primary suite boasts tray ceilings, a stunning freestanding tub that sits between individual vanities, a tiled shower and enormous walk-in closet. Take the party to the upper level to enjoy the game/flex room for friendly competition or relax with a movie in the media room. Act now and call to schedule an appointment to view this amazing home.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 8 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodson\'s Reserve Select' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113646' WHERE `Matrix_Unique_ID` = '208564179' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '90101102' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099631' ,`Longitude` = '-95.350013' ,`PhotoCount` = '19' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '774558.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Peak' ,`StreetNumber` = '28219' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 90101102 - Built by Toll Brothers, Inc. - November completion! ~ Single-story living at it\'s finest, the Loralai High Plains plan features a stunning entry that boasts curb appeal. Friends and family are welcomed with impressive tray ceilings in the foyer which flow into the kitchen and great room. The primary bedroom displays a tray ceiling and en-suite with a luxurious freestanding tub, separate shower with beautiful floor and wall tile, and a spacious walk-in closet. The great room\'s 9-foot multi-slide doors open to the expanded covered patio which is pre-plumbed for sink and gas stub for a future outdoor kitchen. Other features include a study with sloped ceiling, and media room for entertaining.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 30 Blk 1' ,`LotDesciption` = 'Cleared,Other,Subdivision Lot' ,`LotSize` = '8433' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1335' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodson\'s Reserve Select' ,`TaxAmount` = '' ,`TaxRate` = '3.2' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113646' WHERE `Matrix_Unique_ID` = '208698841' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','208765771','1664113646','208765771','2022-09-24T23:40:04.383','69169666','Jared Turner','LennarVillageBldr-JaredTurner','','','30.164605','-95.197089','9','77357','11','515940.00','Active','Timbarra Glen','23422','Drive','New Caney','4','0','5','3359','Single-Family','NEW Lennar Homes Vista Collection, \'\'Sierra Mesa\" Plan, Brick/Stone Elevation A - Spacious 2 Story, 5 bed 4 bath 2 Car Garage \"Everything\'s Included\" Home with Formal Dining Room, Study and Game Room, features an Island Kitchen with Sparkling Countertops, 42\'\' Designer Cabinets & Great Appliance Pkg! Kitchen is open to a Breakfast Room and a Generous Family Room. Primary Suite has Dual Sinks, Luxurious Tub & Separate Shower, Huge Walk-in Closet! Beautiful hard-surface Floors in Main Living Areas, Baths & Utility Room! Mud Room; Covered Rear Patio & Fully Sodded Yards; 16 SEER HVAC System & MORE!','','40','Lennar Homes','','','','Mud','1','','','Porter/New Caney East','Central Gas','1','Tavola 36, BLOCK 003, Lot 003','Subdivision Lot','','','','1125','1','To Be Built/Under Construction','2','','0','','','','','Composition','39 - New Caney','TAVOLA ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Tavola','','3.5826','Public Sewer,Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '46008644' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526694' ,`Longitude` = '-95.412504' ,`PhotoCount` = '7' ,`PostalCode` = '77578' ,`RoomCount` = '10' ,`ListPrice` = '772715.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Hollow' ,`StreetNumber` = '4739' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 46008644 - Built by Toll Brothers, Inc. - October completion! ~ Quality and craftsmanship is what you will find in the Nicholson Traditional plan. As soon as you enter into the two-story foyer with the elegant curved staircase, you notice the natural light that fills the space. The foyer is flanked by a secluded bedroom with full bath and a versatile study with closet across the hall. An open concept in the kitchen and great room is an entertainers dream. The kitchen features stainless appliances, walk-in pantry and a large island that is sure to be a gathering spot. A casual dining room is perfect for hosting a dinner party. The great room offers an electric fireplace and multi-slide doors that open to the covered patio. A luxurious primary suite is host to an ensuite with freestanding tub, separate shower and walk-in closet. Additional highlights are a flex-game room and three secondary bedrooms with walk-in closets, plant shelves and soaring ceilings.' ,`Acres` = '0.1827' ,`Area` = '5' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 13 (A0298 HT&BRR & A0563 HT&BRR) BLK 1 LOT 10' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '7958' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1690' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pomona' ,`TaxAmount` = '' ,`TaxRate` = '3.72' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113646' WHERE `Matrix_Unique_ID` = '209305695' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:41:25.123' ,`MLSNumber` = '39259115' ,`ListAgentFullName` = 'Sylvia Pinson' ,`ListOfficeName` = 'Vista Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.326380' ,`Longitude` = '-94.941756' ,`PhotoCount` = '42' ,`PostalCode` = '77563' ,`RoomCount` = '7' ,`ListPrice` = '454700.00' ,`Status` = 'Active' ,`StreetName` = 'Ling' ,`StreetNumber` = '360' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1684' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the lifestyle of Galveston Bay in this Great Furnished 3-3 Canal Front Home Facing East with Boat House, Cat Walk and Party Deck with cover. Fish and crab from your own pier or Jones Lake and Galveston Bay are only minutes away. Relax on your deck and watch sunrises. Fishermen and Bird Watchers Paradise. Carport and lots of parking. Cargo Lift. Living Room and Kitchen have Beautiful tile floors. The living room has many windows and French doors. Kitchen is open to the living room and has a breakfast bar. Archway leads to Dining Room with gorgeous engineered wood floors. Upstairs has 2 primary bedrooms. Each has an adjoining bath. Downstairs has a complete apartment with a very large game room(32x13) with French doors opposite each other, a bedroom, bath and kitchenette. Storage Room downstairs. All measurements are approximate.' ,`Acres` = '0.0976' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 360 NEW BAYOU VISTA ADDN 3' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '4250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 3' ,`TaxAmount` = '7285' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113646' WHERE `Matrix_Unique_ID` = '209305809' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:38:58.100' ,`MLSNumber` = '17376635' ,`ListAgentFullName` = 'Asmitaben Bhavsar' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.602761' ,`Longitude` = '-95.096778' ,`PhotoCount` = '47' ,`PostalCode` = '77059' ,`RoomCount` = '15' ,`ListPrice` = '498500.00' ,`Status` = 'Active' ,`StreetName` = 'Mighty Redwood' ,`StreetNumber` = '11602' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A dream in Clear Lake,CCISD! This contemporary style charmer located in Brookwood is 5 Bed,4Bath,2 Car Garage. Features Crown Molding,Plantation Shutters,Tiled Flooring and New Carpet in bedrooms. Beautiful Open Concept ,notable Foyer entry with Vaulted Ceilings make this home one you will not want to miss! 2bdrms and Primary are located downstairs. 1 of the bdrms upstairs has an ensuite and a closet with a window. You can get cozy with Two Fireplaces, one in the living rm and one in the primary bdrm. Large stylish kitchen with New appliances, attractive Island layout with electric Cooktop,Silestone Countertops-a Culinary delight! The feature rich primary bdrm has a sitting area, walk-in closet, ensuite Step-in Shower and Whirlpool bath. No backyard neighbor-access to walking trails. Walk to all amenities:pool,tennis ct, Bay Area Park. Quick commute to Nasa-a plus. Updates include Tankless Water Heater, Roof,ACs,Bathrooms and more. NEVER FLOODED All Dimentions are approx. pls verify.' ,`Acres` = '0.2094' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 10 BROOKWOOD SEC 3' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '745' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BROOKWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookwood' ,`TaxAmount` = '10541' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113646' WHERE `Matrix_Unique_ID` = '210239103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:32:52.987' ,`MLSNumber` = '71416109' ,`ListAgentFullName` = 'Wayne Au' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812700' ,`Longitude` = '-95.694919' ,`PhotoCount` = '41' ,`PostalCode` = '77084' ,`RoomCount` = '9' ,`ListPrice` = '323000.00' ,`Status` = 'Active' ,`StreetName` = 'Keystone Oak' ,`StreetNumber` = '18607' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2319' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice neighborhood, Bright home, high ceiling, nice floor plan, stainless still appliances, new microwave good size of backyard, near school, easy access to major highway.' ,`Acres` = '0.1716' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 OAK RIDGE PLACE SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '580' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Rdg Place Sec 07' ,`TaxAmount` = '5730' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113647' WHERE `Matrix_Unique_ID` = '210439612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:52:01.070' ,`MLSNumber` = '18094755' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644806' ,`Longitude` = '-95.027348' ,`PhotoCount` = '28' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '342376.00' ,`Status` = 'Active' ,`StreetName` = 'Lucky Manor' ,`StreetNumber` = '172' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 18094755 - Built by HistoryMaker Homes - Ready Now! ~ This 3 bedroom, 2.5 bathroom, two-story home boasts a soaring two-story entry and 9\' ceilings throughout the remainder of the 1st floor. Luxury vinyl plank can be found in the common areas and all baths. The chef-inspired kitchen offers 42 inch gray cabinetry with crown molding, ceramic tile backsplash, quartz countertops, a corner walk-in pantry, and stainless-steel appliances that make entertaining easy. Settle into the spacious primary bedroom with on suite bathroom featuring dual sink vanity and oversized shower and soaking tub. This home comes with full sod, full irrigation, and covered back patio!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113647' WHERE `Matrix_Unique_ID` = '210550099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:12:11.053' ,`MLSNumber` = '59578124' ,`ListAgentFullName` = 'Michael Goins' ,`ListOfficeName` = 'Lake Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.399518' ,`Longitude` = '-95.628511' ,`PhotoCount` = '37' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble Beach' ,`StreetNumber` = '3566' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1668' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RECENT UPDATES! NEW flooring! NEW paint job! NEW A/C unit! This cute home situated in the prestigious Walden community is a great opportunity to live in a community on Lake Conroe at an affordable cost. THREE full baths go with these 3 bedrooms and an open living, kitchen, eating area. With quick access to Lake Conroe at 2 community boat ramps you can play the days away on the water, or enjoy the top rated golf course, or use the fitness center, tennis club, parks and trails, yacht club, marina, and so much more. Restaurants and options for entertainment abound so you will never be lacking options for an evening out. Enjoy quiet evenings outside on the screened in porch or enjoy a nice fire inside. When you need a break from everyday life - run over to the Margaritaville Resort and spend some time relaxing and recuperating so you can return to the everyday flow of things refreshed and energetic! Don\'t miss this golden opportunity to live life like you are on vacation everyday!' ,`Acres` = '0.1228' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 10, BLOCK 56, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden 10' ,`TaxAmount` = '4190' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113647' WHERE `Matrix_Unique_ID` = '210781002' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:17:19.773' ,`MLSNumber` = '34974296' ,`ListAgentFullName` = 'Jamil Joyner' ,`ListOfficeName` = 'Signature Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665910' ,`Longitude` = '-95.444387' ,`PhotoCount` = '28' ,`PostalCode` = '77025' ,`RoomCount` = '8' ,`ListPrice` = '639000.00' ,`Status` = 'Active' ,`StreetName` = 'Bassoon' ,`StreetNumber` = '10618' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new construction 4 bedroom/2.5 bathroom located in the heart of Houston near the Medical Center and minutes to the Galleria. The home was meticulously built by Grace Building Company with open spaces and plenty of light. The master suite is downstairs and features a soaking tub plus a stand alone shower. The floors are a warm engineered hardwood throughout. The playroom upstairs is spacious and overlooks the first floor. Enjoy double sinks in the upstairs bathroom and a formal dining room on the first floor. This home is not located in a flood zone.' ,`Acres` = '0.1641' ,`Area` = '20' ,`BuilderName` = 'Grace Building Co.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willow Meadows Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 1 WESTWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHEARN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Sec 01' ,`TaxAmount` = '3000' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113647' WHERE `Matrix_Unique_ID` = '210889638' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:54:08.443' ,`MLSNumber` = '72956670' ,`ListAgentFullName` = 'Michael Reed' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.763071' ,`Longitude` = '-95.631237' ,`PhotoCount` = '36' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Senca Park' ,`StreetNumber` = '13826' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely renovated home in highly sought-after Parkway Villages. As you walk in notice the fresh neutral paint and new wood floors. Home features beautiful kitchen with double islands and is open to the large family room. Enjoy the quartz counter tops and SS appliances. Family room has cozy fireplace, wall of windows, French doors to backyard and high ceilings. Private study with French doors located off family room. Split floor plan has two bedrooms with a full hall bathroom towards the front of home. Primary bedroom boasts generous closet space and is located towards the rear of home. Primary bath has new tile, quartz counters, separate shower/jetted tub. Convenient half bath located near breakfast room and laundry room. Easily maintained backyard space with enough room for the kiddos to play or just for relaxing under the retractable awning. Roof replaced 2 years ago. Zoned to Bush Elementary plus great private schools close by. Bonus neighborhood green space across the street.' ,`Acres` = '0.1432' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 3 PARKWAY VILLAGES SEC 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '6239' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1934' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkway Villages Sec 01' ,`TaxAmount` = '9364' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113647' WHERE `Matrix_Unique_ID` = '210993461' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:18:27.163' ,`MLSNumber` = '53249183' ,`ListAgentFullName` = 'Lisa Davis' ,`ListOfficeName` = 'Realty ONE Group Iconic' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.372475' ,`Longitude` = '-95.537901' ,`PhotoCount` = '29' ,`PostalCode` = '77304' ,`RoomCount` = '9' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Masquerade' ,`StreetNumber` = '7318' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2815' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experience life on Lake Conroe in the highly sought after Lake Community of Water Crest on Lake Conroe! WHOLE HOUSE GENERATOR! Lush landscaping w/brick and stone porch with an expansive entry, security system w/cameras, water softener system, and French drains. Home has been freshly painted. Kitchen is open to living room w/an expansive island, breakfast bar, granite countertops, tile backsplash, walk-in pantry, ceramic tile flooring throughout the downstairs. Large extra storage not included in square footage under the stairs can be used as a play area or for your pets. Spacious primary bed and bath with dual sinks, garden tub & separate shower. Game room and bedrooms upstairs. Enjoy the private backyard with no neighbors, neighborhood boat launch, two resort-style pools, excellent clubhouse, fishing ponds, parks, playgrounds, hike/bike paths and so much more! Food Truck Fridays, walking trails & many more perks! Incredible neighborhood amenities. Excellent Location, close to I-45.' ,`Acres` = '0.1641' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S954408 - WATER CREST ON LAKE CONROE 08, BLOCK 1, LOT 7' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'LAGWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Water Crest On Lake Conroe 08' ,`TaxAmount` = '7880' ,`TaxRate` = '3.0823' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113647' WHERE `Matrix_Unique_ID` = '211232845' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:27:01.430' ,`MLSNumber` = '75827774' ,`ListAgentFullName` = 'April Blalock' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = 'Francesca Conway' ,`SellingOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`Latitude` = '30.321545' ,`Longitude` = '-95.553930' ,`PhotoCount` = '50' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '314900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Misty Haven' ,`StreetNumber` = '7472' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A piece of Country Heaven.Unrestricted 3/2/2 Brick home on 1.3 acres with NO HOA.. Property has a workshop w/shower & barn on back of property with a drive to them. Yes you could run a business from home. House is clean & move in ready but could use some updates if you desired. Huge Country kitchen, with tons of solid wood cabinets & counter space, double ovens, gas burner cooktop & refrigerator stays, and is open to a generous Breakfast room. Big Open living room & formal dining room. Walkin pantry & Mudroom with some built-ins & full bath with shower. Main Bedroom is in the back of the house for peace and quiet with 2 more bedrooms down the hall .Beautiful Back acreage has fruit trees, garden area, & gently slopes to the barn.' ,`Acres` = '1.36' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WOODHAVEN 01, LOT 52-A, 53-A, 55, ACRES 1.360' ,`LotDesciption` = 'Cleared' ,`LotSize` = '55600' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Woodhaven 01' ,`TaxAmount` = '3392' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113648' WHERE `Matrix_Unique_ID` = '211496836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:28:11.300' ,`MLSNumber` = '37571157' ,`ListAgentFullName` = 'Cynthia Cisneros' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.880015' ,`Longitude` = '-95.142739' ,`PhotoCount` = '14' ,`PostalCode` = '77044' ,`RoomCount` = '13' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Wandering Creek' ,`StreetNumber` = '15406' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning 4-bedroom home is located at Sheldon Ridge (New Side). Have easy access to Bush International Airport and Downtown Houston. Comes equipped with granite countertops, beautiful backsplash, and ample cabinets. The lot is very spacious for your entertainment needs. Master Bathroom has his/her vanities, spa-like tub and shower. With a walking closet. Your new home awaits-Call Today!!!!!' ,`Acres` = '0.1386' ,`Area` = '2' ,`BuilderName` = 'Long Lake LTD' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 4 SHELDON RIDGE SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheldon Rdg Sec 10' ,`TaxAmount` = '9781' ,`TaxRate` = '3.6393' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113648' WHERE `Matrix_Unique_ID` = '211708495' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:39:45.460' ,`MLSNumber` = '90429241' ,`ListAgentFullName` = 'Alex Arenas' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.606748' ,`Longitude` = '-95.596507' ,`PhotoCount` = '40' ,`PostalCode` = '77478' ,`RoomCount` = '11' ,`ListPrice` = '770000.00' ,`Status` = 'Active' ,`StreetName` = 'Sugar Creek' ,`StreetNumber` = '1218' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4181' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous and fully remodeled home located on prestigious Sugar Creek Boulevard inside Sugar Creek subdivision. This spacious home with an open floor plan was fully remodeled and painted in July 2022. A large Calcatta Vicenza quartz island with a new Euro-Style 36-inch 5-element Jenn-Air cooktop with downdraft and seating for four is the centerpiece of this Chef\'s kitchen. New stainless steel appliances, a farmhouse sink, stunning Calcatta Vicenza quartz countertops with white cabinetry and under-mount lighting, and a butler\'s pantry with a wine fridge complete the kitchen. Calcatta quartz is used throughout the home in the bathrooms and wet bar. New low-E french doors open up from the kitchen and from the gym/ sun room unto the new concrete deck and kitchen pad that are ready for your outdoor patio furniture and your new outside kitchen. This home boasts spa-like master bathrooms in both upstairs and downstairs primary suites with large vanities, jetted tubs, and separate showers.' ,`Acres` = '0.2441' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SUGAR CREEK SEC 21, BLOCK 6, LOT 17' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '10633' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'DULLES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sugar Creek Sec 21' ,`TaxAmount` = '11194' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113648' WHERE `Matrix_Unique_ID` = '211896201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:20:40.770' ,`MLSNumber` = '3603616' ,`ListAgentFullName` = 'Trissa Rosette' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016162' ,`Longitude` = '-95.542320' ,`PhotoCount` = '27' ,`PostalCode` = '77379' ,`RoomCount` = '16' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Vintage Creek' ,`StreetNumber` = '8307' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '3618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A New Orleans inspired beauty nestled among mature trees with modern updates! Home features lovely balcony and has 5 bedrooms w/ 2 primary suites, classic formal & dining, large gameroom, 3 full baths & 2 half! Enjoy gatherings in an open floorplan with a recently remodeled kitchen featuring modern touches. Den offers wet bar & ample seating space. Generous primary suite w/ tastefully remodeled spa-like bathroom + walk-in closet. This well-loved home has granite countertops in all wet areas plus recent flooring w/ NO CARPET on the 1st floor! Shady backyard features both picture-perfect uncovered & covered patio...you’ll want to sit for hours! A long and newly poured driveway (2021) leads to a 3-car garage! DIY much? You’ll love 3rd bay of garage outfitted w/ A/C and sink for easy clean-up. Walkable to restaurants, shops & gym, MNW offers fantastic community amenities (6 tennis courts, beautiful pool + waterplay area). So much to love about this home! Zoned to award-winning Klein ISD!' ,`Acres` = '0.2617' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 10 017*M1876900-003-010-003 MEMORIAL NORTHWEST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '693' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Northwest' ,`TaxAmount` = '6293' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113648' WHERE `Matrix_Unique_ID` = '211921794' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:09:10.473' ,`MLSNumber` = '60746701' ,`ListAgentFullName` = 'Heather Lange' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973250' ,`Longitude` = '-93.980927' ,`PhotoCount` = '25' ,`PostalCode` = '77627' ,`RoomCount` = '7' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '808' ,`StreetSuffix` = 'Street' ,`City` = 'Nederland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.16' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S40E LT 24, 8N10E LT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HIGHLAND PARK ELEMENTARY SCHOOL (NEDERLAND)' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'CENTRAL MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Midway' ,`TaxAmount` = '3040' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113648' WHERE `Matrix_Unique_ID` = '211983434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:11:37.713' ,`MLSNumber` = '17808749' ,`ListAgentFullName` = 'Wei Fang' ,`ListOfficeName` = '3H Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559374' ,`Longitude` = '-95.395883' ,`PhotoCount` = '17' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Hidden Landing' ,`StreetNumber` = '2721' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated seller! Back to the market again. Welcome to see this Beautiful 2-story with a lot of rooms and upgrades. Wood floor downstairs and carpet upstairs. No back neighbors. This property is located at a great location with easy access to 288, and Pearland town center with a lot of facilities.' ,`Acres` = '0.1377' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-16A (PEARLAND), BLOCK 1, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MAREK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '7745' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113648' WHERE `Matrix_Unique_ID` = '212036023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:09:25.617' ,`MLSNumber` = '63535415' ,`ListAgentFullName` = 'Michael Thorman' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.253151' ,`Longitude` = '-95.826650' ,`PhotoCount` = '37' ,`PostalCode` = '77363' ,`RoomCount` = '3' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '11216' ,`StreetSuffix` = 'Drive' ,`City` = 'Plantersville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION in a charming neighborhood, situated just off the private subdivision lake!! Fall in love with this amazing home offering a split, open floor plan, recessed lighting, towering 9\' ceilings & so much more! Kitchen boasts granite countertops, large center island, stainless steel appliances and a walk-in pantry. The primary suite is the perfect place to unwind at the end of a long day, with a large walk-in shower & huge walk-in closet. Each additional bedroom has a ceiling fan! Stunning lake views from the living room, kitchen & primary bedroom will make this home feel like a sanctuary. This incredible home is nestled on a spacious quarter acre lot, with a back patio & option to fish straight from your own backyard! This property also has LOW taxes and LOW HOA! Schedule your private showing today!' ,`Acres` = '0.2' ,`Area` = '60' ,`BuilderName` = 'TX Star Premium Home' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Plantersville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MILL CREEK EST, SEC 1, BLOCK 5, LOT 15, ACRES .20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8712' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '39' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Est, Sec 1' ,`TaxAmount` = '194' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113649' WHERE `Matrix_Unique_ID` = '212040490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:30:19.233' ,`MLSNumber` = '22563191' ,`ListAgentFullName` = 'Cody Briley' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.449598' ,`Longitude` = '-95.444818' ,`PhotoCount` = '22' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Acklen Run' ,`StreetNumber` = '2025' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2245' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 4 bedroom home located in Sterling Lakes! Easy access to 288 and local Alvin ISD schools. Enjoy having all bedrooms and laundry room upstairs, no more trips upstairs carrying laundry. BBQ outside on the deck looking out to no back neighbors in view. Come check this one out today, only two of this floor plan were built in the section!' ,`Acres` = '0.1187' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'STERLING LAKES AT IOWA COLONY SEC 13 (A0289 HT&B) BLK 5 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5171' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sterling Lks/Iowa Colony Sec 1' ,`TaxAmount` = '8655' ,`TaxRate` = '3.5607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113649' WHERE `Matrix_Unique_ID` = '212069873' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:13:57.177' ,`MLSNumber` = '69936460' ,`ListAgentFullName` = 'Cristal Fagan' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677987' ,`Longitude` = '-95.734322' ,`PhotoCount` = '30' ,`PostalCode` = '77407' ,`RoomCount` = '6' ,`ListPrice` = '444900.00' ,`Status` = 'Active' ,`StreetName` = 'Skylar Meadows' ,`StreetNumber` = '6006' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this gorgeous home today! The grand entry welcomes you with high ceilings and tons of inviting natural light. Property includes lovely flooring, a grand kitchen, open floor plan, recessed lighting, a mud room, covered back patio, sprinkler system and so much more! Washer/Dryer/Frig STAY!! You don\'t want to miss the chance to live in this wonderful community zoned to Fort Bend ISD schools, and on a culdesac street. Schedule your appointment!' ,`Acres` = '0.132' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'FIELDSTONE SEC 14, BLOCK 4, LOT 29' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'OAKLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'BOWIE MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fieldstone Sec 14' ,`TaxAmount` = '7929' ,`TaxRate` = '2.8429' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113649' WHERE `Matrix_Unique_ID` = '212082484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:49:51.743' ,`MLSNumber` = '93202916' ,`ListAgentFullName` = 'Shelley Hoecker' ,`ListOfficeName` = 'Rounding Third Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401863' ,`Longitude` = '-94.935559' ,`PhotoCount` = '18' ,`PostalCode` = '77590' ,`RoomCount` = '11' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = '19th' ,`StreetNumber` = '2801' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1862' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come view this beautiful Ranch style brick home. Lots of updates! This home has a great open living area which invites entertainment as well as a formal dining room attached the kitchen and adds to the open concept of the home as you walk into the entry way. The primary bedroom bath has a large soaking tub along with a separate shower as well as large his and her walk in closets. There is also a bonus room in the primary room which could be an office or even a small nursery. There has been many updates to this home such as updated flooring, ranch style interior doors, new fencing around the back yard, the driveway has been updated and expanded to be wider. A covered patio has been added. The windows have been updated with storm grade windows as well as some plumbing has been updated. Bring your family to view this beautiful home!' ,`Acres` = '0.1846' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 R LOGAN SUR LOT 23 CHATEAU WEST' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'GUAJARDO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Chateau West' ,`TaxAmount` = '4555' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113649' WHERE `Matrix_Unique_ID` = '212182127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:46:28.793' ,`MLSNumber` = '91003373' ,`ListAgentFullName` = 'Derrick Love' ,`ListOfficeName` = 'Investment Scouts Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.975234' ,`Longitude` = '-95.209445' ,`PhotoCount` = '50' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '304900.00' ,`Status` = 'Active' ,`StreetName` = 'Texian Forest' ,`StreetNumber` = '4122' ,`StreetSuffix` = 'Trail' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2319' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom home located in an amazing neighborhood in Humble, TX. Open concept floor plan, Large Primary Suite with a huge bathroom featuring a jacuzzi tub and separate shower, walk-in closet and double sinks. Primary bath has custom closet & flooring. Kitchen features Granite counters, Island, Gas range. Upgraded wood flooring in bedrooms. Wood burning fireplace in the living room. Secondary bathroom completely updated with double sinks and walk-in shower. Functional sprinkler system. Gutters all around the home. Lots of natural light throughout the home. Driveway was extended to add additional space for vehicles. Upgraded lighting throughout. Storage shed in backyard. Garage upgraded with epoxy flooring. Double pane windows throughout & radiant heat barrier in attic. 4th bedroom can be used as the home office. 6 camera surveillance system stays with the home. Backyard features a covered back patio with retractable screens to minimize bugs. This Home is ready to move in now.' ,`Acres` = '0.1356' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 ATASCOCITA FOREST SEC 23' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5906' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WHISPERING PINES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Atascocita Forest Sec 23' ,`TaxAmount` = '6229' ,`TaxRate` = '2.773' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113649' WHERE `Matrix_Unique_ID` = '212198738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:36:05.190' ,`MLSNumber` = '17263241' ,`ListAgentFullName` = 'Tiera Huang' ,`ListOfficeName` = 'Nextgen Real Estate Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851658' ,`Longitude` = '-95.813321' ,`PhotoCount` = '25' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '303000.00' ,`Status` = 'Active' ,`StreetName` = 'Queens Causeway' ,`StreetNumber` = '25307' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1807' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious KB Home offers 3 bedrooms, 2 full bathrooms, 1 half bathroom and an attached 2 car garage that zoned to Katy ISD. Upon entry you will be greeted with an open concept living and dinning room that flows into the perfect eat-in kitchen. All bedrooms are upstairs with a spacious game room to add the perfect amount of privacy and convenience. The oversized primary bedroom has an en-suite bathroom with dual sinks and walk in closet.The secondary bedrooms and bathroom are on the other side of the game room creating perfect set up for an arrangement. Looking for the best backyard for hosting parties? look no further, this home offers an oversized backyard perfect a pool, playground, outside kitchen and so much more!' ,`Acres` = '0.1227' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 3 KATY MANOR SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5344' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '465' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kay Manor Sec 8' ,`TaxAmount` = '6841' ,`TaxRate` = '3.4768' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113650' WHERE `Matrix_Unique_ID` = '212216606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:19:35.497' ,`MLSNumber` = '67483722' ,`ListAgentFullName` = 'Jennifer Z Lozier' ,`ListOfficeName` = 'Realty Austin, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.467602' ,`Longitude` = '-95.101478' ,`PhotoCount` = '29' ,`PostalCode` = '77539' ,`RoomCount` = '6' ,`ListPrice` = '312000.00' ,`Status` = 'Active' ,`StreetName` = 'Morgan Isle' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Lane' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime location with easy access to I-45, dining & retail. The quality built, single-story home is in move-in-ready condition with a freshly painted interior & professionally cleaned. Chesmar Homes - Paloma Floorplan: 3 BRMS, 2 baths, a separate office or flex room, a large dining area, a utility room, and two-covered patios. The kitchen has granite countertops & a granite peninsula with plenty of room for bar stools, 42\" cabinets, a walk-in pantry, and stainless-steel appliances including the refrigerator. The primary bath features a separate tub & shower & a walk-in closet. The separate laundry room includes the washer & dryer. Numerous builder-grade upgrades: stone accents, brick porch floors, surround sound speakers, diagonally laid large tile, & wood laminate floors. The professionally landscaped yard makes this property stand out. Bay View community has amenities including a pool, playground, & walking trails around the lake. NOTE - This home has never flooded. Schedule a tour.' ,`Acres` = '0.1283' ,`Area` = '33' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BAY VIEW SEC 1 (2009) ABST 19, BLOCK 4, LOT 19, ACRES 0.128' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5588' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'BAY COLONY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Bay View Sec 1 2009' ,`TaxAmount` = '7134' ,`TaxRate` = '2.8897' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113650' WHERE `Matrix_Unique_ID` = '212219456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:02:39.297' ,`MLSNumber` = '53405335' ,`ListAgentFullName` = 'Sonya Patterson' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.144129' ,`Longitude` = '-95.460126' ,`PhotoCount` = '3' ,`PostalCode` = '77380' ,`RoomCount` = '7' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Crinkleroot' ,`StreetNumber` = '17' ,`StreetSuffix` = '' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is a nestled on a quiet street located on 9th hole of The Tournament Course at the front of Woodlands. It\'s a golfer\'s dream. It is located on the middle of the 9th fairway. It has a view of the Clubhouse, pond located between 9 green and 1 tee with a spectacular evening view of the sunset. Easy access to I-45, shopping, restaurants and so much more. Home will be sold AS IS. Room sizes will need to be verified.' ,`Acres` = '0.2437' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL GROGANS ML 19, LOT 8' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '10615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Grogans Ml 19' ,`TaxAmount` = '10153' ,`TaxRate` = '2.0079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113650' WHERE `Matrix_Unique_ID` = '212350880' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:19:28.650' ,`MLSNumber` = '84999004' ,`ListAgentFullName` = 'Gaelin Nichols' ,`ListOfficeName` = 'Heritage Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194916' ,`Longitude` = '-95.217513' ,`PhotoCount` = '17' ,`PostalCode` = '77357' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Juniper Crossing' ,`StreetNumber` = '21948' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Less than a year old, this Lennar San Marcos plan offers 4 bedrooms, a spacious family room, in-house utility room, and is set apart from all the others by the 17x10 covered patio and huge yard with no back neighbors. If privacy and outdoor space is what you are looking for don\'t miss out on this beauty. The refrigerator, washer, and dry will be included with the sale.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 41, Block 6 Pinewood at Grand Texas' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinewood at Grand Texas' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113650' WHERE `Matrix_Unique_ID` = '212416549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:57:18.560' ,`MLSNumber` = '40049876' ,`ListAgentFullName` = 'Senhong Lai' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781184' ,`Longitude` = '-95.415772' ,`PhotoCount` = '6' ,`PostalCode` = '77007' ,`RoomCount` = '3' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Kiam' ,`StreetNumber` = '5239' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Terrific building site for builders to build THREE NEW Constructions.! 5,350 square foot (HCAD) corner lot in the rising Cottage Grove subdivision. This lot can be replat and put three units on it. Priced at Lot Value Only. This property NEVER Flooded and is close to everything, Downtown, Memorial Park, Galleria and much more! Please come to walk the property, existing home will not be shown. Buyer will need to obtain their own survey. Listing agent happy to answer any questions! Fantastic opportunity.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 975 & 976 COTTAGE GROVE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '5350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cottage Grove' ,`TaxAmount` = '7403' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664113650' WHERE `Matrix_Unique_ID` = '212536659' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:54:52.980' ,`MLSNumber` = '74882343' ,`ListAgentFullName` = 'Sharon Dimicelli' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.551289' ,`Longitude` = '-95.553078' ,`PhotoCount` = '34' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '368000.00' ,`Status` = 'Active' ,`StreetName` = 'Colony Bend' ,`StreetNumber` = '7438' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2806' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! GREAT OPPORTUNITY!! Big Addition in Back to add 325 More Square Feet than listed!! Beautiful suburban home wows you right from the curb! Private Cul-De-Sac Location in Pocket Neighborhood! Full Brick Exterior!! Spacious formal living and dining rooms! Great Entertainment Space!! All beds up and they are Nice and Spacious with a Large Game Room!! Big back yard!! And several Fruit Trees! Outdoor Storage Shed!! Water Softener, New Fencing, Fresh Paint, Great location near First Colony mall and Sugar Land attractions. Excellent Fort Bend ISD Schools! Don’t miss it!' ,`Acres` = '0.1723' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY LAKES SEC 5, BLOCK 1, LOT 46' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7505' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '589' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Lakes Sec 5' ,`TaxAmount` = '7302' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113650' WHERE `Matrix_Unique_ID` = '212629139' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:07:00.763' ,`MLSNumber` = '44719985' ,`ListAgentFullName` = 'Dawn Ellen' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.123295' ,`Longitude` = '-95.377781' ,`PhotoCount` = '47' ,`PostalCode` = '77386' ,`RoomCount` = '11' ,`ListPrice` = '524950.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Bend Shore' ,`StreetNumber` = '3735' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Needle in a Haystack! 5 bed, study, gameroom, media and magnificent stocked waterfront in 77386! 1000 sq ft outside patio w/ fire pit and large pier. Private access to enjoy motorized (electric motor) and non motorized activities! Kayak and paddleboard and fish in your back yard! Covered back patio has gas plumb for outdoor kitchen! Custom ASTORIA lighting installed in all the eaves. WIFI sprinkler system. No front or back neighbors! Open floorplan with phenomenal views of the back yard oasis! Primary bedroom and office/nursery downstairs! Large rooms with great closets upstairs along with gameroom and media!! \r\nHurry to take advantage of this NEEDLE IN A HAY STACK!' ,`Acres` = '0.1494' ,`Area` = '15' ,`BuilderName` = 'PRINCETON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688603 - LEGENDS TRACE 03, BLOCK 2, LOT 53' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6506' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1664' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bristol Lakes' ,`TaxAmount` = '11165' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113651' WHERE `Matrix_Unique_ID` = '212704891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:45:40.803' ,`MLSNumber` = '71864321' ,`ListAgentFullName` = 'Susan Stahley' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.268690' ,`Longitude` = '-95.422823' ,`PhotoCount` = '46' ,`PostalCode` = '77302' ,`RoomCount` = '12' ,`ListPrice` = '849000.00' ,`Status` = 'Active' ,`StreetName` = 'Sonali Springs' ,`StreetNumber` = '13239' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4208' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spectacular ONE OF A KIND with TONS of Recent Updates & AMAZING OUTDOOR PARADISE. One & Half Story w/ 4 Beds Down & Game Room/Media Room Up. Gorgeous Island Kitchen w/ Top of the Line Bosch Appliances, New Cabinets, High End Granite & Designer Backsplash. Completely Remodeled Master Bathroom w/ Fantastic Shower & Soaking Tub. Secondary Bathrooms Remodeled. New High End Carpet. Light, Bright & Open Throughout. Tons of Built Ins for Great Storage. Floor to Ceiling Windows Showcase the BREATHTAKING Private & Serene Backyard w/ Lush Landscaping, Walking Paths, Bridge, Flowing Stream, Arbor, Pool/Spa, Firepit, Covered Veranda w/ Ample Seating Areas Plus an Additional Covered Patio. New Roof in 2022 w/ Automatic Vent Systems. Whole House Generator. Water Softener. Reverse Osmosis System at Kitchen Sink. Both HVAC Systems are New & Have Reme Halo Air Purification Systems, New Media Filter Cabinets & Ducts. New Interior/Exterior Paint. Tankless Water Heater. Lutron Remote Controlled Blinds.' ,`Acres` = '0.6705' ,`Area` = '19' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S355802 - CRIGHTON WOODS 02, BLOCK 1, LOT 22' ,`LotDesciption` = 'Greenbelt,Wooded' ,`LotSize` = '29205' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Crighton Woods 02' ,`TaxAmount` = '10370' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113651' WHERE `Matrix_Unique_ID` = '212710032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:51:29.450' ,`MLSNumber` = '16211498' ,`ListAgentFullName` = 'Patti Bodkins' ,`ListOfficeName` = 'ARG Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675797' ,`Longitude` = '-95.215897' ,`PhotoCount` = '35' ,`PostalCode` = '77502' ,`RoomCount` = '7' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Queens' ,`StreetNumber` = '707' ,`StreetSuffix` = 'Road' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1383' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home, freshly painted inside and out. Original wood floors in all the bedrooms and den. New gas stove purchased in 2022, dishwasher 2020, water heater 2019, PEX pipes 2019. Located near recently built schools. \r\nConveniently located close to I-45 and Hwy 225.' ,`Acres` = '0.1653' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 1 SKYLARK TERRACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'L F SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PASADENA HIGH SCHOOL' ,`SchoolMiddle` = 'QUEENS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Skylark Terrace Sec 02' ,`TaxAmount` = '3334' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113651' WHERE `Matrix_Unique_ID` = '212750271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:45:08.560' ,`MLSNumber` = '10868215' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.571545' ,`Longitude` = '-95.518441' ,`PhotoCount` = '41' ,`PostalCode` = '77459' ,`RoomCount` = '14' ,`ListPrice` = '424795.00' ,`Status` = 'Active' ,`StreetName` = 'Griffith View' ,`StreetNumber` = '1114' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2607' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dramatic today style Chic Stucco & Brick Timeless Elevation! Huge Private Lot W/Covered Patio! 1 Story Ranch Home! Guest Suite W/Bathroom, 3 Guest Bedrooms & Primary Suite! Home Office/Study! Dramatic Open Floor Plan that will welcome you with Carefree Luxurious Wood Plank Vinyl Floors! Huge Family Area open to the Casual Dining & Gourmet Kitchen! Gourmet Kitchen Boasts Tall Stylish Shaker Cabinets, Tile Backsplash, Stainless Steel Appliances, Gorgeous Quartz Counters, Walk In Pantry, Deep Undermount Stainless Steel Sink, Wonderful Large Eat In Working Station Island! Private Primary Suite W/High Ceilings, Huge Walk In Closet, Large Vanity with Quartz Counters with His & Her Undermount Sinks, Large Tile Floors, Shower & More! Guest Bathroom W/Quartz Counters! Guest Bedrooms W/Huge Closets! Fully Landscaped Front & Back Yards! Energy HERS Rated W/Tankless/On-Demand H2O Heater! Park\'s Edge is a 300 acre Master Planned Community W/Lap Pool, Waterslides, Playgrounds, Sports Fields & More!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Parks Edge: Lot 12 /Block 3' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PALMER ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Parks Edge' ,`TaxAmount` = '' ,`TaxRate` = '3.240027' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113651' WHERE `Matrix_Unique_ID` = '212760993' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:21:48.623' ,`MLSNumber` = '11568534' ,`ListAgentFullName` = 'Allison King' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085500' ,`Longitude` = '-95.182825' ,`PhotoCount` = '6' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Clearwater Bluff' ,`StreetNumber` = '9402' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! \"Lantana II-B\" floor plan from the Wildflower Collection by Lennar in Royal Brook. Providing an excellent layout for families, this single-level home has an airy design that’s shared by the kitchen, nook and family room. A covered patio invites outdoor living, while a study and two secondary bedrooms add flexibility. The owner’s suite enjoys privacy, nestled in a back corner location.\r\n\r\nPrices and features may vary and are subject to change. Photos are for illustrative purposes only.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0022 BLK 003 LOT 001' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SHADOW FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Royal Brook' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113651' WHERE `Matrix_Unique_ID` = '212780944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:35:33.850' ,`MLSNumber` = '66038163' ,`ListAgentFullName` = 'Lizzette Mena' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.191177' ,`Longitude` = '-95.352311' ,`PhotoCount` = '21' ,`PostalCode` = '77302' ,`RoomCount` = '3' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Carla' ,`StreetNumber` = '14803' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this home located on almost an acre of land in Conroe with country vibes with easy access and commute to Houston. This home has 3 bedrooms, 2 bathrooms, remodeled kitchen and bath.' ,`Acres` = '0.73' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S799300 - PINEWOOD VILLAGE 01, LOT 101, TITLE # TEX0551314,' ,`LotDesciption` = 'Greenbelt,Ravine' ,`LotSize` = '31799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pinewood Village' ,`TaxAmount` = '1914' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113651' WHERE `Matrix_Unique_ID` = '212797426' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:11:39.993' ,`MLSNumber` = '60612010' ,`ListAgentFullName` = 'Albert Martinez' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.353969' ,`Longitude` = '-95.324663' ,`PhotoCount` = '48' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '789900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Alley' ,`StreetNumber` = '7618' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4693' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is your FOREVER HOME! This property is absolutely gorgeous inside and out and it sits on almost 2 acres. Property has been completely updated to 2022 standards with a beautiful chefs kitchen with a massive island in the middle and custom cabinets w beautiful quartz counter tops. The master bathroom suite is out of a magazine with a large soak in tub, his and her showers, and his and her sinks. The home comes with two primary bedrooms with two large bathroom suites as the other also has his and her sinks, large soak in tub and a large shower to enjoy. The home has a total of 5 bedrooms and 4 full baths and 1 half bath and it comes with an office and another study/ kids room with a MASSIVE game room to enjoy as well. The home also has a custom made wine room with beautiful granite counter tops, and the laundry room is located in home with a wash sink. The property also has new double paned windows and over looks a pond in the backyard. This is a must see in person!' ,`Acres` = '1.63' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'SAVANNAH PLANTATION SEC 3 (A0100 F MOORE) BLK 2 LOT 30 ACRES' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '71003' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Savannah Plantation' ,`TaxAmount` = '9273' ,`TaxRate` = '2.1074' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113652' WHERE `Matrix_Unique_ID` = '212823752' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212873380','1664113652','212873380','2022-09-24T22:41:02.130','88318055','Diane Rendon','JLA Realty','','','29.847919','-94.958975','48','77521','4','399999.00','Active','Fm 1942','6841','Road','Baytown','2','0','4','1846','Single-Family','Welcome home to 2.7 acres, your own country paradise! Don\'t miss this opportunity to own a home on almost 3 gorgeous wooded acres, cleared of underbrush that looks like a park! Well maintained 4 bedroom, 2 bath home. Brand new AC and hot water heater August 2020. All new plumbing throughout the home. Large detached garage with power, space for two cars plus storage, workspace and covered walk way to the house. Additional two car carport. Enjoy gatherings on the back covered patio with propane stove, sink and large fireplace just in time for fall and cool evenings or cooking wood fired pizza. Primary bedroom with walk in closet, attached bathroom and large tiled walk in shower. Ceiling fans in every room and massive laundry room with room for additional storage and a deep freezer. Property is fully fenced with a manual gate at the driveway for added security. Land is becoming harder to come by, this property wont last long!','2.72','1','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','Crosby Area','Central Electric','0','TRS 12B & 13B ABST 54 H NASH','Cleared,Wooded','118483','Appraisal District','','','0','','2','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Composition','12 - Crosby','DREW ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Accompany,Appointment Required,Leave Business Card,Lockbox Back,Lockbox Left Side,Request Online Appointment','Appraisal District','1','Traditional','Hannah Nash League','5240','2.0766','Septic Tank,Well','1978','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:07:59.660' ,`MLSNumber` = '85841346' ,`ListAgentFullName` = 'Angelica Fernandez' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707953' ,`Longitude` = '-95.879184' ,`PhotoCount` = '37' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '468888.00' ,`Status` = 'Active' ,`StreetName` = 'Brooks Valley' ,`StreetNumber` = '29127' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2592' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2018 Perry Home. One story, 4 sided brick and stone home, with a beautiful lake view. This open concept home has 4 bedrooms, 3 full baths, study with French doors, and a mudroom. The grand entryway features extended tile and 12 foot coffered ceilings. Open concept kitchen features granite counter tops, an extended counter, stainless steel appliances, an island with built in seating space, and a walk-in pantry. Dining area flows into open family room with floor to ceiling windows that provides natural lighting with an amazing lake view. The large primary suite has floor to ceiling windows. The double doors lead to the primary bath with dual vanities, soaking tub, enclosed separate glass shower, and 2 large walk in closets. Bonus feature of this home includes a guest suite with full bath and walk in closet. The extended covered patio with recessed lighting over looking the lake is the perfect place to enjoy your weekends. Home has never flooded. MOTIVATED SELLERS !!!' ,`Acres` = '0.1511' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE BROOKS AT CROSS CREEK RANCH SEC 2, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6583' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '10926' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664113652' WHERE `Matrix_Unique_ID` = '212891066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:43:52.480' ,`MLSNumber` = '3136222' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = 'Rangel Oviedo' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.819780' ,`Longitude` = '-94.820866' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '10' ,`ListPrice` = '294990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rain Tree' ,`StreetNumber` = '14922' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Baxtor Plan by D.R. Horton Homes Ready for Move In! Located in TOP #1 School District for all ages! Beautiful Stylish Timeless Chic 1 story home with Amazing Stucco & Brick Elevation! Grand Entry W/High Ceilings, Gorgeous Luxury Vinyl Wood Floors throughout! Lush Carpeting in all the Bedrooms! Amazing Open Floor Plan W/Huge Family Area that Flows into the Gourmet Kitchen W/Gorgeous Silestone Counters, Tile Back-splash, Large Eat-in Island W/Undermount Stainless Sink, Stainless Steel Appliances, Tall Upgraded Shaker Cabinets & more! Private Primary Suite has a Luxurious Bathroom featuring His & Her Undermount Deep Sinks, Vanity has Cultured Marble Countertops \"Massive\" Shower with Tile Surroundings & Walk-in Closet! Enjoy the Covered Patio! Standard Energy Features: HERS Energy Rated, Tankless/On-Demand H2O Heater, 2 USB outlets &\"Smart Home\" w/Amazon Echo & Dot, Skybell, Smart Lighting, Electric Deadbolt, Thermostat & Wireless Security, Control your home from anywhere! NO FLOODING' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Raintree Lot: 14 /Block: 2' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '6600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch,Traditional' ,`Subdivision` = 'Raintree' ,`TaxAmount` = '' ,`TaxRate` = '1.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1664113652' WHERE `Matrix_Unique_ID` = '212891314' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:10:27.703' ,`MLSNumber` = '69990926' ,`ListAgentFullName` = 'Raul Limas' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.512878' ,`Longitude` = '-94.983886' ,`PhotoCount` = '46' ,`PostalCode` = '77518' ,`RoomCount` = '8' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayshore' ,`StreetNumber` = '4122' ,`StreetSuffix` = 'Drive' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is a wonderful opportunity to own completely remodeled 3 bedroom, 2 bath home with water views on a corner lot! You can walk to the shore one block away! All new kitchen w/soft closing cabinets and drawers. New quartz countertops! All new stainless steel appliances! All new waterproof vinyl flooring throughout! Beautifully remodeled bathrooms! Spacious utility room! There is a spacious workshop behind the two car garage that basically doubles the size of your garage. You could do a lot with this space. A brand new uniquely designed wooden privacy fence surrounds the property and the well maintained yard.' ,`Acres` = '0.1656' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 154 LOT 5 BLK 2 PERKINS BEACH SUB' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '7213' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Perkins Beach' ,`TaxAmount` = '4976' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113652' WHERE `Matrix_Unique_ID` = '212892184' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212920721','1664113652','212920721','2022-09-24T22:00:49.613','45508756','Catalina Jackson','Houstonian Properties','','','29.808966','-95.541441','32','77080','7','355000.00','Active','Metronome','10102','Drive','Houston','2','1','4','2045','Single-Family','Located in the cul-de-sac of the highly sought-after neighborhood of Spring Branch, 10102 Metronome has everything you\'re looking for. Centrally located just minutes away from City Center, Memorial City, and Beltway 8, this 4 bedroom 2.5 bath has been meticulously cared for and updated by the owners. As of 2019, the home has a new roof, 1 new A/C unit enhanced with Halo Reme, ductwork, water heater, tile flooring, and crown molding on the entire first floor. The kitchen has custom kitchen cabinets, SS appliances, and SS double oven. Both full bathrooms have double sink vanities with lots of storage. Video tour coming soon. Please see the attachment for a comprehensive list of all improvements.','0.0987','24','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Mock Fireplace','1','Spring Branch','Central Gas','0','LT 13 BLK 1 GESSNER WOODS','Cul-De-Sac,Subdivision Lot','4299','Appraisal District','','25','0','','2','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','49 - Spring Branch','PINE SHADOWS ELEMENTARY SCHOOL','SPRING WOODS HIGH SCHOOL','SPRING WOODS MIDDLE SCHOOL','Accompany,Appointment Required,Supra Keybox','Appraisal','2','Traditional','Gessner Woods','4980','2.4415','Public Sewer,Public Water','1972','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T22:46:01.163' ,`MLSNumber` = '79260602' ,`ListAgentFullName` = 'Maaz Kazmi' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.822797' ,`Longitude` = '-95.736982' ,`PhotoCount` = '31' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Afton Forest' ,`StreetNumber` = '3406' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT INVESTMENT PROPERTY. Property is tenant occupied until April 30, 2023. Gorgeous 5 bedroom, 3 Full Bath, 2 Story Home in Bridgewater Meadow Subdivision. Super Spacious Master Suite with Sitting Area on the second floor + Dual Vanities, Garden Tub, Stand-In Shower & large his/her Closets in the Master Bath. Flex 5th Bedroom or Use as Study w/ French Doors on the first floor. Back yard offers a Covered Patio for a Nice Outdoor Living/BBQ Fun. Kitchen with Stainless Steel Appliances, lots of Cabinets & Refrigerator, Washer & Dryer are Included! Never flooded, Katy ISD Schools, and Close to (99) Grand Parkway.' ,`Acres` = '0.1162' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 BRIDGEWATER MEADOW SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCROBERTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bridgewater Meadow Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664113652' WHERE `Matrix_Unique_ID` = '212922088' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-24T23:53:52.033' ,`MLSNumber` = '83050063' ,`ListAgentFullName` = 'Nhan Ho' ,`ListOfficeName` = 'Home & Investment Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.626042' ,`Longitude` = '-95.641016' ,`PhotoCount` = '34' ,`PostalCode` = '77498' ,`RoomCount` = '7' ,`ListPrice` = '780000.00' ,`Status` = 'Active' ,`StreetName` = 'Silent Manor' ,`StreetNumber` = '83' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2879' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this WONDERFUL WATER FRONT in the desirable Imperial Sugar Land neighborhood. This home has 1.5 story with 4 large bedrooms 4.5 baths, spacious office. EXCELLENT LOCATION provides access to trails, parks, shops, restaurants, freeways, Constellation Feild, Sugar Land city center and much more...Breath-taking LAKE FRONT VIEW with walking trail. Tile roof, wooden floors, high ceilings, granite baths, large island kitchen, custom designed WINE ROOM, tons of natural lights, just to name a few. This gorgeous home features open concept design, smart floorplan, and also high efficiency HVAC with digital thermostats, TESLA EV CHARGER ready IN THE GARAGE. Primary bedroom are professionally designed and well-equipped with built-in closet. You can relax in your backyard under the covered patio that is equipped with beautiful FIREPLACE!!!' ,`Acres` = '0.1583' ,`Area` = '29' ,`BuilderName` = 'Sitterle Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILENT MANOR AT IMPERIAL, BLOCK 2, LOT 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '6895' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '999' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Silent Manor At Imperial' ,`TaxAmount` = '15368' ,`TaxRate` = '3.1094' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664113653' WHERE `Matrix_Unique_ID` = '212924522' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212929264','1664113653','212929264','2022-09-24T22:08:48.923','94162425','Rosie Moran','NextHome Realty Center','','','29.913892','-95.575034','32','77064','11','298900.00','Active','Sand Pass','10519','Lane','Houston','2','0','4','1754','Single-Family','Beautifully updated home on quiet culdesac street in a well-established Winchester Country community of popular Jersey Village area. Home features high ceilings throughout with unique open floorplan, formal living, formal dining and large family room. NEW Roof, NEW fascia/siding, NEW AC Air Ducts, New Tile Flooring and Carpet throughout the house. New Granite Counters in Baths, New Bath fixtures, New exterior/interior Paint, New Stainless Steel appliances, New Granite Countertop and 42in Cabinets in Kitchen, New Garbage Disposal, New electric fixtures and outlets/switches, New landscaping and sod and much more. Great Community with swimming pool, tennis court and playground. Close to US 290 and Beltway that makes it convenient for the commuter. Schedule your appointment today!','0.1598','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Jersey Village','Central Gas','1','LT 26 BLK 2 WINCHESTER COUNTRY SEC 2','Cul-De-Sac,Subdivision Lot','6960','Appraisal District','','400','0','','2','Single Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','BANG ELEMENTARY SCHOOL','JERSEY VILLAGE HIGH SCHOOL','COOK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Winchester Country Sec 02','4703','2.641','Public Sewer,Public Water','1982','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212932157','1664113653','212932157','2022-09-24T22:04:05.470','73056708','Jared Turner','LennarVillageBldr-JaredTurner','','','29.900019','-95.740228','6','77433','8','362990.00','Active','Blue Tuna','21315','Drive','Cypress','2','0','3','1801','Single-Family','NEW! Lennar Wildflower Collection \"Lantana II\" Plan with Elevation \"B\" in Marvida! Providing an excellent layout for families, this single-level home has an airy design that’s shared by the kitchen, nook and family room. A covered patio invites outdoor living, while a formal dining room and two secondary bedrooms add flexibility. The owner’s suite enjoys privacy, nestled in a back corner location.*ESTIMATED COMPLETION DECEMBER 2022*','','25','Lennar Homes','','','','Mud,Other Disclosures','1','','0','Cypress South','Central Gas','1','SEC 0005 BLK 002 LOT 048','Subdivision Lot','','','','1200','1','To Be Built/Under Construction','2','','0','','','','','Composition','13 - Cypress-Fairbanks','ANDRE ELEMENTARY SCHOOL','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required','Builder','1','Traditional','Marvida','','3.59','Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212932487','1664113653','212932487','2022-09-24T23:15:13.867','42524985','Connie Inmon','CB&A, Realtors','','','29.841197','-95.255542','34','77078','6','225000.00','Active','Woodlyn','9122','Road','Houston','2','0','4','1419','Single-Family','Pretty updated 1- story home with 4 bedrooms. The garage was converted to a 4th bedroom. No carpet, tile throughout. Fresh paint, updated cabinets in kitchen, garbage disposal, walk-in shower in master. Ceiling fans throughout. Large backyard. Recent AC and roof. Easy access to BW8, 69, and 610.','0.1736','2','','','Electric Dryer Connections,Washer Connections','','Exclusions,Sellers Disclosure','0','','0','Northeast Houston','Central Gas','0','LT 395 BLK 12 CHATWOOD PLACE SEC 3','Corner,Subdivision Lot','7560','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','ELMORE ELEMENTARY SCHOOL','KASHMERE HIGH SCHOOL','KEY MIDDLE SCHOOL','Lockbox Front,Request Online Appointment','Appraisal District','1','Ranch','Chatwood Place Sec 03','1580','2.3307','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212932931','1664113653','212932931','2022-09-24T23:50:42.743','6042913','George Agaybi','Texas Premium Realty','','','29.801155','-95.179872','0','77015','9','279500.00','Active','Rampchester','13714','Lane','Houston','2','0','4','1526','Single-Family','Beautiful 4 bedroom/ 2 bath Home, COMPLETE REMODEL, NEW ROOF, CARPET, KITCHEN AND VANITY CABINETS, APPLIANCES, PAINTING, UPDATED BATHROOMS','0.1761','2','','','Electric Dryer Connections,Washer Connections','','Mud,Owner/Agent','1','Gas Connections','1','North Channel','Central Electric,Central Gas','1','LT 26 BLK 70 WOODFOREST SEC 19','Subdivision Lot','7670','Appraisal District','','','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range','','Composition','21 - Galena Park','HAVARD ELEMENTARY SCHOOL','NORTH SHORE SENIOR HIGH SCHOOL','NORTH SHORE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Woodforest Sec 19','3918','2.5294','Public Sewer,Public Water,Water District','1975','Appraisal District'); --> New record created successfully